On 8 September 2011 14:11, Marlon Pierce <[email protected]> wrote:
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > +1 and I have a related question: how should we synch/link the rave-portal > and rave-shindig databases? > Probably not. It should be possible to use a different opensocial container (e.g. on a different server). > > > Marlon > > > On 9/8/11 5:50 AM, Jasha Joachimsthal wrote: > > In my attempts to use a different database than H2, one of the issues I > > faced was the initial data. Through the DataSourcePopulator we directly > > execute SQL queries which causes troubles like > > - the exception "table \".*\" not found.*\n*.*" works for H2 and MySQL, > > PostgreSQL returns "ERROR: relation "widget" does not exist". > > - set @variable is not the correct syntax for PostgreSQL > > - a boolean value must be TRUE or FALSE (instead of 'Y' and 'N') to work > > with both H2, MySQL and PostgreSQL > > - and last but not least: a change in sequence strategy means that the > > queries won't be executed because of "next value for user_id_seq". > > > > Some of the initial data is actually essential to let the portal work. If > > you create a new account but don't have a filled page_layout table, the > user > > can log in but immediately gets a stacktrace. > > > > I want to propose to create a new populator that uses JPA to create the > > objects instead of native sql queries. > > > > Jasha Joachimsthal > > > > Europe - Amsterdam - Oosteinde 11, 1017 WT Amsterdam - +31(0)20 522 4466 > > US - Boston - 1 Broadway, Cambridge, MA 02142 - +1 877 414 4776 (toll > free) > > > > www.onehippo.com > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG/MacGPG2 v2.0.16 (Darwin) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iQEcBAEBAgAGBQJOaLEIAAoJEEfVXEODPFIDm6MH/jaWicgojYb9xVxRUrvoblzI > 1L5Ab5Ln+OB297U2E16D2Mru39ctxfg7XRkCZfH5UyevtNkmWAgAtIh7YRTlOTGi > +yIm89lj/lm5o0DmOWXSUErV4FNZMfYr1uSZ1yatxTtaCL4DI1YV2rLkYlvXBRxX > +XVxqN3B+5Sk/aryhrkghQU8wDNkiJAn41LTtRrRnlipdXMcqSKUwCmZ4Ooa7RMV > 3GhcaVzX3Emqi/3ZU7Z4dH5dFh6ShRTpQLq60WCaT9yEK3s8BF90LPky/ZK4uVqK > txV+ur6/I4CzmDxoqhbo2U//g3XYv8lF0GJEVVscKqrAkx9BowGVUn6xdJphk94= > =s9xa > -----END PGP SIGNATURE----- >
