Article:
  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.
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html



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


<jbosscmp-jdbc>
<defaults>
<datasource>java:/MSAccessDS</datasource>
<datasource-mapping>MS ACCESS</datasource-mapping>
</defaults>
</jbosscmp-jdbc>


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">
<authentication>
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal"></module-option>
<module-option name = "userName"></module-option>
<module-option name = "password"></module-option>
<module-option name ="managedConnectionFactoryName">
jboss.jca:service=LocalTxCM,name=MSAccessDS
</module-option>
</login-module>
</authentication>
</application-policy>
Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • Configuring Jboss for MS Access Dtabase
    2005-06-02 08:13:05  hesi [View]

    You can try the HXTT Access Package.It is a type 4 jdbc driver for Microsoft Access,so it don't need jdbc-odbc bridge.
    You can download the trial version from http://www.hxtt.net.
    Good Lucks.
  • Configuring Jboss for MS Access Dtabase
    2005-06-02 08:07:03  hesi [View]

    You can try the HXTT Access Package.It is a type 4 jdbc driver for Microsoft Access,so it don't need jdbc-odbc bridge.
    You can download the trial version from http://www.hxtt.net.
    Good Lucks.
    • Configuring Jboss for MS Access Dtabase and Sql server
      2005-09-24 07:45:04  santoro [View]

      Method to configure JBoss-3.2.5 to use Access and MS Sql database for entity and session bean