Subject Re: Pools and Tomcat Data Sources
Author Roman Rokytskyy
> You assume, I use 1.5 rc 3?

Right.

> I used to use 1.0.1, anyway I have switched now.

In 1.0.1 it was not deprecated.

> Could someone modify the following Code to work with 1.5 ? I could
> not get it running. I already failed to tell the driver which
> dialect the database is using...
> And I could not find an example for 1.5.
>
dataSource = new FBWrappingDataSource();
dataSource.setDatabase( file );
dataSource.setUser( user );
dataSource.setPassword( password );
dataSource.setIdleTimeout( idleTimeout * 60 * 1000 );
dataSource.setPooling( pooling );
dataSource.setMinConnections( minSize );
dataSource.setMaxConnections( maxSize );
dataSource.setLoginTimeout( loginTimeout );

dataSource.setNonStandardProperty("sql_dialect", "3");

See
http://jaybirdwiki.firebirdsql.org/config/FBWrappingDataSourceParameters
for more information.

In final version properties maxConnections, minConnections and
idleTimeout will be deprecated, instead maxPoolSize, minPoolSize and
maxIdleTime should be used (that's names recommended by the JDBC 3.0
specification).

> Does someone have an example about configuring data pools as tomcat
> resources?

http://jaybirdwiki.firebirdsql.org/config/TomcatConnectionPooling

Roman