I tried to use the jTDS driver in glassfishv3 and kept getting an "Unsupported Operation" error (Glassfish + Hibernate + Spring but I think the problem is glassfish). Below is a stack trace snippet. I've 'fixed' the problem for myself by implementing the net.sourceforge.jtds.jdbc.ConnectionJDBC2.getClientInfo() and net.sourceforge.jtds.jdbc.ConnectionJDBC2.setClientInfo() getters and setters with a private Property 'info' variable.
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309) at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.UnsupportedOperationException
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getClientInfo(ConnectionJDBC2.java:2573) <<<<<<<<<<<<<<<<<<<<<
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.getClientInfo(ConnectionHolder40.java:362)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.init(ConnectionHolder40.java:90)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.<init>(ConnectionHolder40.java:81)
at com.sun.gjc.spi.jdbc40.ConnectionWrapper40.<init>(ConnectionWrapper40.java:60)
at com.sun.gjc.spi.jdbc40.Jdbc40ObjectsFactory.getConnection(Jdbc40ObjectsFactory.java:86)
at com.sun.gjc.spi.ManagedConnection.getConnection(ManagedConnection.java:396)
at com.sun.enterprise.resource.allocator.LocalTxConnectorAllocator.fillInResourceObjects(LocalTxConnectorAllocator.java:103)
at com.sun.enterprise.resource.pool.ConnectionPool.getResource(ConnectionPool.java:432)
Anonymous
Ticket moved from /p/jtds/bugs/628/