1 Reply Latest reply on May 16, 2012 9:01 AM by notify

Accessing MS SQL 2008 from JBoss 6.1 - Server major version:8 is not supported by this driver.

notify May 14, 2012 8:18 AM

I using JBoss AS 6.1.0 Final and running using the JRE 6 included with jdk1.6.0_32.

I need to connect to a MS SQL 2008 database and have downloaded the latest Microsoft JDBC drivers contained in sqljdbc_4.0.2206.100_enu.exe.

I have copied sqljdbc4.jar to the default\lib folder and configure my DS etc.

When my App tries to connect to the MS SQL database I get;

12:32:53,064 WARNING [SQLServerConnection] ConnectionID:1 ClientConnectionId: a0955e8d-226a-44e6-b8f8-b0217cd3cf47 Server major version:8 is not supported by this driver.

12:32:53,080 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server version 8 is not supported by this driver. ClientConnectionId:a0955e8d-226a-44e6-b8f8-b0217cd3cf47)

A couple of posts said it was due to a bug in a previous JRE and upgrading to 32 would resolve it!

Any ideas?

TIA.

1. Re: Accessing MS SQL 2008 from JBoss 6.1 - Server major version:8 is not supported by this driver.

notify May 16, 2012 9:01 AM (in response to notify)

FIXED - Used SEAM-GEN to recreate my Project and added my code back. Unsure what caused it.

------------------------------------------------------------------------------------------------------------------------------------------------

Download the JDBC v.3.x driver from MS. "Solved" the "SQL Server version 8 is not supported by this driver" problem but now get (see below) I also get the same error if I use the JTDS open source MS SQL Driver too.

16:54:37,582 ERROR [ProfileServiceBootstrap] Failed to load profile:: org.jboss.deployers.client.spi.IncompleteDeploymentException:
Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

DEPLOYMENTS MISSING DEPENDENCIES:
Deployment "jboss-switchboard:appName=WADE,module=WADE.war" is missing the following dependencies:
    Dependency "persistence.unit:unitName=WADE.ear/WADE.jar#WADE" (should be in state "Installed", but is actually in state "** NOT
FOUND Depends on 'persistence.unit:unitName=WADE.ear/WADE.jar#WADE',whenRequired=MapControllerStateModel$ControllerStateWrapper@173a
f10{Start},dependentState=MapControllerStateModel$ControllerStateWrapper@1ea5dd3{Installed} **")
Deployment "jboss.web.deployment:war=/WADE" is missing the following dependencies:
    Dependency "jboss-switchboard:appName=WADE,module=WADE.war" (should be in state "Installed", but is actually in state "Create")

DEPLOYMENTS IN ERROR:
Deployment "persistence.unit:unitName=WADE.ear/WADE.jar#WADE" is in error due to the following reason(s): ** NOT FOUND Depends on
'persistence.unit:unitName=WADE.ear/WADE.jar#WADE',whenRequired=MapControllerStateModel$ControllerStateWrapper@173af10{Start},depend
entState=MapControllerStateModel$ControllerStateWrapper@1ea5dd3{Installed} **

         at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:1228) [:2.2.2.GA]
        at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(MainDeployerImpl.java:905) [:2.2.2.GA]
        at org.jboss.system.server.profileservice.deployers.MainDeployerPlugin.checkComplete(MainDeployerPlugin.java:87) [:6.1.0.Fin
al]
        at org.jboss.profileservice.deployment.ProfileDeployerPluginRegistry.checkAllComplete(ProfileDeployerPluginRegistry.java:107
) [:0.2.2]
        at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:135
) [:6.1.0.Final]
        at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:56)
[:6.1.0.Final]
        at org.jboss.bootstrap.impl.base.server.AbstractServer.startBootstraps(AbstractServer.java:827) [jboss-bootstrap-impl-base.j
ar:2.1.0-alpha-6]
        at org.jboss.bootstrap.impl.base.server.AbstractServer$StartServerTask.run(AbstractServer.java:417) [jboss-bootstrap-impl-ba
se.jar:2.1.0-alpha-6]
        at java.lang.Thread.run(Thread.java:662) [:1.6.0_32]

16:54:37,692 INFO [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
16:54:37,707 INFO [org.apache.coyote.ajp.AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
16:54:37,707 INFO [org.jboss.bootstrap.impl.base.server.AbstractServer] JBossAS [6.1.0.Final "Neo"] Started in 54s:21ms
Actions