db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Felipe Ramos" <fra...@tissat.es>
Subject Re: Problem with CLOB retreival
Date Wed, 17 Dec 2003 08:42:51 GMT
I have some questions....

Changing the code in village? What's village?  Where I must retrieve the 
result as a oracle.sql.CLOB?

Could you please, give a list of steps to follow?  It would be wonderful !!

I really am very interesting in the same topic.


Jaya wrote:

>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
>
>
>  
>

-- 
------------------------
Felipe Ramos
Tissat SA
C/ Orense 34-9ยช
28020 Madrid
Tel: (+34) 91 4175913 
Fax: (+34) 91 4172914
Mail: framos@tissat.es
------------------------



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message