1 Reply Latest reply on Feb 25, 2010 9:25 PM by Dean Hiller

    jboss5.1 hidden but(no exceptions, but bad results)...

    Dean Hiller Expert

      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