We're seeing the following error output in the pointbase log when using the Pointbase XA driver. The
application is using the EJB Timer Service, which uses a database as a persistent store for timer information.

After the following line appears in the log :
"Wed Apr 30 10:16:04 PDT 2003 SessionId 3 EXCEPTION: 28021 Routine was invoked in an inproper context.",
all accesses fail due to lock timeouts. It's unclear what statement caused the failure.
The errors do not occur when using the non-XA driver(com.pointbase.jdbc.jdbcDataSource).


$ cat sun-appserv-samples_Debug.log
****************START INI PARAMETERS**************

database.home=../../databases
database.pagesize=4096
cache.size=2063
cache.checkpointinterval=10
conpool.size=10
recovery.ignoreError=false
documentation.home=../../docs
sort.size=1024
crypto.databaseAlgorithm=<none>
crypto.communicationAlgorithm=<none>
crypto.communication=false
fetch.blocksize=100
replication.enabled=true
stream.checksize=true
server.port=9092
locks.maxCount=2000
locks.timeout=60
SQLCaching.size=50
table.pageReserve=15
transaction.isolationlevel=TRANSACTION_READ_COMMITTED
debug.log=true
debug.logSize=200000000
debug.logLevel=1
log.forcewrite=true
log.syncatcommit=false
cursor.holdAcrossCommit=false
log.filesize=52428800
table.organization=1
connection.convertUserInfoToUppercase=true

----------------END INI PARAMETERS-----------------
****************START MISC INFO**************

Build : 4.5 RE build 219
Java Vendor : Sun Microsystems Inc.
Java Version : 1.4.1_02
OS : SunOS
OS Version : 5.9

