B4J Question Jasper report with data from Firebird

amorosik

Expert
Licensed User
Longtime 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
Longtime 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