Hi,
I am trying to setup jbpm5.4 with oracle 11g. I have modified following files,
- jbpm-installer\db\jbpm-persistence-JPA2.xml - to point to oracle dialect
- jbpm-installer\db\task-persistence-JPA1.xml - modified properties like url,username and password
- jbpm-installer\task-service\resources\META-INF\persistence.xml - modified the properties to point to my database
- jbpm-installer\lib\jbpm-gwt-console-server-5.4.0.Final-EE6.war\WEB-INF\classes\META-INF\persistence.xml - modified the dialect
- jbpm-installer\lib\jbpm-human-task-war-5.4.0.Final-EE6.war\WEB-INF\classes\META-INF\persistence.xml - modified the dialect
- Placed ojdbc6.jar file under jbpm-installer\db\driver
- Created a oracleserver_module.xml under jbpm-installer\db
- Modified jbpm-installer\build.properties to point to the oracle database
- Did changes in jbpm-installer\standalone.xml
After modifying all the files, I ran "ant install.db.files" - it successfully copied the jar to jboss-as
then I ran "ant start.human.task" to create the table but its throwing me SQLException:
C:\jbpm\jbpm-installer\build.xml:864: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
Copying 1 file to C:\jbpm\jbpm-installer\task-service\target
1 14/03 14:42:35,251[main] ERROR tool.hbm2ddl.SchemaUpdate.execute - could not get database metadata
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:496)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:278)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:190)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:356)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
at org.jbpm.DemoTaskService.main(Unknown Source)
6 14/03 14:42:35,256[main] ERROR tool.hbm2ddl.SchemaUpdate.execute - could not complete schema update
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
NOTE: I have given proper credentials
Thanks in Advance!!!