db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Kromkamp" <r.kromk...@pagelink.nl>
Subject RE: Columns are converted to uppercase
Date Wed, 26 Jul 2006 06:36:57 GMT
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:thoralf.rickert@cadooz.de] 
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:r.kromkamp@pagelink.nl]
> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message