3 Replies Latest reply on Dec 3, 2004 4:12 AM by Alexey Loubyansky

    Oracle and case preserved table names

    Paul Smith Newbie

      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