Error when trying to create 3.5.1. repository on Vista

Classic Servoy
1

I’m trying to get Servoy 3.5.1 running on Vista with MySQL 5.0,
but when I startup Servoy developer for the first time to connect to the (new) repository, I get this error:

com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

This is what the server log says:

2007-10-01 12:03:54,629 ERROR [main] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: No repository found in the database.
	at com.servoy.j2db.persistence.Repository.for(Unknown Source)
	at com.servoy.j2db.persistence.Repository.<init>(Unknown Source)
	at com.servoy.j2db.persistence.Repository.<init>(Unknown Source)
	at com.servoy.j2db.persistence.Server.getRepository(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.startOrCreateRepository(Unknown Source)
	at com.servoy.j2db.develop.au.int(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.goto(Unknown Source)
	at com.servoy.j2db.ClientState.dataBaseInit(Unknown Source)
	at com.servoy.j2db.J2DBClient.dataBaseInit(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.dataBaseInit(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.do(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
	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 com.servoy.j2db.startup.Bootstrap.main(Unknown Source)
	at Servoy.main(Unknown Source)
2007-10-01 12:03:57,983 ERROR [main] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
	at com.servoy.j2db.persistence.n.a(Unknown Source)
	at com.servoy.j2db.persistence.Server.createRepositoryTables(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.startOrCreateRepository(Unknown Source)
	at com.servoy.j2db.develop.au.int(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.goto(Unknown Source)
	at com.servoy.j2db.ClientState.dataBaseInit(Unknown Source)
	at com.servoy.j2db.J2DBClient.dataBaseInit(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.dataBaseInit(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.do(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
	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 com.servoy.j2db.startup.Bootstrap.main(Unknown Source)
	at Servoy.main(Unknown Source)
Caused by: com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
	at com.servoy.j2db.persistence.Server.a(Unknown Source)
	at com.servoy.j2db.persistence.Server.a(Unknown Source)
	... 16 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)
	at com.mysql.jdbc.Statement.execute(Statement.java:706)
	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 com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
	at $Proxy0.execute(Unknown Source)
	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183)
	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183)
	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:183)
	... 18 more

Servoy does create some tables, but not all of them…

Anybody knows what needs to be done?

Servoy Developer
Version 3.5.1-build 514
Java version 1.6.0_02-b06 (Windows Vista)

2

it’s a bug in Servoy 3.5.1 in combination with mySQL
The Servoy team is working on it!

You can work around it, by creating the repository in 3.5 and than update to the final 3.5.1

3

It is fixed in 3.5.2

Rob