Subject Re: [Firebird-Java] Database URL and database alias
Author Michael Ludwig
Mr. Richard Tomkins schrieb am 20.11.2008 um 19:21:28 (-0500):
> OS X 10.4.11
> Firebird 2.1.1
> Jaybird 2.1.6
>
> Why does JDBC require the Database URL to be the full path to
> employee.fdb, rather than simply the database name?

I don't think it does. The following works for me on Windows with
Tomcat 6, Firebird 1.5 and Jaybird 2.1.6:

In "C:\Programme\Firebird\Firebird_1_5\aliases.conf":

test = C:\data\Firebird\test.fdb

In "context.xml":

<Resource name="jdbc/firebird/test"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.firebirdsql.jdbc.FBDriver"
username="bla" password="blub"
url="jdbc:firebirdsql:127.0.0.1:test" />

Or via DriverManager:

Class.forName( "org.firebirdsql.jdbc.FBDriver");
conn = DriverManager.getConnection(
"jdbc:firebirdsql:127.0.0.1:test", properties);

> I just found aliases.conf, what is @prefix@?

Don't know. Maybe a left-over placeholder from failed installation-time
template processing?

Michael Ludwig