Hi, We use the following JBOSS Datasource: <datasources> | <ha-local-tx-datasource> | <!-- | The JNDI name under which the DataSource wrapper will be bound. Note that | this name is relative to the "java:/" prefix unless use-java-context is false.--> | <jndi-name>OracleDS</jndi-name> | | <!-- Setting this to false will bind the DataSource into global jndi --> | | <use-java-context>false</use-java-context> | | | <!-- An element to specify that all intermediate end(suspend) and | start(resume) calls. Also, all work on one tx will go through one | connection. | A side effect of this (currently at least) is that a connection will only | be usable by one tx until the tx commits. | <track-connection-by-tx/> | --> | | | | <!-- The database URL . --> | <connection-url>${redbox.oracle.url}</connection-url> | <url-delimeter>;</url-delimeter> | | <!-- The fully qualifed name of the javax.sql.Driver implementation class --> | <driver-class>${redbox.oracle.driver.class:oracle.jdbc.OracleDriver}</driver-class> | | <!-- The login and password. Remplace | <user-name>${redbox.oracle.username}</user-name> | <?xml version="1.0"?> | <!DOCTYPE connection-factories | PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN" | "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd"> | | <!-- The Hypersonic embedded database JCA connection factory config | $Id: oracle-nonxa-ds.xml,v 1.4 2006/05/18 07:21:38 pignace Exp $ --> | | <datasources> | <ha-local-tx-datasource> | | | <!-- | The JNDI name under which the DataSource wrapper will be bound. Note that | this name is relative to the "java:/" prefix unless use-java-context is false.--> | <jndi-name>OracleDS</jndi-name> | | <!-- Setting this to false will bind the DataSource into global jndi --> | | <use-java-context>false</use-java-context> | | | <!-- An element to specify that all intermediate end(suspend) and | start(resume) calls. Also, all work on one tx will go through one | connection. | A side effect of this (currently at least) is that a connection will only | be usable by one tx until the tx commits. | <track-connection-by-tx/> | --> | | | | <!-- The database URL . --> | <connection-url>${redbox.oracle.url}</connection-url> | <url-delimeter>;</url-delimeter> | | <!-- The fully qualifed name of the javax.sql.Driver implementation class --> | <driver-class>${redbox.oracle.driver.class:oracle.jdbc.OracleDriver}</driver-class> | | <!-- The login and password. Remplace | <user-name>${redbox.oracle.username}</user-name> | <password>${redbox.oracle.password}</password> | --> | | <connection-property name="User">${redbox.oracle.username}</connection-property> | <connection-property name="Password">${redbox.oracle.password}</connection-property> | <user-name>${redbox.oracle.username}</user-name> | <password>${redbox.oracle.password}</password> | | | | <!--example of how to specify class that determines if exception means connection should be destroyed--> | <!--exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorter</exception-sorter-class-name--> | | <!-- this will be run before a managed connection is removed from the pool for use by a client--> | <!-- new-connection-sql>select DUMMY from DUAL</new-connection-sql --> | | <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use --> | <min-pool-size>1</min-pool-size> | | <!-- The maximum connections in a pool/sub-pool --> | <max-pool-size>10</max-pool-size> | | <!-- The time before an unused connection is destroyed --> | <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use --> | <!-- TEMPORARY FIX! - Disable idle connection removal, HSQLDB has a problem with not reaping threads on closed connections --> | <idle-timeout-minutes>1</idle-timeout-minutes> | | <!-- sql to call when connection is created --> | <new-connection-sql>select DUMMY from DUAL</new-connection-sql> | | <!-- sql to call on an existing pooled connection when it is obtained from pool --> | <check-valid-connection-sql>select DUMMY from DUAL</check-valid-connection-sql> | | <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa --> | <no-tx-separate-pools/> | | <!-- example of how to specify a class that determines a connection is valid before it is handed out from the pool --> | <valid-connection-checker-class-name> | org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker | </valid-connection-checker-class-name> | | <!-- Checks the Oracle error codes and messages for fatal errors --> | <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> | | <!-- Whether to check all statements are closed when the connection is returned to the pool, | this is a debugging feature that should be turned off in production --> | <track-statements/> | | <!-- Use the getConnection(user, pw) for logins | <application-managed-security/> | --> | | <!-- Use the security domain defined in conf/login-config.xml --> | <!-- security-domain>HsqlDbRealm</security-domain --> | | <!-- Use the security domain defined in conf/login-config.xml or the | getConnection(user, pw) for logins. The security domain takes precedence. | <security-domain-and-application>HsqlDbRealm</security-domain-and-application> | --> | | <!-- set-tx-query-timeout/ --> | <!-- query-timeout>10</query-timeout --> | | <type-mapping>Oracle9i</type-mapping> | </ha-local-tx-datasource> | </datasources> Sometimes, we noticed that 2 threads are locked (see the following thread dump): Open lock chains | ================ | Chain 1: | "http-0.0.0.0-8080-3" id=306 idx=0x9a tid=4669 waiting for oracle/jdbc/driver/T4CCon | nection@0x1cb77700 held by: | "http-0.0.0.0-8080-2" id=305 idx=0x98 tid=4668 (active) | | ===== END OF THREAD DUMP =============== | | | "http-0.0.0.0-8080-3" id=306 idx=0x9a tid=4669 prio=5 alive, in native, interrupted, blocked, daemon | -- Blocked trying to get lock: oracle/jdbc/driver/T4CConnection@0x1cb77700[thin lock] | at _dl_sysinfo_int80+2(:0)@0x4737a2 | at ptWaitForEvent+45(:0)@0xb7ec8481 | at vmtWaitUntilNotSoftSuspended+67(:0)@0xb7ed39f7 | at tsCheckTransitToJava+26(:0)@0xb7ed3a4a | at jrockit/vm/Threads.shortNap(I)V(Native Method) | at jrockit/vm/Locks.waitForThinRelease(Ljava/lang/Object;I)I(Unknown Source) | at jrockit/vm/Locks.monitorEnterSecondStage(Ljava/lang/Object;I)Ljava/lang/Object; | (Unknown Source) | at jrockit/vm/Locks.monitorEnter(Ljava/lang/Object;)Ljava/lang/Object;(Unknown Source)[optimized] | at oracle/jdbc/driver/PhysicalConnection.prepareStatement(Ljava/lang/String;)Ljava/sql/PreparedStatement;(PhysicalCon | nection.java:651) | | | "http-0.0.0.0-8080-2" id=305 idx=0x98 tid=4668 prio=5 alive, in native, interrupted, daemon | at _dl_sysinfo_int80+0(:0)@0x4737a0 | at RJNI_jrockit_net_SocketNativeIO_readBytesPinned+180(:0)@0xb7eb1428 | at jrockit/net/SocketNativeIO.readBytesPinned(I[BIII)I(Native Method) | at jrockit/net/SocketNativeIO.socketRead(Ljava/io/FileDescriptor;[BIII)I(Unknown Source) | at java/net/SocketInputStream.socketRead0(Ljava/io/FileDescriptor;[BIII)I(Unknown S | ource) | at java/net/SocketInputStream.read([BII)I(SocketInputStream.java:129) | at oracle/net/ns/Packet.receive()V(Unknown Source) | at oracle/net/ns/DataPacket.receive()V(Unknown Source) | at oracle/net/ns/NetInputStream.getNextPacket()V(Unknown Source) | at oracle/net/ns/NetInputStream.read([BII)I(Unknown Source) | at oracle/net/ns/NetInputStream.read([B)I(Unknown Source) | at oracle/net/ns/NetInputStream.read()I(Unknown Source) | at oracle/jdbc/driver/T4CMAREngine.unmarshalUB1()S(T4CMAREngine.java:978) | at oracle/jdbc/driver/T4CMAREngine.unmarshalSB1()B(T4CMAREngine.java:950) | at oracle/jdbc/driver/T4C8Oall.receive()V(T4C8Oall.java:434) | at oracle/jdbc/driver/T4CPreparedStatement.doOall8(ZZZZ)V(T4CPreparedStatement.java:181) | at oracle/jdbc/driver/T4CPreparedStatement.execute_for_rows(Z)V(T4CPreparedStatement.java:629) | at oracle/jdbc/driver/OracleStatement.doExecuteWithTimeout()V(OracleStatement.java:1080) | at oracle/jdbc/driver/OraclePreparedStatement.executeInternal()I(OraclePreparedS | tatement.java:2904) | at oracle/jdbc/driver/OraclePreparedStatement.executeUpdate()I(OraclePreparedStatement.java:2976) | ^-- Holding lock: oracle/jdbc/driver/T4CConnection@0x1cb77700[thin lock] | ^-- Holding lock: oracle/jdbc/driver/T4CPreparedStatement@0x1dd23f38[thin lock] | +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Is it a bug of the JDBC driver or the JBOSS datasource implementation? At any rate, if we use the C3P0 connection pool instead of JBOSS ManagedConnectionPool, the problem of blocked threads do not occur any more. Do you have an explaination? Thanks in advance. Best Regards, David View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100588#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...