commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jan Agermose" <...@agermose.dk>
Subject Re: [DBCP] interbase problems
Date Fri, 25 Apr 2003 12:06:33 GMT
hummm, so no one has ever had any problems like this I guess? Or should I
post some other information? The problem is I do not know the root of the
problem and do not have a small exampel that will recreate the problem....

jan


----- Original Message ----- 
From: "Jan Agermose" <jan@agermose.dk>
To: <commons-user@jakarta.apache.org>
Sent: Sunday, April 20, 2003 11:53 AM
Subject: [DBCP] interbase problems


> I have been using jdbcpool (com.bitmechanic) for a long time, but started
looking at dbcp because it's a jakarata project :-D But now my
webapplications fails
>
> The same thread gets a Connection at the begining of the page request and
during this, other Connections are requested and closed while the first
connetion is open for the hole request. The stacktrace says:
>
> interbase.interclient.ResultSet.checkForClosedCursor(Unknown Source)
> interbase.interclient.ResultSet.isNullPreamble(Unknown Source)
> interbase.interclient.ResultSet.getInt(Unknown Source)
> interbase.interclient.ResultSet.getInt(Unknown Source)
>
org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:
159)
>
org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:
159)
> org.apache.jsp.soeg_jsp._jspService(soeg_jsp.java:673)
> .....
>
> This is my JCOL file:
>
> <object class="org.apache.commons.dbcp.PoolableConnectionFactory"
>     xmlns="http://apache.org/xml/xmlns/jakarta/commons/jocl">
>    <!-- the first argument is the ConnectionFactory -->
>    <object class="org.apache.commons.dbcp.DriverManagerConnectionFactory">
> <!--
> <string value="jdbc:interbase://XXXXXX//path/to/db.gdb"/>
> <string value="jdbc:firebirdsql://XXXXXX//path/to/db.gdb"/>
>        -->
> <string value="jdbc:interbase://XXXXXX//path/to/db.gdb"/>
>       <!-- <object class="java.util.Properties" null="true"/> -->
>        <string value="XXX" />
>        <string value="XXX" />
>    </object>
>    <!-- the next argument is the ObjectPool -->
>    <object class="org.apache.commons.pool.impl.GenericObjectPool">
>       <object class="org.apache.commons.pool.PoolableObjectFactory"
null="true"/>
>       <int value="20"/> <!-- max active -->
>       <byte value="1"/> <!-- when exhausted action, 0 = fail, 1 = block, 2
= grow -->
>       <long value="4000"/> <!-- max wait -->
>       <int value="10"/> <!-- max idle -->
>       <boolean value="true"/> <!-- test on borrow -->
>       <boolean value="false"/> <!-- test on return -->
>       <long value="10000"/> <!-- time between eviction runs -->
>       <int value="5"/> <!-- number of connections to test per eviction
run -->
>       <long value="5000"/> <!-- min evictable idle time -->
>       <boolean value="true"/> <!-- test while idle -->
>    </object>
>    <!-- the next argument is the KeyedObjectPoolFactory -->
>    <object
class="org.apache.commons.pool.impl.StackKeyedObjectPoolFactory">
>       <int value="5"/> <!-- max idle -->
>    </object>
>    <string value="SELECT first 1 id FROM kunder"/> <!-- validation
query -->
>    <boolean value="false"/> <!-- default read only -->
>    <boolean value="true"/> <!-- default auto commit -->
> </object>


Mime
View raw message