Article:
  Configuring JBoss 4.0 JDBC Connectivity
Subject:   Configuring Jboss for MS Access Dtabase
Date:   2005-05-12 22:20:24
From:   doubtman
hi,
Can u tell me how to configure the jboss-cmp-jdbc.xml for Access database.
thanks
Full Threads Oldest First

Showing messages 1 through 4 of 4.

  • Configuring Jboss for MS Access Dtabase
    2005-05-14 05:55:34  Deepak Vohra | [View]


    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>
    • 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