Google 網路論壇不再支援新的 Usenet 貼文或訂閱項目,但過往內容仍可供查看。

Large Data loads from an applet into a Oracle Database

瀏覽次數:0 次
跳到第一則未讀訊息

SESHAGIRI KODUGANTI

未讀,
1998年7月10日 凌晨3:00:001998/7/10
收件者:
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
gi...@newscorp.com

0 則新訊息