Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Reply-To: <svallet@t-systems.fr>
From: "svallet" <svallet@t-systems.fr>
To: "Turbine Torque Users List" <torque-user@db.apache.org>
Subject: Strange values in id table
Date: Wed, 4 Jun 2003 11:02:21 +0200
Message-ID: <GEEKIEAEHCKOCMLIJMHHKEFMCAAA.svallet@t-systems.fr>
MIME-Version: 1.0
Importance: Normal
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset="iso-8859-1"

Hi !

I'm using the id broker feature of Torque ; by looking closer at the id
table, I get (what seems to me) very strange results :

mysql> select * from id_table;
+-------------+-----------------+---------+----------+
| ID_TABLE_ID | TABLE_NAME      | NEXT_ID | QUANTITY |
+-------------+-----------------+---------+----------+
|           1 | ID_TABLE        |   16558 |      713 |
|           2 | TYPE_ENTREE     |   14251 |      610 |
|           3 | ATTRIBUT        |   51901 |     2250 |
|           4 | DICTIONNAIRE    |       1 |       10 |
|           5 | NOM_ATTRIBUT    |       1 |       10 |
|           6 | NOM_TYPE_ENTREE |       1 |       10 |
|           7 | LANGUE          |       3 |       10 |
|           8 | ADOPTION        |      61 |       10 |
|          29 | SIMON           |      31 |       10 |
|          89 | T_TEST2         |       1 |       10 |
|         139 | T_HELLO         |     201 |       10 |
|       15132 | T_CUSTOM        |       1 |        5 |
+-------------+-----------------+---------+----------+
12 rows in set (0.24 sec)

How does it come that Quantity values are so high (2250) ??
my settings are the following (I use torque directly from API) :

[some settings]
torqueProps.addProperty("torque.idbroker.cleverquantity", "true");
//torqueProps.addProperty("torque.idbroker.prefetch", "false");
//torqueProps.addProperty("torque.idbroker.usenewconnection", "false");
Torque.init(torqueProps);

Trying to set "torque.idbroker.prefetch=false" did reset some "Next_id"
values to 1, and not some others... so I commented it out ;
"usenewconnection" has alwas been uncommented

I initialize the id table manually with Quantity values of 10 (the last
table is a test case) -> I would _love_ to get Torque to initialize it, but
didn't got it right :( (but things seem to work, apart from this)

Thanks for any suggestions,
Simon

--
Simon Vallet
T-Systems e-technologies
svallet@t-systems.fr