Hi,
another problem is that I have a table where the primary key is a varchar. I
use in my schema the defaultIdMethod = native. How can I set the pk manually
in this table. In the pseudonyms table I had set the idMethod="none".
<database name="confuoco"
defaultJavaType="object"
defaultIdMethod="native"
skipSql="false">
<!-- #### TABLE PSEUDONYMS ####-->
<table name="PSEUDONYMS" description="PSEUDONYMS TABLE" idMethod="none"
javaNamingMethod="underscore">
<column
name="NICKNAME"
required="true"
primaryKey="true"
type="VARCHAR"
size="256"
description="NICKNAME"/>
<column
name="USER_ID"
required="true"
type="INTEGER"
description="USER_ID"/>
<column
name="STATUS"
required="true"
type="INTEGER"
size="1"
description="STATUS"/>
<foreign-key foreignTable="CONFUOCO_USER">
<reference
local="USER_ID"
foreign="ID"/>
</foreign-key>
</table>
.......
Can I set an entry like:
Pseudonyms pseudonyms = new Pseudonyms();
pseudonyms.setNickname(pseudonym);
pseudonyms.setUserId(primaryKeyUser);
pseudonyms.setStatus(new Integer(1));
pseudonyms.save();
Thanks for any help.
Ferruh