Configuring JBoss 4.0 JDBC Connectivity
Subject:   Configuring Jboss for MS Access Dtabase
Date:   2005-05-14 05:55:34
From:   dvohra09
Response to: Configuring Jboss for MS Access Dtabase

To configure with the MS Access driver:

1. Copy the MS access jdbc-odbc driver jar file to the server/default/lib directory.

Copy msaccess-ds.xml from /docs/examples/jca directory to
/server/default/deploy directory.

In the msaccess-ds.xml set the connection-url to jdbc:odbc:<DSNNAME>. <DSNNAME> variable is the DSN name. Set the user-name and password.

In the standardjbosscmp-jdbc.xml set

<datasource-mapping>MS ACCESS</datasource-mapping>

In the standardjbosscmp-jdbc.xml add a type-mapping for MS ACCESS.

In the login-config.xml add a login configuration for MS ACCESS

<application-policy name = "MSACESSDbRealm">
<login-module code =
flag = "required">
<module-option name = "principal"></module-option>
<module-option name = "userName"></module-option>
<module-option name = "password"></module-option>
<module-option name ="managedConnectionFactoryName">

1 to 2 of 2
1 to 2 of 2