Thank you for your help. about the schema creation problem: At first, the error in the server log is as you guessed: 18:11:55,812 ERROR [[/jbpm-bpel]] DBSchemaServlet: caught an exception | java.sql.SQLException: Table not found: BPEL_ALARMDEFINITION in statement [alter table BPEL_ALARMDEF | INITION] | [...]
When I repeat the schema-creation, the error differs. On Hypersonic, it is: java.sql.SQLException: Constraint not found FK_ACTIVITY_COMPOSITE in table: JBPM_NODE in statement [alter table JBPM_NODE drop constraint FK_ACTIVITY_COMPOSITE] | at org.hsqldb.jdbc.Util.sqlException(Unknown Source) | at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) | at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:161) | at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:299) | [...] On Oracle, it is: java.sql.SQLException: ORA-02275: such a referential constraint already exists in the table | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) | at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) | at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) | at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1111) | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1278) | at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1855) | at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1820) | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:161) | at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:299) Regarding my problem with MySQL: I used MySQL Connector/J 3.1.7. Now I'm using Connector/J 3.1.12 and it works. Regards, Martin View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3916848#3916848 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3916848 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
