SQLException: Connection is read-only While accessing the Birt Report

ReportServer (EN)
1

Hi,

Created the Birt Report and Inside the report I am calling the Stored procedure.
In birt Designer report is working fine. I deployed the report to ReportServer and while accessing the report follwing exception occurred. I am using Mysql5.6 database

SEVERE: Cannot get more result sets from the statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Connection is read-only. Queries leading to data modification are not allowed
;
java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

Thanks,
Raj

2

Hi Raj,

ReportServer per default uses read-only transactions for reporting (for security reasons). The easiest way
to work around this for Birt is to not specify the report’s datasource within ReportServer. The Birt reporting
engine will then use the datasource specified directly within the rptdesign document and not use ReportServer’s
datasource pools (and hence the transaction is not set to read-only).

Hope this helps

Arno

3

Thanks Arno.
I used configured datasource in the report design document and Report is working fine.
Once again Thanks…

Raj