Author Topic: Sql exception every time we create a new intem in the DB  (Read 2543 times)

james

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
    • View Profile
Sql exception every time we create a new intem in the DB
« on: November 18, 2008, 22:43:29 »
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

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
    • View Profile
Re: Sql exception every time we create a new intem in the DB
« Reply #1 on: November 19, 2008, 03:52:44 »
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

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Sql exception every time we create a new intem in the DB
« Reply #2 on: November 19, 2008, 11:24:13 »
I think this is the same issue as http://forum.queuemetrics.com/index.php?topic=337.0