[jboss-user] [jBPM] - jbpm6 use oracle11g will be sql exception?

zhao Li [https://community.jboss.org/people/tiandaochouqin] created the discussion "jbpm6 use oracle11g will be sql exception?" To view the discussion, visit: https://community.jboss.org/message/817602#817602 -------------------------------------------------------------- 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 -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/817602#817602] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]