Subject | query execution - transaction hanlde nullpointer exception |
---|---|
Author | karthick srini |
Post date | 2004-10-21T04:13:25Z |
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
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