DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
AnnDSX
Participant



Joined: 04 Dec 2017
Posts: 4

Points: 41

Post Posted: Mon Dec 04, 2017 2:19 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5
Hi All,

We are trying to use Hive Connector to connect to Hortonworks 2.5/2.6. The Connector fails with the error

main_program: Fatal Error: The connector failed to connect to the data source. The reported error is: java.sql.SQLException: [IBM][Hive JDBC Driver]Cannot establish connection to specified server, using either Hive1 or Hive2 protocol.

The URL provided looks fine.
Contents of the isjdbc.config file:
CLASSPATH=/opt/IBM/InformationServer/ASBNode/lib/java/IShive.jar
CLASS_NAMES=com.ibm.isf.jdbc.hive.HiveDriver

JDBCDriverLogin.conf:

JDBC_DRIVER_01{
com.ibm.security.auth.module.Krb5LoginModule required
credsType=both
principal="dsadm@principlename"
useKeytab="/home/dsadm/.dsadm.keytab";
};

Has anyone come across this error? Any other configuration that needs to be checked?


Last edited by AnnDSX on Mon Dec 04, 2017 8:18 am; edited 1 time in total
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42585
Location: Denver, CO
Points: 219186

Post Posted: Mon Dec 04, 2017 7:35 am Reply with quote    Back to top    

Exclamation

Split this out to its own post. However, since this is your first post here, I had to guess at your version number. Please edit your post and update that if 11.x is not correct.

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
AnnDSX
Participant



Joined: 04 Dec 2017
Posts: 4

Points: 41

Post Posted: Mon Dec 04, 2017 8:16 am Reply with quote    Back to top    

Sure.
IIS version-11.5.0.1
Hive Driver Version-5.1
Hortonworks: 2.5/Hive2
Rate this response:  
Not yet rated
skathaitrooney
Participant



Joined: 06 Jan 2015
Posts: 92

Points: 832

Post Posted: Wed Jun 13, 2018 1:37 am Reply with quote    Back to top    

Did you manage to solve this problem ?
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours