jboss5.1 hidden but(no exceptions, but bad results)...
deanhiller2000 Feb 25, 2010 9:24 PMI 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