| 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
|
|
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
|
|
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.
|
 |
 |
|
|
subject: DB2DBException on insert
|
|
|