[jboss-user] [Datasource Configuration] - Re: IJ000453: Unable to get managed connection for

[Jose Cruz]

Jose Cruz [https://community.jboss.org/people/joselopesdacruz] created the discussion

"Re: IJ000453: Unable to get managed connection for"

To view the discussion, visit: https://community.jboss.org/message/772773#772773

--------------------------------------------------------------
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
[https://community.jboss.org/message/772773#772773]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20121029/e0f84599/attachment.html