What Oracle driver are you using? The JDBC Thin driver from Oracle has a
problem dealing with CLOB datatypes. Try using the JDBC OCI driver. It has
to be installed on the client I think. I have not had personal experience
with CLOBs, this information comes from fellow engineers who have.
Regards,
Frank
-----Original Message-----
From: Amar Das [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 1:22 PM
To: [EMAIL PROTECTED]
Subject: Displaying CLOB values
The following query retruns part of DEF (clob) field when done from oracle
SQL*plus window. I did the same qyery from my jsp page and tried to get
the value. But all I get is null. Why?
Select def from table_name;
Now <%=rs.getString("DEF") %> returns null.
Thank you
Amar
====================================================================
++ Amarjyoti Das
++ email: [EMAIL PROTECTED]
++ phone: (207) 594-3048 x 30
++ fax:(207) 594-3021
++ web: www.stgeorgeconsulting.com
====================================================================
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
