Forum Stats

  • 3,838,069 Users
  • 2,262,326 Discussions
  • 7,900,493 Comments

Discussions

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

852203
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 11.1.1.5

The version of the MySQL database:

mysqld Ver 5.1.53

I am using the following driver :

mysql-connector-java-5.1.25-bin


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(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)


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