Forum Stats

  • 3,838,069 Users
  • 2,262,326 Discussions



852203 Member Posts: 23
edited Feb 26, 2020 11:02AM in Business Process Management Suite
Hi All,

I want to connect to a stored procedure that is on mySQL database via BPEL and Jdeveloper

The version of the MySQL database:

mysqld Ver 5.1.53

I am using the following driver :


I have pointed my JDeveloper to the new driver
By doing the following :
JDeveloper > Tools > Manage Libraries > ...
When I test the connection it give me a success.

In creating a new BPEL partnerlink - DatabaseAdapter with the new Connection to the MySQL and it seems to work, when I want to select from a table.

But when I use the option Call stored procedure or function, using the schema aci. I can see the stored procedure aci_insert but when I want to select it, I am getting the following:

An Error occured while obtaining arguments/source code for the selected stored procedure. Verify that the database connection is valid.

Details :

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'parameters' in information_schema
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
at java.lang.reflect.Constructor.newInstance(
at com.mysql.jdbc.Util.handleNewInstance(
at com.mysql.jdbc.Util.getInstance(

I am selecting the aci schema, but do not know why it keep on refering to information_schema
This discussion has been closed.