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

dhana lakshmi do-not-reply at jboss.com
Thu Mar 14 15:16:24 EDT 2013


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]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130314/986fee6b/attachment-0001.html 


More information about the jboss-user mailing list