-----------------END MISC INFO----------------
Wed Apr 30 10:13:03 PDT 2003 SessionId 2 New Connection. Transaction Isolation Level 2
Wed Apr 30 10:13:04 PDT 2003 SessionId 3 New Connection. Transaction Isolation Level 2
Wed Apr 30 10:13:04 PDT 2003 SessionId 4 New Connection. Transaction Isolation Level 2
Wed Apr 30 10:13:04 PDT 2003 SessionId 5 New Connection. Transaction Isolation Level 2
Wed Apr 30 10:13:04 PDT 2003 SessionId 6 New Connection. Transaction Isolation Level 2
Wed Apr 30 10:13:04 PDT 2003 SessionId 7 New Connection. Transaction Isolation Level 2
Wed Apr 30 10:13:04 PDT 2003 SessionId 8 New Connection. Transaction Isolation Level 2
Wed Apr 30 10:13:04 PDT 2003 SessionId 9 New Connection. Transaction Isolation Level 2
Wed Apr 30 10:13:05 PDT 2003 SessionId 3 start(): Global Id = [B@10bc49d Branch qualifier = [B@1995d80 Flags = 0
Wed Apr 30 10:13:05 PDT 2003 SessionId 3 end(): Global Id = [B@105738 Branch qualifier = [B@ce5b1c Flags = 67108864
Wed Apr 30 10:13:05 PDT 2003 SessionId 3 start(): Global Id = [B@341960 Branch qualifier = [B@6e293a Flags = 2097152
Wed Apr 30 10:13:05 PDT 2003 SessionId 3 end(): Global Id = [B@1e8a1f6 Branch qualifier = [B@1e152c5 Flags = 67108864
Wed Apr 30 10:13:09 PDT 2003 SessionId 3 start(): Global Id = [B@6025e7 Branch qualifier = [B@587c94 Flags = 2097152
Wed Apr 30 10:13:10 PDT 2003 SessionId 3 Stmt2 Prepare " select distinct t0."containerId", t0."creationTimeRaw", t0."initialExpirationRaw", t0."intervalDuration", t0."state", t0."timerId" from "TIMERBEANTABLE" t0 where t0."state" = ? "
Wed Apr 30 10:13:10 PDT 2003 SessionId 3 Stmt2 execute
Wed Apr 30 10:13:11 PDT 2003 SessionId 3 Stmt2 Created ResultSet Rs1
Wed Apr 30 10:13:11 PDT 2003 SessionId 3 Stmt2 Closed ResultSet Rs1
Wed Apr 30 10:13:11 PDT 2003 SessionId 3 Stmt2 Close Statement.
Wed Apr 30 10:13:11 PDT 2003 SessionId 3 end(): Global Id = [B@9e5c73 Branch qualifier = [B@c791b9 Flags = 67108864
Wed Apr 30 10:13:11 PDT 2003 SessionId 3 commit(): Global Id = [B@3020ad Branch qualifier = [B@1b15692 p_OnePhase = true
Wed Apr 30 10:13:21 PDT 2003 SessionId 3 start(): Global Id = [B@1aa9f99 Branch qualifier = [B@d42d08 Flags = 0
Wed Apr 30 10:13:21 PDT 2003 SessionId 3 Stmt4 Prepare " select distinct t0."containerId", t0."creationTimeRaw", t0."initialExpirationRaw", t0."intervalDuration", t0."state", t0."timerId" from "TIMERBEANTABLE" t0 where t0."state" = ? "
Wed Apr 30 10:13:21 PDT 2003 SessionId 3 Stmt4 execute
Wed Apr 30 10:13:21 PDT 2003 SessionId 3 Stmt4 Created ResultSet Rs1
Wed Apr 30 10:13:21 PDT 2003 SessionId 3 Stmt4 Closed ResultSet Rs1
Wed Apr 30 10:13:21 PDT 2003 SessionId 3 Stmt4 Close Statement.
Wed Apr 30 10:13:21 PDT 2003 SessionId 3 end(): Global Id = [B@5e1077 Branch qualifier = [B@18b3364 Flags = 67108864
Wed Apr 30 10:13:21 PDT 2003 SessionId 3 commit(): Global Id = [B@1db05b2 Branch qualifier = [B@530cf2 p_OnePhase = true
Wed Apr 30 10:16:04 PDT 2003 SessionId 3 start(): Global Id = [B@949f69 Branch qualifier = [B@16dadf9 Flags = 0
Wed Apr 30 10:16:04 PDT 2003 SessionId 3 Stmt6 Prepare " insert into "TIMERBEANTABLE"("blob", "containerId", "creationTimeRaw", "initialExpirationRaw", "intervalDuration", "state", "timerId") values(?,?,?,?,?,?,?) "
Wed Apr 30 10:16:04 PDT 2003 SessionId 3 Stmt6 execute
Wed Apr 30 10:16:04 PDT 2003 SessionId 3 Stmt6 Close Statement.
Wed Apr 30 10:16:04 PDT 2003 SessionId 3 commit(): Global Id = [B@961dff Branch qualifier = [B@18b81e3 p_OnePhase = true
Wed Apr 30 10:16:04 PDT 2003 SessionId 3 EXCEPTION: 28021 Routine was invoked in an inproper context.
Wed Apr 30 10:16:11 PDT 2003 SessionId 3 start(): Global Id = [B@1d2fc36 Branch qualifier = [B@ac6a45 Flags = 0
Wed Apr 30 10:16:11 PDT 2003 SessionId 3 Stmt8 Prepare " select distinct t0."containerId", t0."creationTimeRaw", t0."initialExpirationRaw", t0."intervalDuration", t0."state", t0."timerId" from "TIMERBEANTABLE" t0 where t0."containerId" = ? "
Wed Apr 30 10:16:11 PDT 2003 SessionId 3 Stmt8 execute
Wed Apr 30 10:17:11 PDT 2003 SessionId 3 EXCEPTION: 84000 Lock time out; try later.
Wed Apr 30 10:17:11 PDT 2003 SessionId 3 Stmt8 Close Statement.
Wed Apr 30 10:17:11 PDT 2003 SessionId 3 end(): Global Id = [B@1581593 Branch qualifier = [B@1f06dc3 Flags = 67108864
Wed Apr 30 10:17:11 PDT 2003 SessionId 3 rollback(): Global Id = [B@1b64e6a Branch qualifier = [B@1d62270
Wed Apr 30 10:18:51 PDT 2003 SessionId 2 Close Connection.
Wed Apr 30 10:18:51 PDT 2003 SessionId 2 Rollback
Wed Apr 30 10:18:51 PDT 2003 SessionId 3 Close Connection.
Wed Apr 30 10:18:51 PDT 2003 SessionId 3 Rollback
Wed Apr 30 10:18:51 PDT 2003 SessionId 4 Close Connection.
Wed Apr 30 10:18:51 PDT 2003 SessionId 4 Rollback
Wed Apr 30 10:18:51 PDT 2003 SessionId 5 Close Connection.
Wed Apr 30 10:18:51 PDT 2003 SessionId 5 Rollback
Wed Apr 30 10:18:51 PDT 2003 SessionId 6 Close Connection.
Wed Apr 30 10:18:51 PDT 2003 SessionId 7 Close Connection.
Wed Apr 30 10:18:51 PDT 2003 SessionId 8 Close Connection.
Wed Apr 30 10:18:51 PDT 2003 SessionId 6 Rollback
Wed Apr 30 10:18:51 PDT 2003 SessionId 9 Close Connection.
Wed Apr 30 10:18:51 PDT 2003 SessionId 9 Rollback
Wed Apr 30 10:18:51 PDT 2003 SessionId 7 Rollback
Wed Apr 30 10:18:51 PDT 2003 SessionId 8 Rollback
$


Here is the DDL for the table being accessed :

CREATE TABLE "PBPUBLIC"."TIMERBEANTABLE" (
   "blob" BLOB(1G),
   "containerId" DECIMAL(38,0),
   "creationTimeRaw" DECIMAL(38,0),
   "initialExpirationRaw" DECIMAL(38,0),
   "intervalDuration" DECIMAL(38,0),
   "state" INTEGER NOT NULL ,
   "timerId" DECIMAL(38,0) NOT NULL);


ALTER TABLE "PBPUBLIC"."TIMERBEANTABLE" ADD CONSTRAINT "pk_TimerBeanTabl" PRIMARY KEY ( "timerId" );


###@###.### 2003-04-30
###@###.### 2003-05-01