Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 26362 invoked from network); 17 Dec 2007 13:45:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Dec 2007 13:45:18 -0000 Received: (qmail 666 invoked by uid 500); 17 Dec 2007 13:45:00 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 632 invoked by uid 500); 17 Dec 2007 13:45:00 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 616 invoked by uid 99); 17 Dec 2007 13:45:00 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Dec 2007 05:45:00 -0800 X-ASF-Spam-Status: No, hits=3.5 required=10.0 tests=HTML_MESSAGE,SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of harikrishna.korrapati@gmail.com designates 209.85.146.182 as permitted sender) Received: from [209.85.146.182] (HELO wa-out-1112.google.com) (209.85.146.182) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Dec 2007 13:44:39 +0000 Received: by wa-out-1112.google.com with SMTP id j4so3504637wah.1 for ; Mon, 17 Dec 2007 05:44:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=XgZ65Uhr23REJOHtkIxvLHdu0YjSi06mugp87yjMaZQ=; b=KGxrH7qlgnn6aPdA/7UEn4gBF57sOfd6/YMP0EmM1uWzibGrd832lKmFiGifH/8pPEUJsLwU8S5AvQ40TlTU7WoNUiW1sQadR61BToqGWIhBSqiVvZ5dTKPMb5N7/Yx5xqDHRso9QMBs+wtHJEH3ceNJ+UHctTki0BwPpvPB4mU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=LfpFhPV1nr7Un813fsJj9t9pqBKWNNgD0t/rR6J2uX/7p8MeGbq5vhj2TDSQwEBGgh2u/qgnwO+wQz7U4OmzpUCZCEQhHIIWfD7FUAHPODlaZ/pkCR/Szl9fafxTGFxlbVtfu/ruN72BS7xgIuJba6FmsfwnaxMlya95T105esw= Received: by 10.114.60.19 with SMTP id i19mr1778198waa.142.1197899083126; Mon, 17 Dec 2007 05:44:43 -0800 (PST) Received: by 10.114.92.19 with HTTP; Mon, 17 Dec 2007 05:44:43 -0800 (PST) Message-ID: <8a855ce00712170544m4a33a05agcbaf53ce237104a7@mail.gmail.com> Date: Mon, 17 Dec 2007 19:14:43 +0530 From: "Hari Krishna Korrapati" To: user@geronimo.apache.org Subject: Problem with connection management MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6076_27420399.1197899083123" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_6076_27420399.1197899083123 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I am facing some problem with hibernate on Geronimo. Got the following exception when a "*select*" query is issued against DB2. com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68 When i google it, i came to know it can because of connection pooling. Would like to know whether it is something related to connection management which we need to configure in Geronimo. Following is the full log for the exception 17:49:14,738 WARN [GeronimoConnectionEventListener] connectionErrorOccurred called with null com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68 at com.ibm.db2.jcc.a.cc.b(cc.java:2828) at com.ibm.db2.jcc.b.be.i(be.java:181) at com.ibm.db2.jcc.b.be.a (be.java:142) at com.ibm.db2.jcc.b.be.a(be.java:33) at com.ibm.db2.jcc.b.s.a(s.java:31) at com.ibm.db2.jcc.b.h.bH(h.java:273) at com.ibm.db2.jcc.a.cc.N(cc.java:2736) at com.ibm.db2.jcc.b.d.f (d.java:977) at com.ibm.db2.jcc.a.o.a(o.java:181) at com.ibm.db2.jcc.a.cc.c(cc.java:284) at com.ibm.db2.jcc.a.cc.next(cc.java:259) at org.tranql.connector.jdbc.ResultSetHandle.next(ResultSetHandle.java:791) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:200) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java :955) at net.sf.hibernate.loader.Loader.list(Loader.java:946) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:846) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at samples.dao.hibernate.HibernateUserDAO.authticateUser( HibernateUserDAO.java:740) ................................... ................................... 17:49:14,769 WARN [JDBCExceptionReporter] SQL Error: -911, SQLState: 40001 17:49:14,769 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68 17:49:14,769 WARN [BatcherImpl] exception clearing maxRows/queryTimeout java.lang.NullPointerException at org.tranql.connector.jdbc.ConnectionHandle.connectionError( ConnectionHandle.java:103) at org.tranql.connector.jdbc.StatementHandle.getMaxRows( StatementHandle.java:231) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement( BatcherImpl.java:143) at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement( BatcherImpl.java:103) at net.sf.hibernate.loader.Loader.doQuery(Loader.java :234) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (Loader.java:133) at net.sf.hibernate.loader.Loader.doList(Loader.java:955) at net.sf.hibernate.loader.Loader.list(Loader.java :946) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:846) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at samples.dao.hibernate.HibernateUserDAO.authticateUser( HibernateUserDAO.java:740) ................................... ................................... 17:49:14,769 WARN [JDBCExceptionReporter] SQL Error: -911, SQLState: 40001 17:49:14,769 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68 17:49:14,769 ERROR [JDBCExceptionReporter] Could not execute query com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68 at com.ibm.db2.jcc.a.cc.b(cc.java:2828) at com.ibm.db2.jcc.b.be.i(be.java:181) at com.ibm.db2.jcc.b.be.a(be.java:142) at com.ibm.db2.jcc.b.be.a(be.java:33) at com.ibm.db2.jcc.b.s.a(s.java :31) at com.ibm.db2.jcc.b.h.bH(h.java:273) at com.ibm.db2.jcc.a.cc.N(cc.java:2736) at com.ibm.db2.jcc.b.d.f(d.java:977) at com.ibm.db2.jcc.a.o.a(o.java:181) at com.ibm.db2.jcc.a.cc.c(cc.java :284) ................................... ................................... 17:49:14,800 ERROR [AbstractTransactionContext] Unable to roll back transaction java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION at org.apache.geronimo.transaction.manager.TransactionImpl.rollback( TransactionImpl.java:438) at org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow (InheritableTransactionContext.java :308) at org.apache.geronimo.transaction.context.InheritableTransactionContext.complete (InheritableTransactionContext.java:199) at org.apache.geronimo.transaction.context.InheritableTransactionContext.commit( InheritableTransactionContext.java:146) at org.openejb.transaction.ContainerPolicy$TxRequired.invoke( ContainerPolicy.java:152) at org.openejb.transaction.TransactionContextInterceptor.invoke( TransactionContextInterceptor.java :80) at org.openejb.SystemExceptionInterceptor.invoke( SystemExceptionInterceptor.java:82) at org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238) at org.openejb.proxy.EJBMethodInterceptor.intercept ( EJBMethodInterceptor.java:164) at org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$6c960803.authenticate () For the reference below is the part of my DataSource plan javax.sql.DataSource XYZDataSource db2inst3 com.ibm.db2.jcc.DB2Driver db2inst3 jdbc:db2://IP:PORT/DBNAME 10 0 5000 30 and below is the hibernate configuration COM.ibm.db2.jdbc.app.DB2Driver jdbc:db2:DBNAME db2inst3 db2inst3 true true net.sf.hibernate.dialect.DB2Dialect net.sf.hibernate.dialect.DB2Dialect true true 200 100 net.sf.ehcache.hibernate.Provider true net.sf.hibernate.transaction.JDBCTransactionFactory net.sf.hibernate.transaction.GeronimoTransactionManagerLookup Please advice me on how to proceed further. Regards, Hari ------=_Part_6076_27420399.1197899083123 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi,

