Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 ARULDEVAN T.T (Devan)
Virtusa

Virtusa
IN
Devan Member since 2014 34 posts
Virtusa
Posted: Jun 3, 2018
Last activity: Jun 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***

To see attachments, please log in.
Data Integration

Posted: 6 years ago
Posted: 5 Jun 2018 9:41 EDT
Anuj Kumar Srivastava (Anuj Srivastava)
PEGA
Senior Solutions Consultant
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> 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice