Subject | Re: simple script to connect Firebird |
---|---|
Author | rbair23 |
Post date | 2002-07-19T13:05:05Z |
Roman,
You know, I had problems initially with this as well until I saw the
DriverExample - then it all worked fine. The big difference was the
database URL. Formerly, Interclient (and every other JDBC driver I'd
used including PostgreSQL) had a connection string that looked like
this:
jdbc:interbase://myHost/opt/interbase/examples/employee.gdb
now it looks like this:
jdbc:firebirdsql:myHost/3050:/opt/interbase/examples/employee.gdb
I'm not totally familiar with the JDBC specifications, so I don't
know if the URL was changed to be in accordance with JDBC 2.0 or
something else. I'm just curious - why did it change?
You know, I had problems initially with this as well until I saw the
DriverExample - then it all worked fine. The big difference was the
database URL. Formerly, Interclient (and every other JDBC driver I'd
used including PostgreSQL) had a connection string that looked like
this:
jdbc:interbase://myHost/opt/interbase/examples/employee.gdb
now it looks like this:
jdbc:firebirdsql:myHost/3050:/opt/interbase/examples/employee.gdb
I'm not totally familiar with the JDBC specifications, so I don't
know if the URL was changed to be in accordance with JDBC 2.0 or
something else. I'm just curious - why did it change?
--- In Firebird-Java@y..., "rrokytskyy" <rrokytskyy@y...> wrote:
> > So please can someone who actually has it working put
> > together an example to perhaps connect to isc4.gdb and
> > display a list of user names. That should be standard across
> > all platforms.
>
> I just took InterClient's examples/DriverExample.java, replaced all
> references to InterClient with JCA-JDBC driver, and it works fine.
I
> will port other examples to JCA-JDBC driver and commit to CVS (I
> think there will be no licensing issues here, but I will check),
but
> I'm almost sure this will be a trivial task.
>
> Best regards,
> Roman