transaction « Connection « Java Database Q&A





1. How can I enlist an ODBC connection in an XA 2PC transaction?    stackoverflow.com

Our application uses ODBC to communicate with a database (Both DB2 and Oracle, if it makes a difference), and delegates business logic to Java by way of JNI (So it uses ...

2. How to assert that database connection is in a transaction?    stackoverflow.com

I'm using an object/relational mapper to talk to the database. The library in my case is iBatis which is also used for transaction management. However, I recently had a case ...

3. Is there a way to determine that a Connection is managed?    stackoverflow.com

I have some legacy JDBC code that is used within an EJB, in this code a call to setAutocommit() is made (which is not allowed for managed transactions, for understandable reasons). I ...

4. which is proven solution to connect mainframe and java ? which is best in MQ series / IBM CICS Transaction Gateway?    stackoverflow.com

which is proven solution to connect mainframe and java? Which is best in WebSphere MQ / IBM CICS Transaction Gateway? Which is best solution to connect to java and mainframe COBOL?

5. Behaviour of active transaction on connection close?    stackoverflow.com

If the close method is called and there is an active transaction, what will happen to active transactions. Will they be commited or rollback?

7. do we need to change transaction isolation level during life of a connection?    coderanch.com

It would be very unusual to change the isolation level during the connection lifetime. While there may be a benefit in very high performance environments, that would require very careful planning up front, and a solid understanding of the internals of the database being used. In general there should be no need to do this.

8. Connections, Transactions, Locks and Threads    coderanch.com

Boy that sure is a general topic I posted. My study group is getting together today, and I am trying to understand what considerations will need to be made in a distributed web environment. From a high level understanding, what is the interaction between Connections, Transactions, Locks and Threads? We saw that Struts 1 is not thread safe and we need ...

9. XA Transactions don't release connections    coderanch.com

Hello We have configured a distributed transaction in our application server in order to support transaction between Java and .NET running in a service call. The .NET clients are served by webservices and we are using OpenJPA. The problem is that after a bunch of service calls the app. server cannot allocate more connection and it seems the acquired connections won't ...





10. Getting AutoCommit as true for a connection during a JTS transaction    java-forums.org

We have a situation where connections being retrieved from a JDBC connection pool through a JDBCTxDataSource are having their autoCommit flag set to true (which should never happen) though it is in a Disributed transaction . We have confirmed that it is a JTS connection and not a pool connection. Has someone encountered this situation before? Does any configuration condition lead ...

11. is transaction enable connection pool required for a look up apps    forums.oracle.com

I am working on an application sittig on weblogic 9.1 with transaction enable connection pool deployed in server startup. But I am surprised as to why the connection is transaction enable because all the application is doing is table lookup.No update/insert/delete etc. The application uses EJB session bean/spring and hibernate to perform this look up task. Wondering why they must have ...