java stored procedures connection context

From: Eugene <eugene_at_profitlogic.com>
Date: 8 Mar 2004 06:56:10 -0800
Message-ID: <9573e6b2.0403080656.1fd5c21@posting.google.com>

In my Oracle database there are two java stored procedures:

A java stored procedure P1 having
Connection conn1 = DriverManager.getConnection("jdbc:default:connection") and
a java stored procedure P2 having
Connection conn2 = DriverManager.getConnection("jdbc:default:connection")

P1 calls P2 using conn1.CallableStatement.

Here is the question: does P2 inherit the connection context conn1 (so that actualy conn2 = conn1) or P2's transactional scope is separate from P1's one?

Thanks,
-Eugene Received on Mon Mar 08 2004 - 08:56:10 CST