Try entry.getPrimaryKeyAsInt()
This should work.
Herv�
> -----Original Message-----
> From: Erich Meier [mailto:[EMAIL PROTECTED]]
> Sent: vendredi, 6. juillet 2001 12:28
> To: [EMAIL PROTECTED]
> Subject: How to get the new primary key when using MqSQL
> autoincrement?
>
>
> Hi folks,
>
> I am using Torque-generated classes together with MySQL (gjt
> driver) and its
> autoincrement feature within my app.
>
> How do I retrieve the newly created primary key after a
> save() for storing
> object associations?
>
> What I do is the following (Logentry and LogentryProcess are
> Torque-generated
> classes):
>
> public void store(Logentry entry) {
> try {
> entry.save();
> log.info("stored entry under key "+entry.getId());
>
> LogentryProcess assoc = new LogentryProcess();
> assoc.setLogentryId(entry.getId());
> assoc.setProcessId("4"); // for testing
> assoc.save();
>
> log.info("stored association");
> }
>
> The schema definitions of the tables are
>
> <table name="logentry">
> <column name="logentry_id" javaName="Id" required="true"
> autoIncrement="true" primaryKey="true" type="INTEGER"/>
> <column name="name" required="true" size="255" type="VARCHAR"/>
> [...]
> </table>
>
> <table name="logentry_process">
> <column name="logentry_id" required="true" primaryKey="true"
> type="INTEGER"/
> >
> <column name="process_id" required="true" primaryKey="true"
> type="INTEGER"/>
>
> <foreign-key foreignTable="logentry">
> <reference local="logentry_id" foreign="logentry_id"/>
> </foreign-key>
> [...]
>
> I would expect entry.getId() to return the new key id. But it is null.
> How do I get that information? Or do I have to use other
> techniques of storing
> object associations?
>
> TIA,
> Erich
> --
> Dr. Erich Meier, Software Process Improvement
> method park, Wetterkreuz 19a, 91058 Erlangen, Germany
> Tel. +49-9131-97206-316 mailto:[EMAIL PROTECTED]
> Fax. +49-9131-97206-200 http://www.methodpark.de/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
