Grouper Users - Open Discussion List

[Shilen Patel <>]

Does your grouper_ddl table in test currently have anything in it?  If so,
what?  How about in production?

Thanks!

-- Shilen

On 6/4/12 4:29 PM, "Jim Fox" 
<>
 wrote:

>
>
>The test 1.6 database is a copy of my production system (v1.6).
>I ran the 'gsh -registry -check' on it.  The resulting sql file
>can be found at:
>
>    
>http://urizen4.cac.washington.edu/grouperDdl_20120604_11_09_36_938.sql.txt
>
>
>I am using postgres.  My hybernate properties has
>
>   hibernate.connection.url = jdbc:postgresql://localhost/gws1dev
>   hibernate.dialect =
>   hibernate.connection.driver_class =
>    (those are the autodetect options)
>
>Jim
>
>
>
>On Mon, 4 Jun 2012, Shilen Patel wrote:
>
>> Date: Mon, 4 Jun 2012 13:14:20 -0700
>> From: Shilen Patel 
>> <>
>> To: Jim Fox 
>> <>,
>>     grouper users list 
>> <>
>> Subject: Re: [grouper-users] upgrade 1.6 to 2.1
>> 
>> The upgrade should take care of populating those table.  If you want to
>> send me your upgrade script and let me know what type of database you're
>> running (postgres?), I can take a look at what's wrong.
>>
>> Thanks!
>>
>> -- Shilen
>>
>>
>> On 6/4/12 3:57 PM, "Jim Fox" 
>> <>
>>  wrote:
>>
>>>
>>> When I did a test upgrade of 1.6 to 1.7 (when the pit tables were
>>>added)
>>> the conversion sql script had entries like these:
>>>
>>>    drop table grouper_flat_memberships cascade;
>>>    drop table grouper_flat_groups cascade;
>>>    drop table grouper_flat_stems cascade;
>>>    drop table grouper_flat_attribute_def cascade;
>>>
>>>    insert into grouper_pit_fields ...
>>>    insert into grouper_pit_stems ...
>>>    ...
>>>
>>>
>>> When I try a conversion of a test 1.6 to 2.1 I don't see those entries.
>>> My 1.6 DB has the flat tables and does not have the pit tables.
>>>
>>> Is there another way the tables are being populated nowadays?
>>>
>>> Jim
>>>
>>>
>>
>>