Don't use LONG, unless you are on an old unsupported version of Oracle and
can't upgrade.
LONGs are stored inline and make for poor performance if they are large and
you ever do full tablescans.
Instead, use LOBs (either BLOB or CLOB) and the code to load those can be
cribbed from http://technet.oracle.com
Thor HW
----- Original Message -----
From: "Jos� Antonio Quiles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 31, 2000 12:42 AM
Subject: Writing long strings in Oracle
> Hello,
> we are trying to insert a huge string in an Oracle LONG field via JDBC; we
> are using PreparedStatement.setString().
> However, when the string length is longer than 2000 characters, a JDBC
> exception is raised.
> We thought that Oracle LONG field supports any string length...
> What is the problem?
>
> Thank you in advance,
>
> Jose Antonio Quiles
> Telefonica I+D
> Madrid, Spain
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> 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
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> 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
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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
