I am not sure if this is configuration issue or what, but our app in tomcat calls PreparedStatement.close().  JBoss 5.1/seam 2.2.0.GA on the other hand is not calling close NOR calling clearBatch and this looks like it is resulting in 3 updates(when the other 2 updates where already run before.  I have attached the logs(thanks to log4jdbc detail in these logs on every method call into jdbc), but is there a way to configure jboss to call clearBatch after executing it so the driver does not end up with more and more sql calls in it.

Is jboss expecting connection.commit to clear the preparedstatement which may not happen on some drivers that only clear it on clearBatch or close method calls?

partial logs(full logs don't fit)....no clearBatch or PreparedStatement.close in any of my jboss logs(my tomcat logs have close).

2010-02-25 13:22:23,599 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.getMaxRows() returned 0
2010-02-25 13:22:23,600 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.getQueryTimeout() returned 0
2010-02-25 13:22:23,602 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.setString(1, "CTI1E") returned 
2010-02-25 13:22:23,602 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.setString(2, "OP1998") returned 
2010-02-25 13:22:23,602 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.setString(3, "5020090501000974") returned 
2010-02-25 13:22:23,602 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.addBatch() returned 
2010-02-25 13:22:23,602 INFO  [jdbc.sqlonly] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] batching 3 statements: 1: update VOICELOG.Tpvtrans set calltypecd='CTI1E', OPERATORID='OP1998' 
where tpvid='5020090501000971' 2: update VOICELOG.Tpvtrans set calltypecd='CTI1E', OPERATORID='OP1998' 
where tpvid='5020090501000972' 3: update VOICELOG.Tpvtrans set calltypecd='CTI1E', OPERATORID='OP1998' 
where tpvid='5020090501000974' 
2010-02-25 13:22:23,638 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.executeBatch() returned [I@1db1d1c
2010-02-25 13:22:23,639 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.setLong(1, 1361) returned 
2010-02-25 13:22:23,639 INFO  [jdbc.sqlonly] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] select variables0_.SCRIPTMODELID as SCRIPTM16_1_, variables0_.VARIABLEDEFINITIONID as VARIABLE1_1_, 
variables0_.NAME as formula3_1_, variables0_.VARIABLEDEFINITIONID as VARIABLE1_240_0_, variables0_.defaultValue 
as defaultV2_240_0_, variables0_.displayRule as displayR3_240_0_, variables0_.displaySeq as 
displaySeq240_0_, variables0_.displayType as displayT5_240_0_, variables0_.FIXEDVARTYPE as 
FIXEDVAR6_240_0_, variables0_.LABEL as LABEL240_0_, variables0_.WIDGETTYPE as WIDGETTYPE240_0_, 
variables0_.NAME as NAME240_0_, variables0_.SECONDARYNUMVAL as SECONDA10_240_0_, variables0_.orderIndex 
as orderIndex240_0_, variables0_.SCRIPTMODELID as SCRIPTM16_240_0_, variables0_.QUESTIONID 
as QUESTIONID240_0_, variables0_.readOnlyFl as readOnlyFl240_0_, variables0_.requiredResponse 
as require13_240_0_, variables0_.VARTYPE as VARTYPE240_0_, variables0_.version as version240_0_ 
from VL_AGENT.VariableDefinitions variables0_ where variables0_.SCRIPTMODELID=1361 
2010-02-25 13:22:23,682 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.executeQuery() returned net.sf.log4jdbc.ResultSetSpy@185ff15
2010-02-25 13:22:23,731 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.getMaxRows() returned 0
2010-02-25 13:22:23,731 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.getQueryTimeout() returned 0
2010-02-25 13:22:23,732 INFO  [net.voicelog.entities.scripts.Variables] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] [tpvid:5020090501000974:ctiid:2010001390] [BrightHouse_FINAL] [i:0]read in key=fixed.BusinessName value was=null
2010-02-25 13:22:23,733 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.setString(1, "5020090501000974") returned 
2010-02-25 13:22:23,733 INFO  [jdbc.sqlonly] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] select tpvcalldat0_.TPVID as TPVID1_, tpvcalldat0_.displayseq as displayseq1_, tpvcalldat0_.displayseq 
as displayseq259_0_, tpvcalldat0_.TPVID as TPVID259_0_, tpvcalldat0_.displayrule as displayr3_259_0_, 
tpvcalldat0_.displaytype as displayt4_259_0_, tpvcalldat0_.label as label259_0_, tpvcalldat0_.secondaryvalue 
as secondar6_259_0_, tpvcalldat0_.tpvstartdt as tpvstartdt259_0_, tpvcalldat0_.value as value259_0_ 
from VOICELOG.Tpvcalldata tpvcalldat0_ where tpvcalldat0_.TPVID='5020090501000974' order by 
tpvcalldat0_.displayseq asc 
2010-02-25 13:22:23,769 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.executeQuery() returned net.sf.log4jdbc.ResultSetSpy@18369b5
2010-02-25 13:22:23,769 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.getMaxRows() returned 0
2010-02-25 13:22:23,769 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.getQueryTimeout() returned 0
2010-02-25 13:22:23,769 INFO  [net.voicelog.entities.scripts.Variables] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] [tpvid:5020090501000974:ctiid:2010001390] [BrightHouse_FINAL] [i:0]read in key=Inter value was=null
2010-02-25 13:22:23,770 INFO  [net.voicelog.entities.scripts.Variables] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] [tpvid:5020090501000974:ctiid:2010001390] [BrightHouse_FINAL] [i:0]read in key=fixed.OperatorLastName value was=Operator
2010-02-25 13:22:23,770 INFO  [net.voicelog.entities.scripts.Variables] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] [tpvid:5020090501000974:ctiid:2010001390] [BrightHouse_FINAL] [i:0]read in key=Local value was=null
2010-02-25 13:22:23,776 INFO  [jdbc.audit] (http-0.0.0.0-8080-1) [player][session:2e2A__][OP1998] 5. PreparedStatement.setString(1, "5020090501000974") returned