Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes BEA/Weblogic and the fly likes CMP table name using reserved keyword Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "CMP table name using reserved keyword" Watch "CMP table name using reserved keyword" New topic

CMP table name using reserved keyword

Klaus Mittfoch

Joined: Nov 16, 2005
Posts: 3

I am migrating an existing application from JBoss to WebLogic.
One of the issues that came up is that there are three tables
named User, Transaction, Identity which in case of SQL Server
happen to be reserved keywords. In JBoss descriptors we used
to escape those names with square brackets and it worked fine.

I can not seem to find a way to make it work in WebLogic. If
I escape them as mentioned, the appc compilation fails. If I
don't - the application fails to deploy not being able to find
those tables.

There must be a way to specify that the app server should
escape those table names. Can You help?

It is sorta covered in the JavaRanch Style Guide.
subject: CMP table name using reserved keyword
Similar Threads
How to search all the tables of a database for a data item?
jdbc + swing
Want to get table names from db in access
B&S Database Design Structure
Simple mdb connection Error