Forums Register Login

DB2DBException on insert

+Pie Number of slices to send: Send
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?
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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..
+Pie Number of slices to send: Send
 

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 found a beautiful pie. And a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1759 times.
Similar Threads
storing BLOB type in oracle db
Please help me on this insert statement and pass it to the servlet
Insert French Characters
toString() operation in '+' operator
DATE
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 08:35:22.