This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes DB2DBException on insert Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply 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: 16487
    
    2

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: 16487
    
    2

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://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: DB2DBException on insert
 
Similar Threads
storing BLOB type in oracle db
Insert French Characters
DATE
Please help me on this insert statement and pass it to the servlet
toString() operation in '+' operator