As far as I Know a Java stored procedure is a stored procedure written in Java, which can be called from an external java client using jdbc callable statement, exactly as any other pl/sql stored procedure. So does Websphere JDBC Adapter on ESB or WPS support invoking java stored procedure as any other stored procedure? RDBMS is oracle 11g, WPS/WAS/JBC Adapter version is 7.0.x . (I haven't found a clear infocenter reference on this, and I don't have customer's reference to its java stored procedures and database yet to test directly).
This topic has been locked.
Pinned topic JDBC Adapter and Java Stored Procedure
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Re: JDBC Adapter and Java Stored Procedure2013-02-28T17:16:53ZThis is the accepted answer. This is the accepted answer.I found on infocenter http://publib.boulder.ibm.com/infocenter/dmndhelp/v7r0mx/topic/com.ibm.wsadapters.jca.jdbc.doc/doc/cjdb_storedfunctionsov.html the following statement:
For Oracle databases, the adapter supports stored functions that a user creates with the CREATE FUNCTION statement. Although this type of function is sometimes called a user-defined function (UDF), that term more refers to a Java™ stored function or procedure, which the adapter does not support.
I am not really sure to understand: does it mean there is no support to java stored procedure at all?
Re: JDBC Adapter and Java Stored Procedure2013-02-28T17:43:49ZThis is the accepted answer. This is the accepted answer.Hi MM,
Java stored function or procedure is not supported by JDBC adapter since they do not get represented to the adapter as a business object.