okay. that produces a more familiar set of tables and DDL statements. thanks eric! i'll work with laura to get this in the documentation.
tc On Jan 14, 2012, at 12:02 AM, Eric Dalquist wrote: > Hrm, I think the db-hibernate task is the wrong thing to call, it calls three > other hibernate related tasks and it looks like they are all overwriting the > previous run's files > > Try: > > ant db -Dscriptfile=up4_legacy.ddl > ant db-hibernate-portal -Dexport=false -DoutputFile=up4_portal_hibernate.ddl > ant 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 >>> >> > -- 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
