Subject Re: simple script to connect Firebird
Author rbair23
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?

--- 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