Subject SQLException thrown on connect
Author Fernando Fernandes
Hi all,

I'm having trouble on connecting to Firebird (ver 1.5.2.4731) from
JBoss (ver 4.0.2) via JayBird (ver 1.5.5). When the container opens a
connection to the FB server an SQLException exception is thrown due to
a GDS Exception - 335544726. It mention an "Error reading data from
the connection" in the GDS Exception error message.
In all places I've already looked, nobody seems to had this issue
also. Does anybody already had something like this already ?

Informations:
1. I had configured the firebird-ds.xnl file from the
JBOSS_HOME/docs/examples/firebird-ds.xml file.

2. Added the two magic lines:
...
<rar-name>firebirdsql.rar</rar-name>
<connection-definition>javax.sql.DataSource</connection-definition>
...

2. And, have placed the firebirdsql.rar file in the
JBOSS_HOME/server/default/deploy directory

*** Below it's my firebird-ds.xml file:
---
<connection-factories>
<!--FBManager can be used to create and drop databases.
Drop is especially useful during testing, since it
assures a clean start next time. -->
<mbean code="org.firebirdsql.management.FBManager"
name="jboss.jca:service=FirebirdManager">
<attribute name="FileName"></attribute>
<attribute name="UserName">SYSDBA</attribute>
<attribute name="Password">masterkey</attribute>
<attribute name="CreateOnStart">true</attribute>
<attribute name="DropOnStop">false</attribute>
</mbean>

<tx-connection-factory>
<jndi-name>SEIJConfig</jndi-name>
<xa-transaction/>
<rar-name>firebirdsql.rar</rar-name>
<connection-definition>javax.sql.DataSource</connection-definition>
<config-property name="Database"
type="java.lang.String">localhost/3050:d:\lixo\seijweb\config.gdb</config-property>
<driver-class>
org.firebirdsql.pool.FBWrappingDataSource</driver-class>
<user-name>SYSDBA</user-name>
<password>masterkey</password>
<min-pool-size>0</min-pool-size>
</tx-connection-factory>
</connection-factories>
---

Thanks in advance,
Fernando Fernandes.