Hello All;

We are using FireBird (1.0.2) with the JayBird JDBC driver
(RC3) under JBoss (3.04) and are having an exception thrown
after doing a simple select (from within an EJB finder
method). We're not sure if this is coming from the FB level or
from JayBird. The operation will succeed when run the first
time through the system, but subsequent invocations fail.

We're running all of this on a Windows 2000 Pro PC
(accessed via the machine's direct IP address, rather than via
localhost).

We would appreciate any guidance or suggestions you may
have as to how we can pursue this error. The Java exception
stack trace & log is included below.

Thank you very much in advance!

Regards,

Hugh J Borst
The Higher Gear Group, Inc.
hugh_borst@...

SQL Statement:
SELECT t0_o.MEDIA_DATA_ID FROM MEDIA_DATA t0_o WHERE
t0_o.MEDIA_DIGEST = ?

MEDIA_DATA_ID is type INTEGER NOT NULL
MEDIA_DIGEST is type CHAR32 NOT NULL

Other points:
* Transactions are JBoss container-managed.
* Problem does not occur when using InterClient, only with JayBird
* Query is okay interactively in ISQL
* Happens only with JayBird, but works the first time after IB has
been restarted. Fails each afterwards, including after
JBoss/JayBird restart, until IB is restarted.

DDL:

CREATE DOMAIN DOM_ID AS INTEGER DEFAULT 0 NOT NULL
CREATE DOMAIN DOM_MD5 AS CHAR(32) NOT NULL
CREATE DOMAIN DOM_NUMBER AS INTEGER DEFAULT NULL
CREATE DOMAIN DOM_TEXT AS BLOB SUB_TYPE 1 SEGMENT SIZE 1024
CREATE DOMAIN DOM_DATE AS TIMESTAMP DEFAULT NULL
CREATE DOMAIN DOM_NULL_FK_ID AS INTEGER
CREATE DOMAIN DOM_BOOL AS CHAR(1) DEFAULT 'N' CHECK (VALUE IN
('N', 'Y'))

CREATE TABLE MEDIA_DATA (
MEDIA_DATA_ID DOM_ID,
MEDIA_TYPE_ID DOM_ID,
MEDIA_DIGEST DOM_MD5,
DATA_SIZE DOM_NUMBER NOT NULL,
DATA_TEXT DOM_TEXT NOT NULL,
CREATE_DATE DOM_DATE NOT NULL,
ACCESS_DATE DOM_DATE NOT NULL,
MEDIA_TYPE_REF DOM_NULL_FK_ID,
KEEP_IND DOM_BOOL
)

Stack trace:

