java.sql.BatchUpdateException

Hello,

I'm using postgresql-8.1-404.jdbc3.jar driver with the postgreSQL 8.1.0 server.

I run the same source code that successfully executes under Oracle and hsqldb. However, when I run it under postgresql, I get following error:

nested exception is: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO test_stream (id, code, start_utc, end_utc, start_local, end_local, tz_code, update_session) VALUES (302432-1, DOCK, 20041209100000, 20041209115715, 20041209040000, 20041209055715, SD, 20051221_21) was aborted. Call getNextException to see the cause.;

I found one reference to the similar error but it seemed from a long time ago and driver's source code didn't reflect it.

http://archives.postgresql.org/pgsql-patches/2001-08/msg00461.php

I will appreciate if anybody can help me with this issue.

Snapshot of my source code:

++++++++++++++++++++++++++++++++++++++++++++++++

public void storeIntervals(Iterator iterator)
throws CtFatalException
{
String insertQuery =
"INSERT INTO test_stream (id, code, start_utc, end_utc, " +
"start_local, end_local, tz_code, update_session) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

String updateQuery =
"UPDATE test_stream SET id = ?, code = ?, " +
"start_utc = ?, end_utc = ?, start_local = ?, end_local = ?, tz_code = ?, " +
"update_session = ? WHERE motion_gnmbr = ?";

JdbcBatchManager insertBatchManager = new JdbcBatchManager();
JdbcBatchManager updateBatchManager = new JdbcBatchManager();

PreparedStatement insertStmt = null;
PreparedStatement updateStmt = null;

try
{
insertStmt = connection.prepareStatement(insertQuery);
updateStmt = connection.prepareStatement(updateQuery);

while (iterator.hasNext())
{
CafMotionInterval mi = (CafMotionInterval) iterator.next();
updateEarliestProcessedStartUtc(mi);
touchedPanelists.add(mi.getPanelistId());
reconcileAccum.min(mi.getPanelistId(), mi.getStartUtc());

if (mi.getKey() == null)
{
_addBatchInsertCafMotionInterval(insertStmt, mi);
insertBatchManager.addBatch(insertStmt);
}
else
{
_addBatchUpdateCafMotionInterval(updateStmt, mi);
updateBatchManager.addBatch(updateStmt);
}
}

updateStmt.executeBatch();
insertStmt.executeBatch();

}
catch (SQLException e)
{
throw new CtFatalException("Failure in storeCafMotionItervals", e.getNextException());
}
finally
{
JdbcUtility.close(insertStmt);
JdbcUtility.close(updateStmt);
}
}

In JdbcBatchManager:

public void addBatch(PreparedStatement pStmt)
throws SQLException
{

if (maxUnexecutedCount <= unexecutedCount)
{
pStmt.executeBatch();
unexecutedCount = 0;
}

unexecutedCount++;
pStmt.addBatch();
}

+++++++++++++++++++++++++++++++++++++++++++++++++

Thank you.

Stella.