# Can't turn off auto-committing; transactions are not supported. (Dremio is not transactional.)

**URL:** <https://community.dremio.com/t/cant-turn-off-auto-committing-transactions-are-not-supported-dremio-is-not-transactional/1160>\
**Category:** Uncategorized\
**Created:** [May 16, 2018, 4:22pm UTC](https://community.dremio.com/t/cant-turn-off-auto-committing-transactions-are-not-supported-dremio-is-not-transactional/1160 "2018-05-16T16:22:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pavithrakc](https://avatars.discourse-cdn.com/v4/letter/p/a6a055/32.png) [@pavithrakc](https://community.dremio.com/u/pavithrakc)\
**Post date:** [May 16, 2018, 4:22pm UTC](https://community.dremio.com/t/cant-turn-off-auto-committing-transactions-are-not-supported-dremio-is-not-transactional/1160/1 "2018-05-16T16:22:24Z")

</div>

I am trying to connect to dremio using JDBC driver client.

I used the following connection string:

jdbc:dremio:direct=hostname:31010

my query is

SELECT \*  
FROM “@admin”.“CME Quote-Vendor-File-Excel”;

But I am not able to connect.

I see some errors in my end as below:

java.net.ConnectException: Connection refused  
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)  
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717)  
at cdjd.org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361)  
at cdjd.org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1141)

Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)

But I do not see any errors in dremio.

I am running dremio on docker. I am using single node instance in this case.

Please advice

---

<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:** [May 16, 2018, 4:35pm UTC](https://community.dremio.com/t/cant-turn-off-auto-committing-transactions-are-not-supported-dremio-is-not-transactional/1160/2 "2018-05-16T16:35:47Z")

</div>

Hi @pavithrakc,

few things to try,

From your client (from where you are trying the jdbc request)

1. ping 
2. telnet 31010

Can you also please send me the server.log from the Dremio coordinator?

Thanks,  
@balaji.ramaswamy