[overlord-issues] [JBoss JIRA] (BAM-95) Activity store "out of the box" configuration for in-memory H2

[ https://issues.jboss.org/browse/BAM-95?page=com.atlassian.jira.plugin.sys... ] Gary Brown commented on BAM-95: ------------------------------- H2 can now be configured by supplying '-Ddb=h2' to the build. However when running the tests, it results in the following exceptions: 1) Transaction issue 11:44:50,222 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (MSC service thread 1-8) HHH000231: Schema export unsuccessful: java.sql.SQLException: You cannot set autocommit during a managed transaction! at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:888) at org.jboss.jca.adapters.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:715) at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:60) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:52) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:368) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] 2) Field length 11:45:16,421 INFO [stdout] (Timer-3) Hibernate: insert into BAM_ACTIVITIES (timestamp, content, fault, messageType, operation, serviceType, type, unitId, unitIndex) values (?, ?, ?, ?, ?, ?, 'RequestReceived', ?, ?) 11:45:16,548 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-3) SQL Error: 22001, SQLState: 22001 11:45:16,550 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Timer-3) Value too long for column "CONTENT VARCHAR(255)": "'<?xml version=""1.0"" encoding=""UTF-8""?><orders:submitOrder xmlns:orders=""urn:switchyard-quickstart-demo:orders:1.0""> ... (346)"; SQL statement: insert into BAM_ACTIVITIES (timestamp, content, fault, messageType, operation, serviceType, type, unitId, unitIndex) values (?, ?, ?, ?, ?, ?, 'RequestReceived', ?, ?) [22001-161] Have tried setting the @Column annotation, on the getContent() method and _content field, with a greater length and also the @Lob annotation - but nothing seems to work. It still generates the schema with varchar(255). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira