Hi, probably is something that is not allowed in MS SQL Sever2008.<br>Are you using drools 5.1? the trunk?<br>Greetings.<br><br><div class="gmail_quote">On Wed, Aug 4, 2010 at 2:25 AM, XiaoMiTang <span dir="ltr"><<a href="mailto:dingyongchang@hotmail.com">dingyongchang@hotmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><br>
When use the Human Task,some tables were created in DB automatic,but one SQL<br>
statement occured error is this:<br>
<br>
create table Notification_EmailNotificationHeader<br>
(<br>
Notification_id numeric(19,0) not null,<br>
emailHeaders_id numeric(19,0) not null,<br>
mapkey varchar(255) null,<br>
primary key (Notification_id, mapkey),<br>
unique (emailHeaders_id)<br>
)<br>
<br>
the mapkey is nullable,can not be defined as primary key~<br>
Is this a bug? or something wrong with my development enviroment?<br>
Eclipse + tomcat + MS SQL Server2008<br>
Mina 2.0(hibernate-core-3.3.0.SP1.jar)<br>
<br>
persistence.xml is this:<br>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><br>
<persistence<br>
version="1.0"<br>
xsi:schemaLocation=<br>
"<a href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a><br>
<a href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd</a><br>
<a href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a><br>
<a href="http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/orm_1_0.xsd</a>"<br>
xmlns:orm="<a href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a>"<br>
xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"<br>
xmlns="<a href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a>"><br>
<br>
<persistence-unit name="org.drools.task"><br>
<provider>org.hibernate.ejb.HibernatePersistence</provider><br>
<class>org.drools.task.Attachment</class><br>
<class>org.drools.task.Content</class><br>
<class>org.drools.task.BooleanExpression</class><br>
<class>org.drools.task.Comment</class><br>
<class>org.drools.task.Deadline</class><br>
<class>org.drools.task.Comment</class><br>
<class>org.drools.task.Deadline</class><br>
<class>org.drools.task.Delegation</class><br>
<class>org.drools.task.Escalation</class><br>
<class>org.drools.task.Group</class><br>
<class>org.drools.task.I18NText</class><br>
<class>org.drools.task.Notification</class><br>
<class>org.drools.task.EmailNotification</class><br>
<class>org.drools.task.EmailNotificationHeader</class><br>
<class>org.drools.task.PeopleAssignments</class><br>
<class>org.drools.task.Reassignment</class><br>
<class>org.drools.task.Status</class><br>
<class>org.drools.task.Task</class><br>
<class>org.drools.task.TaskData</class><br>
<class>org.drools.task.SubTasksStrategy</class><br>
<class>org.drools.task.OnParentAbortAllSubTasksEndStrategy</class><br>
<class>org.drools.task.OnAllSubTasksEndParentEndStrategy</class><br>
<class>org.drools.task.User</class><br>
<br>
<properties><br>
<property name="hibernate.dialect"<br>
value="org.hibernate.dialect.SQLServerDialect"/><br>
<property name="hibernate.connection.driver_class"<br>
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/><br>
<property name="hibernate.connection.url"<br>
value="jdbc:sqlserver://192.168.101.91:1433;DatabaseName=BinTest" /><br>
<property name="hibernate.connection.username" value="sa"/><br>
<property name="hibernate.connection.password" value="sa"/><br>
<property name="hibernate.connection.autocommit" value="false" /><br>
<property name="hibernate.max_fetch_depth" value="3"/><br>
<property name="hibernate.hbm2ddl.auto" value="create" /><br>
<property name="hibernate.show_sql" value="true" /><br>
</properties><br>
</persistence-unit><br>
</persistence><br>
<br>
Can anyone help?<br>
XiaoMiTang<br>
<font color="#888888"><br>
<br>
--<br>
View this message in context: <a href="http://drools-java-rules-engine.46999.n3.nabble.com/Is-this-a-bug-when-using-Human-Task-tp1021453p1021453.html" target="_blank">http://drools-java-rules-engine.46999.n3.nabble.com/Is-this-a-bug-when-using-Human-Task-tp1021453p1021453.html</a><br>
Sent from the Drools - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br> - CTO @ <a href="http://www.plugtree.com">http://www.plugtree.com</a> <br> - MyJourney @ <a href="http://salaboy.wordpress.com">http://salaboy.wordpress.com</a><br>
- Co-Founder @ <a href="http://www.jbug.com.ar">http://www.jbug.com.ar</a><br> <br> - Salatino "Salaboy" Mauricio -<br>