How to do I insert a long string into a table from Java?

From: Anastasios Kotsikonas <tasos_at_csa.bu.edu>
Date: 29 Jun 1999 20:44:47 GMT
Message-ID: <7lbb7v$13s$1@news1.bu.edu>

Hi all,

one of the most frustrating issues I am dealing with has to do with inserting large strings (like 500K) into a column from Java; whatever the datatype (LONG or NCLOB) the driver throws the exception:

listMsg::send(): java.sql.SQLException: ORA-01704: string literal too long

        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:181)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:631)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1221)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:657
)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:770)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement
.java:812)
        at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:115
4)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1187)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java

:1203)

any suggestions?

thanks

tasos Received on Tue Jun 29 1999 - 15:44:47 CDT