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 09:03:31 GMT
Hi,

I got the info from this mailing list archive only. Please
see the link

http://www.mail-archive.com/turbine-user@jakarta.apache.org/msg07213.html

In villagexxx.jar you can find a class named Value.java where we have to
include the code given below by Shin Ohkubo. Make jar again and use it.

You can get the source code for village from CVS  as given in the link
http://share.whichever.com/index.php?SCREEN=village

Hope this helps you.

Regards,
Jaya


-----Original Message-----
From: Felipe Ramos [mailto:framos@tissat.es]
Sent: Wednesday, December 17, 2003 2:13 PM
To: Apache Torque Users List
Subject: Re: Problem with CLOB retreival


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






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