Return-Path: 
 <torque-user-return-6142-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 6025 invoked from network); 2 Jun 2005 07:24:03 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 2 Jun 2005 07:24:03 -0000
Received: (qmail 13479 invoked by uid 500); 2 Jun 2005 07:24:00 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 13465 invoked by uid 500); 2 Jun 2005 07:24:00 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 13447 invoked by uid 99); 2 Jun 2005 07:23:59 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from mail04.allianz.de (HELO mail04.allianz.de) (194.127.3.24)
  by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 02 Jun 2005 00:23:56 -0700
Received: from rmx3606.muc.allianz ([194.127.36.6])
	by mail04.allianz.de  with ESMTP id j527Nh0h014228
	for <torque-user@db.apache.org>; Thu, 2 Jun 2005 09:23:44 +0200 (MEST)
Received: from dblmxs1.dresdner-bank.lu ([171.25.98.6])
	by rmx3606.muc.allianz (Switch-3.1.7/Switch-3.1.7) with ESMTP id
 j527NgCA020245
	for <torque-user@db.apache.org>; Thu, 2 Jun 2005 07:23:43 GMT
Received: by dblmxs1 with Internet Mail Service (5.5.2653.19)
	id <MCP8RHB5>; Thu, 2 Jun 2005 09:23:19 +0200
Message-ID: <4A2E265BA43ED5408940E6C0815899EB03B50955@DBLMXS3>
From: "Dressler,Erik(externe MA)" <Erik.Dressler@Dresdner-Bank.lu>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Subject: RE: IDBroker problems
Date: Thu, 2 Jun 2005 09:24:15 +0200 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


hi!

that was no try! that was definitely an error!

the id-table needs an init-value itself. something like this:

insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
(1100, 'ID_TABLE', 1000, 10)

greetz, erik

> -----Original Message-----
> From:	Jason Harrelson [SMTP:charrelson@houston.rr.com]
> Sent:	02 June 2005 04:41
> To:	'Apache Torque Users List'
> Subject:	RE: IDBroker problems
> 
> I tried this to no avail.  Once again the record is added to the table
> with
> a primary key of 0.  Of course the next record still fails as it tries to
> insert another primary key of 0.
> 
> Thanks for the try.  Any other ideas out there?
> 
> -----Original Message-----
> From: Dressler,Erik(externe MA) [mailto:Erik.Dressler@Dresdner-Bank.lu] 
> Sent: Friday, May 27, 2005 5:48 AM
> To: 'Apache Torque Users List'
> Subject: RE: IDBroker problems
> 
> 
> i think i can help you!
> 
> look at this row: defaultIdMethod="idBroker">
> 
> xml is case sensitive. you have to write: defaultIdMethod="idbroker">
> 
> good luck, drezze
> 
> 
> > -----Original Message-----
> > From:	Jason Harrelson [SMTP:charrelson@houston.rr.com]
> > Sent:	27 May 2005 04:33
> > To:	torque-user@db.apache.org
> > Subject:	IDBroker problems
> > 
> > I am new to Torque.  I have been successful at creating my DB and
> classes.
> > Everything works correctly, excluding the primary key incrementing, or 
> > populating at all.  When I add a record to my account table, I get a 0 
> > in the primary key column.  A second record added also yields a 0, 
> > thus it fails.
> >  
> > Here is an excerpt from my schema file for the account table:
> >  
> > <database
> > 
> > name="recipe"
> > 
> > defaultIdMethod="idBroker">
> > 
> > <table name="account" description="">
> > 
> > <column
> > 
> > name="account_id"
> > 
> > required="true"
> > 
> > primaryKey="true"
> > 
> > type="INTEGER"
> > 
> > description="Key of the account record"/>
> > 
> > <column
> > 
> > name="account_type"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="INTEGER"
> > 
> > description=""/>
> > 
> > <column
> > 
> > name="name_first"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="25"
> > 
> > description="User's first name"/>
> > 
> > <column
> > 
> > name="name_last"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="25"
> > 
> > description="User's last name"/>
> > 
> > <column
> > 
> > name="street_address"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="35"
> > 
> > description=""/>
> > 
> > <column
> > 
> > name="city"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="25"
> > 
> > description=""/>
> > 
> > <column
> > 
> > name="state"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="2"
> > 
> > description=""/>
> > 
> > <column
> > 
> > name="zip"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="9"
> > 
> > description=""/>
> > 
> > <column
> > 
> > name="email"
> > 
> > required="false"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="50"
> > 
> > description=""/>
> > 
> > <column
> > 
> > name="password"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="10"
> > 
> > description=""/>
> > 
> > <column
> > 
> > name="nickname"
> > 
> > required="true"
> > 
> > primaryKey="false"
> > 
> > type="VARCHAR"
> > 
> > size="25"
> > 
> > description=""/>
> > 
> > </table>
> > 
> >  
> > 
> > The id_table has an entry for account with next_id = 1000 and quantity 
> > = 10.
> > 
> >  
> > 
> > I am not sure what else to post to help with the putting anyone on the 
> > correct trail.  Everything else seems to be working correctly.  I have 
> > combed the archives and found nothing similar to this problem.  If you 
> > need any other info, please let me know and I will provide it.
> > 
> > Thank you in advance for you help.
> > 
>  
> *  *  *  *  *  *  D I S C L A I M E R  *  *  *  *  *  *  *
>  
> This message is confidential and intended for the named addressee(s) only.
> If you are not the intended recipient, please contact the sender by E-Mail
> return and then delete this message from your system. You should not copy
> or
> use it or disclose its contents to any other person.
>  
> If any part of this message is illegible or if you suspect that the
> message
> may have been intercepted or amended, please contact the sender.
> Dresdner Bank Luxembourg S.A. cannot accept any responsibility for the
> accuracy or completeness of this message without further investigation.
>  
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
 
*  *  *  *  *  *  D I S C L A I M E R  *  *  *  *  *  *  *
 
This message is confidential and intended for the named addressee(s) only.
If you are not the intended recipient, please contact the sender by E-Mail
return and then delete this message from your system. You should not copy
or use it or disclose its contents to any other person.
 
If any part of this message is illegible or if you suspect that the message
may have been intercepted or amended, please contact the sender.
Dresdner Bank Luxembourg S.A. cannot accept any responsibility for the
accuracy or completeness of this message without further investigation.
 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org