Multiple Datasources Driver Error

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 11 months ago

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

jenj - 8 years 7 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 - 8 years 7 months ago

0 Answers:

No answers yet