Data Adapter for JasperReports Server

Posted on August 5, 2015 at 7:45am

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!

JasperReports® Server
Jaspersoft® Studio
mattp.prime's picture
mattp.prime
3
Joined: Aug 4 2015 - 7:56am
Last seen: 7 years 7 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 - 7 years 7 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 - 7 years 7 months ago
add comment

1 Answer:

Posted on August 5, 2015 at 6:33pm

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
hozawa
170769
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 9 months ago
Feedback
randomness