How to set autocommit Off

[Pay Liu]

I have a db user, john, who don't have SUPER privilege. 

I'd like john have no autocommit when connecting Cloud SQL.

As I know, to cause clients to begin with a default off, need to set the server's "init_connect" system variable.

(ref: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_autocommit)

How can I do? or no support now?

thanks, 

-Pay

[Rob Clevenger]

Are you using JDBC, or python?  jdbc requires autocommit to be set to true, so you can call setAutoCommit(false) on Connection.

Python's DPAPI driver requires is to be off, and is therefore off by default.

Rob

[Pay Liu]

Dear Rob, 

thanks for reply.

Yes, I'm using JDBC and I know use setAutoCommit(false) to begin a transaction in session scope of Connection. 

But using a SQL User account without authority for auto-commit, can easily force programmer to use commit function to manage transaction.

[Rob Clevenger]

Hi Pay,

We don't support setting init_connect.

Rob

[Pay Liu]

Got it, Thanks, Rob.