B4J Question Jasper report with data from Firebird

amorosik

Expert
Licensed User
I'm trying to create a Jasper report connected with Firebird db server
I'm using Jasper Studio 5.6.1, but since the creation of the data adapter I have problems in the sense that indicating as
Jdbc Driver = org.firebirdsql.jdbc.FBDriver
and as
JDBC Url = jdbc:firebirdsql://192.168.1.10:3050/c:/FIR_DATA/ERp2_test.FDB
does not i can pass the test in the sense that it returns to me

"Reason: org/firebirdsql/jdbc/FBDriver: Unsupported major.minor mersion 52.0" (with Driver ClassPath = jaybird-3.0.8.jar)


B4X:
net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
    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:129)
    at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:165)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
    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:175)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:145)
    ... 4 more

Anyone can help me for connect jasper report to Firebird db data?
 

amorosik

Expert
Licensed User
With last version of Jasper Report Studio 6.20.5, and Driver ClassPath jaybird-5-0-1java11.jar, all is fine
 
Upvote 0
Solution
Top