Hi,
This is strange; the jdbc task should preserve the case of the table and
column names (I checked that using mysql; as I do not have a sybase
database). The jdbc task uses the DatabaseMetaData from the jdbc driver to
get the database; if the database is case sensitive and the
DatabaseMetaData does not preserve case it is a bug of the jdbc driver.
Thomas
On Thu, 13 Jul 2006, Thoralf Rickert wrote:
Hi!
I've created a schema.xml for an existing Sybase database and I was able
to generate the corresponding java classes. If I try to make a query
with them I run into a problem. The database uses case sensitive column
names but torque generates uppercase column names. For example the
following query throws an exception, because the column "STATE" cannot
be found (in the database it's called "state").
SELECT states.STATE FROM states ORDER BY states.STATE ASC
Is there a way to handle this? Is there a sybase specific connection
setting or something like that?
Thanks
Thoralf
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
