Re: NIFI java.lang.UnsupportedOperationException
FIxed the issue , it was JAVA_HOME that should be defined on the server . it was using another version , still when u go to the server and on command prompt u run java --version it gives 1.8 but NIFI was using different version cause JAVA_HOME wasnt defined -- View this message in context: http://apache-nifi-developer-list.39713.n7.nabble.com/NIFI-java-lang-UnsupportedOperationException-tp13392p13427.html Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
Re: NIFI java.lang.UnsupportedOperationException
Hello, I'm not totally sure, but it seems like that error is saying that you are running Java 8, and the sqljdbc4.jar is not compatible with Java 8. >From reading the system requirements when downloading the SQL Server's JDBC Driver, it says: Version support for Java Runtime Environments (JRE) and the associated JDBC API versions are determined by the included JAR files as follows: • Sqljdbc.jar requires a JRE of 5 and supports the JDBC 3.0 API • Sqljdbc4.jar requires a JRE of 6 and supports the JDBC 4.0 API • Sqljdbc41.jar requires a JRE of 7 and supports the JDBC 4.1 API • Sqljdbc42.jar requires a JRE of 8 and supports the JDBC 4.2 API I wonder if the sqljdbc42.jar would work. -Bryan On Mon, Sep 19, 2016 at 9:26 AM, HadyZiade wrote: > I Am running NIFI under windows . > trying to connect to sql server and i got the following error > java.lang.UnsupportedOperationException: Java Runtime Environment > Version1.8 > is not supported by this driver. Use the sqljdbc4.jar class library, which > provides support to JDBC 4.0: java.lang.Unsuppo.. > > > my configuration for DBCPConnection pool (that is working for another Linux > installation) > > Database Connection Url: > jdbc:sqlserver://NEX-ETL-42;databaseName=etl_catalog > Database Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver > Database Driver Location(s) : /enu/sqljdbc4.jar > > for the driver location i tried C:\enu\sqljdbc4.jar > i tried file:///C:\enu\sqljdbc4.jar > i tried the default path when the sqljdbc4.jar is initially installed > .. > nothing is working > i get same issue when i run PUTSQL > > > > > -- > View this message in context: http://apache-nifi-developer- > list.39713.n7.nabble.com/NIFI-java-lang-UnsupportedOperationException- > tp13392.html > Sent from the Apache NiFi Developer List mailing list archive at > Nabble.com. >
RE: NIFI java.lang.UnsupportedOperationException
We are using NiFi to connect to MS SQL Server and have had success with both Sqljdbc41.jar and Sqljdbc42.jar. -Original Message- From: Bryan Bende [mailto:bbe...@gmail.com] Sent: Monday, September 19, 2016 9:12 AM To: dev@nifi.apache.org Subject: Re: NIFI java.lang.UnsupportedOperationException Hello, I'm not totally sure, but it seems like that error is saying that you are running Java 8, and the sqljdbc4.jar is not compatible with Java 8. From reading the system requirements when downloading the SQL Server's JDBC Driver, it says: Version support for Java Runtime Environments (JRE) and the associated JDBC API versions are determined by the included JAR files as follows: • Sqljdbc.jar requires a JRE of 5 and supports the JDBC 3.0 API • Sqljdbc4.jar requires a JRE of 6 and supports the JDBC 4.0 API • Sqljdbc41.jar requires a JRE of 7 and supports the JDBC 4.1 API • Sqljdbc42.jar requires a JRE of 8 and supports the JDBC 4.2 API I wonder if the sqljdbc42.jar would work. -Bryan On Mon, Sep 19, 2016 at 9:26 AM, HadyZiade wrote: > I Am running NIFI under windows . > trying to connect to sql server and i got the following error > java.lang.UnsupportedOperationException: Java Runtime Environment > Version1.8 > is not supported by this driver. Use the sqljdbc4.jar class library, > which provides support to JDBC 4.0: java.lang.Unsuppo.. > > > my configuration for DBCPConnection pool (that is working for another > Linux > installation) > > Database Connection Url: > jdbc:sqlserver://NEX-ETL-42;databaseName=etl_catalog > Database Driver Class Name: > com.microsoft.sqlserver.jdbc.SQLServerDriver > Database Driver Location(s) : /enu/sqljdbc4.jar > > for the driver location i tried C:\enu\sqljdbc4.jar > i tried file:///C:\enu\sqljdbc4.jar > i tried the default path when the sqljdbc4.jar is initially installed > .. > nothing is working > i get same issue when i run PUTSQL > > > > > -- > View this message in context: http://apache-nifi-developer- > list.39713.n7.nabble.com/NIFI-java-lang-UnsupportedOperationException- > tp13392.html > Sent from the Apache NiFi Developer List mailing list archive at > Nabble.com. >