Question

2
Replies
198
Views
Close popover
ARULDEVAN T.T (Devan)
Virtusa

Virtusa
IN
View ProfileSend Message
Devan Member since 2014 34 posts
Virtusa
Posted: June 3, 2018
Last activity: June 6, 2018
Closed

Enabling autocommit is not supported Error for hive2

Hi All,

I'm trying to connect to a hive2 DB from PEGA. I have imported the required jars in PEGA and also configured the datasource in the jboss server. Testing the connectivity of the database rule, below is the error.

enabling autocommit is not supported

Could someone suggest on the resolution for this.

Thanks,

A

***Edited by Moderator Marissa to update platform capability***

Data Integration
Close popover
Moderation Team has archived post
Posted: 2 years ago
Close popover
Anuj Kumar Srivastava (reachanuj)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN
View ProfileSend Message

Hi 


This error is looking more like a bug in either JDBC driver or Hive. You can disable the auto-commit by adding the following line in the connection parameter of JBoss Data source. 


<connection-property name="auto-commit">false</connection-property> 

Posted: 2 years ago
Close popover
ARULDEVAN T.T (Devan)
Virtusa

Virtusa
IN
View ProfileSend Message

Hi Sriva,


The suggested configuration is already in place. We are getting the error even after the configuration is ammended.


Thanks
Share this page Share via LinkedIn Copying...
Copied!