This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes WebLogic Connection Pools and VARRY Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "WebLogic Connection Pools and VARRY" Watch "WebLogic Connection Pools and VARRY" New topic
Author

WebLogic Connection Pools and VARRY

NikhilN Kumar
Greenhorn

Joined: Jun 30, 2003
Posts: 9
We are using weblogic JDBC connection pools in a clustered environment. The stored procs are taking VARRAY's as parms. There seems to be an issue with BEA 7.0 spk2 and earlier - according to our vendors who are working on the project, there seem to be issues with the binding of VARRAY types with WLS drivers.

The question is:
1. Could we use Table/ Tablesets instead of VARRAYs?
2. What are the issues with BEA (7.0 spk2) and VARRAYs?
Any comments/ suggestions?
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
use drivers from the DB vendor maybe?
NikhilN Kumar
Greenhorn

Joined: Jun 30, 2003
Posts: 9
We are using the Oracle thin driver. The issue is that the Oracle connection pools do not serialize and do not cluster. WebLogic connection pools do, but they do not seem to work with VARRAYs. Which is why we are looking for another best practice/ recommendation.
What are the options that we have??
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WebLogic Connection Pools and VARRY
 
Similar Threads
Log in Servlet
Need WEBLOGIC 7.0,Problem with 10g
connection pooling thru weblogic 7.0
Advice for a book
What is connection pooling?and why would one go for it