I am getting this exception when I use jaybirds
connection factory when i use default jboss connection
fatcory I don't get this error.

Anyway I am not sure , let me test this behaviour for
some more tme. since I get this error only after some
time of application start.

For your information , to enable jboss connection I
ahve modified configuration like below ,

<local-tx-datasource>
<jndi-name>FireBirdDS</jndi-name>/

<connection-url>jdbc:firebirdsql:localhost/3050:c:/Temp/MICKEY.FDB</connection-url>

<driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
<user-name>sysdba</user-name>
<password>masterkey</password>

<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
</local-tx-datasource>
and commenetd out <tx-connection-fatcory> in
firebird-ds.xml

S.Karthick
--- Ryan Thomas <ryan@...> wrote:

> I recieved null pointer exceptions after a while
> like you mentioned,
> this was because I was not closing connections and
> statements,
> resultsets etc. So the first thing I would do is
> check that you are
> closing your connections.
>
> This was with JayBird however, I have no experience
> with JBoss, hope I
> was able to help.
>
> -Ryan
>
>
> karthick srini wrote:
> > Firebird-Java@yahoogroups.com
> >
> > Dear Members ,
> >
> > I am experience a null pointer exception when I
> > execute a query in Jboss with firebird db.
> >
> > This happens after some time my application is
> > statrted. During the time , some new tables are
> > created and queries (select , insert , update) are
>
> > executed.
> > Kindly help me in fixing this problem,
> >
> > Below is firebird-ds.xml configuration ,
> > <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. -->
> >
> > <connection-factories>
> > <mbean
> code="org.firebirdsql.management.FBManager"
> > name="jboss.jca:service=FirebirdManager">
> > <attribute
> > name="FileName">c:/Temp/MICKEY.FDB</attribute>
> > <attribute name="UserName">sysdba</attribute>
> > <attribute
> name="Password">masterkey</attribute>
> > <attribute
> name="CreateOnStart">true</attribute>
> > <attribute name="DropOnStop">false</attribute>
> > <attribute name="Server">localhost</attribute>
> > <attribute name="Port">3050</attribute>
> > </mbean>
> >
> >
> >
> > <tx-connection-factory>
> >
> > <jndi-name>FireBirdDS</jndi-name>
> >
> > <xa-transaction/>
> >
> > <adapter-display-name>Firebird Database
> > Connector</adapter-display-name>
> >
> > <config-property name="Database"
> >
>

type="java.lang.String">localhost/3050:c:/Temp/MICKEY.FDB</config-property>

> > <user-name>sysdba</user-name>
> > <password>masterkey</password>
> > <config-property
> > name="TransactionIsolation"></config-property>
> > <config-property
> >
>

name="TransactionIsolationName">TRANSACTION_READ_COMMITTED</config-property>

> > <config-property
> > name="BlobBufferLength"></config-property>
> > <config-property
> > name="Encoding">UNICODE_FSS</config-property>
> > <min-pool-size>0</min-pool-size>
> >
> > </tx-connection-factory>
> >
> > </connection-factories>
> >
> > Excption statck:
> > java.lang.NullPointerException
> > at
> >
>

org.firebirdsql.jgds.GDS_Impl.isc_start_transaction(GDS_Impl.java:539)

> > at
> >
>

org.firebirdsql.jca.FBManagedConnectionFactory.getCurrentIscTrHandle(FBManagedConnectionFactory.java:485)

> > at
> >
>

org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1094)

> > at
> >
>

org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:655)

> > at
> >
>

org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:107)

> > at
> >
>

org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:94)

> > at
> >
>

org.firebirdsql.jdbc.AbstractConnection.ensureInTransaction(AbstractConnection.java:814)

> > at
>

org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:148)

> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>

__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail