Topic
  • 2 replies
  • Latest Post - ‏2013-02-18T22:50:34Z by SystemAdmin
SystemAdmin
SystemAdmin
30895 Posts

Pinned topic WAS7.0.0.23 with MSSQL 2008 Type 3 driver Sqljdbc4.jar

‏2013-02-12T04:57:45Z |
Hi All

Currently we are migrating MSSQL 2000 database to MSSQL2008 in our testing phase in WAS7 we change the driver file to Sqljdbc4.jar but when test the connection from admin console still we can see older version of jar file
2/11/13 16:53:09:506 EST 00005abb DSConfigurati I DSRA8205I: JDBC driver name : Microsoft SQL Server 2005 JDBC Driver
2/11/13 16:53:09:514 EST 00005abb DSConfigurati I DSRA8206I: JDBC driver version : 1.2.2828.100
2/11/13 16:53:09:523 EST 00005abb DSConfigurati I DSRA8025I: Successfully connected to DataSource

following steps completed still old version info in log file
1.Copy new Sqljdbc4.jar file
2.Define Websphere variables on cluster scope
3.Create JDBC provider Microsoft SQL Server JDBC Driver and datasource
Any input will be appreciate
Updated on 2013-02-18T22:50:34Z at 2013-02-18T22:50:34Z by SystemAdmin
  • CodyBurleson
    CodyBurleson
    12 Posts

    Re: WAS7.0.0.23 with MSSQL 2008 Type 3 driver Sqljdbc4.jar

    ‏2013-02-15T06:05:15Z  
    Take a look at the JDBC Datasource item in WAS or the deployment manager. That should show you the WAS variables used in the path to the driver. You can trace it down by looking at WAS Variables and find out what is actually defined for those var1ables. Can you confirm that you have truly put the jar exactly whe th JDBC DS is configured to look and that the jar name is the one with the 4 in it?

    Probably, you tried all that, but... just in case.
  • SystemAdmin
    SystemAdmin
    30895 Posts

    Re: WAS7.0.0.23 with MSSQL 2008 Type 3 driver Sqljdbc4.jar

    ‏2013-02-18T22:50:34Z  
    Take a look at the JDBC Datasource item in WAS or the deployment manager. That should show you the WAS variables used in the path to the driver. You can trace it down by looking at WAS Variables and find out what is actually defined for those var1ables. Can you confirm that you have truly put the jar exactly whe th JDBC DS is configured to look and that the jar name is the one with the 4 in it?

    Probably, you tried all that, but... just in case.
    Thanks for your response,
    Yes in JDBC Datasource item WAS variables is looks like that ${MICROSOFTSQL_JDBC_DRIVER_PATH}/sqljdbc4.jar

    Even I tried this option as well, /usr/opt/WebSphere7/AppServer/driver/MSSQL/sqljdbc4.jar but still showing same old version
    Thanks Shahid Akhtar