Dear uPortal Developers, I've successfully installed uPortal 3.1 RC1 using MySQL and HSQL, but when I tried to run the initdb ANT target against an SQL Server database, it failed complaining that primary keys cannot be created on nullable columns (SQL Server can't handle primary keys being set to nullable columns). We fixed the issue by adding the appropriate <not-null> elements to the three tables.xml files immediately after all the <primary-key> elements using a simple find and replace.
Conan Cook Senior Applications Developer Academic Technologies Group (ATG) University of the West of England Frenchay Campus Bristol BS16 1QY email: [email protected] telephone: 01173 281 053 This email was independently scanned for viruses by McAfee anti-virus software and none were found -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
