[jboss-user] [jBPM] - Help needed in integrating Jbpm5.4 with Oracle 11

dhana lakshmi [https://community.jboss.org/people/dhanalakshmiv14] created the discussion "Help needed in integrating Jbpm5.4 with Oracle 11" To view the discussion, visit: https://community.jboss.org/message/802775#802775 -------------------------------------------------------------- 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!!! -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/802775#802775] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]