Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB2DBException on insert

 
hrishikesh deodhar
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic