I am having an issue with the Informix JDBC driver and wondering if anyone
else has it or has a solution to my problem. I have a method that fills a
preparedstatement with insert SQL ( prepare a Insert statement and then use
setXXX, addBatch() ). At the end of the loop, I perform the executeBatch().
The problem is, the loop may not have anything to insert into the
preparedStatement so there are times when the executeBatch() will have
nothing to execute. The problem I have is that, in this case, it throws a
SQLException indicating a null pointer.

SEVERE: ImportServices.CmptrImport.processItem
Trace stack
java.sql.BatchUpdateException: System or internal error
java.lang.NullPointerException
at
com.informix.jdbc.IfxPreparedStatement.executeBatch(IfxPreparedStatement.jav
a:3070)
at ImportServices.CmptrImport.processItem(CmptrImport.java:258)
at ImportServices.CmptrImport.processCompetitors(CmptrImport.java:159)
at ImportServices.CmptrImport.run(CmptrImport.java:104)
at java.lang.Thread.run(Thread.java:536)

This SQLException does not occur when using SQL Server ( JDBC driver from
DataDirect ). I read the thread about the internals of the preparedStatement
and know I can't see whats being sent to the DB, but can I find out if there
are ANY statements to process? I suppose I can have a counter to keep track
of this, but was wondering why it was throwing an exception. I did not read
anything in the JDBC doc that says it should.

Mel Haynes Jr