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
>
>
>
>
>
>
>
>
>