Why I can't run jbpm4.3 examples on oracle server?
june20100606 Jul 26, 2010 2:11 AMI was so much confused. I am only going to finish one demo using a process manager, fork two services, then join the two results. I chose jbpm4.3. But, up to now , I can't even run the examples on oracle.
First, I run "ant create.jbpm.schema", unsuccessful. I read the script, found varchar2(255 char) was not supported in oracle. So i rewrote the script. Schema was created. I could see them using oracle client.
Second, I configured the file 'jbpm.hibernate.cfg.xml' , making jdbc to my oracle server, then run one example. Errors below:
10:29:51,515 FIN | [BaseJbpmTestCase] === starting testAsyncActivity =============================
10:29:52,625 FIN | [WireContext] eagerly initializing org.jbpm.pvm.internal.id.DatabaseIdComposer
10:29:52,703 INF | [Environment] Hibernate 3.3.1.GA
10:29:52,718 INF | [Environment] hibernate.properties not found
10:29:52,718 INF | [Environment] Bytecode provider name : javassist
10:29:52,734 INF | [Environment] using JDK 1.4 java.sql.Timestamp handling
10:29:52,906 INF | [Configuration] configuring from resource: jbpm.hibernate.cfg.xml
10:29:52,906 INF | [Configuration] Configuration resource: jbpm.hibernate.cfg.xml
10:29:53,062 INF | [Configuration] Reading mappings from resource : jbpm.repository.hbm.xml
10:29:53,593 INF | [Configuration] Reading mappings from resource : jbpm.execution.hbm.xml
10:29:54,218 INF | [Configuration] Reading mappings from resource : jbpm.history.hbm.xml
10:29:54,625 INF | [Configuration] Reading mappings from resource : jbpm.task.hbm.xml
10:29:54,890 INF | [Configuration] Reading mappings from resource : jbpm.identity.hbm.xml
10:29:55,093 INF | [Configuration] Configured SessionFactory: null
10:29:55,187 INF | [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)
10:29:55,187 INF | [DriverManagerConnectionProvider] Hibernate connection pool size: 20
10:29:55,187 INF | [DriverManagerConnectionProvider] autocommit mode: false
10:29:55,406 INF | [DriverManagerConnectionProvider] using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@192.168.1.227:1521:jbpm
10:29:55,421 INF | [DriverManagerConnectionProvider] connection properties: {user=jbpm, password=****}
10:30:00,046 INF | [Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect
10:30:00,062 INF | [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
10:30:00,078 INF | [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
10:30:00,125 INF | [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
10:30:00,281 INF | [SessionFactoryImpl] building session factory
10:30:04,296 INF | [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
10:30:04,343 INF | [SchemaExport] Running hbm2ddl schema export
10:30:04,343 INF | [SchemaExport] exporting generated schema to database
10:30:06,312 SEV | [SchemaExport] Unsuccessful: create table JBPM4_DEPLOYMENT (DBID_ number(19,0) not null, NAME_ clob, TIMESTAMP_ number(19,0), STATE_ varchar2(255 char), primary key (DBID_))
10:30:06,312 SEV | [SchemaExport] ORA-00907: 缺少右括号
Why the example drop the exitent schema and create new?Which java file does this operation?
I could not see the schema using oracle client.
I didn't learn about junit. Where can I find one java application using jbpm? Maybe I will learn the deploying process more clearly.