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]
