Subject | RE: [Firebird-Java] Re: Java and Embedded Firbird. |
---|---|
Author | Ryan Baldwin |
Post date | 2003-10-03T12:42:56Z |
Hi,
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:
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/
>Now I'm having a problem using db visualize to view the data. I can't storeand 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:
> Hito have
>
> 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
> the database relative to the dll? The old one let me use aconnection URL
> like "jdbc:firebirdsql:loopback:FHUS" and it got the database FHUSout of
> the same directory as the dll. However this new one seems to want a pathtoo the
> 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
> same standard as the official release.uploaded could
>
> People who have been using the files from the previous file I
> benefit from using these newer files. I seemed to find that RC4 of thewhile ago.
> 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
> I've been having some problems with the pool's in the current CVSversion -
> but it should be possible to check out the latest code from cvs andreplace
> the firebirdsql-full.jar - the dll's should work OK.http://docs.yahoo.com/info/terms/
>
> Thanks
> Ryan
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
>----------------------------------------------------------------------------
>
>
>
>
>
> --only for
> This message may contain confidential information, and is intended
> the use of the individual(s) to whom it is addressed.============================================================================
>
>
>
> ==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
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/