Posted a bug report and test case under bug #1589 -----Original Message----- From: Werner Guttmann [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 2:24 PM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] Timestamp issues...[bug]
Nick, in this case, can you please file a bug report with BugZilla, and attach the necessary information for me to look at this. A JUnit test case would reall ybe appreciated. Thanks Werner On Mon, 29 Mar 2004 11:14:47 -0500, Nick Stuart wrote: > >Yes, sorry the key-generator is simply IDENTITY it is the top of the mapping file. >The database is HSQLDB 1.7.3(?). Nothing fancy going on in it, i.e. no complex foreign key relationships or anything, just a couple of tables with very simple fields. > >If you need any more info let me know. I could probably come up with a test case >tonight if needed. > >-Nick > >-----Original Message----- >From: Werner Guttmann [mailto:[EMAIL PROTECTED] >Sent: Monday, March 29, 2004 3:44 AM >To: [EMAIL PROTECTED] >Subject: Re: [castor-dev] Timestamp issues...[bug] > > >NIck, > >before starting to dig, what datbase are you using ? And may I ask you why the >mappinmg below does not include a reference to a key generator, i.e. >identity key generator in this case ? As that's what I'd be doing with an >auto-increment field ... > >Regards >Werner > >On Sat, 27 Mar 2004 22:41:39 -0500, Nick Stuart wrote: > >> >>Ok this is silly, and want to make sure its bug (will post as bug if >>is). It seems that if you have an auto-inc. field that happens to >>start at 0 castor doesn't >like it. >> >>My first object in the database has an id of 0. When I go to load it, its fine. But >>when I go to update it I get the following error. >> >>Heres the error: >>Starting getMessageBoard test. >> >>object: [EMAIL PROTECTED] timestamp: >>1080444233614lockertimestamp: 0 Trying to rollback db for command >>getMessageBoard Closing database for command getMessageBoard >>edu.usm.exceptions.CommandException: There was a problem loading this message board: >>Invalid object timestamp detected. >>at edu.usm.commands.GetMessageBoard.execute(GetMessageBoard.java:55) >>at >>edu.usm.impl.CommandReceiverImpl.executeCommand(CommandReceiverImpl.ja >>v >>a:110) at >>edu.usm.tests.ForumTester.testGetMessageBoard(ForumTester.java:108) >>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at >>sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at >>sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> >>The Mapping for this object: >> <class name="edu.usm.beans.MessageBoard" identity="id"> >> <map-to table="board"/> >> <field name="id" type="integer" > >> <sql name="id" type="integer" /> >> </field> >> <!--<field name="forums" type="edu.usm.beans.Forum" collection="vector"> >> <sql many-key="boardId" /> >> </field>--> >> <field name="title" type="string" > >> <sql name="title" type="varchar" /> >> </field> >> <field name="welcome" type="string" > >> <sql name="welcome" type="varchar" /> >> </field> >> </class> >> >>And finally the code that produces the error: >> >> db.begin(); >> query = db.getOQLQuery(oqlString); >> query.bind(title); >> results = query.execute(); >> board = (MessageBoard)results.next(); >> db.update(board); >> db.commit(); >> >> >>I confirmed that when I moved the id to 1, and ran the same code, >>everything worked fine! :/ Besides complaining about being updated >>twice in the >above example, which it didn't before with a 0 id. >> >>Nicholas Stuart >> >>Computer Systems Analyst >> >>Vortechnics, Inc. >>200 Enterprise Drive >>Scarborough, Maine 04074 >> >>--- >>Outgoing mail is certified Virus Free. >>Checked by AVG anti-virus system (http://www.grisoft.com). >>Version: 6.0.634 / Virus Database: 406 - Release Date: 3/18/2004 >> >> >>----------------------------------------------------------- >>If you wish to unsubscribe from this mailing, send mail to >>[EMAIL PROTECTED] with a subject of: >> unsubscribe castor-dev >> > >----------------------------------------------------------- >If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a >subject of: > unsubscribe castor-dev > > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.647 / Virus Database: 414 - Release Date: 3/29/2004 > > >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.647 / Virus Database: 414 - Release Date: 3/29/2004 > > >----------------------------------------------------------- >If you wish to unsubscribe from this mailing, send mail to >[EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004 ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev