Subject Re: [Firebird-Java] Re: problem creating connection-pool on Sun Application-Server 8.1
Author Wolfgang Reder
hello !

yes i did.
i removed some parameters and from then it works fine.
here is the part from domain.xml ( i think some of these parameters are not
necessary ):

<jdbc-connection-pool connection-validation-method="auto-commit"
datasource-classname="org.firebirdsql.pool.FBWrappingDataSource"
fail-all-connections="false" idle-timeout-in-seconds="300"
is-connection-validation-required="true" is-isolation-level-guaranteed="false"
max-pool-size="100" max-wait-time-in-millis="60000" name="MSDMAIN"
pool-resize-quantity="2" res-type="javax.sql.ConnectionPoolDataSource"
steady-pool-size="1" transaction-isolation-level="read-committed">
<property name="TransactionIsolationLevel" value="2"/>
<property name="Isolation" value="TRANSACTION_READ_COMMITTED"/>
<property name="MaxConnections" value="100"/>
<property name="BlobBufferSize" value="16384"/>
<property name="RetryInterval" value="1000"/>
<property name="MinPoolSize" value="1"/>
<property name="PingStatement" value="SELECT cast(1 AS INTEGER) FROM
rdb$database"/>
<property name="LoginTimeout" value="2147"/>
<property name="MaxPoolSize" value="100"/>
<property name="MaxIdleTime" value="300"/>
<property name="BlockingTimeout" value="60000"/>
<property name="IdleTimeout" value="300"/>
<property name="MinConnections" value="1"/>
<property name="PingInterval" value="5000"/>
<property name="MaxStatements" value="1000"/>
<property name="Database"
value="192.168.1.1:/home/wolfi/msdng/msdmain.firebird"/>
<property name="Username" value="j2ee"/>
<property name="Password" value="j2ee"/>
<property name="User" value="j2ee"/>
<property name="user.name" value="j2ee"/>
<property name="Encoding" value="UNICODE_FSS"/>
</jdbc-connection-pool>



fabian_martins_fpu wrote:
>
> Dear Wolfgang,
>
> I got the same; Tried with different classes
> (org.firebirdsql.pool.FBConnectionPoolDataSource,
> org.firebirdsql.pool.FBWrappingDataSource,
> org.firebirdsql.pool.DriverConnectionPoolDataSource )
> and keep gotting the same message; sometimes the browser
> says "waiting for localhost" and I'm sure the Firebird server was
> started... did you got any progress on solving this issue?
>
> fabian_martins_fpu@... /Brazil
>
>