Oracle and case preserved table names

paulsmith001 Dec 1, 2004 12:02 PM

If I create my Oracle table names using the case-preserving quote:
CREATE TABLE "CustomerOrders"
then the table name is not upper-cased by Oracle. I must therefore use the quotes on all SQL statements I issue.
When running on MySQL (I don't have Oracle yet), I noticed that the queries jboss constructs for my CMP entity beans are not quoted.
So when I port to Oracle, my CMP beans will fail - right?
If so, is there a way to tell JBoss to quote table names?
If there is, will JBoss use the quote character appropriate to the DBMS?

Thanks,
Bob

1. Re: Oracle and case preserved table names

paulsmith001 Dec 2, 2004 4:38 AM (in response to paulsmith001)

From my experience, this group is very lightly used and the chances of getting a reply to important questions are slim.

Are there any other JBoss forums that I could use? Of course, by my own argument, I'm unlikely to get an answer to that :)
Actions
2. Re: Oracle and case preserved table names

schmidts Dec 2, 2004 3:10 PM (in response to paulsmith001)

Is there any strong reason at all to use case-preserving create-table DDL in the first place?
Actions
3. Re: Oracle and case preserved table names

aloubyansky Dec 3, 2004 4:12 AM (in response to paulsmith001)

Have you tried including quotes into table-name in jbosscmp-jdbc.xml?
Actions

Go to original post