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

    jbpm6 use oracle11g will be sql exception?

    Zhao Lu Newbie

      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