Hello all, I encountered a problem at the creation of the DB2 schema used by portal. Trying to create the JBP_OBJECT_NODE failed, due to a restiction in DB2 that prevents creating a unique key on a nullable column (NAME here). I used a workaround by creating manually the table without unique (NAME, PARENT_KEY), but is there a smarter way for getting it up and running ?
Thanks, Arnaud Trace : -------------- 14:40:52,110 ERROR [SchemaExport] Unsuccessful: create table JBP_OBJECT_NODE (PK bigint generated by default as identity, PATH varchar(255), NAME varchar(255), PARENT_KEY bigint, primary key (PK), unique (NAME, PARENT_KEY)) 14:40:52,110 ERROR [SchemaExport] [IBM][CLI Driver][DB2/NT] SQL0542N "NAME" ne p eut pas Ûtre une colonne de clÚ primaire ou unique car elle peut contenir des va leurs NULL. SQLSTATE=42831 -------------- Workaround : -------------- create table JBP_OBJECT_NODE (PK bigint generated by default as identity, PATH varchar(255), NAME varchar(255),PARENT_KEY bigint, primary key (PK)) -------------- View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3920902#3920902 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3920902 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
