Large data entry issue

[francan00]

My Form entry uses a Clob data type. The insert always works using
Java PreparedStatement if the form entry is under 4000 characters.
The database is Oracle 9i using ojdbc14 driver on my Tomcat web
container.
Due to restrictions I cant update the ojdbc14 driver at this time.

The issue is when the Form entry is over 4000 characters it wont enter
any data into the database. The error message I get -> SQL Exception:
Data size bigger than max size for the type: 12463

Please advise how I can make it work?

 

[Arne Vajhøj]

My Form entry uses a Clob data type. The insert always works using
Java PreparedStatement if the form entry is under 4000 characters.
The database is Oracle 9i using ojdbc14 driver on my Tomcat web
container.
Due to restrictions I cant update the ojdbc14 driver at this time.

The issue is when the Form entry is over 4000 characters it wont enter
any data into the database. The error message I get -> SQL Exception:
Data size bigger than max size for the type: 12463

I have once used this technique:

stmt.executeUpdate("INSERT INTO lobbo VALUES(1,EMPTY_CLOB())");
ResultSet upd = stmt.executeQuery("SELECT txt FROM lobbo WHERE id=1 FOR
UPDATE");
upd.next();
PrintWriter pw = new
PrintWriter(((oracle.sql.CLOB)upd.getClob(1)).getCharacterOutputStream());
pw.println("yada yada");
pw.close();
con.commit();

Arne

 

[francan00]

I have once used this technique:

stmt.executeUpdate("INSERT INTO lobbo VALUES(1,EMPTY_CLOB())");
ResultSet upd = stmt.executeQuery("SELECT txt FROM lobbo WHERE id=1 FOR
UPDATE");
upd.next();
PrintWriter pw = new
PrintWriter(((oracle.sql.CLOB)upd.getClob(1)).getCharacterOutputStream());
pw.println("yada yada");
pw.close();
con.commit();

Arne

Thanks I will try it tomorrow. Is oracle.sql.Clob class in Java 1.4
because that is the version I am using.

 

[Arne Vajhøj]

Thanks I will try it tomorrow. Is oracle.sql.Clob class in Java 1.4
because that is the version I am using.

It is not in any Java version.

But it is in the Pracle JDBC driver for Java 1.4 (ojdbc14.jar).

Arne