SQLException on inserting string using JDBC

From: Mukul Sood <msood_at_iframe.com>
Date: Fri, 04 Feb 2000 15:44:11 -0500
Message-ID: <389B3A1A.1E81F5E2@iframe.com>

Hello All,

I am having problems inserting a large string, size 64kb, in Oracle 8.0.5
database.
I'm using a PreparedStatement to do the insert. pstmt.setString(1, myString)

This is the error message -
java.sql.SQLException: data size bigger than max size for this type

I'm using Oracle thin driver for Oracle 8.0.5 - classes111b.zip My schema looks like this -
Table Name - TestTable
Column Name - TestString
datatype - LONG

The Oracle LONG datatype supports upto 2gb of char data, so am not sure why I get this error.

Pls. let me know if there is any workaround, or there's some version of Oracle driver which fixes this problem.

Thnx.

Mukul Received on Fri Feb 04 2000 - 14:44:11 CST