Skip to Content
0
Former Member
Sep 08, 2007 at 07:30 AM

Error : Inserting data in to DB2

123 Views

Hello all,

Iam trying to insert data to Db2 Database using the JDBC adapter.

But It is throwing an error :

<b>

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAPTESTLIB.SEFPTINDT' (structure 'Statement'): java.sql.SQLException: [SQL0104] Token 1 was not valid. Valid tokens: ) ,</b>

SAPTESTLIB is the Library name

SEFPTINDT table name

I have tried giving the SAPTESTLIB/SEFPTINDT even then it is giving the same error.

Generated Log ::

INSERT INTO SAPTESTLIB.SEFPTINDT (ITSTTS, ITOVRD, ITDIVSN, ITINNO, ITINSLNO, ITINDT, ITINTY, ITORTY, ITORNO, ITORDT, ITMOCD, ITCHAS, ITVIN, ITCUST, ITUSN, ITJBNO, ITJBCD, ITJBTY, ITPTNO, ITPTNM, ITQNTY, ITUOM, ITJBSTDT, ITJBSTTM, ITRGNO, ITCUGR, ITVHTY, ITLVTY, ITPTFRAN, ITPTBRCD, ITPNABRCD, ITPNAFRAN, ITPNANO, ITRFDOCTY, ITRFDOCNO, ITSPED, ITQTFRAN, ITQTBRCD, ITQTPX, ITQTNO, ITSPLIT, ITWRCAT, ITOVRRSCD, ITUSID, ITRCDT, ITRCTM, ITLUDT, ITLUTM, ITLUPG) VALUES (C, C, C, Str 2, 11, 19990124, C, C, Str 1, 19990124, Str 7, Str 5, Str 6, Str 15, This is a string 10, C, Str 12, C, Str 13, Str 14, 16, C, 19990124, 153345, Str 8, C, C, Str 9, C, 17, 22, C, Str 23, C, Str 19, 24, C, 20, Str 21, Str 21, C, C, Str 4, Str 3, 19990124, 153345, 19990124, 153345, Str 25)

Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAPTESTLIB.SEFPTINDT' (structure 'Statement'): java.sql.SQLException: [SQL0104] Token 1 was not valid. Valid tokens: ) ,.

nable to execute statement for table or stored procedure. 'SAPTESTLIB.SEFPTINDT' (Structure 'Statement') due to java.sql.SQLException: [SQL0104] Token 1 was not valid. Valid tokens: ) ,.

Regards

Gangaprasad