Problem in create-schema of jBPM BPEL
Excuse me,
I got problem in create-schema of jBPM BPEL.
I have try to use the default database or mysql as database but problem still exist.
My setting:
- jboss-4.0.2
- jbpm-bpel-1.0-alpha4
- ant-1.6.5
- jwsdp-1.6
- mysql-connector-java-5.0.0-beta
- mysql-5.0.18
My steps:
1. Extract a new jboss-4.0.2 to C:\JBoss
2. Extract a new jbpm-bpel-1.0-alpha4 to C:\JBPM_BPEL
3. Edit C:\JBPM_BPEL\build.properties
jboss.home=C:/JBoss jbpm.bpel.version=1.0-alpha4 jbpm.version=3.0.2
4. Open command
CD C:\JBPM_BPEL ANT build.service.402
5. Copy C:\JBPM_BPEL\build\jbpm-bpel.sar to C:\JBoss\server\default\deploy
6. Start C:\JBoss\bin\run.bat
7. Edit jbpm-bpel-1.0-alpha\doc\examples\hello\build.properties
wsdp.home=C:/Sun/jwsdp-1.6 jboss.home=C:/JBoss jbpm.bpel.home=C:/JBPM_BPEL jboss.server=default jbpm.version=3.0.2 jbpm.bpel.version=1.0-alpha4
8. Open command
CD C:/JBPM_BPEL/doc/examples/hello ANT create-schema
Using default database
13:28:14,484 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
13:28:14,484 INFO [SessionFactoryImpl] Checking 0 named queries
13:28:14,484 INFO [JbpmService] binding JbpmSessionFactory 'java:/jbpm/BpelSessionFactory' into JNDI...
13:28:14,593 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/C:/JBoss/server/default/
deploy/jboss-xa-jdbc.rar
13:28:14,734 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/C:/JBoss/server/default/
deploy/jms/jms-ra.rar
13:28:14,828 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/C:/JBoss/server/default/
deploy/mail-ra.rar
13:28:15,203 INFO [WrapperDataSourceService] Bound connection factory for resource adapter for ConnectionManager 'jboss
.jca:service=DataSourceBinding,name=DefaultDS to JNDI name 'java:DefaultDS'
13:28:15,484 INFO [A] Bound to JNDI name: queue/A
13:28:15,500 INFO [B] Bound to JNDI name: queue/B
13:28:15,500 INFO [C] Bound to JNDI name: queue/C
13:28:15,500 INFO [D] Bound to JNDI name: queue/D
13:28:15,515 INFO [ex] Bound to JNDI name: queue/ex
13:28:15,546 INFO [testTopic] Bound to JNDI name: topic/testTopic
13:28:15,546 INFO [securedTopic] Bound to JNDI name: topic/securedTopic
13:28:15,546 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic
13:28:15,546 INFO [testQueue] Bound to JNDI name: queue/testQueue
13:28:15,640 INFO [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
13:28:15,687 INFO [DLQ] Bound to JNDI name: queue/DLQ
13:28:16,656 INFO [ConnectionFactoryBindingService] Bound connection factory for resource adapter for ConnectionManager
'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA to JNDI name 'java:JmsXA'
13:28:16,703 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=file:/C:/JBoss/server/default/deploy/jmx-consol
e.war/
13:28:17,171 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
13:28:17,421 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
13:28:17,437 INFO [JkMain] Jk running ID=0 time=0/47 config=null
13:28:17,453 INFO [Server] JBoss (MX MicroKernel) [4.0.2 (build: CVSTag=JBoss_4_0_2 date=200505022023)] Started in 27s:
907ms
13:28:36,593 INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect
13:28:36,593 INFO [Configuration] processing extends queue
13:28:36,593 INFO [Configuration] processing collection mappings
13:28:36,593 INFO [Configuration] processing association property references
13:28:36,593 INFO [Configuration] processing foreign key constraints
13:28:36,609 INFO [Configuration] processing extends queue
13:28:36,609 INFO [Configuration] processing collection mappings
13:28:36,609 INFO [Configuration] processing association property references
13:28:36,609 INFO [Configuration] processing foreign key constraints
13:28:36,671 INFO [SchemaExport] Running hbm2ddl schema export
13:28:36,671 INFO [SchemaExport] exporting generated schema to database
13:28:36,671 INFO [NamingHelper] JNDI InitialContext properties:{}
13:28:36,671 INFO [DatasourceConnectionProvider] Using datasource: java:/JbpmBpelDS
13:28:36,906 INFO [SchemaExport] schema export complete
13:28:36,921 INFO [[/jbpm-bpel]] DBSchemaServlet: completed database schema operation: create
13:28:36,921 ERROR [[/jbpm-bpel]] DBSchemaServlet: caught an exception
java.sql.SQLException: Table not found: BPEL_ALARMDEFINITION in statement [alter table BPEL_ALARMDEFINITION]
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:229)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:145)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:99)
at org.jbpm.bpel.web.deploy.DBSchemaServlet.createSchema(DBSchemaServlet.java:48)
at org.jbpm.bpel.web.deploy.DBSchemaServlet.doGet(DBSchemaServlet.java:30)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
13:28:36,921 INFO [[/jbpm-bpel]] DBSchemaServlet: 168 more exceptions caught
9. Edit C:\JBPM_BPEL\src\resources\jbpm-bpel.sar\jbpm-bpel-ds.xml
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>JbpmBpelDS</jndi-name> <connection-url>jdbc:mysql://localhost/jbpm</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>jbpm_user</user-name> <password>hopesystems</password> <exception-sorter-class-name> org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter </exception-sorter-class-name> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
10. Edit C:\JBPM_BPEL\src\resources\jbpm-bpel.sar\hibernate.properties
# InnoDB supports transactions hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect # could also be used, see hibernate and mysql websites for more info #hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect #hibernate.dialect=org.hibernate.dialect.MySQLDialect hibernate.connection.datasource=java:JbpmBpelDS hibernate.show_sql=false hibernate.query.substitutions=true 1, false 0 #hibernate.c3p0.min_size=1 #hibernate.c3p0.max_size=3
11. Open command
CD C:\JBPM_BPEL ANT build.service.402
12. Copy C:\JBPM_BPEL\build\jbpm-bpel.sar to C:\JBoss\server\default\deploy
13. Copy mysql-connector-java-5.0.0-beta-bin.jar to C:\JBoss\server\default\lib
14. Open command
CD C:/JBPM_BPEL/doc/examples/hello ANT create-schema
Using MySQL as database
13:44:15,593 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
13:44:15,593 INFO [Configuration] processing extends queue
13:44:15,609 INFO [Configuration] processing collection mappings
13:44:15,609 INFO [Configuration] processing association property references
13:44:15,609 INFO [Configuration] processing foreign key constraints
13:44:15,625 INFO [Configuration] processing extends queue
13:44:15,625 INFO [Configuration] processing collection mappings
13:44:15,625 INFO [Configuration] processing association property references
13:44:15,625 INFO [Configuration] processing foreign key constraints
13:44:15,687 INFO [SchemaExport] Running hbm2ddl schema export
13:44:15,687 INFO [SchemaExport] exporting generated schema to database
13:44:15,687 INFO [NamingHelper] JNDI InitialContext properties:{}
13:44:15,687 INFO [DatasourceConnectionProvider] Using datasource: java:JbpmBpelDS
13:44:47,703 INFO [SchemaExport] schema export complete
13:44:47,718 INFO [[/jbpm-bpel]] DBSchemaServlet: completed database schema operation: create
13:44:47,718 ERROR [[/jbpm-bpel]] DBSchemaServlet: caught an exception
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'jbpm.bpel_alarmdefinition' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1626)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3025)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1147)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1070)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:229)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:145)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:99)
at org.jbpm.bpel.web.deploy.DBSchemaServlet.createSchema(DBSchemaServlet.java:48)
at org.jbpm.bpel.web.deploy.DBSchemaServlet.doGet(DBSchemaServlet.java:30)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
13:44:48,000 INFO [[/jbpm-bpel]] DBSchemaServlet: 168 more exceptions caught
I found that the table "bpel_alarmdefinition" is created.
I have no idea what is the reason, could you tell me are my mistakes?
Thank you very much ^^
Roy
