3 Replies Latest reply: Feb 14, 2013 4:54 AM by r035198x RSS

    Column name in the database starts with a number!

    Shahe
      Hello,

      Recently we updated out database and we changed our tables' and columns' names, I'm developing an adf application with EJB3.0 the question is that the new column names start with a number (eg. 001U_ID), its a kind of encoding the names of the tables so no one can modify the values.
      When I create a query on the table it is throwing an exception:

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'U_ID'.

      I think the problem is that the EJB3.0 doesn't recognize column names starting with a number!!! What can I do to solve this issue?

      Thanks
      Shahe