AW: Sybase case insensitive column names
Thanks. I think, that's what I couldn't find. -Ursprüngliche Nachricht- Von: Greg Monroe [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 19. Juli 2006 23:59 An: Apache Torque Users List Betreff: RE: Sybase case insensitive column names FWIW - Doing some quick research I found that Sybase can almost meet the SQL standards by setting the sort order to case insensitive. See: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase. dc36556_1500/html/histserv/title.htm -Original Message- From: Greg Monroe [mailto:[EMAIL PROTECTED] Sent: Monday, July 17, 2006 3:27 PM To: Apache Torque Users List Subject: RE: Sybase case insensitive column names Just a couple of quick comments. According to a quick read of the SQL 99 standard, column names are supposed to be case insensitive unless they are delimited. Sybase is doing non-standard things here (or my interpretation could be wrong 8) ) Also, changing the way Torque has generated column names since day one could possibly break (badly written) application code if someone has hardcoded this expected behaviour into it. Should this be an optional generation flag? -Original Message- From: Thoralf Rickert [mailto:[EMAIL PROTECTED] Sent: Monday, July 17, 2006 4:45 AM To: Apache Torque Users List Subject: AW: Sybase case insensitive column names Okay, I'll submit a bug report. -Ursprüngliche Nachricht- Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Juli 2006 10:04 An: Apache Torque Users List Betreff: AW: Sybase case insensitive column names The column names in the class files should be generated in the same case as they appear in the schema file. If this is not the case, this is a bug. This is Torque 3.2 and you did not change anything there, I assume ? If yes, would you mind to submit a bug report to Jira ? Thomas Thoralf Rickert [EMAIL PROTECTED] schrieb am 17.07.2006 09:19:17: That is correct. The JDBC task doesn't change the names. But if you create the classes (om) it creates the column names with uppercase letters and than there is the problem because you cannot make any queries. Here is an example: Generated XML file (correct): table name=address column name=class javaName=aClass primaryKey=true required=true size=2 type=CHAR/ column name=id primaryKey=true required=true size=30 type=VARCHAR/ column name=position primaryKey=true required=true type=INTEGER/ column name=name1 size=50 type=VARCHAR/ column name=name2 size=50 type=VARCHAR/ column name=name3 size=50 type=VARCHAR/ column name=street size=50 type=VARCHAR/ column name=zipcode size=25 type=VARCHAR/ column name=city size=60 type=VARCHAR/ column name=phone size=40 type=VARCHAR/ column name=phone2 size=40 type=VARCHAR/ column name=country size=200 type=VARCHAR/ column name=state size=200 type=VARCHAR/ column name=fax size=40 type=VARCHAR/ column name=email size=150 type=VARCHAR/ /table Generated constants in the BaseAddressPeer (incorrect): static { CLASS = address.CLASS; ID = address.ID; POSITION = address.POSITION; NAME1 = address.NAME1; NAME2 = address.NAME2; NAME3 = address.NAME3; STREET = address.STREET; ZIPCODE = address.ZIPCODE; CITY = address.CITY; PHONE = address.PHONE; PHONE2 = address.PHONE2; COUNTRY = address.COUNTRY; STATE = address.STATE; FAX = address.FAX; EMAIL = address.EMAIL; I think the uppercase column names or uppercase because it's better to read (?). There is no bug in the Sybase JDBC driver (5.5 and 6. 0). I've tested a generated SQL statement on the sybase console (isql) and it fails if the case is not correct, for example: SELECT FROM address WHERE address.CITY=Hamburg failes, but with address.city=... everything is okay. I think this case sensitive behaviour is a Sybase-feature... Maybe I should ask someone on a Sybase JDBC mailinglist howto disable this behaviour. Bye Thoralf -Ursprüngliche Nachricht- Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 15. Juli 2006 09:10 An: Apache Torque Users List Betreff: Re: Sybase case insensitive column names Hi, This is strange; the jdbc task should preserve the case
AW: Sybase case insensitive column names
That is correct. The JDBC task doesn't change the names. But if you create the classes (om) it creates the column names with uppercase letters and than there is the problem because you cannot make any queries. Here is an example: Generated XML file (correct): table name=address column name=class javaName=aClass primaryKey=true required=true size=2 type=CHAR/ column name=id primaryKey=true required=true size=30 type=VARCHAR/ column name=position primaryKey=true required=true type=INTEGER/ column name=name1 size=50 type=VARCHAR/ column name=name2 size=50 type=VARCHAR/ column name=name3 size=50 type=VARCHAR/ column name=street size=50 type=VARCHAR/ column name=zipcode size=25 type=VARCHAR/ column name=city size=60 type=VARCHAR/ column name=phone size=40 type=VARCHAR/ column name=phone2 size=40 type=VARCHAR/ column name=country size=200 type=VARCHAR/ column name=state size=200 type=VARCHAR/ column name=fax size=40 type=VARCHAR/ column name=email size=150 type=VARCHAR/ /table Generated constants in the BaseAddressPeer (incorrect): static { CLASS = address.CLASS; ID = address.ID; POSITION = address.POSITION; NAME1 = address.NAME1; NAME2 = address.NAME2; NAME3 = address.NAME3; STREET = address.STREET; ZIPCODE = address.ZIPCODE; CITY = address.CITY; PHONE = address.PHONE; PHONE2 = address.PHONE2; COUNTRY = address.COUNTRY; STATE = address.STATE; FAX = address.FAX; EMAIL = address.EMAIL; I think the uppercase column names or uppercase because it's better to read (?). There is no bug in the Sybase JDBC driver (5.5 and 6.0). I've tested a generated SQL statement on the sybase console (isql) and it fails if the case is not correct, for example: SELECT FROM address WHERE address.CITY=Hamburg failes, but with address.city=... everything is okay. I think this case sensitive behaviour is a Sybase-feature... Maybe I should ask someone on a Sybase JDBC mailinglist howto disable this behaviour. Bye Thoralf -Ursprüngliche Nachricht- Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 15. Juli 2006 09:10 An: Apache Torque Users List Betreff: Re: Sybase case insensitive column names 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: Sybase case insensitive column names
The column names in the class files should be generated in the same case as they appear in the schema file. If this is not the case, this is a bug. This is Torque 3.2 and you did not change anything there, I assume ? If yes, would you mind to submit a bug report to Jira ? Thomas Thoralf Rickert [EMAIL PROTECTED] schrieb am 17.07.2006 09:19:17: That is correct. The JDBC task doesn't change the names. But if you create the classes (om) it creates the column names with uppercase letters and than there is the problem because you cannot make any queries. Here is an example: Generated XML file (correct): table name=address column name=class javaName=aClass primaryKey=true required=true size=2 type=CHAR/ column name=id primaryKey=true required=true size=30 type=VARCHAR/ column name=position primaryKey=true required=true type=INTEGER/ column name=name1 size=50 type=VARCHAR/ column name=name2 size=50 type=VARCHAR/ column name=name3 size=50 type=VARCHAR/ column name=street size=50 type=VARCHAR/ column name=zipcode size=25 type=VARCHAR/ column name=city size=60 type=VARCHAR/ column name=phone size=40 type=VARCHAR/ column name=phone2 size=40 type=VARCHAR/ column name=country size=200 type=VARCHAR/ column name=state size=200 type=VARCHAR/ column name=fax size=40 type=VARCHAR/ column name=email size=150 type=VARCHAR/ /table Generated constants in the BaseAddressPeer (incorrect): static { CLASS = address.CLASS; ID = address.ID; POSITION = address.POSITION; NAME1 = address.NAME1; NAME2 = address.NAME2; NAME3 = address.NAME3; STREET = address.STREET; ZIPCODE = address.ZIPCODE; CITY = address.CITY; PHONE = address.PHONE; PHONE2 = address.PHONE2; COUNTRY = address.COUNTRY; STATE = address.STATE; FAX = address.FAX; EMAIL = address.EMAIL; I think the uppercase column names or uppercase because it's better to read (?). There is no bug in the Sybase JDBC driver (5.5 and 6. 0). I've tested a generated SQL statement on the sybase console (isql) and it fails if the case is not correct, for example: SELECT FROM address WHERE address.CITY=Hamburg failes, but with address.city=... everything is okay. I think this case sensitive behaviour is a Sybase-feature... Maybe I should ask someone on a Sybase JDBC mailinglist howto disable this behaviour. Bye Thoralf -Ursprüngliche Nachricht- Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 15. Juli 2006 09:10 An: Apache Torque Users List Betreff: Re: Sybase case insensitive column names 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] - 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]
AW: Sybase case insensitive column names
Okay, I'll submit a bug report. -Ursprüngliche Nachricht- Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Juli 2006 10:04 An: Apache Torque Users List Betreff: AW: Sybase case insensitive column names The column names in the class files should be generated in the same case as they appear in the schema file. If this is not the case, this is a bug. This is Torque 3.2 and you did not change anything there, I assume ? If yes, would you mind to submit a bug report to Jira ? Thomas Thoralf Rickert [EMAIL PROTECTED] schrieb am 17.07.2006 09:19:17: That is correct. The JDBC task doesn't change the names. But if you create the classes (om) it creates the column names with uppercase letters and than there is the problem because you cannot make any queries. Here is an example: Generated XML file (correct): table name=address column name=class javaName=aClass primaryKey=true required=true size=2 type=CHAR/ column name=id primaryKey=true required=true size=30 type=VARCHAR/ column name=position primaryKey=true required=true type=INTEGER/ column name=name1 size=50 type=VARCHAR/ column name=name2 size=50 type=VARCHAR/ column name=name3 size=50 type=VARCHAR/ column name=street size=50 type=VARCHAR/ column name=zipcode size=25 type=VARCHAR/ column name=city size=60 type=VARCHAR/ column name=phone size=40 type=VARCHAR/ column name=phone2 size=40 type=VARCHAR/ column name=country size=200 type=VARCHAR/ column name=state size=200 type=VARCHAR/ column name=fax size=40 type=VARCHAR/ column name=email size=150 type=VARCHAR/ /table Generated constants in the BaseAddressPeer (incorrect): static { CLASS = address.CLASS; ID = address.ID; POSITION = address.POSITION; NAME1 = address.NAME1; NAME2 = address.NAME2; NAME3 = address.NAME3; STREET = address.STREET; ZIPCODE = address.ZIPCODE; CITY = address.CITY; PHONE = address.PHONE; PHONE2 = address.PHONE2; COUNTRY = address.COUNTRY; STATE = address.STATE; FAX = address.FAX; EMAIL = address.EMAIL; I think the uppercase column names or uppercase because it's better to read (?). There is no bug in the Sybase JDBC driver (5.5 and 6. 0). I've tested a generated SQL statement on the sybase console (isql) and it fails if the case is not correct, for example: SELECT FROM address WHERE address.CITY=Hamburg failes, but with address.city=... everything is okay. I think this case sensitive behaviour is a Sybase-feature... Maybe I should ask someone on a Sybase JDBC mailinglist howto disable this behaviour. Bye Thoralf -Ursprüngliche Nachricht- Von: Thomas Fischer [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 15. Juli 2006 09:10 An: Apache Torque Users List Betreff: Re: Sybase case insensitive column names 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED