Large Data loads with JDBC and ORACLE

From: SESHAGIRI KODUGANTI <giri_at_newscorp.com>
Date: Tue, 7 Jul 1998 15:23:10 -0400
Message-ID: <6ntso2$c8j$1@fisher.nis.newscorp.com>

Hello friends,

    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 giri_at_newscorp.com

Received on Tue Jul 07 1998 - 14:23:10 CDT