Java Sql Exception

Question

I am trying to retrieve thexml from oracle db and then trying to insert the same xml into the Oracle Database different table. The select via clob is working fine but its throwing an error while updation.

java.sql.Clob myClob = null;
connect = DriverManager.getConnection(str2, str3, str4);
String sql = "select xml from table1 where id='3|32'";
stmt = connect.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
    myClob = rs.getClob("XML"); // This part is working fine.


    //Updation


    connect1 = DriverManager.getConnection(str22, str33, str44);
    String query1 = "update documentsout set xml = ?   " +
        "where  id = ? ";
    stmt1 = connect1.prepareStatement(query1);
    stmt1.setString(1, myClob); // Inserting the same CLOB
    stmt1.setString(2, id);
    stmt1.executeUpdate();      // ERROR HERE

The error is

java.sql.SQLException: ORA-00600: internal error code, arguments: [kglgtbo1], [0x700000482AA4608], [], [], [], [], [], [], [], [], [], []

Can you please help?

@Gourav were you able to figure this out? I'm suffering the same problem (albeit for an insert). .setString() & .setClob() - neither working for me. — inyourcorner
– inyourcorner, Commented Jan 5, 2017 at 18:33

manchicken · Accepted Answer · 2013-08-29 13:43:21Z

2

You should contact your DBA and/or Oracle support representative. According to the documentation on this ORA-00600 error, this is actually an internal problem with Oracle itself.

Source: http://www.orafaq.com/wiki/ORA-00600

answered Aug 29, 2013 at 13:43

manchicken

1556 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ashish Chaurasia · Accepted Answer · 2013-08-29 13:46:13Z

0

use this

stmt.setClob(position, clob);

instead of

 stmt1.setString(1, myClob);

answered Aug 29, 2013 at 13:46

Ashish Chaurasia

1,74717 silver badges24 bronze badges

3 Comments

Gourav Over a year ago

I did try with set clob also

Gourav Over a year ago

stmt1.setClob(1, myClob); but same result

Ashish Chaurasia Over a year ago

stackoverflow.com/questions/5549450/… , see this may be it help you

Rakesh Soni · Accepted Answer · 2013-08-29 13:46:42Z

0

you will have to use the setClob method

  // get clob
  java.sql.Clob clob = (java.sql.Clob) rs.getObject(1);

  // set clob
  String query = "insert into clob_table(id, clob_column) values(?, ?)";
  pstmt = conn.prepareStatement(query);
  pstmt.setString(1, newID);
  pstmt.setClob(2, clob);

answered Aug 29, 2013 at 13:46

Rakesh Soni

11k6 gold badges48 silver badges53 bronze badges

1 Comment

Gourav Over a year ago

Rakesh....as I stated in my last comment...i did try setClob but it still doesn't work

inyourcorner · Accepted Answer · 2017-01-05 18:54:39Z

0

This may have limitations, but it worked for my situation. Below, srcValue is the value read from the source (src), which was a clob field, and stmt is the prepared statement i'm using (in my case, an insert). The target (tgt) is also a clob field.

        Clob srcClob = (Clob)srcValue;
        Clob tgtClob = stmt.getConnection().createClob();
        tgtClob.setString(1, srcClob.getSubString(1, (int)srcClob.length()));
        stmt.setClob(icol, tgtClob);

I believe clobs are tied to connections/sessions in some way, which requires the workaround. If there's a better way I'm all ears.

answered Jan 5, 2017 at 18:54

inyourcorner

6939 silver badges27 bronze badges

Collectives™ on Stack Overflow

Java Sql Exception

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related