I had a problem with table name case with an older MySQL version. One thing to check is if the names in the Torque XML schema match the case of the DB tables exactly. The generator uppercase's the Column names but does not it for tables. FWIW, This could be why the test case works because the tables are created from the schema used.
Does this behaviour hold only for Torque queries or does it occure with PostGres's native tools as well? It would be good to check it with some native JDBC code as well. This could tell you if it's a DB server setting (case 1 fails) or a JDBC driver issued (case 2 fails). > -----Original Message----- > From: Thomas Fischer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 26, 2006 3:22 AM > To: Apache Torque Users List > Subject: RE: Columns are converted to uppercase > > Hi, > > I get the feeling there is something else quite wrong there > (or I do not understand the issue). I have run the torque > test project, which contains upper-case and mixed case table > names, repeatedly against postgresql 7 and postgresql 8, and > it worked perfectly, no quotes in the table name or something like it. > > Did you create the tables via the sql script generated by > Torque ? Do you use any other non-standard driver options or > postgresql settings ? > > Thomas > > > "Robert Kromkamp" <[EMAIL PROTECTED]> schrieb am > 26.07.2006 08:36:57: > > > Hi All again, > > > > The solution below works, but when I execute the following query on > > postgreSQL: > > > > SELECT * FROM myTable > > > > I get the response: ERROR: relation "myTable" does not exist. > > Instead I have to execute the following query to get my results: > > > > SELECT * FROM "myTable" > > > > At the moment while creating java files based on a Torque > schema, it's > > impossible to use a postgreSQL database in combination with > capitals > > in my tables or fields ( e.g: theFieldName) without using > quotes. Is > > there a solution for my problem? So the quotes are not > generated for > > the tables and columns. > > > > Robert > > > > > > -----Original Message----- > > From: Thoralf Rickert [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, July 19, 2006 9:58 AM > > To: Apache Torque Users List > > Subject: AW: Columns are converted to uppercase > > > > Hi, > > > > there is currently a discussion about that problem on this > list and a > > bug report ( > http://issues.apache.org/jira/browse/TORQUE-44). If you > > need it now, you have to change the Torque templates that generates > > the column names in the Torque classes (Peer.vm and MapBuilder.vm). > > There is no switch or property for this problem. > > > > bye > > Thoralf > > > > > -----Ursprüngliche Nachricht----- > > > Von: Robert Kromkamp [mailto:[EMAIL PROTECTED] > > > Gesendet: Mittwoch, 19. Juli 2006 09:33 > > > An: Apache Torque Users List > > > Betreff: Columns are converted to uppercase > > > > > > > > > Hi All, > > > > > > By default, PostgreSQL folds names to lower case. So to "select * > > > from Y" there has to be a table named with a lowercase > 'y'. If the > > > table name is really a capital 'Y' you > > > need: select * from "Y" > > > > > > At the moment while creating java files based on a Torque > schema, al > > > columns are converted to uppercase. Is there an option to > converted > > > the columns exactly as they are described in the > schema.xml (I've a > > > mix of upper and lowercase like a column PersonFirstname)? At the > > > moment I am using Torque-3.1.1. > > > > > > Cheers, > > > Robert > > > > > > > -------------------------------------------------------------------- > > > - 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] > > Duke CE Privacy Statement Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
