Subject | Jaybird deploy problem: No suitable driver |
---|---|
Author | lbhifi |
Post date | 2010-04-27T09:03:28Z |
I'm a java newbie trying to connect to a remote Firebird db from a Windows 2003 server us-ing this code:
Class.forName("org.firebirdsql.jdbc.FBDriver");
DriverManager.getConnection(url, username, password);
the url is: jdbc:firebirdsql://hostname:3050/firebirdalias
Running the app using JDeveloper (and Win XP) works fine, but DriverManager.getConnection throws the error "No suitable driver" when running the deployed jar to a Windows 2003 server with this command:
java -Xms256M -Xmx1024M -jar d:\webroot\belops\prioritization\myapp.jar
I should note that the app runs fine on the server, apart from the Firebird connection. I even have an Oracle connection working, but jaybird is giving me a headache.
I have tried to remove jaybird from the deployed jar, just to se if it made a difference, and as expected Class.forName("org.firebirdsql.jdbc.FBDriver") throwed the error:
java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
So (when I include Jaybird in deploy jar) it seems java knows there's a Firebird driver, but for some reason refuses to return a connection.
Could it be a version problem?
I'm using jaybird-full-2.1.6.jar.
Win XP java:
java version "1.3.1.9"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1.9)
Java HotSpot(TM) Client VM (build 1.3.1-rc2-b22, mixed mode)
Windows 2003 Server java:
java version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode)
Class.forName("org.firebirdsql.jdbc.FBDriver");
DriverManager.getConnection(url, username, password);
the url is: jdbc:firebirdsql://hostname:3050/firebirdalias
Running the app using JDeveloper (and Win XP) works fine, but DriverManager.getConnection throws the error "No suitable driver" when running the deployed jar to a Windows 2003 server with this command:
java -Xms256M -Xmx1024M -jar d:\webroot\belops\prioritization\myapp.jar
I should note that the app runs fine on the server, apart from the Firebird connection. I even have an Oracle connection working, but jaybird is giving me a headache.
I have tried to remove jaybird from the deployed jar, just to se if it made a difference, and as expected Class.forName("org.firebirdsql.jdbc.FBDriver") throwed the error:
java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
So (when I include Jaybird in deploy jar) it seems java knows there's a Firebird driver, but for some reason refuses to return a connection.
Could it be a version problem?
I'm using jaybird-full-2.1.6.jar.
Win XP java:
java version "1.3.1.9"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1.9)
Java HotSpot(TM) Client VM (build 1.3.1-rc2-b22, mixed mode)
Windows 2003 Server java:
java version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode)