Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[IBM][CLI Driver][DB2/SUN] SQL0010N SQLSTATE=42603 Error.

10 views
Skip to first unread message

Sanjay

unread,
Sep 10, 2001, 12:34:41 AM9/10/01
to
I am trying to insert records using JDBC in a java program and am
getting the following error.

java.sql.SQLWarning:
[IBM][CLI Driver][DB2/SUN] SQL0010N
"'TXNKIND=31&DATE=2001%2f09%2f10%2013%3a16%3a14&CENTERID=2000&CENTER_T"
で始まるストリング定数に、終わりの区切り文字
がありません。
SQLSTATE=42603

Server StackTrace:
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(SQLException.java:43)
at java.sql.SQLWarning.<init>(SQLWarning.java:37)

The insert statement is as follows:
INSERT INTO IOLOG_TBL (SRDATE, SRTIME, SRFLG, SRLENGTH, SRDATA) VALUES
('20010910', '131509422', '2', '140',
'TXNKIND=31&DATE=2001%2f09%2f10%2013%3a16%3a14&CENTERID=2000&CENTER_TRNID=9100063c&RECEIVECODE=0&RESPONSEID=y0ca8qxSZn1nSqcC5WY%2b8g%3d%3d')

Can someone please let me know what is wrong here ?

0 new messages