JBoss Community

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