Announcement Announcement Module
Collapse
No announcement yet.
Connectionpooling - Db2 issue under load Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Connectionpooling - Db2 issue under load

    We are trying to execute a load test on Tomcat server which connects to DB2 database.
    Under load, we are getting the below exception:

    ERROR ; pool-1-thread-23; ?; XXXX; 2011-09-29 04:30:16,732 ; XXXX{msg: select failed with SQLException, iid: null, t: 0, code: null, loc: null, cat: null, srv: null, op: ViewStatus, sinf: WWW;D;82927, extra: {SQL=<<select query removed for security reasons>>, SQLErrorCode=-805, SQLState=51002, SQLException=DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH214 0X5359534C564C3031} }
    com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH214 0X5359534C564C3031
    at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
    at com.ibm.db2.jcc.b.gb.o(gb.java:747)
    at com.ibm.db2.jcc.b.gb.g(gb.java:143)
    at com.ibm.db2.jcc.b.gb.a(gb.java:39)
    at com.ibm.db2.jcc.b.w.a(w.java:34)
    at com.ibm.db2.jcc.b.vb.g(vb.java:139)
    at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
    at com.ibm.db2.jcc.c.gg.eb(gg.java:1862)
    at com.ibm.db2.jcc.c.gg.d(gg.java:2295)
    at com.ibm.db2.jcc.c.gg.V(gg.java:424)
    at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407)
    at sun.reflect.GeneratedMethodAccessor118.invoke(Unkn own Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.tomcat.jdbc.pool.interceptor.StatementD ecoratorInterceptor$StatementProxy.invoke(Statemen tDecoratorInterceptor.java:229)
    at $Proxy7.executeQuery(Unknown Source)


    My Db configuration is something like this:
    <Resource auth="Container" driverClassName="com.ibm.db2.jcc.DB2Driver" size="54" minIdle="7" maxWait="20000" minEvictableIdleTimeMillis="840000" timeBetweenEvictionRunsMillis="300000" name="jdbc/Xyz" password="XXX" username="CCC" type="javax.sql.DataSource" url="jdbc:db2://<<servername>>:<<port>>/<<dbName>>" defaultTransactionIsolation="2" />


    I have a questions here:
    Why is the StatementDecoratorInterceptor.java is interfering when there is no interceptor configured.
    Last edited by naganaveen; Sep 29th, 2011, 10:41 AM.
Working...
X