Hello,
I'm trying to do jboss use a windows odbc connection, but I haven't success.
I've created a new odbc connection at Start->Settings->Control Panel-> Administrative Tools->Datasources (ODBC) called myODBCCon.
It's returning sucess when I test this connection clicking on Test Connection Button.
So... I've created odbc-ds.xml file at my project deploy directory:
<local-tx-datasource>
<jndi-name>myJNDIODBC</jndi-name>
<connection-url>jdbc:odbc:myODBCCon</connection-url>
<driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>
<user-name>myUser</user-name>
myPassword
<use-java-context>false</use-java-context>
</local-tx-datasource>
I don't have the error right now, but my question is about driver-class...
Do I need to put something in the classpath to do sun.jdbc.odbc.JdbcOdbcDriver works properly?
Am I forgetting some details in my odbc-ds.xml file?
Thank you
P.S: There's no possibility to use a jdbc driver right now, I really need to use a windows ODBC connection, please, don't ask about my reasons to use an ODBC connection.
That should be fine - the ODBC JDBC driver is included with the JDK rt.jar file. You'll need to post the error message along with the stack trace.