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 Ferruh Zamangoer <fe...@gistec-online.de> on 2004/08/23 14:06:13 UTC

single column pk tables

Hi NG,

in michaels posting my experience with torque I read the following:
	in torque's docs i have not seen any word speaking about the restriction to
single column pk tables.

Are there no another way to solve this problem, if I have single column pk
tables.
In my schema I use the  defaultIdMethod="native"


<table name="freetext" description="freetext">
<column
  name="id_freetext"
  required="true"
  primaryKey="true"
  type="INTEGER"
  size="5"
  description="ID Freetext"/>
<id-method-parameter value="freetext_seq"/>
</table>

How can I set any value to a table, which is defined like the table above ??

I've tried the following code but it doesn't works:

Torque.init("Torque.properties");

Freetext freetext = new Freetext();
freetext.save();

Any help is appreciated!

Regards
Ferruh


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


AW: single column pk tables

Posted by Ferruh Zamangoer <fe...@gistec-online.de>.
Hi Scott,

I also know that a table like this is totally pointless, but the problem is
that I have a Databaschema which is determined by ISO Standard. I can't
redesign the schema or add a column to this table? Are there any options
where I can turn off these restriction check?

Regards
Ferruh

-----Ursprungliche Nachricht-----
Von: Scott Eade [mailto:seade@backstagetech.com.au]
Gesendet: Montag, 23. August 2004 14:20
An: Apache Torque Users List
Betreff: Re: single column pk tables


Ferruh Zamangoer wrote:

>Hi NG,
>
>in michaels posting my experience with torque I read the following:
>	in torque's docs i have not seen any word speaking about the restriction
to
>single column pk tables.
>
>Are there no another way to solve this problem, if I have single column pk
>tables.
>In my schema I use the  defaultIdMethod="native"
>
>
><table name="freetext" description="freetext">
><column
>  name="id_freetext"
>  required="true"
>  primaryKey="true"
>  type="INTEGER"
>  size="5"
>  description="ID Freetext"/>
><id-method-parameter value="freetext_seq"/>
></table>
>
>How can I set any value to a table, which is defined like the table above
??
>
>I've tried the following code but it doesn't works:
>
>Torque.init("Torque.properties");
>
>Freetext freetext = new Freetext();
>freetext.save();
>
>Any help is appreciated!
>
>
Such a table is totally pointless and is hence rejected by the Torque
runtime.

Try adding some actual data columns to the table definition.

Scott

--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Re: single column pk tables

Posted by Scott Eade <se...@backstagetech.com.au>.
Ferruh Zamangoer wrote:

>Hi NG,
>
>in michaels posting my experience with torque I read the following:
>	in torque's docs i have not seen any word speaking about the restriction to
>single column pk tables.
>
>Are there no another way to solve this problem, if I have single column pk
>tables.
>In my schema I use the  defaultIdMethod="native"
>
>
><table name="freetext" description="freetext">
><column
>  name="id_freetext"
>  required="true"
>  primaryKey="true"
>  type="INTEGER"
>  size="5"
>  description="ID Freetext"/>
><id-method-parameter value="freetext_seq"/>
></table>
>
>How can I set any value to a table, which is defined like the table above ??
>
>I've tried the following code but it doesn't works:
>
>Torque.init("Torque.properties");
>
>Freetext freetext = new Freetext();
>freetext.save();
>
>Any help is appreciated!
>  
>
Such a table is totally pointless and is hence rejected by the Torque 
runtime.

Try adding some actual data columns to the table definition.

Scott

-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org