Subject Re: problem creating connection-pool on Sun Application-Server 8.1
Author fabian_martins_fpu
Hi Wolfgang,

I just suceed on starting a connection usin JBird and the class
org.firebirdsql.pool.sun.AppServerXADataSource.

Thanks for your help on solving the problem.


--- In Firebird-Java@yahoogroups.com, Wolfgang Reder
<wolfgang.reder@...> wrote:
>
> 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
> >
> >
>