0 Replies Latest reply on Sep 29, 2005 10:20 AM by Sanjeev Tanugula

    jBPM+Tomcat+Oracle 9.2+Cannot insert null value into SYSTEM.

    Sanjeev Tanugula Newbie

      I am running into a problem trying to get the above combination working. I have downloaded jBPM 3.0 and have setup the oracle configuration by creating a oracle folder under src/resources and copied the create.db.hibernate.properties.

      hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
      hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
      hibernate.connection.url=jdbc:oracle:thin:@<host_ip>:1521:jbpmDB
      hibernate.connection.username=system
      hibernate.connection.password=system
      hibernate.c3p0.min_size=1
      hibernate.c3p0.max_size=3
      hibernate.show_sql=true
      hibernate.query.substitutions=true 1, false 0
      
      
      


      then I created a oracle folder under lib folder and copied Oracle9Driver jar to it. I also changed the JbpmSessionFactory.java by adding the configuration details that are shown above in the code segment.

      I was able to successfully build the build.deploy.xml file and was able to connect to the jbpm application on tomcat at http://localhost:8080/jbpm.

      However once I login and try to create a process I get the following error

      "Cannot insert null value into SYSTEM.JBPM_TOKEN.ID_"


      I am not sure what is the problem.

      Need some direction/help.

      Thanks in advance.