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 Apprentice

      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 Apprentice

          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