ID Broker question

[Deb Rogind]

Hello,

 

I may have set up my id_table schema incorrectly. The next_id of id_table skips large blocks of numbers when inserting rows in a member table. I am using torque / tomcat / mysql db. The member table whose indices jump is defined as:

   <table name="member" idMethod="null" skipSql="false" abstract="false">

Thanks in advance for your help!

Regards,

Debbie Rogind

 

 

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!DOCTYPE database SYSTEM 
"http://jakarta.apache.org/turbine/dtd/database.dtd";>

<!-- ==================================================================== -->
<!--                                                                      -->
<!-- I D  B R O K E R  S C H E M A                                        -->
<!--                                                                      -->
<!-- ==================================================================== -->
<!-- This is the XML schema use by Torque to generate the SQL for         -->
<!-- ID_TABLE table used by the id broker mechanism in Turbine.           -->
<!-- ==================================================================== -->
<!-- @author: <a href="mailto:[EMAIL PROTECTED]";>Jason van Zyl</a>       -->
<!-- @version $Id: id-table-schema.xml,v 1.5 2002/02/18 19:55:53 jon Exp $ -->
<!-- ==================================================================== -->

<database name="input">
  <table name="ID_TABLE" idMethod="idbroker">
    <column name="ID_TABLE_ID" required="true" primaryKey="true" type="INTEGER"/>
    <column name="TABLE_NAME" required="true" size="255" type="VARCHAR"/>
    <column name="NEXT_ID" type="INTEGER"/>
    <column name="QUANTITY" type="INTEGER"/>
    
    <unique>
      <unique-column name="TABLE_NAME"/>
    </unique>        
    
  </table>
</database>  


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]