Re: MysqlConnectionPoolDataSource - Can not insert to mysql db using jdbc?
Posted by: Ceyhan Kasap
Date: June 18, 2018 05:15AM

Hi Filipe,

The config is exactly as you say as I learnt from db team. They disabled global autocommit value on the server... The rationale behind this is that global autocommit value is off for oracle and to be compliant they also changed it for mysql db...

Among the solutions you provided , the only applicable option is to set autocommit once again.. This sends an additional SET autocommit=1 command and we can persist our update.

But I still can not understand why the autocommit status is cleared...

Do you think this is a bug in mysql server or jdbc driver?

We do not have this behavior when we use oracle db and ojdbc..

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.