This discussion is archived
3 Replies Latest reply: Feb 14, 2013 2:54 AM by r035198x RSS

Column name in the database starts with a number!

Shahe Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points