DB2/400 inserts fail with Torque code

2004-01-21 Thread Vikas Phonsa
Hi, I can't insert data into my DB2/400 using the torque generated classes. The reason is the ResultSetMetaData obtained from the ResultSet returned by the Select statement before the Inserts in Torque code, gives all my columns to be readOnly. This is not pointed out in the exception sta

java.lang.StringIndexOutOfBoundsException: String index out of range: 23

2004-01-21 Thread mohan
Hi All I am getting this error java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) at org.postgresql.jdbc2.ResultSet.toTimestamp(ResultSet.java:1653) at org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.ja

Re: How to use trim in select clause

2004-01-21 Thread Dave Newton
On Wed, 2004-01-21 at 01:00, John Varghese wrote: > What is the Torque equivalent for the following > select query run from sql prompt > - > > select * from product_revision where UPPER(TRIM(REVISIO

Re: n-to-n relationship howto

2004-01-21 Thread Hartwig, Thomas
Ok, I found the solution. I have seen that Torque does generate the methods getABs() in both BaseA and BaseB which returns the approbiate collection which then contains the methods getA() and getB(). Thomas Hartwig, Thomas wrote: Hello, I'm sure there are a lot of users already needed a n-to-n

n-to-n relationship howto

2004-01-21 Thread Hartwig, Thomas
Hello, I'm sure there are a lot of users already needed a n-to-n relationship solution. Does Torque support this with a useable modell or do I have to implement this. I have looked thru the docs but all I found was: 1-to-n Schema suggestion with a n-to-n relation, but this is not enough I'm afr

AW: Criteria question...

2004-01-21 Thread Michael Burschik
This problem seems to pop up every few months. Can't some maintainer patch the distributed source to allow for something used this often? Especially since the change is so small. Regards Michael Burschik > -Ursprungliche Nachricht- > Von: Andres Quijano - Rizonet [mailto:[EMAIL PROTECTED