How do i get clob data using java and assign to a variable

[r035198x]

CAN U TELL ME WAT IS WRONG WITH THE CODE.
THE CODE IS NOT EXECUTING


pstmt=con.prepa reStatement("IN SERT INTO TABLE values('','','' ,?,'','','')");
oracle.sql.CLOB newClob =oracle.sql.CLO B.createTempora ry(con, false, oracle.sql.CLOB .DURATION_CALL) ;
newClob.putStri ng(1,VALUE);
pstmt.setClob(4 , newClob);
int rowcnt = pstmt.executeUp date();

THANK U IN ADVANCE

What is the full Exception that you get when you execute it?

[kanthi84]

Getting the item ParentID:java.l ang.NullPointer Exception

[r035198x]

Getting the item ParentID:java.l ang.NullPointer Exception

Now which line in your code is giving that exception.

[kanthi84]

THE EXCEPTION IS GETTING AFTER THE FOLLOWING LINE


oracle.sql.CLOB newClob =oracle.sql.CLO B.createTempora ry(con, false, oracle.sql.CLOB .DURATION_CALL) ;

AFTER THIS LINE,ST.CLOSE() IS EXCECUTED AND EXCEPTION IS DISPLAYED

[r035198x]

THE EXCEPTION IS GETTING AFTER THE FOLLOWING LINE


oracle.sql.CLOB newClob =oracle.sql.CLO B.createTempora ry(con, false, oracle.sql.CLOB .DURATION_CALL) ;

AFTER THIS LINE,ST.CLOSE() IS EXCECUTED AND EXCEPTION IS DISPLAYED

If you are sure that's the line throwing the nullpointer exception then check your value of con. It could be the one that is null at the time of call. Where are you getting it from?

[kanthi84]

con=DBConnectio n.getConnection ();

[kanthi84]

con=DBConnectio n.getConnection ();


THIS IS THE STATEMENT FOR GETTING CONNECTION.
AND THE CONNECTION IS CLOSED ONLY AFTER THOSE STATEMENTS.

[r035198x]

con=DBConnectio n.getConnection ();


THIS IS THE STATEMENT FOR GETTING CONNECTION.
AND THE CONNECTION IS CLOSED ONLY AFTER THOSE STATEMENTS.

You might have the post all the code then ...

[kanthi84]

private void Details(String A,String B,String C,String D)
{
Clob tempClob = null;
try
{
con=DBConnectio n.getConnection ();

pstmt=con.prepa reStatement("IN SERT INTO TABLE values('','"+A+ "','',EMPTY_CLO B(),'"+B+"','"+ D+"','')");
tempClob = (Clob) oracle.sql.CLOB .createTemporar y(con, false,oracle.sq l.CLOB.DURATION _SESSION);
((oracle.sql.CL OB) tempClob).putSt ring(1, C);
pstmt.setClob(4 , tempClob);
pstmt.executeUp date();
}

catch(SQLExcept ion e)
{
System.out.prin tln("Getting the item ParentID:"+e);
}
catch(Exception e)
{
System.out.prin tln("Getting the item ParentID:"+e);
}
finally
{
try{
pstmt.close();
st.close();
con.close();
}catch(SQLExcep tion e)
{
System.out.prin tln(e);
}
}
}