I am facing some problem with hibernate on Geronimo. Got the following exception when a "select" query is issued against DB2.
                     com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68

When i google it, i came to know it can because of connection pooling.
Would like to know whether it is something related to connection management which we need to configure in Geronimo.

Following is the full log for the exception

17:49:14,738 WARN  [GeronimoConnectionEventListener] connectionErrorOccurred called with null
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68
    at com.ibm.db2.jcc.a.cc.b(cc.java:2828)
    at com.ibm.db2.jcc.b.be.i(be.java:181)
    at com.ibm.db2.jcc.b.be.a (be.java:142)
    at com.ibm.db2.jcc.b.be.a(be.java:33)
    at com.ibm.db2.jcc.b.s.a(s.java:31)
    at com.ibm.db2.jcc.b.h.bH(h.java:273)
    at com.ibm.db2.jcc.a.cc.N(cc.java:2736)
    at com.ibm.db2.jcc.b.d.f (d.java:977)
    at com.ibm.db2.jcc.a.o.a(o.java:181)
    at com.ibm.db2.jcc.a.cc.c(cc.java:284)
    at com.ibm.db2.jcc.a.cc.next(cc.java:259)
    at org.tranql.connector.jdbc.ResultSetHandle.next(ResultSetHandle.java :791)
    at net.sf.hibernate.loader.Loader.doQuery(Loader.java:200)
    at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
    at net.sf.hibernate.loader.Loader.doList(Loader.java :955)
    at net.sf.hibernate.loader.Loader.list(Loader.java:946)
    at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:846)
    at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
    at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
    at samples.dao.hibernate.HibernateUserDAO.authticateUser(HibernateUserDAO.java:740)
    ...................................
    ...................................
