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