db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: Columns are converted to uppercase
Date Wed, 26 Jul 2006 13:30:21 GMT
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:fischer@seitenbau.net] 
> 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" <r.kromkamp@pagelink.nl> 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: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
> >
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 

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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message