[Topic] Error in first login with 1.1.3 build 20071027

I have experienced the same problem:
"Hi.
I have a problem with first login
I installed agileTrack Client and I selected HSQLDB in connection property. Then I use
user:admin
password:admin
and click the login button.
I get this error:
Login Cannot be performed. Trouble connecting to AgileTrack Server.
Table not found in statement [SELECT schema_version FROM agiletrack_config]"

The agiletrack-info.log says:
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
84161 [Thread-3] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
84161 [Thread-2] ERROR: hsqldb.TrackerHSQLDatabase – Problem shutting down HSQLDB.
java.lang.RuntimeException: java.sql.SQLException: SOO10 Argomento non valido per una chiamata JDBC

at agiletrack.server.persistence.DatabaseResourceProvider.<init>(DatabaseResourceProvider.java:33) at agiletrack.persistence.hsqldb.TrackerHSQLDatabase.close(TrackerHSQLDatabase.java:120) at agiletrack.persistence.hsqldb.TrackerHSQLDatabase$1.run(TrackerHSQLDatabase.java:500) at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: SOO10 Argomento non valido per una chiamata JDBC at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at agiletrack.server.persistence.DatabaseResourceProvider.<init>(DatabaseResourceProvider.java:30) ... 3 more
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
117830 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
22252 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
50 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
27259 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
50 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
361360 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.

The agiletrack-client.log says:
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
84161 [Thread-3] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
84161 [Thread-2] ERROR: hsqldb.TrackerHSQLDatabase – Problem shutting down HSQLDB.
java.lang.RuntimeException: java.sql.SQLException: SOO10 Argomento non valido per una chiamata JDBC

at agiletrack.server.persistence.DatabaseResourceProvider.<init>(DatabaseResourceProvider.java:33) at agiletrack.persistence.hsqldb.TrackerHSQLDatabase.close(TrackerHSQLDatabase.java:120) at agiletrack.persistence.hsqldb.TrackerHSQLDatabase$1.run(TrackerHSQLDatabase.java:500) at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: SOO10 Argomento non valido per una chiamata JDBC at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at agiletrack.server.persistence.DatabaseResourceProvider.<init>(DatabaseResourceProvider.java:30) ... 3 more
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
117830 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
22252 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
20 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
50 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
27259 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.
MySQL JDBC driver found.
Registered persistence provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
HSQLDB JDBC driver found.
Registered persistence provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
SQLServer JDBC driver found.
Registered persistence provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.sqlserver.TrackerSQLServerDatabaseFactory
Registered data access provider: agiletrack.persistence.hsqldb.TrackerHSQLDatabaseFactory
Registered data access provider: agiletrack.persistence.mysql.TrackerMySQLDatabaseFactory
Registered data access provider: agiletrack.access.xmlrpc.http.TrackerXMLRPCDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.http.TrackerJSONRPCHttpDataAccessFactory
Registered data access provider: agiletrack.access.jsonrpc.direct.TrackerJSONRPCStreamDataAccessFactory
0 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'default'.
50 [AWT-EventQueue-0] INFO : controller.LocalSettings – Check profile 'demo'.
Tabella non trovata in statement [SELECT schema_version FROM agiletrack_config]
361360 [Thread-2] INFO : hsqldb.TrackerHSQLDatabase – Shutdown HSQLDB.

Bye

Nicola from Italy

—Posted by nicola on Nov 13, 2007


You may post a reply to this topic, but you must be logged in. If you already have an account, you may login now. If you need to create an account, you may also register now.