1 Reply Latest reply on Aug 12, 2003 8:04 AM by scoy

    Oracle mixed case table name

    chrick
    chrick Aug 6, 2003 10:55 AM

      I'm trying to use JBoss 3.0.7 and Oracle 9i with mixed-case tablenames, and can't get JBoss to see my tables. As long as the table name is all upper case things work fine - the mixed case tables are the problem. Interestingly enough, mixed-case column names work as long as I put double quotes around them in the jbosscmp-jdbc.xml file - but the same trick doesn't work for table names.

      Any suggestions?

      Thanks,

      Chris

      • 1463 Views
      • Tags:
        • 1. Re: Oracle mixed case table name
          scoy
          scoy Aug 12, 2003 8:04 AM (in response to chrick)

          The current code base uses the table name to construct various other database artifacts, and does not take quoting into account at all. In other words, it won't work.

          If it were ever to be implemented, it is unlikely to happen on the 3.0 branch as that is now on care and maintenance only.


          Steve Coy

            • Actions