Database path

[Mamu Jan]

Hi,

How can I make the following line "drive independent":

String myDB ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=F:/MyApp/data/month.MDB";

I am looking for the java equivalent of App.drive/App.path of Visual Basic or something similar.

Any sorta help wud b gr8ly appreciated
[ October 11, 2005: Message edited by: Mamu Jan ]

[Annie Smith]

What do you mean by "drive independent"?

One way I could think of, configure a connection pool and use a datasource to lookup for connections.