db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Monroe <mon...@dukece.com>
Subject RE: Problem with ID Table
Date Mon, 16 Feb 2009 18:48:00 GMT
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:ludwig@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-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@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-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message