You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@commons.apache.org by Sergey Karpov <ks...@smtp.ru> on 2004/11/24 09:53:30 UTC

Call Oracle stored procedure via DBCP?

Hello!

Is Tomcat + DPCP + JNDI and Oracle + stored procedure...

When from the application on Tomcat the call of stored procedure is carried out through "direct" connection with Oracle - all normally... And results in ResultSet come back...

However when "direct" connection is replaced with the connection received from pool connection (DBCP) there is a mistake. 

Thus all elementary searches (such as select...) through DBCP to base work normally...

For connection with base in all cases it is used JDBC thin driver. 

What could it be?

KSV