File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes DB2DBException on insert Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2DBException on insert " Watch "DB2DBException on insert " New topic
Author

DB2DBException on insert

hrishikesh deodhar
Greenhorn

Joined: Feb 27, 2007
Posts: 11
I am trying to fire an insert statement from within the webapplication
and i am getting the following error

ca.kraft.util.manager.data.sql.exception.DatabaseQueryException: SQLException performing query[INSERT INTO xlibemfcrp/WEBTO (sourceWarehouseId,sourceWarehouseName,wtoType,criteriaLocation,criteriaPONumber,criteriaReleaseNumber,creationDate,creatorId,creatorName,status) values (?,?,?,?,?,?,?,?,?,?)] using args[[CO, COBOURG WAREHOUSE, 2, WTO0606, Null sql type:1, Null sql type:1, 2007-06-06 14:08:27.715, MOSCHOP, Moschovas, Philip, In Preparation]],
Exception[
com.ibm.db2.jdbc.app.DB2DBException: WEBTO in XLIBEMFCRP not valid for operation.],
Message[WEBTO in XLIBEMFCRP not valid for operation.],
SQLState[55019],
ErrorCode[-7008].].

i dont know what this is, can anybody tell me?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18563
    
    8

It's an error message that tells you that the insert statement failed, and provides some cryptic reasons why it failed.

From the classname ("ca.kraft...") I guess you are not the person who is solely responsible for DB2 there. It would be best if you found a database administrator and discussed this message with them.
hrishikesh deodhar
Greenhorn

Joined: Feb 27, 2007
Posts: 11
no, these are the classes that were designed and coded by us...
we are using a V5r2 native driver to connect to the AS400 database...
and i dont know why it is doing that to only a single application....
it works fine when we are querying the database but then it bombs when we try to do an insert..
i searched on the SQL state on the iSeries documentation
and the 7008 asks for the journaling to be on.
now i am not sure if this is what i am supposed to do, is it a datasource issue or an issue with rights on the table..
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18563
    
    8

Originally posted by hrishikesh deodhar:
now i am not sure if this is what i am supposed to do, is it a datasource issue or an issue with rights on the table..
I don't know, but as far as I can see it isn't a Websphere issue, right? So I'm going to move it to the JDBC forum.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB2DBException on insert