Return-Path: 
 <torque-user-return-6122-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 77522 invoked from network); 27 May 2005 10:44:02 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 27 May 2005 10:44:02 -0000
Received: (qmail 87099 invoked by uid 500); 27 May 2005 10:43:58 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 87055 invoked by uid 500); 27 May 2005 10:43:57 -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 36466 invoked by uid 99); 27 May 2005 02:33:07 -0000
X-ASF-Spam-Status: No, hits=1.4 required=10.0
	tests=DNS_FROM_RFC_POST,HTML_60_70,HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of charrelson@houston.rr.com
 designates 24.93.47.42 as permitted sender)
Message-Id: <200505270233.j4R2WxRZ004491@ms-smtp-03-eri0.texas.rr.com>
From: "Jason Harrelson" <charrelson@houston.rr.com>
To: <torque-user@db.apache.org>
Subject: IDBroker problems
Date: Thu, 26 May 2005 21:33:16 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0000_01C5623A.880C9B80"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
Thread-Index: AcViZGsp8xoYQTb/T4WLlFg12cTbsg==
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: Symantec AntiVirus Scan Engine
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_NextPart_000_0000_01C5623A.880C9B80
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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.


------=_NextPart_000_0000_01C5623A.880C9B80--