I’m trying to connect to an existing Firebird database with Lucee 5.3.7.47 on Windows 10.
I’ve tried creating a datasource and defining it in the Application.cfc with zero luck.
I can connect to MS SQL and My SQL fine. I’ve put the JAR files in Lucee for Firebird.
Here’s the connection string (it works in several other apps): jdbc:firebirdsql://hub:3050/D:\SiteWatch\DB\SiteWatch.FDB
I believe it’s a problem with where to put the JAR Files. I spent two days checking the connection string. The other possibility is the user account running Lucee doesn’t have access to the network path. (Windows 10 default install). Other tools like DBeaver connect with that connection string.
Thanks!
What is the correct folder to place the Jar files for the JDBC Driver?
As for the database path, I’ve tried several variations. Note that I do have several other tools linked to that server via JDBC with the exact connection defined above. (DBBeaver, etc.) The JDBC Driver is “jaybird” as you can see in the error log below.
I’ll be happy to fix this or write an extension if one is needed.
Thanks!
This is on a server and I’ve tried the network path a number of ways
'jdbc:firebirdsql://hub:3050/D:/SiteWatch/DB'
'jdbc:firebirdsql://hub:3050/D$/SiteWatch/DB'
'jdbc:firebirdsql://hub:3050/D:\SiteWatch\DB'
'jdbc:firebirdsql://hub:3050/D$\SiteWatch\DB'
```etc.
**This is the end of the error thread:**
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NoClassDefFoundError: javax/resource/ResourceException
… 48 more
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException not found by jaybird.4.0.1.java8 [51]
at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1597)
at org.apache.felix.framework.BundleWiringImpl.access$300(BundleWiringImpl.java:79)
at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.loadClass(BundleWiringImpl.java:1982)
at java.lang.ClassLoader.loadClass(Unknown Source)
… 48 more
Ok - so I know the jaybird.jar files are being used because they are locked by Windows. It still cannot find something. See the error below. I’m not sure if I’m missing a JAR file or not putting them everywhere they should be. They are in:
…\lucee\tomcat\lucee-server\context\lib
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.NoClassDefFoundError: javax/resource/ResourceException
... 48 more
Caused by: java.lang.ClassNotFoundException: javax.resource.ResourceException not found by jaybird.4.0.1.java11 [50]
at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1597)
at org.apache.felix.framework.BundleWiringImpl.access$300(BundleWiringImpl.java:79)
at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.loadClass(BundleWiringImpl.java:1982)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
Thank you!
That worked perfectly! I was using jaybird-full-4.0.1.java8.jar, not jaybird-full-3.0.9.jar (although I thought I had tried it.)
I put the Jar in \lucee\lib
Is the same/better to put it in Tomcat?
Thanks again, you don’t know how much I appreciate it. I knew it was something easy, just couldn’t get the right combination or Jar, directory, etc.