Skip to main content

Is Glassfish 9.1 supported MS SQL Server 2008?

4 replies [Last post]
sankarm
Offline
Joined: 2008-09-03

We are using Glassfish with MS SQL Server 2008.
Glassfish 9.0 is supported for MS SQL Server 2008.
But Glassfish 9.1 is not supported.

If possible, how to configure..
let me know how to proceed this scenario.

This is exception trace when i deploy our application in glassfish with MS SQL Server 2008.
java.sql.SQLFeatureNotSupportedException: This operation is not supported.
at com.microsoft.sqlserver.jdbc.SQLServerConnection.getClientInfo(SQLServerConnection.java:2874)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.getClientInfo(ConnectionHolder40.java:353)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.init(ConnectionHolder40.java:81)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.(ConnectionHolder40.java:72)
at com.sun.gjc.spi.jdbc40.Jdbc40ObjectsFactory.getConnection(Jdbc40ObjectsFactory.java:51)
at com.sun.gjc.spi.ManagedConnection.getConnection(ManagedConnection.java:328)
at com.sun.enterprise.resource.LocalTxConnectorAllocator.fillInResourceObjects(LocalTxConnectorAllocator.java:100)
at com.sun.enterprise.resource.AbstractResourcePool.getResource(AbstractResourcePool.java:502)
at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:248)
at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:176)
at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:327)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:158)
at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:108)
at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:730)
at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
at com.sun.enterprise.server.PersistenceUnitLoaderImpl.load(PersistenceUnitLoaderImpl.java:149)
at com.sun.enterprise.server.PersistenceUnitLoaderImpl.load(PersistenceUnitLoaderImpl.java:84)
at com.sun.enterprise.server.AbstractLoader.loadPersistenceUnits(AbstractLoader.java:898)
at com.sun.enterprise.server.ApplicationLoader.doLoad(ApplicationLoader.java:184)
at com.sun.enterprise.server.TomcatApplicationLoader.doLoad(TomcatApplicationLoader.java:126)
at com.sun.enterprise.server.AbstractLoader.load(AbstractLoader.java:244)
at com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:225)
at com.sun.enterprise.server.ApplicationLifecycle.onStartup(ApplicationLifecycle.java:217)
at com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:442)
at com.sun.enterprise.server.ondemand.OnDemandServer.onStartup(OnDemandServer.java:120)
at com.sun.enterprise.server.PEMain.run(PEMain.java:411)
at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
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)
at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
sankarm
Offline
Joined: 2008-09-03

Thanx for the information......

sankarm
Offline
Joined: 2008-09-03

Hi ryan,
I can ping in connection pool of application server. but if i deploy the application that exception arises..

jr158900
Offline
Joined: 2005-04-13

I am assuming you use Jdk 1.6 and the jdbc-driver is jdbc 4.0 compliant. But it does not seem to support setClientInfo. GlassFish will try to set / reset client info for every getConnection(). Since the driver is throwing the exception, it is logged. If you are not using clientInfo, you can ignore the exception.

Related bug :
https://glassfish.dev.java.net/issues/show_bug.cgi?id=1766

Please check your driver vendor's documentation for connection.get/setClientInfo implementation/support.

Ryan de Laplante

You probably need a newer version of the JDBC driver that supports MSSQL
Server 2008. Also look at the open source jTDS driver for MS SQL Server.

http://jtds.sourceforge.net/

glassfish@javadesktop.org wrote:
> We are using Glassfish with MS SQL Server 2008.
> Glassfish 9.0 is supported for MS SQL Server 2008.
> But Glassfish 9.1 is not supported.
>
> If possible, how to configure..
> let me know how to proceed this scenario.
>
> This is exception trace when i deploy our application in glassfish with MS SQL Server 2008.
> java.sql.SQLFeatureNotSupportedException: This operation is not supported.
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.getClientInfo(SQLServerConnection.java:2874)
> at com.sun.gjc.spi.jdbc40.ConnectionHolder40.getClientInfo(ConnectionHolder40.java:353)
> at com.sun.gjc.spi.jdbc40.ConnectionHolder40.init(ConnectionHolder40.java:81)
> at com.sun.gjc.spi.jdbc40.ConnectionHolder40.(ConnectionHolder40.java:72)
> at com.sun.gjc.spi.jdbc40.Jdbc40ObjectsFactory.getConnection(Jdbc40ObjectsFactory.java:51)
> at com.sun.gjc.spi.ManagedConnection.getConnection(ManagedConnection.java:328)
> at com.sun.enterprise.resource.LocalTxConnectorAllocator.fillInResourceObjects(LocalTxConnectorAllocator.java:100)
> at com.sun.enterprise.resource.AbstractResourcePool.getResource(AbstractResourcePool.java:502)
> at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:248)
> at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:176)
> at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:327)
> at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189)
> at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165)
> at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:158)
> at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:108)
> at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
> at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
> at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
> at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
> at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915)
> at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:730)
> at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
> at com.sun.enterprise.server.PersistenceUnitLoaderImpl.load(PersistenceUnitLoaderImpl.java:149)
> at com.sun.enterprise.server.PersistenceUnitLoaderImpl.load(PersistenceUnitLoaderImpl.java:84)
> at com.sun.enterprise.server.AbstractLoader.loadPersistenceUnits(AbstractLoader.java:898)
> at com.sun.enterprise.server.ApplicationLoader.doLoad(ApplicationLoader.java:184)
> at com.sun.enterprise.server.TomcatApplicationLoader.doLoad(TomcatApplicationLoader.java:126)
> at com.sun.enterprise.server.AbstractLoader.load(AbstractLoader.java:244)
> at com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:225)
> at com.sun.enterprise.server.ApplicationLifecycle.onStartup(ApplicationLifecycle.java:217)
> at com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:442)
> at com.sun.enterprise.server.ondemand.OnDemandServer.onStartup(OnDemandServer.java:120)
> at com.sun.enterprise.server.PEMain.run(PEMain.java:411)
> at com.sun.enterprise.server.PEMain.main(PEMain.java:338)
> 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)
> at com.sun.enterprise.server.PELaunch.main(PELaunch.java:412)
> [Message sent by forum member 'sankarm' (sankarm)]
>
> http://forums.java.net/jive/thread.jspa?messageID=315704
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net