5 Replies Latest reply on May 15, 2013 6:23 AM by tiandaochouqin

    jbpm6 use oracle11g will be sql exception?

    tiandaochouqin

      First of all, I modified the jbpm-console/WEB-INF/classes/META-INF below persistence.xml as follows

       

       

      <properties>

            <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>

            <property name="hibernate.max_fetch_depth" value="3"/>

            <property name="hibernate.hbm2ddl.auto" value="update" />

            <property name="hibernate.show_sql" value="true" /> 

                  <property name="hibernate.format_sql" value="true" /> 

                  <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" />

            <!-- BZ 841786: AS7/EAP 6/Hib 4 uses new (sequence) generators which seem to cause problems -->

            <property name="hibernate.id.new_generator_mappings" value="false" />

          </properties>

       

      Of course, I also modified $ {jboss.home} / standalone / configuration standalone.xml

       

        <subsystem xmlns="urn:jboss:domain:datasources:1.0">

                  <datasources>

                      <datasource jta="true" jndi-name="java:jboss/datasources/jbpmDS" pool-name="jbpm6pool" enabled="true" use-java-context="true" use-ccm="true">

                          <connection-url>jdbc:oracle:thin:@localhost:1521:orcl</connection-url>

                          <driver>oracle</driver>

                          <pool>

                              <min-pool-size>1</min-pool-size>

                              <max-pool-size>4</max-pool-size>

                              <prefill>false</prefill>

                              <use-strict-min>false</use-strict-min>

                              <flush-strategy>FailingConnectionOnly</flush-strategy>

                          </pool>

                          <security>

                              <user-name>jbpm6</user-name>

                              <password>jbpm6</password>

                          </security>

                      </datasource>

                      <datasource jta="true" jndi-name="java:jboss/datasources/BamAppDS" pool-name="BamAppDS" enabled="true" use-java-context="true" use-ccm="true">

                          <connection-url>jdbc:oracle:thin:@localhost:1521:orcl</connection-url>

                          <driver>oracle</driver>

                          <pool>

                              <min-pool-size>1</min-pool-size>

                              <max-pool-size>4</max-pool-size>

                              <prefill>false</prefill>

                              <use-strict-min>false</use-strict-min>

                              <flush-strategy>FailingConnectionOnly</flush-strategy>

                          </pool>

                          <security>

                              <user-name>bamapp</user-name>

                              <password>bamapp</password>

                          </security>

                          <validation>

                              <check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

                              <validate-on-match>false</validate-on-match>

                              <background-validation>false</background-validation>

                              <use-fast-fail>false</use-fast-fail>

                          </validation>

                      </datasource>

                      <drivers>

                          <driver name="oracle" module="com.oracledatabase.oracle">

                              <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

                          </driver>

                      </drivers>

                  </datasources>

              </subsystem>

       

       

      Start jboss7, there will be java.lang.ClassNotFoundException

      Finally, when I view the tasks in the console will appear sql Exception

      The following error

      java.sql.SQLSyntaxErrorException

      Can view the attachment

      Thank you

        • 1. Re: jbpm6 use oracle11g will be sql exception?
          salaboy21

          This seems to be related with oracle:

           

          18:37:00,256 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-7) HHH000388: Unsuccessful: alter table NodeInstanceLog add connection varchar2(255 char)

          18:37:00,258 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-7) ORA-01430: �����Ѵ���Ҫ���ӵ���

           

           

          18:37:00,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-7) HHH000388: Unsuccessful: alter table NodeInstanceLog add externalId varchar2(255 char)

          18:37:00,263 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-7) ORA-01430: �����Ѵ���Ҫ���ӵ���

           

          Can you check the encoding and  your settings? I don't have an oracle database to test here..

           

          Can you also try doing the following:

           

          1) go inside your <jboss as>/bin

          2) do rm -rf .niogit/  -> that's where the example repository is stored for jboss as 7

           

          Cheers

          • 2. Re: jbpm6 use oracle11g will be sql exception?
            salaboy21

            I forgot the third step

             

            3) start jboss again

            • 3. Re: jbpm6 use oracle11g will be sql exception?
              tiandaochouqin

              Hi Mauricio Salatino

                       Thank you very much for your answer!

                       Let's me have some ideas;

                       so I have solved the problem, I modified the oracle driver jar package,use ojdbc6_g.jar.

                       I am very much looking forward to final version of jBPM6! Hope to have more documentation and demo about jBPM6.

              • 4. Re: jbpm6 use oracle11g will be sql exception?
                salaboy21

                Hi Zhao,

                Great to see that it's working with Oracle!

                Feel free to contribute back with examples and help with the documentation. Remember that this is a community project, so your collaboration, no matter how small it is, it's highly appreciated.

                 

                Cheers

                • 5. Re: jbpm6 use oracle11g will be sql exception?
                  tiandaochouqin

                  Hi Mauricio Salatino

                  Hope you have time to help me solve the problem? Even give me a little idea. When I visited the jbpm6 console, console can only be deployed process definition in the /processes pathway.

                    https://community.jboss.org/thread/228016