Re: BigDecimal and MySQL decimal

2006-12-14 Thread Jon August
Hey Alvaro, Thanks for the suggestion. I tried this: column name=pricescale=2 size=7 type=DECIMAL / but I get this error when I run maven torque: org.apache.torque.engine.EngineException: org.xml.sax.SAXException: Error while parsing wp-schema.xml at line 13 column

AW: BigDecimal and MySQL decimal

2006-12-14 Thread Thoralf Rickert
Try size=7,2 instead of size=.. scale=.. -Ursprüngliche Nachricht- Von: Jon August [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 14. Dezember 2006 13:52 An: Apache Torque Users List Betreff: Re: BigDecimal and MySQL decimal Hey Alvaro, Thanks for the suggestion. I tried

Re: AW: BigDecimal and MySQL decimal

2006-12-14 Thread Jon August
Thanks - that fixed the maven torque... Now when I do the save from my object, I get an error that I wasn't getting when the scale wasn't set: java.lang.NullPointerException java.math.BigDecimal.init(BigDecimal.java:181) On Dec 14, 2006, at 7:55 AM, Thoralf Rickert wrote:

Re: AW: BigDecimal and MySQL decimal

2006-12-14 Thread Jon August
The suggestions by Thoralf and Alvaro fixed the problem. My issue with the NullPointerException was unrelated. Thanks for the help. -Jon On Dec 14, 2006, at 8:35 AM, Jon August wrote: Thanks - that fixed the maven torque... Now when I do the save from my object, I get an error that I

RE: AW: BigDecimal and MySQL decimal

2006-12-14 Thread Greg Monroe
For the record, the proper way to do this since Torque 3.2 is to use the size and scale attributes. (Though the older size=(size,scale) is still supported). One thing that can cause the SAX parsing exception is if the DTD specified in the DOCTYPE of your schema isn't set to use the same DTD as

Re: AW: BigDecimal and MySQL decimal

2006-12-14 Thread Jon August
You're right. I had 3.1 in the DOCTYPE. The separate attribute method is working for me. On Dec 14, 2006, at 9:18 AM, Greg Monroe wrote: For the record, the proper way to do this since Torque 3.2 is to use the size and scale attributes. (Though the older size=(size,scale) is still

Re: Maven2 Torque plugin and JDBC driver

2006-12-14 Thread Thomas Fischer
You have to state the dependency in the plugin, not in the pom itself. Like this (replacing the variables ${...} by the actual values): plugin groupIdorg.apache.db.torque/groupId artifactIdtorque-maven-plugin/artifactId configuration ...

retrieve columns returned by doSelect(Criteria) query

2006-12-14 Thread David Zhao
Hi there, If I did this: Criteria crit = new Criteria(); crit.addJoin(Table1Peer.ID1, Table2Peer.ID2, Criteria.INNER_JOIN ); crit.addSelectColumn(Table1Peer.ID1);

Re: retrieve columns returned by doSelect(Criteria) query

2006-12-14 Thread Shane Beasley
David Zhao wrote: If I did this: Criteria crit = new Criteria(); crit.addJoin(Table1Peer.ID1, Table2Peer.ID2, Criteria.INNER_JOIN ); crit.addSelectColumn(Table1Peer.ID1); crit.addSelectColumn(Table2Peer.NAME); crit.addSelectColumn(Table2Peer.NOTES); List list = null; try { list =