torque-3.1.zip archives

2003-12-16 Thread Edwin Yearwood
Hi, We're investigating torque-3.1 as a strategic solution, but have noticed that the .zip archive is missing a number of resources specifically the /schema, /templates, build.properties and build-torque.xml directories and files respectively. 1) Is there a reason for this since it cause

AW: Criteria.addAscendingOrderByColumn(field) NullPointerEx

2003-12-16 Thread Gerhard Otte
Hello Rolf I faced the same problem here - NullPOinter Exception when using addAscendingOrderByColumn(). After putting the line torque.database.LVS.adapter=mssql (where LVS is the Name of my database using SQL Server) into my configuration file the problem didn't come up again. I think it has to

Problem with CLOB retreival

2003-12-16 Thread Jaya
Hi, We are using Torque with Oracle 8.1.7. But we are facing problem with CLOB retreival. It returns null when the column is retrieved as a string. We tried some workarounds like changing the data type to LONGVARBINARY in schema.xml. But it didn't work out. If any one knows the solution for this

Problem with CLOB retreival

2003-12-16 Thread Jaya
Hi, We are using Torque with Oracle 8.1.7. But we are facing problem with CLOB retreival. It returns null when the column is retrieved as a string. We tried some workarounds like changing the data type to LONGVARBINARY in schema.xml. But it didn't work out. If any one knows the solution for

AW: Problem with CLOB retreival

2003-12-16 Thread Michael Beier
Hi, a possible Solution would be to switch your CLOB field to LONG RAW in Oracle and in your schema.xml leave it on LONGVARBINARY. This should help to load and store large binary data (even if null). We used this workaround. Maybe someone else can help, if you can not edit your database schema.

RE: torque-3.1.zip archives

2003-12-16 Thread Edwin Yearwood
Hi, yes that's right I am talking about the torque-3.1.zip. If I've understood you correctly that means we need to extract both the torque-3.1.zip and torque-gen-3.1.zip archives before using the application, right? I don't think the tutorial guide emphasises this?. Thanks. Edwin Yearwood

Re: torque-3.1.zip archives

2003-12-16 Thread Bogdan Vatkov
Yep , documentation is not clear enough in all cases ..but yes you will have to dowlonad torque-gen-3.1.zip in order to obtain the torque peer classes generator. You will define your database schema and generate corresponding java classes and sql statements inside torque-gen distribution define

Re: Problem with CLOB retreival

2003-12-16 Thread Bill Leng
try datadirect's jdbc driver Jaya wrote: Hi, We are using Torque with Oracle 8.1.7. But we are facing problem with CLOB retreival. It returns null when the column is retrieved as a string. We tried some workarounds like changing the data type to LONGVARBINARY in schema.xml. But it didn't work

RE: Problem with CLOB retreival

2003-12-16 Thread Shin Ohkubo
Hi, I was facing the same problem the other day. I retrieved the result as a oraqle.sql.CLOB, and then used the getSubString method. Object o = rset.getObject(2); if (o instanceof CLOB) { CLOB clob = (CLOB) o; System.out.println(SOURCE Length: +

RE: Problem with CLOB retreival

2003-12-16 Thread Jaya
Hi, Thanks a lot. It is working by changing the code in village as you have said. Regards, Jaya. -Original Message- From: Shin Ohkubo [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 5:59 AM To: 'Apache Torque Users List' Subject: RE: Problem with CLOB retreival Hi, I