Re: Oracle Data Source Config

[Robert McIntosh]

I would venture to say that just about any generic connection pooling 
library/implementation is going to wrap the underlying connection so 
that the pool can do its job, as they generally override the close() 
methods at the very least. Does the Oracle driver/connection have a 
specific method for executing the query? If it doesn't and it uses the 
basic executeQuery() type of methods on the JDBC statement, it would 
seem that it would work, since connection pool wrappers are just going 
to pass along the query to the underlying driver anyway, which would be 
your oracle one. If you have to use a specific method though, you might 
be out of luck.

- Robert

Austin Lowry wrote:

Maybe I should clarify my question.

The Weblogic connection pool works fine, the problem is that it 
returns a Weblogic connection object which is not suitable for use by 
OracleXMLQuery. I must have an Oracle connection object, such as 
OracleConnectionPoolDataSource for OracleXMLQuery to behave properly. 
My question is basicly, does anyone have a good way to implement 
Oracle connection pooling with Struts?

Thanks.

Marco Tedone wrote:

If Weblogic release a connection pool under a jndi name, you can get a
connection from the pool. I've done it with Jboss.
 

-----Original Message-----
From: Austin Lowry [mailto:[EMAIL PROTECTED] Sent: Monday, 
March 10, 2003 4:09 PM
To: [EMAIL PROTECTED]
Subject: Oracle Data Source Config

I've hit a bump in the road with my development because I have to be 
able to use an Oracle connection in order to use a class vital to my 
application. This made my Weblogic connection pool unusable because 
it uses it's own connection objects that use the Oracle driver. I 
think my best option at this point is to use the Struts 
<data-sources>. Does anyone have any experience with using Oracle 
and OracleConnectionPoolDataSource or OracleConnectionCacheImpl? I'm 
not really sure how to set this up and make sure I get back an 
Oracle connection object that I can use. Also, is there a better way 
to implement the connection pool and still return an Oracle 
connection object than through Struts? Thanks for your help.

  


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]