Topic
1 reply Latest Post - ‏2013-05-03T23:46:58Z by alberto_cl
SystemAdmin
SystemAdmin
37422 Posts
ACCEPTED ANSWER

Pinned topic Configuring JDBC provider for MS SQL in WAS7

‏2013-03-13T15:24:01Z |
Hello,
I'm trying to create a data source in WAS7 using MS SQL server db. I have tried to configure a jdbc provider using sqljdbc_4.0. I renamed the classpath value to sqljdbc4.jar. I created the data source. But the connection fails and says:

The test connection operation failed for data source Microsoft SQL Server JDBC Driver - XA DataSource on server server1 at node TP-AHMEDSW7Node01 with the following exception: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0..

I've seen in the other threads suggesting to use the sqljdbc_1.2, but that version is no longer available.
Any workaround for this?

Thank you
  • alberto_cl
    alberto_cl
    1 Post
    ACCEPTED ANSWER

    Re: Configuring JDBC provider for MS SQL in WAS7

    ‏2013-05-03T23:46:58Z  in response to SystemAdmin

     

    I have had the same problem (or similar one):

    In my case I had a sqljdbc.jar in the class path and it was used instead of sqljdbc4.jar

    I removed this jar and everything was ok 

    Alberto