3 Replies Latest reply on Feb 14, 2013 10:54 AM by r035198x

    Column name in the database starts with a number!


      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?