Subject Jaybird deploy problem: ”No suitable driver”
Author lbhifi
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)