17:49:14,769 WARN  [JDBCExceptionReporter] SQL Error: -911, SQLState: 40001
17:49:14,769 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68
17:49:14,769 WARN  [BatcherImpl] exception clearing maxRows/queryTimeout
java.lang.NullPointerException
    at org.tranql.connector.jdbc.ConnectionHandle.connectionError(ConnectionHandle.java:103)
    at org.tranql.connector.jdbc.StatementHandle.getMaxRows(StatementHandle.java:231)
    at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:143)
    at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:103)
    at net.sf.hibernate.loader.Loader.doQuery(Loader.java :234)
    at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
    at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
    at net.sf.hibernate.loader.Loader.list(Loader.java :946)
    at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:846)
    at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
    at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
    at samples.dao.hibernate.HibernateUserDAO.authticateUser(HibernateUserDAO.java:740)
    ...................................
    ...................................
17:49:14,769 WARN  [JDBCExceptionReporter] SQL Error: -911, SQLState: 40001
17:49:14,769 ERROR [JDBCExceptionReporter] DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68
17:49:14,769 ERROR [JDBCExceptionReporter] Could not execute query
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68
    at com.ibm.db2.jcc.a.cc.b(cc.java:2828)
    at com.ibm.db2.jcc.b.be.i(be.java:181)
    at com.ibm.db2.jcc.b.be.a(be.java:142)
    at com.ibm.db2.jcc.b.be.a(be.java:33)
    at com.ibm.db2.jcc.b.s.a(s.java :31)
    at com.ibm.db2.jcc.b.h.bH(h.java:273)
    at com.ibm.db2.jcc.a.cc.N(cc.java:2736)
    at com.ibm.db2.jcc.b.d.f(d.java:977)
    at com.ibm.db2.jcc.a.o.a(o.java:181)
    at com.ibm.db2.jcc.a.cc.c(cc.java :284)
    ...................................
    ...................................
   
17:49:14,800 ERROR [AbstractTransactionContext] Unable to roll back transaction
java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION
    at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:438)
    at org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java :308)
    at org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
    at org.apache.geronimo.transaction.context.InheritableTransactionContext.commit (InheritableTransactionContext.java:146)
    at org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.java:152)
    at org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java :80)
    at org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.java:82)
    at org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
    at org.openejb.proxy.EJBMethodInterceptor.intercept (EJBMethodInterceptor.java:164)
    at org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$6c960803.authenticate(<generated>)



For the reference below is the part of my DataSource plan
          <connection-definition>
                <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>XYZDataSource</name>
                    <config-property-setting name="Password">db2inst3</config-property-setting>
                    <config-property-setting name="Driver">com.ibm.db2.jcc.DB2Driver</config-property-setting>
                    <config-property-setting name="UserName">db2inst3</config-property-setting>
                    <config-property-setting name="ConnectionURL">jdbc:db2://IP:PORT/DBNAME</config-property-setting>
                    <connectionmanager>
                        <local-transaction/>
                        <single-pool>
                            <max-size>10</max-size>
                            <min-size>0</min-size>
                            <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
                            <idle-timeout-minutes>30</idle-timeout-minutes>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>

and below is the hibernate configuration
        <property name="connection.driver_class"> COM.ibm.db2.jdbc.app.DB2Driver</property>
        <property name="connection.url">jdbc:db2:DBNAME</property>
        <property name="connection.username">db2inst3</property>
        <property name="connection.password">db2inst3</property>       
        <property name="show_sql">true</property>
        <property name="use_outer_join">true</property>
        <property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>    

 <!-- Database settings -->
        <property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>
        <property name="show_sql">true</property>
        <property name="use_outer_join">true</property>

        <!-- JDBC settings -->
        <property name="hibernate.jdbc.batch_size">200</property>
        <property name="statement_cache.size">100</property>

        <!-- Cache settings-->
        <property name="hibernate.cache.provider_class">net.sf.ehcache.hibernate.Provider</property>
        <property name="hibernate.cache.use_query_cache">true</property>

        <!-- Transaction API -->
        <property name="transaction.factory_class">net.sf.hibernate.transaction.JDBCTransactionFactory</property>
        <property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.GeronimoTransactionManagerLookup</property>



Please advice me on how to proceed further.

Regards,
Hari ------=_Part_6076_27420399.1197899083123--