Large Data loads from an applet into a Oracle Database
SESHAGIRI KODUGANTI
I wanted to load a large chuck of textual data into a Oracle 8.0
Database. The table has a field with datatype long which as DB Admin with
support 2 MB of data loading. I am using Oracle 8.0 Thin JDBC driver. But
the it is unable to load the even a small file of data and instead gives me
this error
java.sql.SQLException: ORA-01704: string literal too long
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:184)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:631)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1206)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:6
)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.j
a:761)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStateme
.java:803)
at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1
5)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleState
nt.java:1178)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.ja
:1194)
at loadtest.ExecuteQuery(loadtest.java:48)
at loadtest.main(loadtest.java:63)
Any Ideas. How do you people load large amounts of data into databases.
Does Level 4 thin driver support large data loads ??
I would appreciate any help in this regard.
- Giri
gi...@newscorp.com