Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: Brad BrezinskiHi,
We are using a JDBC Query node to connect to a SQL server using the DbDriver com.microsoft.sqlserver.jdbc.SQLServerDriver. It works on our test server, but doesn't work on our production server. I've include the error message below. What is the message indicating and how to I resolve the issue.
The db that we are querying did just update the java 1.8. Would I need to copy a new version of sqljdbc4.jar or sqljdbc.jar to the production server? Note, it's not affecting the test server....
We are using com.microsoft.sqlserver.jdbc.SQLServerDriver....
Thanks in advance! Brad
ERROR: missing required property: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
WARN: Node reported the following messages to stderr:
Jul 12, 2017 12:37:35 PM com.microsoft.sqlserver.jdbc.SQLServerConnection <init>
SEVERE: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Error Code: brain.unhandledLogging