users@glassfish.java.net

Re: How to configure JDBC-ODBC driver as a JDBC resource?

From: <glassfish_at_javadesktop.org>
Date: Thu, 12 Jul 2007 07:25:44 PDT

That fixed that issue. I'm now stuck at a different ODBC error.

java.lang.RuntimeException: javax.resource.ResourceException: Connection could not be allocated because: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
        at com.sun.enterprise.tools.admingui.util.JMXUtil.invoke(JMXUtil.java:124)
        at com.sun.enterprise.tools.admingui.util.JMXUtil.invoke(JMXUtil.java:75)
        at com.sun.enterprise.tools.admingui.handlers.JdbcHandlers.pingJdbcConnectionPool(JdbcHandlers.java:530)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)

It looks like the ODBC side of the bridge is unable to locate the DSN. I've configured the DSN as a System DSN (Windows XP) and succesfully tested the connection both via the "ODBC Data Source Administrator" dialog and via a Java SE application.

So looks like this might be related to Glassfish.
[Message sent by forum member 'r_sudh' (r_sudh)]

http://forums.java.net/jive/thread.jspa?messageID=226338