Question

2
Replies
206
Views
 ARULDEVAN T.T (Devan)
Virtusa

Virtusa
IN
Devan Member since 2014 34 posts
Virtusa
Posted: June 3, 2018
Last activity: June 6, 2018
Posted: 3 Jun 2018 2:08 EDT
Last activity: 6 Jun 2018 5:06 EDT
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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 5 Jun 2018 9:41 EDT
Anuj Kumar Srivastava (reachanuj)
PEGA
Lead Technical Specialist
Pegasystems Inc.
IN

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>