Hello Roman

The JDBC standard recomends a database URL syntax (see jdbc 3.0 - 9.2.1).

The syntax for the URL is jdbc:<subprotocol>:<subname>
and the syntax for network address as part of the subname //hostname:port/subsubname

Interclient follows this syntax as do DB2, Informix, PostgreSQL, SAPDB, mysql, Mimer, Frontbase and others.

Oracle, Sybase and SQLServer don't follow it.

This is one of the first problems the people face when trying to use our Driver and if we can support the standard URL it will
easier to switch from Interclient or from other databases.

I think this must be a task to do.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "rrokytskyy" <rrokytskyy@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Friday, July 19, 2002 3:37 PM
Subject: [Firebird-Java] Re: simple script to connect Firebird


> Richard,
>
> > 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
>
> Well... One can argue about URLs, Oracle for example has
>
> jdbc:oracle:thin:user/passwd@...:1521:ora_db
>
> :)
>
> > 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?
>
> As far a I know, URL format is not specified. When I joined the
> project it was already so, so nobody changed it later. Maybe it was
> easier to parse the string into components... If you wish, you can
> check org.firebirdsql.jgds.GDS_Impl.DBAttachInfo and create a patch
> that will support both schemes. If nobody has anything against it, we
> will commit it to the CVS. Personally I do not have anything against
> it but I would not invest time into this as well.
>
> Alejandro? David? Blas? Any comments on this?
>
> Best regards,
> Roman Rokytskyy
>
>
>
> 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/
>
>
>