Subject Re: [Firebird-Java] Error connecting Database
Author Rick Fincher
Hi Andres,

Instead of:
jdbc:firebirdsql://192.168.0.100/
<firebirdsql://192.168.0.100/>\\database\\informacionzonal.fdb

Use:
jdbc:firebirdsql://192.168.0.100:3050//database/informacionzonal.fdb

You have to have the Firebird port number (3050) in the URL.

Hope this helps,

Rick


Andres Eguiguren wrote:

> Hi everybody:
>
> I am using Eclipse and Firebird 1.5
>
> Inside Eclipse I don't have any problems connecting to database.
>
> But, when I create .jar file and access it I receive the following
> error:
>
> ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
> SQLException: No suitable driver
>
> I checked .classpath and has the following:
> <classpathentry exported="true" kind="lib"
> path="hibernate/firebirdsql-full.jar"/>
>
> I have a folder named hibernate and inside it firebirdsql-full.jar
> file.
>
> File structure is:
> \if\if.jar
> \if\hibernate\firebirdsql-full.jar
>
> the code I am using is:
>
> String DriverBDD = "org.firebirdsql.jdbc.FBDriver";
>
> String url = "jdbc:firebirdsql://192.168.0.100/
> <firebirdsql://192.168.0.100/>
> \\database\\informacionzonal.fdb";
>
> try {
> Class.forName("org.firebirdsql.jdbc.FBDriver");
>
> } catch(java.lang.ClassNotFoundException e) {
> System.err.print("ClassNotFoundException: ");
> System.err.println(e.getMessage());
> }
>
> try {
> con = DriverManager.getConnection(url,"SYSDBA", "masterkey");
> }
> catch(SQLException ex) {
> System.err.println("SQLException: " + ex.getMessage());
> }
> //end makeConnection
>
> Again: from inside Eclipse all is Ok., but with .jar file it doesn't
> work.
>
> Please, help me.
>
> Thanks in advance for you help.
>
>




[Non-text portions of this message have been removed]