ReportServer Forum

RajaSekhar

Member

Registered: 2013-10-25

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

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

Arno Mittelbach

datenwerke

Registered: 2012-02-14

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

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

RajaSekhar

Member

Registered: 2013-10-25

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

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

Raj