Hello! I'm using Jaybird driver and want to use Jaybird connection pool. According driver's documentation, there are two classes: org.firebirdsql.pool.FBSimpleDataSource and org.firebirdsql.pool.FBWrappingDataSource. Both works when I write pure jdbc code. Hibernate gives me an error Could not instantiate connection provider: org.firebirdsql.pool.FBSimpleDataSource. If I remove <property name="hibernate.connection.provider_class"> it still using built-in pool.
How can use Jaybird connection pool in Hibernate?

Here is my hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.FirebirdDialect</property>
<property name="hibernate.connection.driver_class">org.firebirdsql.jdbc.FBDriver</property>
<property name="hibernate.connection.url">jdbc:firebirdsql:localhost:erpdebug</property>
<property name="hibernate.connection.username">vitaly</property>
<property name="hibernate.connection.password">1</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<property name="hibernate.use_sql_comments">true</property>
<property name="hibernate.connection.provider_class">org.firebirdsql.pool.FBSimpleDataSource</property>
<!-- Tune JayBird connection pool -->
<property name="org.firebirdsql.pool.FBSimpleDataSource.LoginTimeout">10</property>
<property name="org.firebirdsql.pool.FBSimpleDataSource.Encoding">UTF8</property>
<property name="org.firebirdsql.pool.FBSimpleDataSource.DefaultIsolation">TRANSACTION_READ_COMMITTED</property>
<property name="hibernate.connection.pool_size">1</property>
<mapping resource="breserp/VOrg.hbm.xml"/>
<mapping resource="breserp/VDept.hbm.xml"/>
<mapping class="" file="" jar="" package="" resource="breserp/VAddress.hbm.xml"/>
<mapping resource="breserp/VRank.hbm.xml"/>
<mapping resource="breserp/VPerson.hbm.xml"/>
<mapping resource="breserp/VEnergoObjects.hbm.xml"/>
<mapping resource="breserp/VNet.hbm.xml"/>
</session-factory>
</hibernate-configuration>

Hi,

although I do not have a working example of using Firebird with the Hibernate-provided connection pool, I will post my config for using Hibernate with a tomcat-dbcp connection pool. Hope this is useful for you.


hibernate.cfg.xml:




context.xml: