agaw-runner SQL problem?

[Wessel]

Hi running the agaw-runner under a normal linux user with the admin user a login account some how blows up with a strange error. Here are the details:

First thing I needed to to fix is that the line

VMOPTS=-server -Xmx256M -Xms256M

gives an error:
./agaw-runner.sh: line 14: -Xmx256M: command not found

Fixing this (I'm not a bash guru but i think it can be fixed like this)
VMOPTS='-server -Xmx256M -Xms256M'

After this the scripts starts up, but still gives some weired errors:

QM: 1.5.0
Java: 1.5.0_14
MySQL: Ver 14.12 Distrib 5.0.32
AppSer: TomCat 5.5

agaw-runner.sh
JAVA=/usr/bin/java
VMOPTS=-server -Xmx256M -Xms256M

USER=admin
PASS=admin
JDBC="jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude"
QMPATH=/var/lib/tomcat5.5/webapps/queuemetrics
ITER=10
IDLE=15000
RUNLOG=false
RUNLOGDIR=/root/runlog

MYSQLJAR=/usr/share/java/mysql-connector-java.jar  (5.0.4)
SERVLET=/usr/share/java/servlet-api.jar (2.4)
==============================

============
QM User name: admin
QM password:  admin
QM path:      /var/lib/tomcat5.5/webapps/queuemetrics
JDBC URI:     jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Number of loops:         10
Idle time between loops: 15000 ms
Keep run log: false
Run log dir: /root/runlog
Path: '/var/lib/tomcat5.5/webapps/queuemetrics/WEB-INF/agaw.properties'
Chiave: '5231317C-4E324465-6D6F2D31-2E352E30-2D52232D-23516D52-756E6E65-727C5333-31323539-38383132-30303030-307C'
 *** LOWAY TPF licence: to 'Demo-1.5.0-R' up to 'Fri Dec 04 00:00:00 CET 2009'
Data Scad [2009-12-04]: Fri Dec 04 00:00:00 CET 2009
Data scad:Fri Dec 04 00:00:00 CET 2009 - Scaduto: 0
Servlet A01 - Step X3
Servlet A01 - Step X4 - 103
-- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
Stack trace:
Problema DB: com.mysql.jdbc.exceptions.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 ')' at line 1
   at it.loway.tpf.SQL.selectScalare(Unknown Source)
   at it.loway.app.queuemetrics.agaw.BO.AgentReader.closeRunsCreatedByAPreviousExecution(AgentReader.java:436)
   at it.loway.app.queuemetrics.agaw.QueueRunner.run(QueueRunner.java:157)
   at it.loway.app.queuemetrics.agaw.QueueRunner.main(QueueRunner.java:728)
-- End Inner Exception --

============
QM User name: admin
QM password:  admin
QM path:      /var/lib/tomcat5.5/webapps/queuemetrics
JDBC URI:     jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Number of loops:         10
Idle time between loops: 15000 ms
Keep run log: false
Run log dir: /root/runlog
Path: '/var/lib/tomcat5.5/webapps/queuemetrics/WEB-INF/agaw.properties'
Chiave: '5231317C-4E324465-6D6F2D31-2E352E30-2D52232D-23516D52-756E6E65-727C5333-31323539-38383132-30303030-307C'
 *** LOWAY TPF licence: to 'Demo-1.5.0-R' up to 'Fri Dec 04 00:00:00 CET 2009'
Data Scad [2009-12-04]: Fri Dec 04 00:00:00 CET 2009
Data scad:Fri Dec 04 00:00:00 CET 2009 - Scaduto: 0
Servlet A01 - Step X3
============
QM User name: admin
QM password:  admin
QM path:      /var/lib/tomcat5.5/webapps/queuemetrics
JDBC URI:     jdbc:mysql://127.0.0.1/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Number of loops:         10
Idle time between loops: 15000 ms
Keep run log: false
Run log dir: /root/runlog
Path: '/var/lib/tomcat5.5/webapps/queuemetrics/WEB-INF/agaw.properties'
Chiave: '5231317C-4E324465-6D6F2D31-2E352E30-2D52232D-23516D52-756E6E65-727C5333-31323539-38383132-30303030-307C'
 *** LOWAY TPF licence: to 'Demo-1.5.0-R' up to 'Fri Dec 04 00:00:00 CET 2009'
Data Scad [2009-12-04]: Fri Dec 04 00:00:00 CET 2009
Data scad:Fri Dec 04 00:00:00 CET 2009 - Scaduto: 0
Servlet A01 - Step X3
Servlet A01 - Step X4 - 103
-- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
Stack trace:
Problema DB: com.mysql.jdbc.exceptions.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 ')' at line 1
   at it.loway.tpf.SQL.selectScalare(Unknown Source)
   at it.loway.app.queuemetrics.agaw.BO.AgentReader.closeRunsCreatedByAPreviousExecution(AgentReader.java:436)
   at it.loway.app.queuemetrics.agaw.QueueRunner.run(QueueRunner.java:157)
   at it.loway.app.queuemetrics.agaw.QueueRunner.main(QueueRunner.java:728)
-- End Inner Exception --


Any hints ? 

Wessel

[QueueMetrics]

Looks like it's a known bug, as of here: http://forum.queuemetrics.com/index.php?topic=402.0 - easy to fix though