Hey Bruke,
Well I do have sequences defined for my each table which acts as a primary key
for my table now I want to use this generatedkey as a foreign key in another
table so now if I use my class attribute to have this sequence id , then how
can I get that key in java code , I am assuming I can do in following manner
please tell me if I a, doing in a right way or not (my DB is Postgres).
<insert id="MSCPerfCntrTrunkTblImpl"
parameterClass="com.hns.hss.nmf.server.log.manager.gensrc.MSCPerformance.impl.MSCPerfCntrTrunkTblImpl">
<selectKey keyProperty="generatedSequenceId_0" resultClass="int">
SELECT nextval('MSCPerfCntrTrunk_seq')
</selectKey>
insert into MSCPerfCntrTrunkTbl(
seq_no,
neinfo_id,
rectimeStamp,
transactionId,
destNum_2,
)
values
(
#generatedSequenceId_0#,
#neInfoId_0#,
#timeStamp_0#,
#transactionId_1.value#,
#count_2.value#,
)
And in my java code if I am writing following statements
SqlMapClient.insert("MSCPerfCntrTrunkTblImpl",ObjectpointingtoMSCPerfCntrTrunkTblImpl)
Above statement will return an Object but an object of what type??.
Looking forward to your response.
Regards
Rahul Saluja
________________________________
From: Burke.Kevin [mailto:kevin.bu...@cic.gc.ca]
Sent: Thursday, February 12, 2009 11:17 PM
To: user-java@ibatis.apache.org
Subject: RE: KeyProperty attribute in Selectkey Tag
Rahul,
My experience with this tag is you use it to define a query to determine your
primary key, in the absence of, say an IDENTITY column.
You need to specify the keyProperty attribute if you want the following SQL to
be able to utilize the result of the query. In the following example, I
utilize an integer based primary key column. The following allows me to manage
the primary keys myself, without an auto-incrementing identity column.
Ex:
<selectKey resultClass="int" keyProperty="id">
SELECT max( pkey_column)+ 1 AS id from <table>
</selectKey>
INSERT INTO <table>
( pkey_column,
<other column>,
<other column>,
... )
VALUES
( #id:INTEGER#,
value,
value,
...)
I guess there is a possibility that you could have concurrency issues, unless
you synchronize access on the DAO methods invoking this statement. Otherwise,
you could experience another thread attemping an insert between the <selectKey>
query to determine the next value, and the actual insert in your statement.
-Kevin
-----Original Message-----
From: Rahul Saluja [mailto:rahul.sal...@vnl.in]
Sent: February 12, 2009 12:00 PM
To: user-java@ibatis.apache.org
Subject: RE: KeyProperty attribute in Selectkey Tag
Does anybody care to reply.
Please.
________________________________
The information contained in this e-mail is private & confidential and may also
be legally privileged. If you are not the intended recipient, please notify us,
preferably by e-mail, and do not read, copy or disclose the contents of this
message to anyone.
