JBPM_BPEL: Too many tables. MySQL can only use 31 tables in
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
