Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

DB2DBException on insert

 
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?
 
Marshal
Posts: 25682
69
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
Marshal
Posts: 25682
69
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.
    Bookmark Topic Watch Topic
  • New Topic