CODEWITHSUNDEEP
javasqlsql-serverjdbcsql-server-2014
Nayan Sonthalia
Nayan Sonthalia

Reputation: 247

JDBC driver for SQL server 2014

We have recently migrated to SQL server 2014 with JAVA 5 on one machine and JAVA 6 on another (this is a requirement). When I try to connect to database I get follwoing exception.

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (
       com.microsoft.sqlserver.jdbc.SQLServerException:
             The server version is not supported.
             The target server must be SQL Server 2000 or later.
       )
    at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:168)
    at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
    at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)

Following is the configuration:

Upvotes: 3

Views: 46769

Answers (2)

Nayan Sonthalia
Nayan Sonthalia

Reputation: 247

We discarded the sqljdnc4.jar and used jtds jar instead and everything works like a charm.

Upvotes: 0

Gord Thompson
Gord Thompson

Reputation: 123474

You will need to upgrade your SQL Server JDBC driver to at least version 4.0 (download here). Then you can use its versions of

  • sqljdbc.jar for Java 5, and
  • sqljdbc4.jar for Java 6

to access SQL Server 2014.

Upvotes: 2

Related Questions