QueueMetrics > MySQL storage and Qloaderd/Uniloader

MySQL 5 not working ?

(1/2) > >>

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: ---"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 -- - "
--- End code ---

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!

Navigation

[0] Message Index

[#] Next page