Jump to content
Changes to the Jaspersoft community edition download ×

Data Adapter for JasperReports Server


Recommended Posts

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!

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...