Oracle -> Java -> Oracle without creating new connection

From: Manolis Fanourgakis <manolis.fanourgakis_at_ontelecoms.com>
Date: Thu, 19 Oct 2006 14:44:37 +0300
Message-ID: <eh7of6$2kap$1@ulysses.noc.ntua.gr>

Hi there!

I am using an Oracle stored procedure to call a java class. I want this class to access the Oracle database that called it. I use the following line of code to get the connection:

Connection cn = DriverManager.getConnection("jdbc:default:connection")

Now, this works, but (I suppose) this creates a new connection. Can I get, somehow, the original connection that called the java class? This could be a lot quicker? Possibly not consuming connections from the connection pool?

Thanks in advance for any help. Received on Thu Oct 19 2006 - 06:44:37 CDT