Hi everyone:
When I used the websale example supported by jbpm-3.0.1 , I changed the database to MySQL, so I created "mysql" directory in "jbpm-3.0.1\lib" ,copied two files :create.db.hibernate.properties, identity.db.xml from 'hsqldb' to 'mysql' , and edited the "create.db.hibernate.properties" file like this:
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/jbpm
hibernate.connection.username=root
hibernate.connection.password=810727
hibernate.c3p0.min_size=1
hibernate.c3p0.max_size=3
hibernate.show_sql=true
Of course, I have created a database "jbpm" in MySQL first,and set the username and password as above. Meanwhile I did some corresponding changes in " build.deploy.xml" file in jbpm-3.0.1.
Then I deployed websale example to the database 'jbpm' using ANT tool, and the tables were created successfully.
Next I execute ANT order : ant build.webapp -buildfile build.deploy.xml , and the "jbpm.war " file was created successfully, so I copy the "jbpm.war" file to Jboss-4.0.2 .
When I started Jboss-4.0.2 , I found the Errors: JDBC Driver class not found: com.mysql.jdbc.driver. I checked the classpath and found the "mysql-connector-java-3.1.7-bin.jar " was in the classpath , I don't know why this error happened .
I hope someone could help me , I've been confused for several days. Thanks a lot !
Regards
Jeff !