From torque-user-return-7792-apmail-db-torque-user-archive=db.apache.org@db.apache.org Fri Feb 22 14:24:18 2008 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 33753 invoked from network); 22 Feb 2008 14:24:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 22 Feb 2008 14:24:17 -0000 Received: (qmail 94458 invoked by uid 500); 22 Feb 2008 14:24:02 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 94379 invoked by uid 500); 22 Feb 2008 14:24:02 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 94324 invoked by uid 99); 22 Feb 2008 14:24:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Feb 2008 06:24:02 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [88.198.38.107] (HELO mx4.synyx.de) (88.198.38.107) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 22 Feb 2008 14:23:28 +0000 Received: from localhost (localhost [127.0.0.1]) by mx4.synyx.de (Postfix) with ESMTP id E081110640A9 for ; Fri, 22 Feb 2008 15:23:35 +0100 (CET) Received: from mx4.synyx.de ([127.0.0.1]) by localhost (synyx.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id qltbLnWgJs3H for ; Fri, 22 Feb 2008 15:23:35 +0100 (CET) Received: from [192.168.0.92] (unknown [91.89.242.118]) by mx4.synyx.de (Postfix) with ESMTP id A9755106405C for ; Fri, 22 Feb 2008 15:23:35 +0100 (CET) Message-ID: <47BEDAF9.7020404@synyx.de> Date: Fri, 22 Feb 2008 15:23:53 +0100 From: Florian Hopf User-Agent: Thunderbird 1.5.0.14pre (X11/20071022) MIME-Version: 1.0 To: Apache Torque Users List Subject: Maven Multiproject and IDBroker X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi, I'm still struggling with some problems in our multiproject structure. We have several subprojects that contain seperate schema files. Id generation is set to idbroker. Generation and initialization seem to work ok, but the ids for the ID_TABLE are calculated incorrectly. Every submodule starts with the id 100 again and therefore overwrites existing entries in the database. E.g. the following entries get created for different submodules: First id-table.sql insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (101, 'log_entry', 1000, 10); insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (102, 'binary_files', 1000, 10); ... The second id-table.sql insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (101, 'poll', 1000, 10); Therefore the id table does not contain all the entries needed because some of them get lost. Is there a way to configure the idbroker on a per schema basis to start from a certain id? I noticed that there's the element but I can't find any documentation. Also, I tried to have a look at the sources for the maven plugin to find out how the generation is implemented but the link on http://db.apache.org/torque/releases/torque-3.3/maven2-plugin/source-repository.html is dead and using my svn client with svn://svn.apache.org/repos/asf/db/torque/torque-maven-plugin results in connection refused. Thanks in advance Florian --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org