msaccess-service.xml

[rbottoms]

"rbottoms" wrote:

"rbottoms" wrote:

"rbottoms" wrote:
Could someone detail the steps to connect to an Access databases under Jboss 3.0 and Windows XP?

Thanks,
r.b.

[sbrbot]

"sbrbot" wrote:

"sbrbot" wrote:

"sbrbot" wrote:
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.

HTH

[vrotaru]

"vrotaru" wrote:

"vrotaru" wrote:

"vrotaru" wrote:
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.