As you know, I've been having trouble with container managed transactions and Oracle. I thought I would try the following code.
In essence, it gets a connection from the pool, does an insert, throws away the connection, then gets another connection and
tries the second insert. This exhibits the same problem that I'm having with my session beans and entity beans where the connections
are separate and the insert into the document_version table fails because it is waiting on the row in the product table.
Should I avoid Foreign Keys wherever my entity beans have relationships?
Any Ideas?
This code is in a business method of a stateless session bean (ddc/DocumentLoader). I invoke it from a servlet.
try
{
Context context = new InitialContext();
DataSource ds = (DataSource)context.lookup(JNDINames.DB_POOL);
Connection con = ds.getConnection();
con.setAutoCommit(false);
String sql = "INSERT INTO product ( product_type_cd, school_cd, product_id, tng_mat_production_dt, security_class_cd, product_nm, product_proponent_cd, proponent_person_id, product_status_cd, distribution_restriction_cd, distribution_restriction_tx ) VALUES ( 'FM', '1', 'FM 1-1', ?, 'U', 'Test', 1, 'boltd', 'A', 'A', 'Public Distribution' )";
PreparedStatement stmt = con.prepareStatement(sql);
stmt.setDate(1,Conversion.toSQLDate("01/01/2001"));
stmt.executeUpdate();
stmt.close();
con.close();
ds = null;
con = null;
ds = (DataSource)context.lookup(JNDINames.DB_POOL);
con = ds.getConnection();
sql = "INSERT INTO document_version ( product_id,document_version_id, product_status_cd, version_creation_dt, web_publish_cd, document_version_nm ) VALUES ( 'FM 1-1', 1, 'P', ?, 'N', 'Test' )";
stmt = con.prepareStatement(sql);
stmt.setDate(1,Conversion.toSQLDate("01/01/2001"));
// This insert will fail, due to the FK relationship between product and document_version.
stmt.executeUpdate();
stmt.close();
con.close();
}
catch (SQLException e)
{
System.out.println(e.getMessage());
e.printStackTrace();
throw new EJBException("Could not lookup Product");
}
catch (NamingException ne)
{
System.out.println(ne);
throw new EJBException("Could not lookup Product");
}
catch (Exception ne)
{
System.out.println(ne);
throw new EJBException("Could not lookup Product");
}
Here is the server log file
[File logging] Initialized
[Classpath extension] Initializing
[Classpath extension] Added directory:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/tmp/
[Classpath extension] Initialized
[Classpath extension] Initializing
[Classpath extension] Added directory:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/db/
[Classpath extension] Initialized
[Info] Java version: 1.3.0,Sun Microsystems Inc.
[Info] Java VM: Java HotSpot(TM) Server VM 2.0fcs-E,Sun Microsystems Inc.
[Info] System: Windows NT 4.0,x86
[Classpath extension] Initializing
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/activation.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/awt.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/classes12.zip
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/dynaserver.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/ejb.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/ejxeditor.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/ejxejb.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/ejxjaws.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/ejxjboss.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/hsql.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/idb.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/jboss.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/jetty-service.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/jms.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/jmxtools.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/jndi.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/jnpserver.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/jpl-util-0_5b.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/jta-spec1_0_1.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/mail.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/spydermq.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/tomcat-service.jar
[Classpath extension] Added library:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/lib/ext/xerces.jar
[Classpath extension] Initialized
[JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
[JDBC] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
[Webserver] Initializing
[Webserver] Initialized
[Hypersonic] Initializing
[Hypersonic] Initialized
[Naming] Initializing
[Naming] Naming started on port 1099
[Naming] Initialized
[Transaction manager] Initializing
[Transaction manager] Initialized
[JAAS Security Manager] Initializing
[JAAS Security Manager] Initialized
[Simple Realm Mapping] Initializing
[Simple Realm Mapping] Initialized
[Security manager] Initializing
[Security manager] Initialized
[InstantDB] Initializing
[InstantDB] Initialized
[DefaultDS] Initializing
[DefaultDS] Initialized
[OracleDB] Initializing
[OracleDB] Initialized
[StaffingDB] Initializing
[StaffingDB] Initialized
[Container factory] Initializing
[Container factory] Initialized
[Auto deploy] Watching D:\JBOSS\jboss_tomcat\jboss-2.0-FINAL\deploy
[Auto deploy] Initializing
[Auto deploy] Initialized
[JMX RMI Adaptor] Initializing
[JMX RMI Adaptor] Initialized
[JMX RMI Connector] Initializing
[JMX RMI Connector] Initialized
[Configuration] Initializing
[Configuration] Initialized
[J2EE Deployer] Initializing
[J2EE Deployer] Initialized
[EmbeddedTomcat] Initializing
[EmbeddedTomcat] Initialized
[SpyderMQ] Initializing
[SpyderMQ] Initialized
[Configuration] MaxActiveClientCount set to 10 in Adaptor:name=html
[Configuration] Port set to 8082 in Adaptor:name=html
[Configuration] LibraryDirectory set to d:\JBOSS\jboss_tomcat\jboss-2.0-FINAL\bin in DefaultDomain:service=MLet
[Configuration] URL set to jdbc:oracle:oci8:@lom in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] GCMinIdleTime set to 1200000 in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] JDBCUser set to doctrine in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] MaxSize set to 500 in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] Password set to doctrine in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] GCEnabled set to false in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] InvalidateOnError set to false in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] TimestampUsed set to false in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] Blocking set to true in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] GCInterval set to 120000 in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] IdleTimeout set to 1800000 in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] IdleTimeoutEnabled set to false in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] LoggingEnabled set to true in DefaultDomain:service=XADataSource,name=StaffingDB
[StaffingDB] DRVR OPER Enabled logging (moduleMask 0x0fffffff, categoryMask 0x0fffffff)
[Configuration] MaxIdleTimeoutPercent set to 1.0 in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] MinSize set to 25 in DefaultDomain:service=XADataSource,name=StaffingDB
[Configuration] TransactionTimeout set to 300 in DefaultDomain:service=TransactionManager
[Configuration] Format set to [{2}] {4} in DefaultDomain:service=Logging,type=Console
[Configuration] Port set to 8083 in DefaultDomain:service=Webserver
[Configuration] URL set to jdbc:idb:../conf/default/instantdb.properties in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] GCMinIdleTime set to 1200000 in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] MaxSize set to 10 in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] GCEnabled set to false in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] InvalidateOnError set to false in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] TimestampUsed set to false in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] Blocking set to true in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] GCInterval set to 120000 in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] IdleTimeout set to 1800000 in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] IdleTimeoutEnabled set to false in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] LoggingEnabled set to false in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] MaxIdleTimeoutPercent set to 1.0 in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] MinSize set to 0 in DefaultDomain:service=XADataSource,name=InstantDB
[Configuration] Format set to [{2}] {4} in DefaultDomain:service=Logging,type=File
[Configuration] LogName set to server in DefaultDomain:service=Logging,type=File
[Configuration] Port set to 1476 in DefaultDomain:service=Hypersonic
[Configuration] Silent set to true in DefaultDomain:service=Hypersonic
[Configuration] Database set to default in DefaultDomain:service=Hypersonic
[Configuration] Trace set to false in DefaultDomain:service=Hypersonic
[Configuration] URL set to jdbc:oracle:thin:@atiadb:1521:lom in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] GCMinIdleTime set to 1200000 in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] JDBCUser set to itc in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] MaxSize set to 0 in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] Password set to itc in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] GCEnabled set to false in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] InvalidateOnError set to false in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] TimestampUsed set to false in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] Blocking set to true in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] GCInterval set to 120000 in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] IdleTimeout set to 1800000 in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] IdleTimeoutEnabled set to false in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] LoggingEnabled set to false in DefaultDomain:service=XADataSource,name=OracleDB
[StaffingDB] DRVR OPER Disabled logging
[Configuration] MaxIdleTimeoutPercent set to 1.0 in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] MinSize set to 0 in DefaultDomain:service=XADataSource,name=OracleDB
[Configuration] URL set to jdbc:HypersonicSQL:hsql://localhost:1476 in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] GCMinIdleTime set to 1200000 in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] JDBCUser set to sa in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] MaxSize set to 10 in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] GCEnabled set to false in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] InvalidateOnError set to false in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] TimestampUsed set to false in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] Blocking set to true in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] GCInterval set to 120000 in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] IdleTimeout set to 1800000 in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] IdleTimeoutEnabled set to false in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] LoggingEnabled set to false in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] MaxIdleTimeoutPercent set to 1.0 in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] MinSize set to 0 in DefaultDomain:service=XADataSource,name=DefaultDS
[Configuration] VerifyDeployments set to true in EJB:service=ContainerFactory
[Configuration] MetricsEnabled set to false in EJB:service=ContainerFactory
[Configuration] VerifierVerbose set to true in EJB:service=ContainerFactory
[Configuration] Detected JMX Bug: Server reports attribute 'JDBCUser' is not writeable for MBean 'DefaultDomain:name=StaffingDB,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'TimestampUsed' is not writeable for MBean 'DefaultDomain:name=StaffingDB,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'JDBCUser' is not writeable for MBean 'DefaultDomain:name=InstantDB,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'TimestampUsed' is not writeable for MBean 'DefaultDomain:name=InstantDB,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'JDBCUser' is not writeable for MBean 'DefaultDomain:name=OracleDB,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'TimestampUsed' is not writeable for MBean 'DefaultDomain:name=OracleDB,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'JDBCUser' is not writeable for MBean 'DefaultDomain:name=DefaultDS,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'TimestampUsed' is not writeable for MBean 'DefaultDomain:name=DefaultDS,service=XADataSource'
[EmbeddedTomcat] Starting
[EmbeddedTomcat] Testing if Tomcat is present....
[EmbeddedTomcat] OK
[EmbeddedTomcat] ContextManager: Adding context Ctx( )
[EmbeddedTomcat] path="" :jsp: init
[EmbeddedTomcat] PoolTcpConnector: Starting HttpConnectionHandler on 8080
[EmbeddedTomcat] Started
[Simple Realm Mapping] Starting
[Simple Realm Mapping] Started
[Webserver] Starting
[Webserver] Codebase set to http://boltd:8083/
[Webserver] Started webserver on port 8083
[Webserver] Started
[Transaction manager] Starting
[Transaction manager] Started
[Naming] Starting
[Naming] Started
[Hypersonic] Starting
[Hypersonic] Server 1.4 is running
[Hypersonic] Database started
[Hypersonic] Started
[StaffingDB] Starting
[Hypersonic] Press [Ctrl]+[C] to abort
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@88e6c
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@5a6029
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@5d9084
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@661fd1
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@766a24
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@774b9b
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@3fa5ac
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@79dce4
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@1bb25a
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@658cb8
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@39e45a
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@100363
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@67064
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@17d01f
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@feb48
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@5a3a1e
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@303be0
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@13a53d
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@53fb57
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@238f4
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@297ffb
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@74cbee
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@326484
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@a49e0
[StaffingDB] Pool StaffingDB created a new object: oracle.jdbc.xa.client.OracleXAConnection@54864a
[StaffingDB] XA Connection pool StaffingDB bound to java:/StaffingDB
[StaffingDB] No transaction right now.
[StaffingDB] Pool StaffingDB [1/25/500] gave out pooled object: oracle.jdbc.xa.client.OracleXAConnection@238f4
[StaffingDB] Pool StaffingDB [0/25/500] returned object oracle.jdbc.xa.client.OracleXAConnection@238f4 to the pool.
[StaffingDB] Started
[OracleDB] Starting
[OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
[OracleDB] Started
[InstantDB] Starting
[InstantDB] XA Connection pool InstantDB bound to java:/InstantDB
[InstantDB] The Initial Developer of the Original Code is Lutris Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies, Inc.
All Rights Reserved.
[InstantDB] Started
[DefaultDS] Starting
[DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[DefaultDS] Started
[JAAS Security Manager] Starting
[JAAS Security Manager] Started
[Container factory] Starting
[Container factory] Started
[J2EE Deployer] Starting
[J2EE Deployer] Cleaning up deployment directory file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/bin/../tmp/deploy/
[J2EE Deployer] Started
[Security manager] Starting
[Security manager] Started
[Auto deploy] Starting
[Auto deploy] Auto deploy of file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/deploy/ddc.ear
[J2EE Deployer] Deploy J2EE application: file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/deploy/ddc.ear
[J2EE Deployer] Could not delete temporary file: /D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/bin/../tmp/deploy/copy1001.zip
[J2EE Deployer] Create application ddc.ear
[J2EE Deployer] Installing web package: ddc.war
[J2EE Deployer] Installing EJB package: ddc-ejb.jar
[J2EE Deployer] Starting module ddc-ejb.jar
[Container factory] Deploying:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/bin/../tmp/deploy/ddc.ear/ejb1003.jar
[Container factory] Loading ejb-jar.xml : jar:file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/bin/../tmp/deploy/ddc.ear/ejb1003.jar!/META-INF/ejb-jar.xml
[Container factory] Loading standardjboss.xml : file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/conf/tomcat/standardjboss.xml
[Verifier] Verifying file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/bin/../tmp/deploy/ddc.ear/ejb1003.jar
[Verifier] ddc/DocumentPartMedia: Verified.
[Verifier] ddc/DocumentPart: Verified.
[Verifier] ddc/Product: Verified.
[Verifier] ddc/DocumentVersion: Verified.
[Verifier] ddc/DocumentLoader: Verified.
[Container factory] Deploying ddc/DocumentPartMedia
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Optimize='true'
[Container factory] Deploying ddc/DocumentPart
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Optimize='true'
[Container factory] Deploying ddc/Product
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Optimize='true'
[Container factory] Deploying ddc/DocumentVersion
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Optimize='true'
[Container factory] Deploying ddc/DocumentLoader
[Container factory] Container Invoker RMI Port='4444'
[Container factory] Container Invoker Optimize='true'
[Container factory] Binding an EJBReference ddc/DocumentPart
[Container factory] Binding ddc/DocumentPart to internal JNDI source: ddc/Product
[Container factory] Binding an EJBReference ddc/Product
[Container factory] Binding ddc/Product to internal JNDI source: ddc/Product
[Container factory] Binding an EJBReference ddc/DocumentPartMedia
[Container factory] Binding ddc/DocumentPartMedia to internal JNDI source: ddc/Product
[Container factory] Binding an EJBReference ddc/DocumentVersion
[Container factory] Binding ddc/DocumentVersion to internal JNDI source: ddc/Product
[Container factory] Mapped Container method remove HASH -1842617161
[Container factory] Mapped Container method getEJBHome HASH -993218923
[Container factory] Mapped Container method getHandle HASH 1182305581
[Container factory] Mapped Container method getPrimaryKey HASH -131865408
[Container factory] Mapped Container method isIdentical HASH 285457048
[Container factory] Mapped processDocument -771612751to public void mil.army.atsc.atia.ddc.ejb.DocumentLoaderEJB.processDocument(java.lang.String)
[Container factory] Mapped testIt -1882777018to public void mil.army.atsc.atia.ddc.ejb.DocumentLoaderEJB.testIt()
[Container factory] Mapping remove
[Container factory] Mapping remove
[Container factory] Mapping getEJBMetaData
[Container factory] Mapping getHomeHandle
[Container factory] Mapping create
[Container factory] Bound ddc/DocumentPart to ddc/DocumentPart
[Bean Cache] Cache policy scheduler started
[Container factory] Bound ddc/Product to ddc/Product
[Container factory] Bound ddc/DocumentLoader to ddc/DocumentLoader
[Container factory] Bound ddc/DocumentPartMedia to ddc/DocumentPartMedia
[Container factory] Bound ddc/DocumentVersion to ddc/DocumentVersion
[Container factory] Deployed application: file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/bin/../tmp/deploy/ddc.ear/ejb1003.jar
[J2EE Deployer] Starting module ddc.war
[EmbeddedTomcat] ContextManager: Adding context Ctx( /staff )
[EmbeddedTomcat] path="/staff" :jsp: init
[J2EE Deployer] J2EE application: file:/D:/JBOSS/jboss_tomcat/jboss-2.0-FINAL/deploy/ddc.ear is deployed.
[Auto deploy] Started
[SpyderMQ] Starting
[SpyderMQ] Testing if SpyderMQ is present....
[SpyderMQ] OK
[SpyderMQ] Starting SpyderMQ...
[SpyderMQ] Started
[JMX RMI Adaptor] Starting
[JMX RMI Adaptor] Started
[JMX RMI Connector] Starting
[JMX RMI Connector] Started
[Default] 23 services and 4 other MBeans started.
[Default] Shutdown hook added
[Default] jBoss 2.0 FINAL Started
[EmbeddedTomcat] path="/staff" :Controller: init
[StaffingDB] Resource 'oracle.jdbc.xa.client.OracleXAResource@4310d0' enlisted for 'oracle.jdbc.xa.client.OracleXAConnection@238f4'.
[StaffingDB] Pool StaffingDB [1/25/500] gave out pooled object: oracle.jdbc.xa.client.OracleXAConnection@238f4
[StaffingDB] Pool StaffingDB [0/25/500] returned object oracle.jdbc.xa.client.OracleXAConnection@238f4 to the pool.
[StaffingDB] Resource 'oracle.jdbc.xa.client.OracleXAResource@7a681c' enlisted for 'oracle.jdbc.xa.client.OracleXAConnection@238f4'.
[StaffingDB] Pool StaffingDB [1/25/500] gave out pooled object: oracle.jdbc.xa.client.OracleXAConnection@238f4
[Bean Cache] Resized cache for bean ddc/DocumentPartMedia: old size = 1000, new size = 50
[ddc/DocumentLoader] ORA-02049: timeout: distributed transaction waiting for lock
[ddc/DocumentLoader] java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock
[ddc/DocumentLoader] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
[ddc/DocumentLoader] at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
[ddc/DocumentLoader] at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1209)
[ddc/DocumentLoader] at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1321)
[ddc/DocumentLoader] at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
[ddc/DocumentLoader] at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
[ddc/DocumentLoader] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
[ddc/DocumentLoader] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
[ddc/DocumentLoader] at mil.army.atsc.atia.ddc.ejb.DocumentLoaderEJB.testIt(DocumentLoaderEJB.java:631)
[ddc/DocumentLoader] at java.lang.reflect.Method.invoke(Native Method)
[ddc/DocumentLoader] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:378)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:144)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
[ddc/DocumentLoader] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:163)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:228)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:152)
[ddc/DocumentLoader] at $Proxy7.testIt(Unknown Source)
[ddc/DocumentLoader] at mil.army.atsc.atia.ddc.controller.BeanTesterCommand.execute(BeanTesterCommand.java:41)
[ddc/DocumentLoader] at mil.army.atsc.atia.ddc.controller.Controller.handleRequest(Controller.java:73)
[ddc/DocumentLoader] at mil.army.atsc.atia.ddc.controller.Controller.doGet(Controller.java:49)
[ddc/DocumentLoader] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
[ddc/DocumentLoader] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[ddc/DocumentLoader] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[ddc/DocumentLoader] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[ddc/DocumentLoader] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[ddc/DocumentLoader] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
[ddc/DocumentLoader] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[ddc/DocumentLoader] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
[ddc/DocumentLoader] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[ddc/DocumentLoader] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[ddc/DocumentLoader] at java.lang.Thread.run(Thread.java:484)
[ddc/DocumentLoader] endresources(1): state=1
[ddc/DocumentLoader] TRANSACTION ROLLBACK EXCEPTION:Could not lookup Product; nested exception is:
javax.ejb.EJBException: Could not lookup Product
[ddc/DocumentLoader] javax.ejb.EJBException: Could not lookup Product
[ddc/DocumentLoader] at mil.army.atsc.atia.ddc.ejb.DocumentLoaderEJB.testIt(DocumentLoaderEJB.java:639)
[ddc/DocumentLoader] at java.lang.reflect.Method.invoke(Native Method)
[ddc/DocumentLoader] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:378)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:144)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
[ddc/DocumentLoader] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:163)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:228)
[ddc/DocumentLoader] at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:152)
[ddc/DocumentLoader] at $Proxy7.testIt(Unknown Source)
[ddc/DocumentLoader] at mil.army.atsc.atia.ddc.controller.BeanTesterCommand.execute(BeanTesterCommand.java:41)
[ddc/DocumentLoader] at mil.army.atsc.atia.ddc.controller.Controller.handleRequest(Controller.java:73)
[ddc/DocumentLoader] at mil.army.atsc.atia.ddc.controller.Controller.doGet(Controller.java:49)
[ddc/DocumentLoader] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
[ddc/DocumentLoader] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[ddc/DocumentLoader] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[ddc/DocumentLoader] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[ddc/DocumentLoader] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[ddc/DocumentLoader] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
[ddc/DocumentLoader] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[ddc/DocumentLoader] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
[ddc/DocumentLoader] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[ddc/DocumentLoader] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[ddc/DocumentLoader] at java.lang.Thread.run(Thread.java:484)
[EmbeddedTomcat] javax.transaction.TransactionRolledbackException: Could not lookup Product; nested exception is:
javax.ejb.EJBException: Could not lookup Product
[EmbeddedTomcat] path="/staff" :jsp: init
Dave Bolt
There is always plenty of bandwidth, just none for you.
