User is reporting that they are not able to use Tibco Hive JDBC in JRS 7.5 to connect to Apache Zookeeper. The following URL works with a native driver
jdbc:hive2://jumbomaster1.dmicorp.com:2181,jumbomaster2.dmicorp.com:2181,jumbomaster3.dmicorp.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
but the format failed with Tibco driver
jdbc:tibcosoftware:hive://jumbomaster1.dmicorp.com:2181,jumbomaster2.dmicorp.com:2181,jumbomaster3.dmicorp.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
------------------------------------------------------------------------
URLs tested and error we got:
1)
jdbc:tibcosoftware:hive://[jumbomaster1.dmicorp.com:2181,jumbomaster2.dmicorp.com:2181,jumbomaster3.dmicorp.com:2181];serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
[TibcoSoftware][Hive JDBC Driver]Error establishing socket. Unknown host: jumbomaster1.dmicorp.com:2181,jumbomaster2.dmicorp.com:2181,jumbomaster3.dmicorp.com:2181 Show Details
2)
jdbc:tibcosoftware:hive://jumbomaster1.dmicorp.com:2181,jumbomaster2.dmicorp.com:2181,jumbomaster3.dmicorp.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
[TibcoSoftware][Hive JDBC Driver]Unable to connect. Invalid URL. If you are using an IPv6 address, please ensure that the address is bounded by left and right brackets. Ex: jdbc:datadirect:driver://[fe70::201:54ff:fe87:afd2%ce1]:50000;databaseName=DBNAME Show Details
---------------------------------------------------------------
Tibco Hive JDBC driver works with a single host connection but our user does not care about single host connection. They need to have a connection with failover configuration.
---------------------------------------------------------------
This user is using "hive-jdbc-1.2.1000.2.5.0.0-1245-standalone.jar" to run a test in SQUIRRL SQL client, and Zookeeper connection works.
When attempting to use this native driver in JRS 7.5, user got the following error:
javax.xml.parsers.FactoryConfigurationError: Provider for class javax.xml.parsers.SAXParserFactory cannot be created
at javax.xml.parsers.FactoryFinder.findServiceProvider(FactoryFinder.java:311)
at javax.xml.parsers.FactoryFinder.find(FactoryFinder.java:267)
at javax.xml.parsers.SAXParserFactory.newInstance(SAXParserFactory.java:127)
at org.apache.tomcat.util.digester.Digester.getFactory(Digester.java:500)
at org.apache.tomcat.util.digester.Digester.getParser(Digester.java:652)
at org.apache.tomcat.util.digester.Digester.getXMLReader(Digester.java:824)
at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1478)
at org.apache.catalina.startup.Catalina.load(Catalina.java:566)
at org.apache.catalina.startup.Catalina.load(Catalina.java:607)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:303)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473)
Caused by: java.lang.RuntimeException: Provider for class javax.xml.parsers.SAXParserFactory cannot be created
at javax.xml.parsers.FactoryFinder.findServiceProvider(FactoryFinder.java:308)
... 14 more
Caused by: java.util.ServiceConfigurationError: javax.xml.parsers.SAXParserFactory: Provider org.apache.xerces.jaxp.SAXParserFactoryImpl not found
at java.util.ServiceLoader.fail(ServiceLoader.java:239)
at java.util.ServiceLoader.access$300(ServiceLoader.java:185)
at java.util.ServiceLoader$LazyIterator.nextService(ServiceLoader.java:372)
at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:404)
at java.util.ServiceLoader$1.next(ServiceLoader.java:480)
at javax.xml.parsers.FactoryFinder$1.run(FactoryFinder.java:294)
at java.security.AccessController.doPrivileged(Native Method)
at javax.xml.parsers.FactoryFinder.findServiceProvider(FactoryFinder.java:289)
... 14 more
=================================================
Here is this user's inquiry regarding to this problem:
"We use the native HIVE driver, but those JARs didn't work in report server pro, it failed to startup after adding them. Do we have access to that source code for the tibco driver? I think we need whomever re-packaged that or built that integration to tell us if its A.) supported, and B.) if not, why. If it's not we're going to have to figure out another driver that works in there which is not ideal since that's part of the reason for the paid version is this big data integration is supposed to work out of the box."
Components | Connectors |