1 Reply Latest reply: May 16, 2012 9:01 AM by Roger Lee RSS

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

Roger Lee Novice

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.
    Roger Lee Novice

    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