[Newbie] Cannot create a ODBC-JdBC Datasource

[michelmemeteau]

Hi, I'm a Jboss beginner .

i want to connect to an access database and so am trying to use the SUN JDBC-ODBC bridge :

in standalone.xml I added  a driver

   <driver name="com.gemalto.odbc" module="com.xxx.odbc">

                        <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>

                        <datasource-class>

                            sun.jdbc.odbc.JdbcOdbcDriver

                        </datasource-class>

       </driver>

And created the correct path in module  /com/xxx/odbc containing a module.xml :

<module xmlns="urn:jboss:module:1.0" name="com.xxx.odbc">

  <resources>

    <resource-root path="rt.jar"/>

        <!-- Insert resources here -->

  </resources>

  <dependencies>

    <module name="javax.api"/>

  </dependencies>

</module>

I then created a DataSource that use this new  driver and get the following log at startup :

New missing/unsatisfied dependencies:

      service jboss.jdbc-driver.com_xxx_odbc (missing)

- If I use the same syntax but for MySQL JDBC driver it works great.

Two questions :

- How can I get a detailed log of the Phase where it tries to lookup the sun.jdbc.odbc.JdbcOdbcDriver class from the module info ? I guess it just cannot find the Class although it's right in the rt.jar of my JDK 1.6 ( I've tested with a sample java code that works with this ODBC driver)

- Is this the right way to connect to this kind of JDBC driver ? I guess the fact that it's not JDBC 4.0 compliant has someting to do with my problem ?

Regards

[jesper.pedersen]

http://www.javalinux.it/wordpress/2011/07/14/how-to-create-an-manage-datasources-in-as7/

[michelmemeteau]

Hi jesper and thanks for your suggestion.

But it seems i'm correctly specifying my Driver, it's just that it does not work with the ODBC-JDBC bridge , the same config works great if I use the MySQL JDBC jar .

[jesper.pedersen]

Try and add sun/jdbc in the sun.jdk module and add system as a dependency in your module.