2 Replies Latest reply on Jul 4, 2011 8:14 AM by selfcare

Understanding GateIn tables

selfcare Jun 30, 2011 8:39 AM

Hi,

Please share any guide to understand GateIn tables (JBID and JCR).. How tables are linked and interpretations for column names..

Actually I want to migrate Jboss Portal tables (tables like JBP_ROLES, JBP_USERS etc) to GateIn JBID and JCR tables.

Regards,

1. Re: Understanding GateIn tables

kien_nguyen Jul 4, 2011 5:41 AM (in response to selfcare)

IMO, It's GateIn internal and i think there is no public doc for this. There is a trick, you can change database setup to MySQL using this guide:http://docs.jboss.com/gatein/portal/3.1.0-FINAL/reference-guide/en-US/html_single/index.html#sect-Reference_Guide-Database_Configuration. and then dig GateIn tables from MySQL.
The basic, GateIn has two type of tables: jbid (for PicketLink IDM) and JCR.
Detail information of table, you should read from in files *.hbm.xml of GateIn source.
Actions
2. Re: Understanding GateIn tables

selfcare Jul 4, 2011 8:14 AM (in response to kien_nguyen)

Thanks Kien,

I am using Oracle 10g and dont have that much time to investigate in MySql as we are already running out of time. Neither am well versed in Hibernate (as we use iBatis).. It would be of great help if you/someone sheds light on understanding basics of those tables.

Regards,
Actions