zhao Li
2013-05-14 10:48:37 UTC
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&containerType=14&container=2034]
"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&containerType=14&container=2034]