search

PHPJasper / phpjasper

A PHP report generator
MIT License
463 stars 162 forks source link

JRJdbcQueryExecuter:144 - The supplied java.sql.Connection object is null #317

Closed johnwswar closed 2 years ago

johnwswar commented 2 years ago

I'm relatively new to Jasper Reports, and get the following error: JRJdbcQueryExecuter:144 - The supplied java.sql.Connection object is null. I believe the issue could be due to the REPORT_CONNECTION. <![CDATA[$P{REPORT_CONNECTION}]]>. I didn't understand the answer that was posted by Danillosdd.

I am currently passing the options which includes the db_connections. What is causing this error? Do I need to separately pass in the REPORT_CONNECTION parameter? If so, what information do I pass in and how does it get passed? A sample code would be beneficial. Thank you.

johnwswar commented 2 years ago

I was able to resolve this issue by changing the 'db_connection' parameter. Hope it helps someone.