Subject | firebirdsql and JBoss 2.4.4 setup |
---|---|
Author | murphyp1 |
Post date | 2002-02-01T22:04:52Z |
I am working on getting JBoss 2.4.4. to work with Firebird 1.0RC2
databases. I have built the following in jboss.jcml:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=D6501Security">
<attribute name="PoolName">D6501Security</attribute>
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
</attribute>
<attribute
name="URL">jdbc:firebirdsql:localhost/3050:/home2/d6501/d6501.gdb</att
ribute>
<attribute name="JDBCUser">sysdba</attribute>
<attribute name="Password">masterkey</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
</mbean>
The JBoss server says that it comes up OK. My question is if I
should be using a firebirdsql DataSource instead of the jboss wrapper
and if the firebirdsql driver does connection pooling on it's own?
databases. I have built the following in jboss.jcml:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=D6501Security">
<attribute name="PoolName">D6501Security</attribute>
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
</attribute>
<attribute
name="URL">jdbc:firebirdsql:localhost/3050:/home2/d6501/d6501.gdb</att
ribute>
<attribute name="JDBCUser">sysdba</attribute>
<attribute name="Password">masterkey</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
</mbean>
The JBoss server says that it comes up OK. My question is if I
should be using a firebirdsql DataSource instead of the jboss wrapper
and if the firebirdsql driver does connection pooling on it's own?