MySQL 5 not working ?

[zefrench]

I have storage setup for MySQL, everything works well, except for any kind of transaction does does a database SQL insert.  (I need MySQL 5 for data replication)

Am I the only one experiencing this?

[QueueMetrics]

What error do you get? we deploy a lot of systems on MySQL 5.
Can you post a screenshot of the error?

[zefrench]

Code: [Select]

"Errore tecnico nella classe 'it.loway.app.queuemetrics.configurazione.inserisciCoda'.
-- Inner Exception --
- Exception: it.loway.tpf.common.exceptions.TechException
- Stack trace:
- Problema update DB: java.sql.SQLException: Incorrect integer value: '' for column 'id_coda' at row 1
- at it.loway.tpf.SQL.insertSql(Unknown Source)
- at it.loway.tpf.SQL.insertContext(Unknown Source)
- at it.loway.app.queuemetrics.configurazione.inserisciCoda.doRun(Unknown Source)
- at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source)
- at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source)
- at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(Unknown Source)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
- at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:419)
- at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:394)
- at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
- at java.lang.Thread.run(Unknown Source)
-
-- End Inner Exception -- - "

[QueueMetrics]

I think this is the cause: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

Try setting SQL mode to MYSQL40 in my.ini and see if this fixes your problems.

We are tracking this as bug#413.

[zefrench]

It did fix my issue, thanks a lot!

[QueueMetrics]

Cool - we have to add this to the DB updater as well, so that it checks to see if there is an incompatible SQL mode.

[QueueMetrics]

This has been fixed (that is, the DB updater will tell you why this happens and what to do about it) and for this we have released version 1.4.6.