JBoss Community

Re: IJ000453: Unable to get managed connection for

created by Jose Cruz in Datasource Configuration - View the full discussion

Hello,

 

the problem was related with Oracle Nested Tables as stored procedure parameters. For each Table Type parameter the java api opens a connection to database. I still dont know why the connection pool aparently depleted all the connections, but after I transformed the nested table types to xml in the parameters (know I have varchar2 instead of table type), the access was much faster (about 100x, seriously!) and the problem disappeared.

 

thanks anyway,

José Cruz

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community