-----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?
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-----
