SQL Error on 6.1.0 jboss bundle first start

1
0
-1

After following the directions for installing the 6.1.0 JBoss bundle, I run the run.sh script and get the error below regarding SQL syntax. Has anyone else seen this?

Thanks

2013-11-06 12:43:03,380 INFO [STDOUT] (main) 12:43:03,380 INFO [SettingsFactory] Database ->
name : MySQL
version : 5.5.34-0ubuntu0.13.10.1
major : 5
minor : 5
2013-11-06 12:43:03,380 INFO [STDOUT] (main) 12:43:03,380 INFO [SettingsFactory] Driver ->
name : MySQL-AB JDBC Driver
version : mysql-connector-java-5.1.22 ( Revision: ${bzr.revision-id} )
major : 5
minor : 1

2013-11-06 12:43:06,680 INFO [STDOUT] (main) 12:43:06,680 ERROR [JDBCExceptionReporter] Table 'bonita.platform' doesn't exist
2013-11-06 12:43:06,719 INFO [STDOUT] (main) 12:43:06,714 ERROR [PlatformServiceImpl] com.mysql.jdbc.exceptions.jdbc4.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 'IMAGE NOT NULL
)' at line 4
org.bonitasoft.engine.services.SPersistenceException: com.mysql.jdbc.exceptions.jdbc4.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 'IMAGE NOT NULL
)' at line 4
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughJDBC(AbstractHibernatePersistenceService.java:715)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:669)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:186)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.createStructure(AbstractDBPersistenceService.java:119)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:103)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:137)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:195)
at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:45)

Comments

Submitted by ttoine on Thu, 11/21/2013 - 15:09

Hello, it seems that you have a problem with the way you set MySQL. Did you tried first the bundle with the default H2 database ?

No answers yet.
Notifications