Problem when insert data - SQLSTATE 42704

talex · #1 (**permalink**) 07-18-08, 18:59

hi ,

I've a WebSphere server and connect to DB2 using passw.

DOC table structure:

CREATE TABLE DB1.DOC
(DOC_ID BIGINT NOT NULL )
DATA CAPTURE NONE
IN USERSPACE1;

ALTER TABLE DB1.DOC
LOCKSIZE ROW
APPEND OFF
NOT VOLATILE;

ALTER TABLE DB1.DOC
ADD CONSTRAINT PK_DOC PRIMARY KEY
(DOC_ID);

in java code i call insert into DB1.DOC(doc_template_id) values (23);

Here is an exception message:

Exception data: javax.ejb.EJBException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB1.DOC

and as i know => SQLSTATE 42704: An undefined object or constraint name was detected.

Help needed, thx!

Marcus_A · #2 (**permalink**) 07-18-08, 19:52

According to your DDL, the column name is DOC_ID. In your insert statement, you called it doc_template_id.

talex · #3 (**permalink**) 07-21-08, 12:30

Quote:

Originally Posted by Marcus_A

According to your DDL, the column name is DOC_ID. In your insert statement, you called it doc_template_id.

Thx for help. The problem was in code, more in Eclipse IDE, it was needed to stop, clean than build and only after start server to apply changes.
Nothing with DB issues.

Internet Services

Web Development

Digital Marketing

Consumer Tech