The Artima Developer Community
Sponsored Link

Java Buzz Forum
Connection Pooling Issue

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Nanik

Posts: 16
Nickname: nanik
Registered: Jun, 2003

Seasoned Contractor for J2EE
Connection Pooling Issue Posted: Jul 29, 2003 5:59 AM
Reply to this message Reply

This post originated from an RSS feed registered with Java Buzz by Nanik.
Original Post: Connection Pooling Issue
Feed Title: Nanik's Weblog
Feed URL: http://sedoparking.com/search/registrar.php?domain=®istrar=sedopark
Feed Description: Java, J2EE, Open Source, Cafe and other
Latest Java Buzz Posts
Latest Java Buzz Posts by Nanik
Latest Posts From Nanik's Weblog

Advertisement
We are going to use a lot of Stored Procedure in Oracle 9i, and we are having problem getting connection from the iPlanet connection pooling, because the connection returned is of type com.netscape.server.jdbc.ConnectionProxy and nowhere I read tells me that I can get the original OracleConnection object. In Tomcat it is possible to get the "original" database connection by using the following,


Context init = new InitialContext();
Context ctx = (Context) init.lookup("java:comp/env");
DataSource ds = (DataSource) ctx.lookup("jdbc/myOracleDS");

Connection cc = ds.getConnection();

PoolableConnection c = (PoolableConnection)cc;
Connection conn = c.getDelegate();

It's amazing sometimes that FREE product are much better and easier to learn and understand because of the availability of the source code.

Tips:
Read source-code if you are against the wall  

Read: Connection Pooling Issue

Topic: Broken Windows Previous Topic   Next Topic Topic: How Soon We Forget

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use