JDBC executeBatch() restriction???

[luvcal]

Is there a restriction on the number of rows I am allowed to insert into a table using Statement.executeBatch()? I was able to insert 273 rows into a DB2 table, but anything greater than that resulted in a CLI0118E Invalid SQL syntax. SQLSTATE=37000 error. Please help me!!

Thanks a bunch

 

[MarcLodge]

Luvcal,
As far as I am aware there is not a limit. I'd be more inclined to examine your 274th record for something weird
Marc

 

[Guest_imported]

Hi

I have encountered the same problem
but with 2000 insert SQL.

I think maybe something to do with
the max length?

I am still looking for a solution

Jacinle

 

[MarcLodge]

Jacinle,
I suspect you may have a JBDC/ODBC limit on the number of records that you are allowed to insert. 2000 is just to round a number!
hth
Marc