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

Hi Filipe,

Actually it seems totally unrelated but setting paranoid=true in client solved my issue.

Please note that my sample code is not tied to any pooling mechanism.


I did what you said. I set profileSQL true and set a log4j logger.

For both cases (set paranoid or not ) I exactly see the same trace and as you say I can see that SET autocommit=1 is issued..

Do you have any idea about this?

2018-06-06 15:14:15,021 : [INFO ] [main ][Log4jLogger] QUERY created: Wed Jun 06 15:14:15 EEST 2018 duration: 15 connection: 1268 statement: 999 resultset: 0 message: SET autocommit=1
2018-06-06 15:14:15,024 : [INFO ] [main ][Log4jLogger] FETCH created: Wed Jun 06 15:14:15 EEST 2018 duration: 4 connection: 1268 statement: 999 resultset: 0
2018-06-06 15:14:15,122 : [INFO ] [main ][MysqlProblemServer] connection com.mysql.cj.jdbc.ConnectionWrapper@517566b
2018-06-06 15:14:15,143 : [INFO ] [main ][MysqlProblemServer] timeout: 10
2018-06-06 15:14:15,143 : [INFO ] [main ][MysqlProblemServer] Starting query execution for query: INSERT INTO xxxx
2018-06-06 15:14:15,165 : [INFO ] [main ][Log4jLogger] QUERY created: Wed Jun 06 15:14:15 EEST 2018 duration: 20 connection: 1268 statement: 0 resultset: 0 message: INSERT INTO yyyy
2018-06-06 15:14:15,165 : [INFO ] [main ][Log4jLogger] FETCH created: Wed Jun 06 15:14:15 EEST 2018 duration: 0 connection: 1268 statement: 0 resultset: 0

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.