Re: MysqlConnectionPoolDataSource - Can not insert to mysql db using jdbc?
Posted by: Filipe Silva
Date: June 04, 2018 11:56AM


I would recommend setting the connection property `profileSQL=true` and/or turning on the general log on server (`general_log=1`).

This way you should be able to see what queries are being executed in the client and server sides. Look for "SET autocommit=..." queries and try to identify who issued them. Maybe the connection pooling mechanism you are using is turning autocommit off and you may have to call `Connection.commit()` manually.


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.