QueueMetrics > QueueMetrics installation

Sql exception every time we create a new intem in the DB

(1/1)

james:
Every time I try to add a new user, queues, agents ( whatever) i'm getting this error; but it does not happen when I edit something already created like a user. The error is the following:
A problem occurred in QueueMetrics.

The following error occurred in the Transaction handler:
"Errore tecnico nella classe 'it.loway.app.queuemetrics.configurazione.cfg2.ptLocations'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema update DB: java.sql.SQLException: !Statement.GeneratedKeysNotRequested! - at it.loway.tpf.SQL.insertSql(Unknown Source) - at it.loway.tpf.SQL.insertContext(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.performSave(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.processEditor(Unknown Source) - at it.loway.tpf.transaction.db.PagedTransactor.PTProcessVerb(Unknown Source) - at it.loway.app.queuemetrics.configurazione.cfg2.ptLocations.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:709) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) - at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) - at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) - at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) - at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) - at java.lang.Thread.run(Thread.java:595) - -- End Inner Exception -- - "

james:
I solved the problem using a less recent mysql connector. I was using 5.0 and i went back to 3.1 and it is working fine.

QueueMetrics:
I think this is the same issue as http://forum.queuemetrics.com/index.php?topic=337.0

Navigation

[0] Message Index