File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes On SQL Error 407 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "On SQL Error 407" Watch "On SQL Error 407" New topic

On SQL Error 407

Deena Raj

Joined: Mar 01, 2007
Posts: 7
I am getting SQLException with error code 407 when trying to insert value to a table. I do not know the values in the insert query (it is in the production environment) so I cant figure out value which is null. The exception trace is : DB2 SQL error: SQLCODE: -407, SQLSTATE: 23502, SQLERRMC: TBSPACEID=9, TABLEID=5, COLNO=24. From this statement can i find out the column which is causing the issue (the column which is null). Does COLNO=24 indicate that the 24th column in the insert query was null?
Jan Cumps

Joined: Dec 20, 2006
Posts: 2541

In general, this error does indeed indicate that column #24 was null, but needs a value.
It can also be caused by a known program error.
Regards, Jan

OCUP UML fundamental and ITIL foundation
It is sorta covered in the JavaRanch Style Guide.
subject: On SQL Error 407
It's not a secret anymore!