Data Adapter for JasperReports Server

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 community@tibco.com with questions or issues requiring TIBCO review or response.

Hello, I'm new to creating reports and need some help setting up a data adapter to talk to my JasperReports Server in AWS. 

I can connect to the server using Studio and everything shows up fine. I tried creating a JR adapter, but not sure how to point it at the server, domain, etc. Halp!

mattp.prime's picture
Joined: Aug 4 2015 - 7:56am
Last seen: 6 years 10 months ago

Update, I was able to add the data source from the server, but when creating a new report studio hangs on getting data from the data source. Am I missing a driver?

mattp.prime - 6 years 11 months ago

Error text when testing connection:

net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: tibcosoftware.jdbc.sqlserver.SQLServerDriver
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:173)
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)
at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)
at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:162)
at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:59)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: tibcosoftware.jdbc.sqlserver.SQLServerDriver
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:501)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:174)
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:145)
... 5 more
mattp.prime - 6 years 11 months ago

1 Answer:

Is the error from Jaspersoft Studio or from JasperReports Server?

>net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: tibcosoftware.jdbc.sqlserver.SQLServerDriver

The error is just saying you're missing a jar file. I strongly recommend not using Tibco software's jdbc driver but instead use jdbc driver from Microsoft.

You'll need to specify the jar file in the "Driver Classpath" tab in Jaspersoft Studio and upload the jar file when creating Datasource in JasperReports Server.

hozawa's picture
132120
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 3 weeks ago
Feedback
randomness