BIRT JDBC ResultSet Error using Stored Proc with MariaDB
Hi. We're trying to create a BIRT report Data Set in Eclipse, with a result set from a stored proc, using a MariaDB database and Java/JDBC driver. Using the following query syntax:
{call sp_fetch_data(?,?)}
This worked with an earlier MariaDB client version (1.5.9), but with newer versions (I've tried 2.0.3 and 2.7.1), it fails with the following error, and the parameters and output columns are not populated:
A BIRT exception occurred.
Plug-in Provider:Eclipse BIRT Project
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:4.13.0.v202303021806
Error Code:odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:(conn:64) OUT or INOUT argument 2 for routine mydb.sp_fetch_data is not a variable or NEW pseudo-variable in BEFORE trigger
;
java.sql.SQLSyntaxErrorException: (conn:64) OUT or INOUT argument 2 for routine mydb.sp_fetch_data is not a variable or NEW pseudo-variable in BEFORE trigger
If I switch the MariaDB JDBC driver back to the earlier version (1.5.9), it works again.
I'm using the latest version of Eclipse/BIRT, 4.13.0, and the back end MariaDB is 10.2.17.
Any ideas? Could this be a bug / difference in the newer (v2.x) MariaDB JDBC driver versions, or is there something we need to do differently to work with this version? Thanks.
Categories
- All Categories
- 117 Developer Announcements
- 52 Articles
- 145 General Questions
- 132 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 8.9K Extended ECM
- 912 Cloud Fax and Notifications
- 81 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 165 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 4 XM Fax