Object model:
MyOrder is a class that has a field of type OrderLine (as a collection).
I saved two MyOrder objects into a database.
order1 references 2 OrderLine objects.
order2 references 3 OrderLine objects.
If I select all MyOrder objects, the OrderLine objects of the order2 are
always removed from the data base when do transaction commit(even I do give
MyOrder
objects permanent references). Do I have any way to avoid this?
Thanks very much in advance!
java code:
--------------------------------------------------------------
public void run( PrintWriter writer)
throws Exception
{
Database db;
OQLQuery orderOql;
QueryResults results;
System.out.println(".....get database");
db = _jdo.getDatabase();
Vector outOrders = new Vector();
Vector ols = new Vector();
db.begin();
int k=0;
orderOql = db.getOQLQuery( "SELECT o FROM
com.MyOrder o");
results = orderOql.execute();
while ( results.hasMore() ) {
k++;
System.out.println( ".......add order(" + k
+ ")");
outOrders.add((MyOrder) results.next());
}
results.close();
orderOql.close();
System.out.println(".....do commit");
db.commit();
db.close();
}
output
---------------------------------------------------------------------
.....get database
[test] SELECT
"ORDERS"."ID","ORDERS"."NAME","ORDERS"."CUSTOMER","ORDER_LINE"."ID" FROM
"ORDER_LINE","ORDERS" WHERE "ORDERS"."ID"="ORDER_LINE"."ORDER_ID"(+)
[test] Castor: Loading com.Customer (101)
[test] Castor: Loading com.OrderLine (1)
[test] Castor: Loading com.OrderLine (2)
[test] Castor: Loading com.MyOrder (1)
.......add order(1)
[test] Castor: Loading com.Customer (202)
[test] Castor: Loading com.OrderLine (3)
[test] Castor: Loading com.OrderLine (4)
[test] Castor: Loading com.OrderLine (5)
[test] Castor: Loading com.MyOrder (2)
.......add order(2)
.....do commit
[test] Castor: Removing com.OrderLine (3)****why removed?
[test] Castor: Removing com.OrderLine (4)****why removed?
[test] Castor: Removing com.OrderLine (5)****why removed?
Notes:
If I have 4 orders, the orderLines of the 4th order will be removed!
-----------------------------------------------------------------------
Ping Ding
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
