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

[Gary Brown (JIRA)]

    [ https://issues.jboss.org/browse/BAM-95?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739232#comment-12739232 ] 

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).


                
> Activity store "out of the box" configuration for in-memory H2
> --------------------------------------------------------------
>
>                 Key: BAM-95
>                 URL: https://issues.jboss.org/browse/BAM-95
>             Project: Business Activity Monitoring
>          Issue Type: Task
>            Reporter: Gary Brown
>            Assignee: Gary Brown
>             Fix For: 1.0.0.M3
>
>
> Use the JPA activity store implementation with configuration for an in-memory H2 db. Configurable dbs will be provided as part of next (or later) milestone.

--
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