Hello,

I appologise for the slow reply, and also for not picking up the potential
problem in the first time around.

The URL 'jdbc:firebirdsql:native://localhost/e:/path/to/mydb.fdb' will
attempt to use the driver in type 2 mode - as opposed to using the embeded
database.

The driver is loading either fbclient.dll or gds32.dll and attempting to
make a connection to an interbase or firebird server - and this is
presumably not running on localhost which is why the unavailable database
exception is being thrown.

My current intention is to use something like
jdbc:firebirdsql:native_embeded://localhost/e:/path/to/mydb.fdb - perhaps
allowing the host and port name to be exluded - for using the embeded
server. This has not been done in
firebirdsql-full_withtype2changes_02.jar(the code which I will be commiting
today with any luck). Basicly for the driver its a matter of linking with a
different library fbembeded.dll as opposed to the actual client library. I
will add this in shortley after commiting the main modifications - at which
point the cvs version of the driver will be usable with the embeded
database.

I will let you know once I have commited everything needed to use the
embeded server to CVS. It should only be a matter of days now.

Thanks
Ryan



-----Original Message-----
From: Luca Lafranchi [mailto:luca.lafranchi@...]
Sent: 18 June 2003 08:55
To: Firebird-Java@yahoogroups.com
Subject: Re: [Firebird-Java] Re: Type 2 driver modifications are ready
for review.


Sorry if it took so long...

I'm still getting
"
org.firebirdsql.jdbc.FBSQLException: Resource Exception. unavailable
database
Reason: unavailable database
"

I'm using the "firebirdsql-full_withtype2changes_02.jar" file.

Again, if I use the "firebird_embeded.jar" from
firebirdembededforjava_JDK14_RC1_01.zip everything goes well (of course
the connection looks different...) so I'm still assuming that the dlls
are in the right place...

Ciao
Luca


Ryan Baldwin wrote:

> Hello,
>
> Did Roman's suggestion help ?
>
> If not then which jar file are you attempting to use ?
>
> These changes have not been commited to CVS yet so the CVS version will

not

> accept this URL yet.
>
> Thanks
> Ryan
>
>
> -----Original Message-----
> From: Luca Lafranchi [mailto:luca.lafranchi@...]
> Sent: 17 June 2003 08:02
> To: Firebird-Java@yahoogroups.com
> Subject: Re: [Firebird-Java] Re: Type 2 driver modifications are ready
> for review.
>
>
> 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.f

> db
> 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(FBManagedConne

> ctionFactory.java:602)
> at
>

org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:109)

> at
>

org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBMan

> agedConnectionFactory.java:433)
> at
>

org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStand

> AloneConnectionManager.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
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/