Re: [Treebase-devel] Hibernate_sequence need a bigger value

[Rutger V. <rut...@gm...>]

Hi all,

it sounds like Youjun is right: the AbstractPersistedObject needs its
id creation to be set to NATIVE, not SEQUENCE so that all of APO's
subclasses use their own sequences as defined in their respective
tables in the schema as opposed to one called by hibernate.

All the symptoms seem to suggest this: insertion from the command line
works, but through hibernate it doesn't, as per the exception we're
now getting after mesquite started working again.

The reason why it was set to SEQUENCE was, simply put, that I wasn't
sure what I was doing during the migration from DB2 to Pg. To be
honest, I'm still not sure - but Youjun and Hilmar sound authoritative
enough to convince me.

Rutger

On Wed, Dec 30, 2009 at 3:39 PM, youjun guo <you...@ya...> wrote:
>> I wonder if all this is related to a bug that Rutger had reported at our
>> last phone conference.
>
> The code I encounter the problem is unit test of taxonlabel and phylotree
> dao class. Both focus on testing of single table add and delete operation
> without entangling with other factors.
>
> Again, right now database treebase-dev is not working, it refuse connection.
>
> Youjun
>
> On Tue, Dec 29, 2009 at 4:57 PM, William Piel <wil...@ya...> wrote:
>>
>> On Dec 26, 2009, at 10:12 AM, Vladimir Gapeyev wrote:
>>
>> > Bill, have new studies been entered into the DB after Rutger created the
>> > sequences?
>>
>> probably yes -- just a few new studies for testing the submission system.
>> But until Rutger had solved the Mesquite problem, no new phylotree records
>> would have been created successfully.
>>
>> bp
>>
>> ps. I wonder if all this is related to a bug that Rutger had reported at
>> our last phone conference -- that he got the Mesquite parser working except
>> for the result that it was creating twice as many records as it should?
>> (could that happen if two sequence systems are in operation on the same
>> table & row?)
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Verizon Developer Community
>> Take advantage of Verizon's best-in-class app development support
>> A streamlined, 14 day to market process makes app distribution fast and
>> easy
>> Join now and get one step closer to millions of Verizon customers
>> http://p.sf.net/sfu/verizon-dev2dev
>> _______________________________________________
>> Treebase-devel mailing list
>> Tre...@li...
>> https://lists.sourceforge.net/lists/listinfo/treebase-devel
>
>
> ------------------------------------------------------------------------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> _______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel
>
>



-- 
Dr. Rutger A. Vos
School of Biological Sciences
Philip Lyle Building, Level 4
University of Reading
Reading
RG6 6BX
United Kingdom
Tel: +44 (0) 118 378 7535
http://www.nexml.org
http://rutgervos.blogspot.com