Hi Everybody,
I am stuck at a very weird problem. The oracle.sql.ARRAY constructor is
intermittently taking 2-3 secs to load. Below is the code snippet.
// We first obtain the connection from the connection pool
Connection con = ConnectionManager.getConnection (false);
// We then get the underlying connection.
Connection underlyingCon = ((WrappedConnection) con).getUnderlyingConnection();
// Here TAB_TEST is our oracle collection object
ArrayDescriptor tabTest = ArrayDescriptor.createDescriptor ("TAB_TEST", underlyingCon);
// objTest is the actual data that we want to pass to the database. Its class implements SQLData
// *This constructor is taking lots of time*
ARRAY tabTestArray = new ARRAY (tabTest, underlyingCon, objTest);
I have tried using ojdbc14.jar and ojdbc5.jar in vain.
If anyone has any pointers on this issue, please share.
I am aware that this is a duplicate post (
437908 But no solution was provided in this post.
TIA,
Nitin.