4 Replies Latest reply on May 15, 2012 6:39 AM by maderhan

    Problem: Configuration MS Access DataSource JDBC-ODBC driver (sun.jdbc.odbc.jdbcodbcdriver, AS7.1.1, windows)

    maderhan
    maderhan May 15, 2012 6:33 AM

      Hi,

      I have got problems using a ms access database datasource.

      It simply does not work.

      Here is the message during restart:

       

      JBAS014775:    New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.jdbcodbc (missing) dependents:

                [service jboss.data-source.java:/comp/env/jdbc/accessDb]

       

      I did a lot research but now I got stuck... Please help!!

      Any ideas higly appreciated.

       

      Hans-Dieter

       

      Config: ../standalone.xml

       

      ...

      <datasource jta="false" jndi-name="java:/comp/env/jdbc/accessDb" pool-name="accessDb_Pool"

           enabled="true" use-java-context="true" use-ccm="true">

       

           <connection-url>"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=\\path\MAPS_MFA_ERG07.accdb"</connection-url>

           <driver>jdbcodbc</driver>

       

      </datasource>

      ...

      <drivers>

           <driver name="jdbcodbc" module="josf3.sun.jdbc.odbc"/>

      </drivers>

       

       

      Config: ..modules/josf3/sun/jdbc/odbc/main/main.xml

       

      <?xml version="1.0" encoding="UTF-8"?>

      <module xmlns="urn:jboss:module:1.1" name="josf3.sun.jdbc.odbc">

          <dependencies>

              <system export="true">

                  <paths>

                      <path name="sun/jdbc/odbc"/>

                      <path name="sun/jdbc/odbc/ee"/>

                  </paths>

              </system>

          </dependencies>

      </module>