Subject query execution - transaction hanlde nullpointer exception
Author karthick srini
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