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&containerType=14&container=2034]
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user