2 Replies Latest reply on Jan 19, 2004 4:08 PM by Victor Rotaru

    msaccess-service.xml

    Richard Bottoms Newbie

       

      "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.




        • 1. Re: msaccess-service.xml
          Stjepan Brbot Newbie

           

          "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


          • 2. Re: msaccess-service.xml
            Victor Rotaru Newbie

             

            "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.