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?
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??