You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Dennis Vredeveld <vr...@imst.de> on 2006/01/30 15:20:21 UTC
convenience methods to handle foreign keys not working
Hello,
I'm having some troubles with foreign keys when inserting new objects into
an existing DB.
The Torque documentation states that the following should be the most
convenient way to handle foreign keys:
Publisher addison = new Publisher();
addison.setName("Addison Wesley Professional");
addison.save();
/*
* Using the convenience methods to handle
* the foreign keys.
*/
Book effective = new Book();
effective.setTitle("Effective Java");
effective.setISBN("0-618-12902-2");
effective.setPublisher(addison);
effective.save();
I'm trying to do the same with a Segment table which as been defined as
follows:
<table name="Segment">
<column name="segment_ID" primaryKey="true" required="true"
type="BIGINT"/>
<column default="NONE" name="IP_Address" required="true"
size="100" type="VARCHAR"/>
<column default="0" name="Port" required="true" type="SMALLINT"/>
<column default="NONE" name="Name" required="true" size="30"
type="VARCHAR"/>
<column default="0" name="PAN_Identifier" required="true"
type="INTEGER"/>
</table>
I create and save it using:
// Add Segment
Segment seg = new Segment();
assertNotNull(seg);
seg.setIpAddress(IPAddress1);
seg.setPort(port1);
seg.setName(segment1Name);
try {
seg.save();
} catch (Exception ex) {
ex.printStackTrace();
}
The problem is, that the value of segment_ID is 0 at all times. However, in
my opinion it should be updated after the seg.save() statement. When I look
in the database, the Segment instance is correctly stored, but its ID is 1
(the ID is a primary key with auto-increment, so on an emtpy DB, ID=1 is ok
for the first row).
Due to this problem, I cannot use the statement
setSegment(seg) or
setSegmentID(seg.getSegmentId())
on any tables that have foreign keys to Segment, as this yields an SQL error
on a foreign key constraint failing, when trying to insert.
As this belongs to the basic functionality of Torque, I must have been
overlooking something!?
I'm using Torque3.2 on an MySQL DB.
Thanks in advance,
Dennis Vredeveld
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
AW: convenience methods to handle foreign keys not working
Posted by Dennis Vredeveld <vr...@imst.de>.
Thanks, you are right: the idMethod and autoIncrement values were not set. I
didn't even know they had to be set manually, as my schema.xml has been
reverse engineered from an existing DB. Within the DB auto_increment has
been set.
So should Torque also automatically generated these properties for me or
should I get used to editing the schema.xml file manually after generating,
if I want to be able to write in the DB?
> -----Ursprüngliche Nachricht-----
> Von: Greg Monroe [mailto:Greg.Monroe@DukeCE.com]
> Gesendet: Monday, January 30, 2006 22:08
> An: Apache Torque Users List
> Betreff: RE: convenience methods to handle foreign keys not working
>
>
> You need to have the autoIncrement=true attribute set
> on the Segment_ID column definition in the Schema XML
> (as well define the idMethod).
>
> ________________________________
>
> From: Patrick Carl [mailto:patrick.carl@web.de]
> Sent: Mon 1/30/2006 9:56 AM
> To: Apache Torque Users List
> Subject: Re: convenience methods to handle foreign keys not working
>
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> what do you use as idMethod? It looks to me as if you are using the
> default "none" which leaves it to you to determine the ids. But since
> you state that the db creates a correct id you should use
> idMethod="native" in your table definition.
>
> Have a look at
> http://db.apache.org/torque/generator/schema-reference.html in the
> databse section. There is some documentation for the attribute
> [default]idMethod.
>
> Patrick
>
> Dennis Vredeveld schrieb:
> > Hello,
> >
> > I'm having some troubles with foreign keys when inserting new
> objects into
> > an existing DB.
> > The Torque documentation states that the following should be the most
> > convenient way to handle foreign keys:
> >
> > Publisher addison = new Publisher();
> > addison.setName("Addison Wesley Professional");
> > addison.save();
> >
> > /*
> > * Using the convenience methods to handle
> > * the foreign keys.
> > */
> > Book effective = new Book();
> > effective.setTitle("Effective Java");
> > effective.setISBN("0-618-12902-2");
> > effective.setPublisher(addison);
> > effective.save();
> >
> > I'm trying to do the same with a Segment table which as been defined as
> > follows:
> > <table name="Segment">
> > <column name="segment_ID" primaryKey="true" required="true"
> > type="BIGINT"/>
> > <column default="NONE" name="IP_Address" required="true"
> > size="100" type="VARCHAR"/>
> > <column default="0" name="Port" required="true"
> type="SMALLINT"/>
> > <column default="NONE" name="Name" required="true" size="30"
> > type="VARCHAR"/>
> > <column default="0" name="PAN_Identifier" required="true"
> > type="INTEGER"/>
> > </table>
> >
> > I create and save it using:
> >
> > // Add Segment
> > Segment seg = new Segment();
> > assertNotNull(seg);
> > seg.setIpAddress(IPAddress1);
> > seg.setPort(port1);
> > seg.setName(segment1Name);
> > try {
> > seg.save();
> > } catch (Exception ex) {
> > ex.printStackTrace();
> > }
> >
> > The problem is, that the value of segment_ID is 0 at all times.
> However, in
> > my opinion it should be updated after the seg.save() statement.
> When I look
> > in the database, the Segment instance is correctly stored, but
> its ID is 1
> > (the ID is a primary key with auto-increment, so on an emtpy
> DB, ID=1 is ok
> > for the first row).
> > Due to this problem, I cannot use the statement
> > setSegment(seg) or
> > setSegmentID(seg.getSegmentId())
> > on any tables that have foreign keys to Segment, as this yields
> an SQL error
> > on a foreign key constraint failing, when trying to insert.
> >
> > As this belongs to the basic functionality of Torque, I must have been
> > overlooking something!?
> >
> > I'm using Torque3.2 on an MySQL DB.
> >
> >
> > Thanks in advance,
> > Dennis Vredeveld
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFD3ikN8WXLwOuqqQ0RAk4tAKDPZP/3sq+RNboTw/dKNwekAS2/wACfYA+I
> U+3r8jonLzHGQv9OfHpiO1g=
> =QB8S
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
> Duke CE Privacy Statement
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged
> or confidential and are intended solely for the individual or
> entity to whom they are addressed. If you are not the intended
> recipient you may not rely on the contents of this email or any
> attachments, and we ask that you please not read, copy or
> retransmit this communication, but reply to the sender and
> destroy the email, its contents, and all copies thereof
> immediately. Any unauthorized dissemination, distribution or
> copying of this communication is strictly prohibited.
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: convenience methods to handle foreign keys not working
Posted by Greg Monroe <Gr...@DukeCE.com>.
You need to have the autoIncrement=true attribute set
on the Segment_ID column definition in the Schema XML
(as well define the idMethod).
________________________________
From: Patrick Carl [mailto:patrick.carl@web.de]
Sent: Mon 1/30/2006 9:56 AM
To: Apache Torque Users List
Subject: Re: convenience methods to handle foreign keys not working
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
what do you use as idMethod? It looks to me as if you are using the
default "none" which leaves it to you to determine the ids. But since
you state that the db creates a correct id you should use
idMethod="native" in your table definition.
Have a look at
http://db.apache.org/torque/generator/schema-reference.html in the
databse section. There is some documentation for the attribute
[default]idMethod.
Patrick
Dennis Vredeveld schrieb:
> Hello,
>
> I'm having some troubles with foreign keys when inserting new objects into
> an existing DB.
> The Torque documentation states that the following should be the most
> convenient way to handle foreign keys:
>
> Publisher addison = new Publisher();
> addison.setName("Addison Wesley Professional");
> addison.save();
>
> /*
> * Using the convenience methods to handle
> * the foreign keys.
> */
> Book effective = new Book();
> effective.setTitle("Effective Java");
> effective.setISBN("0-618-12902-2");
> effective.setPublisher(addison);
> effective.save();
>
> I'm trying to do the same with a Segment table which as been defined as
> follows:
> <table name="Segment">
> <column name="segment_ID" primaryKey="true" required="true"
> type="BIGINT"/>
> <column default="NONE" name="IP_Address" required="true"
> size="100" type="VARCHAR"/>
> <column default="0" name="Port" required="true" type="SMALLINT"/>
> <column default="NONE" name="Name" required="true" size="30"
> type="VARCHAR"/>
> <column default="0" name="PAN_Identifier" required="true"
> type="INTEGER"/>
> </table>
>
> I create and save it using:
>
> // Add Segment
> Segment seg = new Segment();
> assertNotNull(seg);
> seg.setIpAddress(IPAddress1);
> seg.setPort(port1);
> seg.setName(segment1Name);
> try {
> seg.save();
> } catch (Exception ex) {
> ex.printStackTrace();
> }
>
> The problem is, that the value of segment_ID is 0 at all times. However, in
> my opinion it should be updated after the seg.save() statement. When I look
> in the database, the Segment instance is correctly stored, but its ID is 1
> (the ID is a primary key with auto-increment, so on an emtpy DB, ID=1 is ok
> for the first row).
> Due to this problem, I cannot use the statement
> setSegment(seg) or
> setSegmentID(seg.getSegmentId())
> on any tables that have foreign keys to Segment, as this yields an SQL error
> on a foreign key constraint failing, when trying to insert.
>
> As this belongs to the basic functionality of Torque, I must have been
> overlooking something!?
>
> I'm using Torque3.2 on an MySQL DB.
>
>
> Thanks in advance,
> Dennis Vredeveld
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFD3ikN8WXLwOuqqQ0RAk4tAKDPZP/3sq+RNboTw/dKNwekAS2/wACfYA+I
U+3r8jonLzHGQv9OfHpiO1g=
=QB8S
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited.
Re: convenience methods to handle foreign keys not working
Posted by Patrick Carl <pa...@web.de>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
what do you use as idMethod? It looks to me as if you are using the
default "none" which leaves it to you to determine the ids. But since
you state that the db creates a correct id you should use
idMethod="native" in your table definition.
Have a look at
http://db.apache.org/torque/generator/schema-reference.html in the
databse section. There is some documentation for the attribute
[default]idMethod.
Patrick
Dennis Vredeveld schrieb:
> Hello,
>
> I'm having some troubles with foreign keys when inserting new objects into
> an existing DB.
> The Torque documentation states that the following should be the most
> convenient way to handle foreign keys:
>
> Publisher addison = new Publisher();
> addison.setName("Addison Wesley Professional");
> addison.save();
>
> /*
> * Using the convenience methods to handle
> * the foreign keys.
> */
> Book effective = new Book();
> effective.setTitle("Effective Java");
> effective.setISBN("0-618-12902-2");
> effective.setPublisher(addison);
> effective.save();
>
> I'm trying to do the same with a Segment table which as been defined as
> follows:
> <table name="Segment">
> <column name="segment_ID" primaryKey="true" required="true"
> type="BIGINT"/>
> <column default="NONE" name="IP_Address" required="true"
> size="100" type="VARCHAR"/>
> <column default="0" name="Port" required="true" type="SMALLINT"/>
> <column default="NONE" name="Name" required="true" size="30"
> type="VARCHAR"/>
> <column default="0" name="PAN_Identifier" required="true"
> type="INTEGER"/>
> </table>
>
> I create and save it using:
>
> // Add Segment
> Segment seg = new Segment();
> assertNotNull(seg);
> seg.setIpAddress(IPAddress1);
> seg.setPort(port1);
> seg.setName(segment1Name);
> try {
> seg.save();
> } catch (Exception ex) {
> ex.printStackTrace();
> }
>
> The problem is, that the value of segment_ID is 0 at all times. However, in
> my opinion it should be updated after the seg.save() statement. When I look
> in the database, the Segment instance is correctly stored, but its ID is 1
> (the ID is a primary key with auto-increment, so on an emtpy DB, ID=1 is ok
> for the first row).
> Due to this problem, I cannot use the statement
> setSegment(seg) or
> setSegmentID(seg.getSegmentId())
> on any tables that have foreign keys to Segment, as this yields an SQL error
> on a foreign key constraint failing, when trying to insert.
>
> As this belongs to the basic functionality of Torque, I must have been
> overlooking something!?
>
> I'm using Torque3.2 on an MySQL DB.
>
>
> Thanks in advance,
> Dennis Vredeveld
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFD3ikN8WXLwOuqqQ0RAk4tAKDPZP/3sq+RNboTw/dKNwekAS2/wACfYA+I
U+3r8jonLzHGQv9OfHpiO1g=
=QB8S
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org