jndi datsource pooling

From: John Poole (john..IXXURESCANADA.com)
Date: Thu Feb 20 2003 - 18:24:36 EST

  • Next message: Duran Zuloaga Alfredo: "Disable link DataMap to Object (modeler)"

    Hi,

                Our first attempt with Cayenne is working out great. The one
    issue we have is that we're getting an exception when a web application
    idles for too long.( ~30 minutes?) It looks to me as though the jdbc
    connection is timing out, and then the application tries to use it
    without testing it. Are we doing something wrong? Should be using a
    connection pool other than the one that comes with Cayennne?

     

                

    Thanks for any info,

     

    John

     

    <Exception>

    java.sql.SQLException: Io exception: Connection reset by peer: socket
    write error
            at
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
            at
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
            at
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
            at
    oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:559)
            at
    org.objectstyle.cayenne.conn.PooledConnectionImpl.close(PooledConnection
    Impl.java:106)
            at
    org.objectstyle.cayenne.conn.PooledConnectionImpl.returnConnectionToTheP
    ool(PooledConnectionImpl.java:137)
            at
    org.objectstyle.cayenne.conn.ConnectionWrapper.close(ConnectionWrapper.j
    ava:129)
            at
    org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:336
    )
            ... 41 more

    </Exception>

     

     

                We're using :

                Tomcat 4.1.12

    cayenne-1.0a5-1

    Oracle 8.1.6.3

    classes12.zip

     

    In conf/server.xml we have:

     

    <Context path="/webapp" docBase="webapp" debug="0"

                     reloadable="true" crossContext="true">

              <Logger className="org.apache.catalina.logger.FileLogger"

                         prefix="localhost_webapp_log." suffix=".txt"

                  timestamp="true"/>

                <ResourceParams name="jdbc/pixx">

                    <parameter>

                        <name>factory</name>

     
    <value>org.objectstyle.cayenne.conn.ContainerPoolFactory</value>

                    </parameter>

                 

                    <parameter>

                        <name>username</name>

                        <value>user</value>

                    </parameter>

                

                    <parameter>

                        <name>password</name>

                        <value>password</value>

                    </parameter>

                    <parameter>

                        <name>driver</name>

                        <value>oracle.jdbc.driver.OracleDriver</value>

                    </parameter>

                    <parameter>

                        <name>url</name>

                        <value>jdbc:oracle:thin..vro:1521:pixx</value>

                    </parameter>

                    <parameter>

                        <name>min</name>

                        <value>1</value>

                    </parameter>

                    <parameter>

                        <name>max</name>

                        <value>3</value>

                    </parameter>

                </ResourceParams>

            </Context>

     

     

     

    This archive was generated by hypermail 2.0.0 : Thu Feb 20 2003 - 18:26:58 EST