Multiple Datasources Driver Error

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email with questions or issues requiring TIBCO review or response.

In reference to

I've followed these instructions, switched language to "Groovy", and pasted my jdbc driver in just about every /lib/ I can find. Also, this was working just fine yesterday. I'm dead in the water on this.

My setup:

- I have a primary datasource that works well, the main query returns values.

- I have a secondary datasource that tests successfully, and if I use it in another dataset, records are returned.

- As soon as I add a parameter to the main report, java.sql.Connection, with the default expression, java.sql.DriverManager.getConnection("jdbc:rssbus:salesforce:user=aaa;password=bbb;AccessToken=ccc","aaa","bbb")

I get this error:  

Filling report...  Locale: English (United States)  Time zone: Default Error filling print... Error evaluating expression :      Source text : java.sql.DriverManager.getConnection("jdbc:rssbus:salesforce:user=aaa;password=bbb;AccessToken=ccc","aaa","bbb") net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :      Source text : java.sql.DriverManager.getConnection("jdbc:rssbus:salesforce:user=aaa;password=bbb;AccessToken=ccc","aaa","bbb")      at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(      at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(      at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(      at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(      at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(      at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(      at net.sf.jasperreports.engine.fill.JRFiller.fill(      at net.sf.jasperreports.engine.JasperFillManager.fill(      at net.sf.jasperreports.engine.JasperFillManager.fillReport(      at      at org.openide.util.RequestProcessor$      at org.openide.util.RequestProcessor$  Caused by: java.sql.SQLException: No suitable driver found for jdbc:rssbus:salesforce:user=aaa;password=bbb;AccessToken=ccc      at java.sql.DriverManager.getConnection(Unknown Source)      at java.sql.DriverManager.getConnection(Unknown Source)      at java_sql_DriverManager$ Source)      at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(      at      at      at MonthlyReport45v1_1407358374503_946504.evaluate(calculator_MonthlyReport45v1_1407358374503_946504:166)      at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(      ... 13 more  Print not filled. Try to use an EmptyDataSource...

jenj's picture
Joined: Jun 17 2014 - 11:04am
Last seen: 6 years 2 months ago

(Also I have my classpath set to the driver jar)

jenj - 7 years 11 months ago

I am instead using a subreport with this alternate datasource, and passing it the connection parameter. That seems to be working for now.

jenj - 7 years 10 months ago

0 Answers:

No answers yet