Servoy Forum

Hi all,

i faced some problem when i am trying to upgrade the repository after installing servoy application server 6.x version. I am connecting with existing database of MySql. after installation when i am upgrade the repository , i am getting the following error

2012-05-21 21:14:54,084 INFO [main] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2012-05-21 21:14:54,094 INFO [main] org.hibernate.dialect.Dialect - Using dialect: com.servoy.j2db.dialect.MySQL5InnoDBDialect
2012-05-21 21:14:54,760 ERROR [main] com.servoy.j2db.util.Debug - Error upgrading repository
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:942)
at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1119)
at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:73)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:308)
Caused by: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
at com.mysql.jdbc.Statement.execute(Statement.java:692)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.servoy.j2db.Za.Zg.invoke(Zg.java:16)
at $Proxy0.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:930)
... 3 more


Mine is

OS: Mac
DB: MySql
Servoy -version: servoy 6.x


any suggestion can help to me.

Thanks
Chaitanya s

Chaitanya,

What version of mysql are you using?

Rob

i am using MySql 5.5.24-osx10.6-x86_64

It seems you have to change a mysql setting.
Google for binlog_format.

Rob

Hi Rob ,

It is working correctly , nice job. Thanks for your response.


Thanks
Chaitanya s