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]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
