Hibernate version: 3.2
Name and version of the database you are using: DB2 (8.1)

Hi,

I have the following scenario:
-> A Transaction table (with transaction_id as it's pk)
-> An MQ_Transaction table having a transaction_id column (where, the transaction_id in the MQ_Transaction table = the transaction_id in the Transaction table) and vendor_id column

This is what I want to do:
I want to have a one-to-one association between my Transaction table and MQ_Transaction table.
So that, while updating my fields in the Transaction table, I also want MQ_Transaction to be one of the fields in the mapping. This is what it looks like:

(I am using a sequence ID generator)
Transaction txn = new Transaction();
txn.setVendorID("xyz");
txn.setRequestTime("abcd");
MQTxn mqTxn = new MQTxn();
mqTxn.setSomething ("something");
//Please note that I did not set any transactionID for the mqTxn object.
txn.setMQTxn (mqTxn);
open session;
saveOrUpdate;
commit;

And of course, I'm getting an error saying that I have to explicitly set the transactionID field for the MQ_Transaction table.

This is what I'm not understanding how to do:
Since I'm using a sequence ID generator, my Transaction table is being updated with the proper transactionID. But, what I want is the same transactionID to be updated to the MQ_Transaction table's transactionID field as well.

Any help please? I can provide more information if I was not clear, and please excuse me if I was not clear enough.

Thanks,
-mpochampalli

Try performing a save of mqTxn before
txn.setMQTxn(mqTxn)

Hi Somu,

If I do a save on the txn object, and then set the mqTxn object to the txn object, it works (but of course, even then, I have to explicitly set the transactionID from the txn object to the mqTxn object's txnID field).

But what I want is for hibernate to generate and update mqTxn with the same ID that has been generated for the Transaction table.

Thank you.
-mp

I think there is some issue with your java files. (because mqTxn class need not have a txnId field in it. What it should have is just a reference to txn class)

Your java file should be similar to this

class Txn {
private Long txnId;
}

class MQTxn {
private Long mqTxnId;
private Long vendorId;
private Txn txn;
}

Can you post your java files?

Thanks

Extension to above reply

Then do a save of Txn as

txn.saveUpdate(); // This step generates the txnId

and then

mqTxn.setTxn(txn);
mqTxn.save();

That would solve.

Thanks

Thanks Somu,

What I want is for the MQ_Transaction table to have the same PK that the Transaction table has, withouth explicitly setting it. The Transaction table has a Primary Key generated because I am using a sequence generator. But what about MQ_Transaction? What property should I use for the MQ_Transaction table, so that it can have the same Primary Key that the Transaction table had?

Following is my Transaction.hbn.xml:

Following is my MQ_Transaction.hbn.xml:

Use foreign for MQ_Transaction. I am not aware of the exact syntax though (sorry about that)