Subject RE: [Firebird-Java] Re: Java and Embedded Firbird.
Author Ryan Baldwin
Hi,

>Now I'm having a problem using db visualize to view the data. I can't store
and retrieve data via jdbc connection. >My jdbc connection string is
jdbc:firebirdsql:embedded/C:/programs/firebird/db/test.gdb but this seems to
cause >problems. Any idea why? What db visualize tool have you guys
successfully used?

Not knowing what visualization tool you are trying to use how its set up or
what actual problem your having I can only give some general advice.

So to use the embedded database with a visualization tool you will need to -

1) Ensure the the JRE being used to run the visualization has had the
jaybird native and embedded database files extracted ito its bin directory
as with the JDK.

2) You will need to make sure that the firebirdsql-full.jar file is on the
classpath for the visulization tool. Their may be a configuration file where
this can be specified or it is in theory possible for this to be done at
runtime - but somehow you will need to have told it about
firebirdsql-full.jar.

3) Somewhere you will need to tell the visualization tool about
'org.firebirdsql.jdbc.FBDriver' so it can do a
Class.forName("org.firebirdsql.jdbc.FBDriver");

4) Try a URL like this
'jdbc:firebirdsql:embedded://localhost:3050/C:\DATABASE.FDB'. I know its
stupid to specify localhost:3050 for embedded database - but I cant say for
certain that it will work without this - but I can say that this URL should
work. I will sort this out for the first offfical beta of jaybird 1.5.

Hope this helps

Ryan


-----Original Message-----
From: Aden [mailto:saden1@...]
Sent: 02 October 2003 16:30
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Java and Embedded Firbird.


Ok I'm up and running with embedded firebird. Now I'm having a problem
using db visualize to view the data. I can't store and retrieve data
via jdbc connection. My jdbc connection string is
jdbc:firebirdsql:embedded/C:/programs/firebird/db/test.gdb but this
seems to cause problems. Any idea why? What db visualize tool have you
guys successfully used?

--- In Firebird-Java@yahoogroups.com, "Ryan Baldwin"
<ryan.baldwin@n...> wrote:
> Hi
>
> I will look into this - it should be possible to make it work with a
> relative path again. I would also like to remove the need to specify the
> hostname too while I'm at it as obviously this makes no sense for the
> embedded server.
>
> Thanks
> Ryan
>
> -----Original Message-----
> From: Brian Chevrier [mailto:chevrierbr@l...]
> Sent: 02 October 2003 04:57
> To: Firebird-Java@yahoogroups.com
> Subject: RE: [Firebird-Java] Re: Java and Embedded Firbird.
>
>
> I am trying to use this new one and am wondering if there is a way
to have
> the database relative to the dll? The old one let me use a
connection URL
> like "jdbc:firebirdsql:loopback:FHUS" and it got the database FHUS
out of
> the same directory as the dll. However this new one seems to want a path
> from the root directory of the drive.
>
> >>> ryan.baldwin@n... 09/30/03 04:16AM >>>
> Hi,
>
> I've uploaded an updated set of files for jaybird and FB1.5 embedded to
> http://groups.yahoo.com/group/Firebird-Java/files/ in zip file
> FBEmbeddedRC6ForJaybird.zip.
>
> This archive contains brief usage instructions. I have made these files
> available 'unofficialy' and they are not meant to be of or packaged
too the
> same standard as the official release.
>
> People who have been using the files from the previous file I
uploaded could
> benefit from using these newer files. I seemed to find that RC4 of the
> embedded server(and maybe RC1 too) had a major performance problem which
> appears to be fixed in RC6. Minor bugfixes have also been made in the
> jaybird native code.
>
> The firebirdsql-full.jar file included is built from CVS a little
while ago.
> I've been having some problems with the pool's in the current CVS
version -
> but it should be possible to check out the latest code from cvs and
replace
> the firebirdsql-full.jar - the dll's should work OK.
>
> Thanks
> Ryan
>
>
>
> 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/
>
>
>
>
>
>
----------------------------------------------------------------------------
> --
> This message may contain confidential information, and is intended
only for
> the use of the individual(s) to whom it is addressed.
>
>
>
============================================================================
> ==
>
>
>
> 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/