"leon" wrote...

I'm not sure what you mean by "DataSource" in this case, as it could happen
that you've mixed up two different concepts...

As the documentation for javax.sql.DataSource says, DataSources is
"typically" used through JNDI, but it is not necessary to use JNDI in order
to use DataSources.

The use of DataSources is most efficient though, when it can be used through
JNDI as "DataSource-factories", e.g. from a J2EE/EJB-container, where JNDI
is "built-in".

Well...

If you really "need" to use a DataSource through JNDI, then you have to put
up a JNDI-compliant nameserver with the possibility to manage DataSources
somewhere...

Otherwise you're really better off using the "old" way with DriverManager,
if you're using MS Access...

In what environment are you actually going to use this database?

If it is from such a container, then you have to figure out how to configure
the container to use the ordinary jdbc/odbc-bridge for MS Access, which can
be tricky, and the configuration can also differ between different
containers.

Some of them also have difficulties to configure a datasource based on the
jdbc/odbc-bridge at all...

And you'll also have a hard time to try to find some other jdbc-drivers for
MS Access that support the use of DataSources...

If you just want the "feeling" of using a DataSource, then you can roll your
own... ;-)

An example of a DataSource for MS Access I had laying around... ;-)

======================================================

package abelli;

import java.sql.SQLException;
import java.sql.Connection;
import java.io.PrintWriter;
import java.io.File;
import java.sql.DriverManager;

/**
 * AccessDataSource is a basic implementation of a DataSource
 * for a Microsoft JET/Access database, to simplify the
 * handling of such a database as a DataSource.
 *
 * NB!!! This is nothing else than a wrapper around an ordinary
 * jdbc/odbc-bridge, so don't expect any improvement in performance...
 * <p>
 *
 * @AccessDataSource.java    1.02 2002-11-01
 * @author Bj?rn Abelli
 * @see javax.sql.DataSource
 * @see java.sql.DriverManager
 * @since JDK1.4
 */

public class AccessDataSource implements javax.sql.DataSource
{
 private String url = null;

/**
*
* AccessDataSource(String path) registers the standard JdbcOdbcDriver
* with the DriverManager, and sets an internal pathvalue to the mdb-file.
*
* @AccessDataSource
*
* @param path
*
* <b>path</b> is the physical address to the mdb-file with the database.
*
*/

 public AccessDataSource (String path) throws SQLException
 {
   DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
   url = "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" + path;

   File file = new File(path);
   if (!file.exists())
      throw new SQLException("\nFile \"" + path + "\" not found");
 }

/**
*
* getConnection() returns a Connection based on the path
* passed at construction of this DataSource.<br>
*
* @getConnection
*
* @see java.sql.Connection
*/

 public Connection getConnection() throws SQLException
 {
   return DriverManager.getConnection (url);
 }

/**
*
* getConnection() returns a Connection based on the path
* passed at construction of this DataSource.<br>
*
* @getConnection
*
* @param username
* @param password
*
* <b>username</b> and <b>password</b> are passed to the database
* in the attempt to establish a Connection. If the database is not
* password-protected, the arguments are ignored.<br>
*
* @see java.sql.Connection
*/

 public Connection getConnection(String username, String password)
 throws SQLException
 {
   return DriverManager.getConnection (url, username, password);
 }

/**
*
* getLogWriter() returns the PrintWriter-object
* connected to the DriverManager's LogWriter.<br>
*
* @getLogWriter
*
* @see java.sql.DriverManager
* @see java.io.PrintWriter
*/

 public PrintWriter getLogWriter() throws SQLException
 {
   return DriverManager.getLogWriter();
 }

/**
*
* setLogWriter(PrintWriter out) sets the PrintWriter-object
* connected to the DriverManager's LogWriter.<br>
*
* @setLogWriter
*
* @param out
*
* @see java.sql.DriverManager
* @see java.io.PrintWriter
*/

 public void setLogWriter(PrintWriter out) throws SQLException
 {
   DriverManager.setLogWriter(out);
 }

/**
*
* setLoginTimeout() is ignored. It is not possible at
* this time to set any timeout<br>
*
* @setLoginTimeout
*
*/

 public void setLoginTimeout(int seconds) throws SQLException
 {
 }

/**
*
* getLoginTimeout() returns the default value of 0<br>
*
* @getLoginTimeout
*
*/

 public int getLoginTimeout()
 {
   return 0;
 }
}

=========================================

So, now you can just instantiate it like this:

import abelli.*;
...

DataSource mdb = new AccessDataSource ("path\\foobar.mdb");

Connection conn = mdb.getConnection("", "");

...

Good luck...

// Bjorn A