Author Topic: The following error occurred in the Transaction handler  (Read 3711 times)

adz

  • Newbie
  • *
  • Posts: 28
  • Karma: 0
    • View Profile
Hello,

I am getting the following error when I try to install QM:

Code: [Select]
"Errore tecnico nella classe 'it.loway.app.queuemetrics.autenticazione.caricaDatiIniziali'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema DB: - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=HEAP SELECT id_location, loc_name, read_key from locations WHERE id_locatio' at line 1 - at it.loway.tpf.SQL.execSql(SQL.java:101) - at it.loway.app.queuemetrics.FA.makeSqlUnionLt(FA.java:1087) - at it.loway.app.queuemetrics.autenticazione.caricaDatiIniziali.doRun(caricaDatiIniziali.java:178) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:255) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:543) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:365) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:210) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) - 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:230) - 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:104) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) - at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) - at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) - at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) - at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) - at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) - at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:686) - at java.lang.Thread.run(Thread.java:619) - -- End Inner Exception -- - " 

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: The following error occurred in the Transaction handler
« Reply #1 on: May 06, 2010, 18:27:44 »
Which version of MySQL are you using?
Did you create the database and load it?

adz

  • Newbie
  • *
  • Posts: 28
  • Karma: 0
    • View Profile
Re: The following error occurred in the Transaction handler
« Reply #2 on: May 06, 2010, 18:50:44 »
MySQL Version 5.1.45

Yes I created the Database and loaded the test data from the .sql file without any errors.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: The following error occurred in the Transaction handler
« Reply #3 on: May 07, 2010, 10:24:53 »
Does it show a storage engine called HEAP?