2003-03-28 13:58:22,515 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.MediaData.findByMD5]
Executing SQL: SELECT t0_o.MEDIA_DATA_ID FROM MEDIA_DATA t0_o WHERE
t0_o.MEDIA_DIGEST = ?
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_allocate_statement
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl] sent
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_object: 2
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_blob_id: 0
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_data size: 0
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 0
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl]
received
2003-03-28 13:58:22,515 DEBUG
[org.firebirdsql.jca.FBManagedConnection] preparing sql: SELECT
t0_o.MEDIA_DATA_ID FROM MEDIA_DATA t0_o WHERE t0_o.MEDIA_DIGEST = ?
2003-03-28 13:58:22,515 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_prepare_statement
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl] sent
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_object: 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_blob_id: 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_data size: 1024
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
received
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
parseSqlInfo started
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
parseSqlInfo: first 2 bytes are 1796 or: 4, 7
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
xsqlda.sqln read as 1
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl] new
xsqlvar 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_type 496
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_sub_type 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_scale 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_length 4
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_field MEDIA_DATA_ID
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_relation MEDIA_DATA
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_owner SYSDBA
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_alias MEDIA_DATA_ID
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
parseSqlInfo ended
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_info_sql
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl] sent
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_object: 2
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_blob_id: 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_data size: 1024
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
received
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
parseSqlInfo started
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
parseSqlInfo: first 2 bytes are 1797 or: 5, 7
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
xsqlda.sqln read as 1
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl] new
xsqlvar 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_type 452
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_sub_type 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_scale 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_length 32
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_field
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_relation
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_owner
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
isc_info_sql_alias
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
parseSqlInfo ended
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_execute
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl] sent
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_object: 1
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_blob_id: 35101368
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
op_response resp_data size: 0
2003-03-28 13:58:22,531 DEBUG [org.firebirdsql.jgds.GDS_Impl]
readStatusVector arg:isc_arg_gds int: 335544794
2003-03-28 13:58:22,593 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.MediaData.findByMD5]
Find failed
org.firebirdsql.jdbc.FBSQLException: GDS Exception. operation was
cancelled
at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute
(FBPreparedStatement.java:425)
at org.firebirdsql.jdbc.FBPreparedStatement.executeQuery
(FBPreparedStatement..java:101)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
(JDBCAbstractQueryCommand.java:112)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute
(JDBCFindEntityCommand.java:44)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity
(JDBCStoreManager.java:541)
at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity
(CMPPersistenceManager.java:336)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.find
Entity(CachedConnectionInterceptor.java:301)
at org.jboss.ejb.EntityContainer.findLocal
(EntityContainer.java:636)
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown
Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
(EntityContainer.java:1119)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome
(EntitySynchronizationInterceptor.java:206)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
keHome(CachedConnectionInterceptor.java:215)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome
(EntityInstanceInterceptor.java:90)
at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome
(EntityLockInterceptor.java:79)
at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome
(EntityCreationInterceptor.java:44)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:111)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions
(TxInterceptorCMT.java:178)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome
(TxInterceptorCMT.java:52)
at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome
(SecurityInterceptor.java:105)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome
(LogInterceptor.java:129)
at org.jboss.ejb.EntityContainer.invokeHome
(EntityContainer.java:487)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invokeHome
(BaseLocalContainerInvoker.java:230)
at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke
(LocalHomeProxy.java:110)
at $Proxy209.findByMD5(Unknown Source)
at
com.highergear.hgservices.email.ejb.EmailParseBean.getMediaData
(EmailParseBean.java:319)
at com.highergear.hgservices.email.ejb.EmailParseBean.parse
(EmailParseBean.java:121)
at com.highergear.hgservices.email.ejb.EmailParseBean.parse
(EmailParseBean.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke
(StatelessSessionContainer.java:660)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
ke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke
(StatelessSessionInstanceInterceptor.java:77)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:107)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions
(TxInterceptorCMT.java:178)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:60)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke
(SecurityInterceptor.java:130)
at org.jboss.ejb.plugins.LogInterceptor.invoke
(LogInterceptor.java:204)
at org.jboss.ejb.StatelessSessionContainer.invoke
(StatelessSessionContainer.java:313)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invoke
(BaseLocalContainerInvoker.java:301)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke
(StatelessSessionProxy.java:81)
at $Proxy280.parse(Unknown Source)
at com.highergear.hgservices.email.ParseMailWorker.run
(ParseMailWorker.java:53)
at
org.firebirdsql.gds.GDSException: operation was cancelled
at org.firebirdsql.jgds.GDS_Impl.readStatusVector
(GDS_Impl.java:1683)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse
(GDS_Impl.java:1636)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2
(GDS_Impl.java:865)
at org.firebirdsql.jca.FBManagedConnection.executeStatement
(FBManagedConnection.java:782)
at org.firebirdsql.jdbc.FBConnection.executeStatement
(FBConnection.java:1072)
at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute
(FBPreparedStatement.java:420)
at org.firebirdsql.jdbc.FBPreparedStatement.executeQuery
(FBPreparedStatement..java:101)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
(JDBCAbstractQueryCommand.java:112)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute
(JDBCFindEntityCommand.java:44)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity
(JDBCStoreManager.java:541)
at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity
(CMPPersistenceManager.java:336)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.find
Entity(CachedConnectionInterceptor.java:301)
at org.jboss.ejb.EntityContainer.findLocal
(EntityContainer.java:636)
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown
Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
(EntityContainer.java:1119)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome
(EntitySynchronizationInterceptor.java:206)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
keHome(CachedConnectionInterceptor.java:215)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome
(AbstractInterceptor.java:73)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome
(EntityInstanceInterceptor.java:90)
at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome
(EntityLockInterceptor.java:79)
at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome
(EntityCreationInterceptor.java:44)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:111)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions
(TxInterceptorCMT.java:178)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome
(TxInterceptorCMT.java:52)
at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome
(SecurityInterceptor.java:105)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome
(LogInterceptor.java:129)
at org.jboss.ejb.EntityContainer.invokeHome
(EntityContainer.java:487)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invokeHome
(BaseLocalContainerInvoker.java:230)
at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke
(LocalHomeProxy.java:110)
at $Proxy209.findByMD5(Unknown Source)
at
com.highergear.hgservices.email.ejb.EmailParseBean.getMediaData
(EmailParseBean.java:319)
at com.highergear.hgservices.email.ejb.EmailParseBean.parse
(EmailParseBean.java:121)
at com.highergear.hgservices.email.ejb.EmailParseBean.parse
(EmailParseBean.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke
(StatelessSessionContainer.java:660)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo
ke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke
(StatelessSessionInstanceInterceptor.java:77)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:107)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions
(TxInterceptorCMT.java:178)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:60)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke
(SecurityInterceptor.java:130)
at org.jboss.ejb.plugins.LogInterceptor.invoke
(LogInterceptor.java:204)
at org.jboss.ejb.StatelessSessionContainer.invoke
(StatelessSessionContainer.java:313)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invoke
(BaseLocalContainerInvoker.java:301)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke
(StatelessSessionProxy.java:81)
at $Proxy280.parse(Unknown Source)
at com.highergear.hgservices.email.ParseMailWorker.run
(ParseMailWorker.java:53)