db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jaya" <j...@gft.com>
Subject RE: Problem with CLOB retreival
Date Wed, 17 Dec 2003 06:01:52 GMT
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:sh.okubo@po1.iftc.co.jp]
Sent: Wednesday, December 17, 2003 5:59 AM
To: 'Apache Torque Users List'
Subject: RE: Problem with CLOB retreival


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: " + clob.length());
		String content = clob.getSubString(1, (int)
clob.length());
		System.out.println("SOURCE: " + content);
	}

hth,

SO

>> -----Original Message-----
>> From: Jaya [mailto:Jayalakshmi@gft.com] 
>> Sent: Tuesday, December 16, 2003 9:13 PM
>> To: torque-user@db.apache.org
>> Subject: Problem with CLOB retreival
>> 
>> 
>> 
>> 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,please let me know.
>> 
>> Thank You.
>> 
>> Regards,
>> Jaya.
>> 
>> 
>> 
>> 
>> ---------------------------------------------------------------------
>> 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