I think the quick fix for this is to add the id-table-schema.xml file as an external-schema in your main DB schema file. E.g.
<database .... > <external-schema filename="id-table-schema.xml" /> This should make the datadump task include the id broker table information. Note that this may cause some "table exists" errors when you create tables because the process might call both the id-table-init-sql process to create the tables which are now in the schema sql. FWIW - An alternative is to look at the db.apache.org/ddlutils project (a peer project to Torque). It has some nice features not in Torque for comparing a Schema.XML to the existing DB and creating a modify db script. Works great with adding or dropping columns and criteria. > -----Original Message----- > From: Ludwig Magnusson [mailto:lud...@itcatapult.com] > Sent: Saturday, February 14, 2009 10:01 AM > To: 'Apache Torque Users List' > Subject: Problem with ID Table > > Hi! > I am working on a project where I am using the data in the database at > the > same time as I am developing it. This means that when I need to make > changes > in the database (add tables, columns etc) I need to do a datadump and > then > put in all the data again. > > The problem with this is that my ID table does not update when I do the > datadump. The effect is that when I make new entries in the database I > get a > lot of duplicate key errors. > Is there any property that I have not set? Should there be some kind of > id-table-data.xml file generated like there is myproject-all-data.xml? > ยจ/Ludwig > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org > For additional commands, e-mail: torque-user-h...@db.apache.org > DukeCE Privacy Statement: Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org For additional commands, e-mail: torque-user-h...@db.apache.org