[rules-users] Exception when use Human Task

Tue Jul 27 21:34:54 EDT 2010

Hi ,kris ,thank you very much for your reply. I have orm.xml in META-INF folder.

Yesterday,i modified the persistence.xml to solve this problem like below:

=================persistence.xml================

      <property name="hibernate.max_fetch_depth" value="3"/>
      <!--property name="hibernate.hbm2ddl.auto" value="create" /-->
      <property name="hibernate.show_sql" value="true" />

==================persistence.xml END==============

I change the  <property name="hibernate.hbm2ddl.auto" value="create" /> into comments,then 

create the table in DB using the SQL:

========SQL========

create table Notification_EmailNotificationHeader
 (Notification_id numeric(19,0) not null, emailHeaders_id numeric(19,0) not
null, mapkey varchar(255) not null, primary key (Notification_id, mapkey), unique (emailHeaders_id))

=====SQL END========

it works ok now~

but i want to know where the SQL "creat table……" defined?

> From: kris.verlaenen at cs.kuleuven.be
> To: rules-users at lists.jboss.org
> Date: Tue, 27 Jul 2010 14:32:37 +0200
> Subject: Re: [rules-users] Exception when use Human Task
> 
> It doesn't seem to be able to find a query, which should be defined in the 
> orm.xml. Do you have the orm.xml file in your META-INF folder on your 
> classpath?
> http://anonsvn.jboss.org/repos/labs/labs/jbossrules/trunk/drools-process/drools-process-task/src/main/resources/META-INF/orm.xml
> 
> Kris
> 
> ----- Original Message ----- 
> From: "XiaoMiTang" <dingyongchang at hotmail.com>
> To: <rules-users at lists.jboss.org>
> Sent: Tuesday, July 27, 2010 11:06 AM
> Subject: [rules-users] Exception when use Human Task
> 
> 
> >
> > I got an exception when using Human Task ,caused by the following code:
> >
> > ===============code===========
> > EntityManagerFactory emf = Persistence.createEntityManagerFactory("aaaa");
> > TaskService taskService = new
> > TaskService(emf,SystemEventListenerFactory.getSystemEventListener());
> > ===============code end=======
> >
> > the error info in the Eclipse's Console llike this:
> > ===========error info=====
> > 严重: Unsuccessful: create table Notification_EmailNotificationHeader
> > (Notification_id numeric(19,0) not null, emailHeaders_id numeric(19,0) not
> > null, mapkey varchar(255) null, primary key (Notification_id, mapkey),
> > unique (emailHeaders_id))
> > 2010-7-27 16:39:38 org.hibernate.tool.hbm2ddl.SchemaExport create
> > 严重: 无法在表 'Notification_EmailNotificationHeader' 中可为 Null 的列上定义 PRIMARY KEY
> > 约束。
> > 2010-7-27 16:39:38 org.hibernate.tool.hbm2ddl.SchemaExport create
> > 严重: Unsuccessful: alter table Notification_EmailNotificationHeader add
> > constraint FK92169CC0379F97EA foreign key (emailHeaders_id) references
> > EmailNotificationHeader
> > 2010-7-27 16:39:38 org.hibernate.tool.hbm2ddl.SchemaExport create
> > 严重: 找不到对象 "Notification_EmailNotificationHeader"，因为它不存在或者您没有所需的权限。
> > 2010-7-27 16:39:38 org.hibernate.tool.hbm2ddl.SchemaExport create
> > 严重: Unsuccessful: alter table Notification_EmailNotificationHeader add
> > constraint FK92169CC01B1E66DC foreign key (Notification_id) references
> > Notification
> > 2010-7-27 16:39:38 org.hibernate.tool.hbm2ddl.SchemaExport create
> > 严重: 找不到对象 "Notification_EmailNotificationHeader"，因为它不存在或者您没有所需的权限。
> > 2010-7-27 16:39:38 org.hibernate.tool.hbm2ddl.SchemaExport execute
> > 信息: schema export complete
> > java.lang.IllegalArgumentException: Named query not found:
> > UnescalatedDeadlines
> > at
> > org.hibernate.ejb.AbstractEntityManagerImpl.createNamedQuery(AbstractEntityManagerImpl.java:108)
> > at org.drools.task.service.TaskService.<init>(TaskService.java:65)
> > at org.drools.task.service.TaskService.<init>(TaskService.java:48)
> > at com.demo.action.loginController.HumanTask(loginController.java:94)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> > at java.lang.reflect.Method.invoke(Unknown Source)
> > at
> > org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:174)
> > at
> > org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:421)
> > at
> > org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:409)
> > at
> > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)
> > at
> > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
> > at
> > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
> > at
> > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at
> > org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
> > at
> > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> > at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> > at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> > at
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> > at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> > at
> > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
> > at
> > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
> > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> > at java.lang.Thread.run(Unknown Source)
> > =======error info end===============================================
> >
> > the top error info(chinese text) means that:
> > [mapkey] is nullable, it can not be defined as primary key ;
> >
> > how to slove it?
> > Thansks~
> > -- 
> > View this message in context: 
> > http://drools-java-rules-engine.46999.n3.nabble.com/Exception-when-use-Human-Task-tp998703p998703.html
> > Sent from the Drools - User mailing list archive at Nabble.com.
> >
> > _______________________________________________
> > rules-users mailing list
> > rules-users at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/rules-users
> > 
> 
> 
> Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users

_________________________________________________________________
Hotmail: Powerful Free email with security by Microsoft.
https://signup.live.com/signup.aspx?id=60969
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20100728/4ac799b1/attachment.html 