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).
Thanks
MM
Topic
This topic has been locked.
2 replies
Latest Post
- 2013-02-28T17:43:49Z by SystemAdmin
ACCEPTED ANSWER
Answered question
This question has been answered.
Unanswered question
This question has not been answered yet.
Pinned topic JDBC Adapter and Java Stored Procedure
2013-02-28T16:37:52Z
|
Answered question
This question has been answered.
Unanswered question
This question has not been answered yet.
Updated on 2013-02-28T17:43:49Z at 2013-02-28T17:43:49Z by SystemAdmin
-
ACCEPTED ANSWER
Re: JDBC Adapter and Java Stored Procedure
2013-02-28T17:16:53Z in response to SystemAdminI 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?
MM -
ACCEPTED ANSWER
Re: JDBC Adapter and Java Stored Procedure
2013-02-28T17:43:49Z in response to SystemAdminHi 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.
Thanks,
Vinod
