# JDBC connection issue

**URL:** <https://community.dremio.com/t/jdbc-connection-issue/5132>\
**Category:** Uncategorized\
**Created:** [February 28, 2020, 6:42am UTC](https://community.dremio.com/t/jdbc-connection-issue/5132 "2020-02-28T06:42:11Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ganapathyanitha](https://avatars.discourse-cdn.com/v4/letter/g/eada6e/32.png) [@ganapathyanitha](https://community.dremio.com/u/ganapathyanitha)\
**Post date:** [February 28, 2020, 6:42am UTC](https://community.dremio.com/t/jdbc-connection-issue/5132/1 "2020-02-28T06:42:11Z")

</div>

Hi

Can someone answer, after updating to dremio 4.1.4 our clients using an JDBC connector are failing.

I’ve downloaded the driver from the server (dremio/jars/jdbc-driver/dremio-jdbc-driver-4.1.4-202001240912140359-a90eb503.jar).  
After connecting with JDBC in streamsets I get following error :

JDBC\_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Can’t turn off auto-committing; transactions are not supported. (Dremio is not transactional.)

Connection URL : jdbc:dremio:direct=server-address:31010

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [February 28, 2020, 2:30pm UTC](https://community.dremio.com/t/jdbc-connection-issue/5132/2 "2020-02-28T14:30:18Z")

</div>

@ganapathyanitha

What are the SQL statements you are trying to run via JDBC?

---

<div class="post-metadata">

**Author:** ![annchinnu](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@annchinnu](https://community.dremio.com/u/annchinnu)\
**Post date:** [March 9, 2021, 5:17am UTC](https://community.dremio.com/t/jdbc-connection-issue/5132/3 "2021-03-09T05:17:26Z")

</div>

Hi,

The above same issue happened to me also. I was trying to execute a SELECT querry.  
dremio-jdbc-driver-4.3.1-202005202256080999-5dcfb82a.jar this is the jar version

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [March 9, 2021, 6:36am UTC](https://community.dremio.com/t/jdbc-connection-issue/5132/4 "2021-03-09T06:36:25Z")

</div>

@annchinnu

Kindly send us the profile for the failed job

> **[How To Share A Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)**
>
> Tutorial explaining how to share a query profile in Dremio.

---

<div class="post-metadata">

**Author:** ![annchinnu](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@annchinnu](https://community.dremio.com/u/annchinnu)\
**Post date:** [March 9, 2021, 9:26am UTC](https://community.dremio.com/t/jdbc-connection-issue/5132/5 "2021-03-09T09:26:05Z")

</div>

@balaji.ramaswamy  
Error is thrown before even hitting dremio server. I don’t see any job running for my querry.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [March 10, 2021, 8:04am UTC](https://community.dremio.com/t/jdbc-connection-issue/5132/6 "2021-03-10T08:04:09Z")

</div>

@annchinnu

Are you getting the below error?  
`Can’t turn off auto-committing; transactions are not supported. (Dremio is not transactional.)`

What happens if you run the same query from the Dremio UI? If you get the same error, kindly send us the profile

---

<div class="post-metadata">

**Author:** ![annchinnu](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@annchinnu](https://community.dremio.com/u/annchinnu)\
**Post date:** [March 10, 2021, 8:16am UTC](https://community.dremio.com/t/jdbc-connection-issue/5132/7 "2021-03-10T08:16:46Z")

</div>

@balaji.ramaswamy I’m getting the same error when running query through pentaho using JNDI connection.  
While executing from dremio i’m not getting this error.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [March 10, 2021, 8:17am UTC](https://community.dremio.com/t/jdbc-connection-issue/5132/8 "2021-03-10T08:17:44Z")

</div>

@annchinnu

Can you please send us the profile when run via UI, also send us a screenshot of the error you get when querying via JDBC