Openanzo and mysql

[dani]

I have problem starting the anzo server with mysql database.
I'm using the mysql 5.1 and the openanzo 3.0 version. The mysql runs
on 61616 port.
The exception is:
=============================================================
Error Starting ServiceContainer
org.openanzo.common.exceptions.AnzoException: ErrorCode[512:262148]
[INTERNAL_ER
ROR] Error executing database operation:ErrorCode[320:262162]
[DATASOURCE_ERROR]
[RDB_ERROR] Failed to lock database table:SERVER
at
org.openanzo.server.repository.rdb.services.NodeCentricResetService.r
esetDatabaseTables(NodeCentricResetService.java:222)
at
org.openanzo.server.repository.rdb.services.NodeCentricResetService.r
esetDatabase(NodeCentricResetService.java:173)
at
org.openanzo.server.repository.rdb.services.NodeCentricBackend.initia
lizeConnection(NodeCentricBackend.java:305)
at
org.openanzo.server.repository.rdb.services.NodeCentricBackend$1.make
Object(NodeCentricBackend.java:284)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericOb
jectPool.java:840)
at
org.openanzo.server.repository.rdb.services.NodeCentricBackend.start(
NodeCentricBackend.java:193)
at
org.openanzo.servicecontainer.ServiceContainer.start(ServiceContainer
.java:396)
at
org.openanzo.standalone.StandaloneServer.<init>(StandaloneServer.java
:218)
at
org.openanzo.standalone.StandaloneServer.main(StandaloneServer.java:6
2)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.codehaus.classworlds.Launcher.launchStandard(Launcher.java:410)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:344)
at org.codehaus.classworlds.Launcher.main(Launcher.java:461)
Caused by: org.openanzo.common.exceptions.AnzoException:
ErrorCode[320:262162] [
DATASOURCE_ERROR] [RDB_ERROR] Failed to lock database table:SERVER
at
org.openanzo.server.repository.rdb.services.NodeCentricBackend.lockTa
ble(NodeCentricBackend.java:633)
at
org.openanzo.server.repository.rdb.services.NodeCentricBackend.begin(
NodeCentricBackend.java:717)
at
org.openanzo.server.repository.rdb.services.NodeCentricResetService.d
ropTables(NodeCentricResetService.java:311)
at
org.openanzo.server.repository.rdb.services.NodeCentricResetService.r
esetDatabaseTables(NodeCentricResetService.java:201)
... 15 more
Caused by: org.openanzo.jdbc.utils.RdbException: ErrorCode[256:262181]
[RDB_ERRO
R] Failed to execute an sql operation:[lockTable] SQL:[SELECT
GET_LOCK(''{0}'' ,
{1})] Params:[] Templates:[tableName=SERVER,tableLocksExtra=] Root
Cause: com.my
sql.jdbc.exceptions.MySQLSyntaxErrorException You have an error in
your SQL synt
ax; check the manual that corresponds to your MySQL server version for
the right
syntax to use near ')' at line 1
at
org.openanzo.server.repository.rdb.sql.ServerRdbWrapper.lockTable(Ser
verRdbWrapper.java:529)
at
org.openanzo.server.repository.rdb.services.NodeCentricBackend.lockTa
ble(NodeCentricBackend.java:631)
... 18 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You
have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL
server ver
sion for the right syntax to use near ')' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1332)
at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(Delegatin
gPreparedStatement.java:168)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(Delegatin
gPreparedStatement.java:168)
at
org.openanzo.server.repository.rdb.sql.ServerRdbWrapper.lockTable(Ser
verRdbWrapper.java:525)
... 19 more
==========================================================================

Please help.

[Simon Martin]

Hi Dani,

More recent updates have meant that we have had to put support for Mysql
on hold. Mysql's lack of sequence support and the fact that it doesn't
allow you to reference a temporary table more than once within the same
query has made support of mysql in openanzo 3.0 very difficult. We
recommend using postgres as an alternative. I am sorry if this has
caused you any trouble. I will be sure to remove references to mysql
support from the documentation.

Regards,

Simon.