On 2002.01.03 18:46:00 -0500 Ken Freeman wrote:
This worked for me with jboss "2.3" -- haven't tested with jboss 2.4.x.

This gives you xa transactions. (with 1pc commit optimization with only one
datasource, so you aren't losing any speed.)

Prepared statements should be ok... although not all type conversions may
be in place for JAWS. If you figure out which ones are broken please let
me know.



<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="JCA:service=ConnectionFactoryLoader,name=FirebirdsqlDS">
<attribute name="FactoryName">DefaultDS</attribute>
<attribute name="RARDeployerName">JCA:service=RARDeployer</attribute>
<attribute name="ResourceAdapterName">
Firebird Database Connector
</attribute>
<attribute name="Properties">
Database=localhost/3050:/usr/local/firebird/dev/client-java/db/fbmctest.gdb
</attribute>

<attribute name="ConnectionManagerFactoryName">
MinervaXACMFactory
</attribute>
<attribute name="ConnectionManagerProperties">
# Pool type - uncomment to force, otherwise it is the default
#PoolConfiguration=per-factory

# Connection pooling properties - see
# org.jboss.pool.PoolParameters
MinSize=0
MaxSize=10
Blocking=true
GCEnabled=false
IdleTimeoutEnabled=false
InvalidateOnError=false
TrackLastUsed=false
GCIntervalMillis=120000
GCMinIdleMillis=1200000
IdleTimeoutMillis=1800000
MaxIdleTimeoutPercent=1.0
</attribute>

<attribute name="PrincipalMappingClass">
org.jboss.resource.security.ManyToOnePrincipalMapping
</attribute>
<attribute name="PrincipalMappingProperties">
userName=sysdba
password=masterkey
</attribute>
</mbean>




> BTW, I am able to get a db connection by copying the firebirdsql.jar
> (extracted from firebirdsql.rar) to JBoss' lib/ext directory and setting
> my
> connection pool similar to the one I had for Interclient. However, when I
> try to create a prepared statement, I get "java.sql.SQLException: Unable
> to
> create PreparedStatement!"
>
> Can the driver create prepared statements?
>
> Ken
>
> BTW, here's the relevant section of my JBoss.jcml file, in case anyone is
> interested:
>
> <mbean code="org.jboss.jdbc.JdbcProvider"
> name="DefaultDomain:service=JdbcProvider">
> <attribute name="Drivers">org.firebirdsql.jdbc.FBDriver</attribute>
> </mbean>
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=Interbase">
> <attribute name="PoolName">Interbase</attribute>
> <attribute
> name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
> ibute>
> <attribute
> name="URL">jdbc:firebirdsql://localhost/c:/dev/appiq/database/appiq.gdb</att
> ribute>
> <attribute name="JDBCUser">SYSDBA</attribute>
> <attribute name="Password">masterkey</attribute>
>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="GCEnabled">false</attribute>
> </mbean>
>
> ----- Original Message -----
> From: Ken Freeman
> To: IB-Java@yahoogroups.com
> Sent: Thursday, January 03, 2002 6:31 PM
> Subject: [IB-Java] JDBC type 4 driver with JBoss 2.4.3
>
>
> Hi,
>
> I want to use (or at least try) the type 4 driver with JBoss 2.4.3. I
> found
> instructions at http://www.jboss.org/online-manual/HTML/ch03s12.html for
> JBoss 3, post-Alpha. Are there any instructions to use it with 2.4?
>
> Ken
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>