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:
AS FOLLOWS:
open the environment variables and set the folder here as follows:
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