Subject Re: [IB-Java] JDBC type 4 driver with JBoss 2.4.3
Author Ken Freeman
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