Databricks JDBC Error while connecting from Datastage JDBC connector

Fuzail
New Contributor III

I am reading data from Databricks in datatstage 11.7 on prem using datastage JDBC connector and getting the below error. I tried to limit the select queries to one row , it was able to read data form the source, 

JDBC_Connector_0: The connector encountered a Java exception: 
java.sql.SQLException: [Databricks][JDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: null, Query: select cola,colb  from table1, Error message from Server: Configuration AutoCommit is not available..

I am using the latest JDBC driver available on databricks and done the required configuration. any assistance on this would be of great help