-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 So newly approved Rave account should call Shindig's Person RPC method? I think it would be a good idea for the initial populator to do the same. The initial_data.sql scripts for rave-portal and rave-shindig are currently out of synch.
Marlon On 9/8/11 8:33 AM, Jasha Joachimsthal wrote: > On 8 September 2011 14:11, Marlon Pierce <[email protected]> wrote: > > +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/ iQEcBAEBAgAGBQJOaL3MAAoJEEfVXEODPFIDyJ0IAIT1IIqC8NfuCfQHCbPftZME cdBJyx8CsTu7qjzphALOneVBlIuk7t/BbElnUVmSc7b4IW0uzvgqEXLS5qmQXBCP 8aRaUdrRHLUQM3mzz8DwFYtevOnSNgeLlN424PgTgJ/0JvvY25A9OOIWU1v2x7kI j25XngEbM8ZR+rXqtQ5/4UmW+m1lWWCZs8w/RJ/rFI3IuvJ3Ipwldf6KTkvSioOQ mMIThYc5vaJZWrmcbwCmIRJC+GhHw4Pm+d7BqhsO2kaowNxz8OAFj/AjhLyDWlKN vCQZ7VWgvOaN65mGlqhmF618W47j4u3kUMISeRF3bI7YCIiHpIMPM0c9RuV5Ncs= =SqmH -----END PGP SIGNATURE-----
