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(a)cs.kuleuven.be
To: rules-users(a)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/...
Kris
----- Original Message -----
From: "XiaoMiTang" <dingyongchang(a)hotmail.com>
To: <rules-users(a)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-Hu...
> Sent from the Drools - User mailing list archive at
Nabble.com.
>
> _______________________________________________
> rules-users mailing list
> rules-users(a)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(a)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