Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

WebLogic Connection Pools and VARRY

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
use drivers from the DB vendor maybe?
 
NikhilN Kumar
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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??
 
Today's lesson is that you can't wear a jetpack AND a cape. I should have read this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic