This content has been marked as final. Show 2 replies
AFAIK Microsoft Access database one can access from Java only through Type I JDBC driver i.e. JDBC-ODBC bridge. So you have to define ODBC datasource (DSN) on your computer and access this datasource using bridge driver provided by Sun.
In %JBOSS_HOME%/docs/examples/jca you can find an example of msaccess-ds.xml configuration file and see how to do it.
<datasources> <local-tx-datasource> <jndi-name>MSAccessDS</jndi-name> <connection-url>jdbc:odbc:DSN</connection-url> <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class> <user-name>username</user-name> <password>password</password> </local-tx-datasource> </datasources>
Define this file according to the name of your DSN and deploy it under deploy directory of your JBoss application server.
Go to: http://servlet.java.sun.com/products/jdbc/drivers and search:
There are a couple of companies selling JDBC drivers for Access.
Jdbc-Odbc bridge is just for playing. Don't even think of using it in production.