Db2 Sql Error Sqlcode=-798 Sqlstate=428c9
Contents |
question and get tips & solutions from a community of 418,478 IT Pros & db2 sql error sqlcode 104 sqlstate 42601 Developers. It's quick & easy. Autoincrement DB2 JBOSS EJB CMP P:
Db2 Sql Error Sqlcode 206 Sqlstate 42703
n/a Grzes_P J have database DB2 and create table T_TEST with fields: ID - integer autoincrement db2 sql error sqlcode 407 sqlstate 23502 NAME - varchar(50) QTY - Integer I create java bean CMP and install it on Jboss server and when create new record from client I get error: http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n798.html com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -798, SQLSTATE: 428C9, SQLERRMC: ID I get the same error when execute command: Insert into T_test (id,name,qty ) values (10,'OK',12) and when execute : Insert into T_test (name,qty ) values ('OK',12) .... all is OK!!! how to configure Jboss ? Please Help!!! thanks Mar 2 '07 #1 Post Reply Share https://bytes.com/topic/db2/answers/610669-autoincrement-db2-jboss-ejb-cmp this Question 1 Reply P: n/a db2admin you are specifying value for column which is supposed to be auto generated that is the cause of error you are getting here is the explanation from db2 ================================================== ======= SQL0798N A value cannot be specified for column " UTC Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group driver VJ22-Aug-2007, 14:15I've eDir 8.8 & IDM 3.5 I've DB2 (ver8) installed on Solaris. I've imported and configured JDBC IDM Driver. Mapped table & columns with eDir class and attributes. when I insert record in DB table, its creating user in eDir. But when I create user in eDir its giving error in trace and not inserting record in Table. Here is what the error message I'm getting in trace