I used Hibernate tools to generate db code.
I have a table called Transaction. The reverse engineering created 3 classes:
1. Transaction.java
2. TransactionId.java for my composite key
3. TranasactionHome.java

My question is how can I retrieve my Transaction objects that include all of the primary key data as well?

Right now I can query for objects, but not for primary keys.
I can already persist an object and query for all Transaction objects.

DoI have to query for the keys then use the keys to retrieve the other items? Seems strange if so.

To load your 'Transaction' class by its composite key, you can use:



This will load your Transaction object by its composite id, provided that you supply the necessary key values.

Thanks that helps alot.

How do I select all data including the keys without 1st providing a key?
Currently I can retreive all data without the keys.

: )

I figured it out:
I can get the burried TransactionId, by using transacton.getId().getCompositeKey(getAccountNumber,getAccountId,getFundName,etc..)

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session = sessionFactory.openSession();
//Criteria Query Example
Query q = session.createQuery("from Transaction");
List transactions = q.list();

System.out.println(transactions.size());


for(Iterator it = transactions.iterator();it.hasNext();){
Transaction transaction = (Transaction) it.next();
System.out.println("Cusip: " + transaction.getCusip());
System.out.println("Rep id: " + transaction.getRepid());

//important line....
System.out.println(transaction.getId().getAccountnumber());

}

If it helped, could you rate the post?

Thanks,