Thanks for your workarround, my another Idea was to overload or to define an new
method doInsert() in the PtFreetextPeer class where I can set my SQLstatetments by
hand with:
executeStatement("INSERT INTO PT_FREETEXT values "1");
I have just 10 or 12 single column pk tables where I writing this code. I can set than
manually the foreign keys. I don't know if it's a good solution? Another question,
when I use my own doInsert() method are there any possibilty to use the generator for
PrimaryKey's or do I have to create my own Generator?
Regards
Ferruh
-----UrsprÃngliche Nachricht-----
Von: Saravana Krishnan Kannan [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 24. August 2004 16:03
An: [EMAIL PROTECTED]
Betreff: Re: single column pk tables
Hi,
Another crazy sounding workaround, if you cant modify the table definition, is to
create another table called DummyX that has two columns and create a trigger for
insert and delete and write code inside the trigger to insert/delete just the relevant
field into the original table. You can then operate on DummyX from torque. Hope this
helps.
-Sarav
-----Original Message-----
From: "Ferruh Zamangoer" <[EMAIL PROTECTED]>
To: "Apache Torque Users List" <[EMAIL PROTECTED]>
Date: Tue, 24 Aug 2004 14:34:41 +0200
Subject: single column pk tables
Hi,
I want to know if somebody else have anytime tested the Methods
setModified(true) + setNew(true) for single column pk tables. When I look at
Source Code in the BaseXXX classes it seems very good but nothing happens
when I call this methods. Does anybody have a suggestion how I can make a
workarround for this problem. My idea was that I can take a second dummy
column which is never used, but then I have possibility to insert something
into the tables, but it's not a very nice solution.
Thanks for any help!
Regards
Ferruh
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
