Try:
ant db -Dscriptfile=up4_legacy.ddl ant db-hibernate-portal -Dexport=false -DoutputFile=up4_portal_hibernate.ddlant db-hibernate-raw-events -Dexport=false -DoutputFile=up4_raw-events_hibernate.ddl ant db-hibernate-aggr-events -Dexport=false -DoutputFile=up4_aggr-events_hibernate.ddl
The three different db-hibernate-* tasks are due the allowance in uPortal to use a different data source for the main portal database, the raw events collection database and the aggregate event database.
-Eric On 1/13/12 9:09 PM, Carroll, Tim wrote:
made it to this... i was running this with mysql dialect to complete the build. 1. added mysql dependencies to pom.xml 2. created a new mysql database to serve as a place holder 3. configured rdbm.properties with mysql database details 4. ran two targets that eric recommended below resulted in ddl stmts for these tables: UP_USER UP_USER_LOCALE UP_PERMISSION UP_USER_LAYOUT UP_LAYOUT_STRUCT UP_LAYOUT_PARAM UP_SEQUENCE UP_USER_PROFILE UP_GROUP UP_ENTITY_TYPE UP_GROUP_MEMBERSHIP UP_ENTITY_CACHE_INVALIDATION UP_ENTITY_LOCK UP_ENTITY_PROP UP_EVENT_AGGR_STATUS UP_EVENT_AGGR_STATUS_SEQ either things have been dramatically simplified since 3.1.1, or this process isn't producing all the require table ddl. does this list look complete? if so, i can work with laura to document the bare minimum requirements for executing these tasks. thanks, tim On Jan 12, 2012, at 9:01 AM, Carroll, Tim wrote:thanks drew/eric. i'll try this out later today. looks like i'll need to upgrade my version of ant first. On Jan 10, 2012, at 11:23 PM, Eric Dalquist wrote:If you just want the schema with no data I believe the following will do it: ant db -Dscriptfile=up4_legacy.ddl ant db-hibernate -Dexport=false -DoutputFile=up4_hibernate.ddl Note that since uPortal 4 uses dialect autodection you will still have to have uPortal configured with database settings and the appropriate JDBC driver for your database. Also please test this against a DB that doesn't contain data you care about, this should all work but I haven't just generated the DDL files directly in a long while. -Eric On 1/10/12 5:00 PM, Carroll, Tim wrote:Hi All. I'm interested in generating the uPortal 4 database schema for review without installing the product. Is there an easy way to do this? Thanks, Tim-- 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
smime.p7s
Description: S/MIME Cryptographic Signature
