mattp.prime Posted August 5, 2015 Share Posted August 5, 2015 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 More sharing options...
mattp.prime Posted August 5, 2015 Author Share Posted August 5, 2015 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? Link to comment Share on other sites More sharing options...
mattp.prime Posted August 5, 2015 Author Share Posted August 5, 2015 Error text when testing connection:net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: tibcosoftware.jdbc.sqlserver.SQLServerDriverat 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.SQLServerDriverat 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 More sharing options...
hozawa Posted August 6, 2015 Share Posted August 6, 2015 Is the error from Jaspersoft Studio or from JasperReports Server?>net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: tibcosoftware.jdbc.sqlserver.SQLServerDriverThe 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now