This came out when I tried the JBoss ESB console:
02:55:13,218 INFO [SchemaExport] Executing import script: /import.sql 02:55:13,220 ERROR [SchemaExport] schema export unsuccessful org.hibernate.JDBCException: Error during import script execution Caused by: java.sql.SQLException: Wrong data type: hexadecimal string with odd number of characters at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:84) at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:254) ... 109 more
There's an issue with running this import script on hypersonic (http://jira.jboss.com/jira/browse/JBESB-281). It will be fixed in the GA. Sorry!
If you're familiar with hypersonic and would like to have a go at fixing that script, we'd really appreciate that :-)
Sorry, hit return to fast.... the postgres deployment option should work it you're interested in trying that :-)
The GA will also have a number of other features not found in CR2:
1. Transformation Testing.
2. Hot Redploy of Transformation Changes