jueves, 11 de junio de 2015

HOW TO FIX A JDBC ERROR IN WAS SERVER websphere application server 8.5.5



WHEN YOU HAVE THE FOLLOWING ERROR IN WEBSPHERE APPLICATION SERVER V8.5.5:

[6/11/15 22:00:43:918 PDT] 00000069 SQLServerConn E   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.
[6/11/15 22:00:43:918 PDT] 00000069 DataSourceCon E   DSRA8040I: Failed to connect to the DataSource.  Encountered "": 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.
at com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304)
at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(SQLServerDataSource.java:620)




SOLUTION:

FIRST: VERIFY THE FOLLOWING CONFIGURATION IN THE JDBC DRIVER:
AS FOLLOWS:


open the environment variables and set the folder here as follows:

verify the connection test the connection, we are using Java JRE 1.6


Then you need to verify the systemout.log of the was server

SYSTEMOUT.log

FINALLY THE VALIDATION:
***************************************
[6/11/15 22:10:35:408 PDT] 00000067 DSConfigurati I   DSRA8205I: JDBC driver name  : Microsoft SQL Server JDBC Driver 3.0
[6/11/15 22:10:35:408 PDT] 00000067 DSConfigurati I   DSRA8206I: JDBC driver version  : 3.0.1301.101
[6/11/15 22:10:35:408 PDT] 00000067 DSConfigurati I   DSRA8025I: Successfully connected to DataSource.
[6/11/15 22:10:35:439 PDT] 00000067 DSConfigurati I   DSRA8203I: Database product name : Microsoft SQL Server



THE CONNECTION WAS SUCCESFULL, IS MIPORTANT TO NOTE TO USE JDBC DRIVER 3 NOT 4

No hay comentarios:

Publicar un comentario

Blogger Widgets