You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Chad Smykay <cs...@mapr.com> on 2015/06/30 19:07:06 UTC
Turn off auto-commit for JDBC access
>From Drill’s documentation, it seems as though it is possible to turn off
auto-committing through the shell by setting autoCommit to false:https://
<https://drill.apache.org/docs/configuring-the-drill-shell/>drill.apache.org
<https://drill.apache.org/docs/configuring-the-drill-shell/>/docs/
<https://drill.apache.org/docs/configuring-the-drill-shell/>
configuring-the-drill-shell
<https://drill.apache.org/docs/configuring-the-drill-shell/>/
<https://drill.apache.org/docs/configuring-the-drill-shell/>
Do anyone know of any way to pass this setting along when connecting with
the jdbc, like in the URL or something?
Re: Turn off auto-commit for JDBC access
Posted by Parth Chandra <pc...@maprtech.com>.
Well, no. It wouldn't do much good to set auto commit to false in Drill,
would it?
On Tue, Jun 30, 2015 at 10:48 AM, Chad Smykay <cs...@mapr.com> wrote:
> So this is not possible to set to pass through JDBC?
> On Jun 30, 2015 12:38 PM, "Parth Chandra" <pa...@apache.org> wrote:
>
> > We should update the documentation. Drill is mostly read only and it
> > autocommits for the few operations that do a write. Drill JDBC will trow
> an
> > exception if the user tries to set AutoCommit off.
> >
> > On Tue, Jun 30, 2015 at 10:07 AM, Chad Smykay <cs...@mapr.com> wrote:
> >
> > > From Drill’s documentation, it seems as though it is possible to turn
> off
> > > auto-committing through the shell by setting autoCommit to
> false:https://
> > > <https://drill.apache.org/docs/configuring-the-drill-shell/>
> > > drill.apache.org
> > > <https://drill.apache.org/docs/configuring-the-drill-shell/>/docs/
> > > <https://drill.apache.org/docs/configuring-the-drill-shell/>
> > > configuring-the-drill-shell
> > > <https://drill.apache.org/docs/configuring-the-drill-shell/>/
> > > <https://drill.apache.org/docs/configuring-the-drill-shell/>
> > >
> > > Do anyone know of any way to pass this setting along when connecting
> with
> > > the jdbc, like in the URL or something?
> > >
> >
>
Re: Turn off auto-commit for JDBC access
Posted by Chad Smykay <cs...@mapr.com>.
So this is not possible to set to pass through JDBC?
On Jun 30, 2015 12:38 PM, "Parth Chandra" <pa...@apache.org> wrote:
> We should update the documentation. Drill is mostly read only and it
> autocommits for the few operations that do a write. Drill JDBC will trow an
> exception if the user tries to set AutoCommit off.
>
> On Tue, Jun 30, 2015 at 10:07 AM, Chad Smykay <cs...@mapr.com> wrote:
>
> > From Drill’s documentation, it seems as though it is possible to turn off
> > auto-committing through the shell by setting autoCommit to false:https://
> > <https://drill.apache.org/docs/configuring-the-drill-shell/>
> > drill.apache.org
> > <https://drill.apache.org/docs/configuring-the-drill-shell/>/docs/
> > <https://drill.apache.org/docs/configuring-the-drill-shell/>
> > configuring-the-drill-shell
> > <https://drill.apache.org/docs/configuring-the-drill-shell/>/
> > <https://drill.apache.org/docs/configuring-the-drill-shell/>
> >
> > Do anyone know of any way to pass this setting along when connecting with
> > the jdbc, like in the URL or something?
> >
>
Re: Turn off auto-commit for JDBC access
Posted by Parth Chandra <pa...@apache.org>.
We should update the documentation. Drill is mostly read only and it
autocommits for the few operations that do a write. Drill JDBC will trow an
exception if the user tries to set AutoCommit off.
On Tue, Jun 30, 2015 at 10:07 AM, Chad Smykay <cs...@mapr.com> wrote:
> From Drill’s documentation, it seems as though it is possible to turn off
> auto-committing through the shell by setting autoCommit to false:https://
> <https://drill.apache.org/docs/configuring-the-drill-shell/>
> drill.apache.org
> <https://drill.apache.org/docs/configuring-the-drill-shell/>/docs/
> <https://drill.apache.org/docs/configuring-the-drill-shell/>
> configuring-the-drill-shell
> <https://drill.apache.org/docs/configuring-the-drill-shell/>/
> <https://drill.apache.org/docs/configuring-the-drill-shell/>
>
> Do anyone know of any way to pass this setting along when connecting with
> the jdbc, like in the URL or something?
>