Subject Re: [Firebird-Java] Re: Type 2 driver modifications are ready for review.
Author Luca Lafranchi
Hi Ryan :)


> Hello,
>
> I've continued to develop the type 2 driver modifications. The main things
> I've done since my last post are:
>
> 1) Exposed type 2 driver.
>
> a) Through DriverManager.getConnection() using url 'jdbc:firebirdsql:native
> etc etc'. Url 'jdbc:firebirdsql etc etc' uses type 4 as normal.
>


Sorry if this seems trivial, but I'm stuck at the connection.
If I try "jdbc:firebirdsql:native://localhost/e:/path/to/mydb.fdb" I get

"Cannot connect to this database:
jdbc:firebirdsql:native://localhost/e:/databases/firebird/immopac_20030616.fdb
org.firebirdsql.jdbc.FBSQLException: Resource Exception. unavailable
database
Reason: unavailable database"

If I try "jdbc:firebirdsql:native//localhost/e:/path/to/mydb.fdb"
(without ":" after "native") I get
"java.lang.NumberFormatException: For input string: "/e"
at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:426)
at java.lang.Integer.parseInt(Integer.java:476)
at org.firebirdsql.jgds.GDS_Impl$DbAttachInfo.<init>(GDS_Impl.java:2051)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:254)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:602)
at
org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:109)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:433)
at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:61)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:104)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:288)"

Note that I can substitute "localhost" with anything ("loopback"
included), and still it doesn't work.
The dlls are in /bin directory of the jdk, and using the prevoius
"firebird_embeded.jar" file everything goes well.

What am I doing wrong?

TIA
Luca