Hello Gemma,
Tuesday, June 19, 2001, 7:08:13 PM, you wrote:
GM> Hi, I am new with JSP and I am trying to connect with Access and my
GM> problem is that i have a record of type "Memo" and I don`t
GM> Know how to get it
GM> If it was String, I will have to use resultset.getString("name")
GM> and with Memo? resultset.getXXX
Access is not good way.. Just as odbc bridge from sun.
I think that memo mapped to the java.sql.Clob - use this class to work
with it.
Clob clob = (Clob)rs.getObject( "document_text" );
InputStream is = clob.getAsciiStream();
byte[] result = new byte[ is.available() ];
is.read( result, 0, is.available() );
text = new String( result );
--
Best regards,
Oleg mailto:[EMAIL PROTECTED]
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
