OK, just checked out & rebuilt Castor from CVS, and the tests worked !
Fantastic. This was with HypersonicSQL. I'll try it against Postgres &
Oracle next week.
Unfortunately, it's too late to use in the project I originally intended - I
had to use JDBC when I found the last bug. However, I'll use Castor for
sure next time...
Jon.
-----Original Message-----
From: Thomas Yip [mailto:[EMAIL PROTECTED]]
Sent: 21 September 2001 18:24
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] Newbie question about 1 to many auto loading
problems
Have you try the cvs version?
-----Original Message-----
>From: Jon Barber [mailto:[EMAIL PROTECTED]]
>Sent: Friday, September 21, 2001 5:25 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [castor-dev] Newbie question about 1 to many auto loading
problems
>
>Hi Thomas,
>
>I actually ran the test against HypersonicSQL. I was developing against
>PostgresQL as well, and saw the same problem.
>
>Jon.
>
>On Thursday 20 September 2001 8:25 pm, Thomas Yip wrote:
>> I ran your example, and it worked as expected. It doesn't removal of
object
>> after the loading.
>>
>> The only different is I used oracle, because I don't have mysql.
>>
>> It is run many times and I crosschecked the result in the oracle console.
>>
>>
>>
>> Thomas
>>
>> -----Original Message-----
>> From: Jon Barber [mailto:[EMAIL PROTECTED]]
>>
>> >Sent: Thursday, September 20, 2001 12:07 PM
>> >To: [EMAIL PROTECTED]
>> >Subject: [castor-dev] Newbie question about 1 to many auto loading
>> > problems
>> >
>> >Dear All,
>> >
>> >This is driving me nuts - I must be doing somethin wrong surely ? I'm
>> > just trying to load some objects previously stored to a database, but
I'm
>>
>> finding
>>
>> >that the rows in the second table representing the Vecto elements are
>> >deleted in a most odd way. Surely these rows should be left alone ?
>>
>> Please
>>
>> >help...
>> >
>> >Attached is the database & mapping xml files, which are adapted from the
>> >examples, and below is the relevant methods from VectorTest with sample
>> >output - the behaviour is seen after the second execution, but it
happens
>> >with a more complex program I'm doing with the same behaviour.
>> >
>> >
>> > void populateDB( PrintWriter writer )
>> > throws Exception
>> > {
>> > Database db;
>> > Product product;
>> > ProductDetail detail;
>> >
>> > db = _jdo.getDatabase();
>> >
>> > db.begin();
>> > writer.println( "Begin transaction" );
>> >
>> > product = new Product();
>> > product.setName( "Greenhouse" );
>> > writer.println( "Creating new product: " + product );
>> >
>> > detail = new ProductDetail();
>> > detail.setName("Glass");
>> > product.addDetail(detail);
>> >
>> > detail = new ProductDetail();
>> > detail.setName("Door");
>> > product.addDetail(detail);
>> >
>> >
>> > db.create( product );
>> >
>> >
>> > product = new Product();
>> > product.setName( "Vegetable" );
>> > writer.println( "Creating new product: " + product );
>> >
>> > detail = new ProductDetail();
>> > detail.setName("colour");
>> > product.addDetail(detail);
>> >
>> > detail = new ProductDetail();
>> > detail.setName("shape");
>> > product.addDetail(detail);
>> >
>> > db.create( product );
>> >
>> > writer.println( "Commit transaction" );
>> > db.commit();
>> >
>> > db.close();
>> > }
>> >
>> >
>> >
>> > void queryDB( PrintWriter writer )
>> > throws Exception
>> > {
>> > Database db;
>> > Product product;
>> > ProductDetail detail;
>> > OQLQuery productOql;
>> > QueryResults results;
>> >
>> > db = _jdo.getDatabase();
>> >
>> > db.begin();
>> >
>> > writer.println( "Begin transaction" );
>> >
>> > // Look up the product and if found in the database,
>> > // delete this object from the database
>> > productOql = db.getOQLQuery( "SELECT p FROM test.Product p " );
>> > results = productOql.execute();
>> > while ( results.hasMore() ) {
>> > product = (Product) results.next();
>> > writer.println( "Found this product : " + product );
>> > writer.println(product.getDetails());
>> > }
>> >
>> >
>> > db.commit();
>> >
>> > db.close();
>> > }
>> >
>> >
>> >
>> >
>> >
>> >F:\JBuilder4\jdk1.3\bin\javaw -classpath
>>
>"F:\work\castor\CastorTest\classes;F:\castor-0.9.3src\castor-0.9.3\lib\ser
>> >v
>>
>> l
>>
>>
>et.jar;F:\castor-0.9.3src\castor-0.9.3\lib\jndi_1.2.1.jar;F:\castor-0.9.3s
>> >r
>>
>> c
>>
>>
>\castor-0.9.3\lib\ant1_3.jar;F:\castor-0.9.3src\castor-0.9.3\lib\jakarta-r
>> >e
>>
>> g
>>
>>
>exp-1.1.jar;F:\castor-0.9.3src\castor-0.9.3\lib\xslp_1.1d.jar;F:\castor-0.
>> >9
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
