2 Replies Latest reply on Oct 19, 2005 8:06 AM by Cassio Freire

    JBPM_BPEL: Too many tables. MySQL can only use 31 tables in

    Cassio Freire Newbie

      Hi,

      I am trying to use the Ant tasks that come with the jbpm-bpel-1.0-alpha3 release and I have trouble to run the examples. When I run the deploy-application target, got the following exception:

      18:36:19,950 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
      18:36:20,090 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
      18:36:20,106 INFO [JkMain] Jk running ID=0 time=0/62 config=null
      18:36:20,122 INFO [Server] JBoss (MX MicroKernel) [4.0.2 (build: CVSTag=JBoss_4_0_2 date=200505022023)] Started in 26s:841ms
      18:38:25,233 INFO [EARDeployer] Init J2EE application: file:/C:/JAVA/JBPM/jboss-4.0.2/server/default/deploy/hello-application.ear
      18:38:25,608 INFO [TomcatDeployer] deploy, ctxPath=/hello, warUrl=file:/C:/JAVA/JBPM/jboss-4.0.2/server/default/tmp/deploy/tmp31460hel
      lo-application.ear-contents/hello-web-exp.war/
      18:38:26,546 WARN [JDBCExceptionReporter] SQL Error: 1116, SQLState: S1000
      18:38:26,546 ERROR [JDBCExceptionReporter] General error, message from server: "Too many tables. MySQL can only use 31 tables in a joi
      n"
      18:38:26,546 ERROR [[/hello]] StandardWrapper.Throwable
      org.hibernate.exception.GenericJDBCException: could not initialize a collection: [org.jbpm.graph.def.ProcessDefinition.nodes#2]
      at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
      at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.loader.Loader.loadCollection(Loader.java:1407)
      at org.hibernate.loader.collection.OneToManyLoader.initialize(OneToManyLoader.java:107)
      at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:483)
      at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventList
      ener.java:60)


      I am using MySQL 4.0.16-nt and JDBC Driver 3.0.9. Looking for solution, I tried change the value of parameter (hibernate.max_fetch_depth) into hibernate.properties, but haven´t solve.

      Is there other configuration to do ?

      Thanks in advance