10 Replies Latest reply on May 14, 2002 11:42 AM by Chad Brandon

    Table name case in CMP sql statements

    Chad Brandon Newbie

      Hi Dain,

      Dumb as this may sound, our customer has an existing SQL Server database that is case sensitive (I've never seen this before). I have an application that is using CMP JBoss-3.0.0RC2, and while developing I've had no issues (since my database isn't case sensitive), but now that I'm trying to test on their site with their database I'm getting errors that the tables aren't found because the generated CMP SQL statements have the table names all lower case. For example in the jbosscmp-jdbc.xml file I have the table-name attribute set as "Persons" but in the SQL statement generated by the container I'm getting "SELECT Per_ID FROM persons WHERE Per_ID=?". Is there anyway you could change this so that the table name would match the case of the table name found in the jbosscmp-jdbc.xml file, instead of making it lowercase?

      Thanks!

      Chad