Re: [castor-user] Query on 1:n relation does not work as expected

[Axel Mueller]

Werner,
Since I have to get things up and running pretty soon I decided to use
Apache OJB as O/R mapping tool but continue to use Castor XML for XML
binding.
From a previous project I knew that 1:n relations in OJB are working
without problems the way I wouold expect them to work.
Thanks again for the help you offered!
Axel
Werner Guttmann wrote:
Axel,
just looking at your problem right now, but it seems I still need some classes to get this to compiel and run correctly. Here's a list of classes I seem to be 
missing:

com.ibm.rfid.testcontroller.ValueRange
com.ibm.rfid.testcontroller.PersistenceException;
com.ibm.rfid.testcontroller.PersistenceUtil;
com.ibm.rfid.testcontroller.UrlObjectTreeProvider;
com.ibm.rfid.testcontroller.TestcaseException
com.ibm.rfid.testcontroller.TestRun
Thanks for your help. Feel free to send these files to me privately ...
Werner
On Sun, 08 Aug 2004 20:44:03 +0200, Werner Guttmann wrote:
 

Thanks, Axel. I'll let you know about any progress I make ...
Werner
On Sun, 08 Aug 2004 08:25:28 +0200, Axel Mueller wrote:
   

Werner,
Werner Guttmann wrote:
     

Axel,
On Sat, 07 Aug 2004 09:18:47 +0200, Axel Mueller wrote:

       

Werner,
Thanks for your reply! From your post I conclude that there is no 
obvious mistake I made.
  

         

Well, actually, this is not the case. Whilst I have not spotted any mistakes so far, it could equally be that there is ... hence my desire to 'replay' your 
scenario. Speaking of which, could be you please post your Java classes as well ?

       

So there is still hope the Castor rocks but the user doesn't ;-)
Below are the classes (straight forward I would think). You can run the 
Junit test class TestcaseFactoryTest in order to replay the test.

----------------------------------------------------------------------------------------------
package com.ibm.rfid.testcontroller;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.exolab.castor.jdo.Database;
/**
* @author Axel Mueller
*/
public abstract class PersistentObjectFactory {
  private static Log logger = 
LogFactory.getLog(PersistentObjectFactory.class);

  protected ClassLoader classLoader = null;
  protected Database db = null;
  protected boolean useExternalTransaction = false;
  public PersistentObjectFactory(ClassLoader classLoader) {
      this.classLoader = classLoader;
  }
  public void setDatabase(Database db) {
      this.db = db;
      useExternalTransaction = true;
      logger.debug("Using external transaction.");
  }
}
----------------------------------------------------------------------------------------------
package com.ibm.rfid.testcontroller.testcase;
import java.util.Iterator;
import java.util.Vector;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.exolab.castor.jdo.OQLQuery;
import org.exolab.castor.jdo.QueryResults;
import com.ibm.rfid.testcontroller.PersistenceException;
import com.ibm.rfid.testcontroller.PersistenceUtil;
import com.ibm.rfid.testcontroller.PersistentObjectFactory;
import com.ibm.rfid.testcontroller.UrlObjectTreeProvider;
/**
* @author Axel Mueller
*/
public class TestcaseFactory extends PersistentObjectFactory {
private static Log logger = LogFactory.getLog(TestcaseFactory.class);
public TestcaseFactory(ClassLoader classLoader) {
  super(classLoader);
}
public Testcase getTestcase(String urlString) throws TestcaseException {
  return this.getTestcaseFromUrl(urlString);
}
  public Testcase getTestcaseFromDatabase(String urlString) throws 
TestcaseException {
      Testcase testcase = null;
      try {
          if (!useExternalTransaction) {
              db = 
PersistenceUtil.getDatabase(this.getClass().getClassLoader());
              db.begin();
          }
          OQLQuery oql = db.getOQLQuery("SELECT tc FROM 
com.ibm.rfid.testcontroller.testcase.Testcase tc WHERE source = $1");
          oql.bind(urlString);
          QueryResults results = oql.execute();
          logger.debug("Number of testcases: " + results.size());
          while(results.hasMore()) {
               testcase = (Testcase) results.next();
               logger.debug("Number of testcase variables: " + 
testcase.getTestcaseVariables().size());
               Vector variables = testcase.getTestcaseVariables();
               for (Iterator iter = variables.iterator(); 
iter.hasNext(); ) {
                      TestcaseVariable variable = (TestcaseVariable) 
iter.next();
                      logger.debug (variable);
               }
          }
          results.close();
          if (!useExternalTransaction) {
              db.commit();
          }
      }
      catch (Throwable t) {
          throw new TestcaseException(t);
      }
      finally {
          if (!useExternalTransaction) {
              try {
                  db.close();
              }
              catch (org.exolab.castor.jdo.PersistenceException e) {
                  logger.error("Error closing database: ", e);
              }
          }
      }
      return testcase;
  }

----------------------------------------------------------------------------------------------
package com.ibm.rfid.testcontroller.testcase;
import junit.framework.Assert;
import junit.framework.TestCase;
/**
* @author Axel Mueller
*/
public class TestcaseFactoryTest extends TestCase {
/**
 * Constructor for TestcaseTest.
 * @param arg0
 */
public TestcaseFactoryTest(String arg0) {
  super(arg0);
}
  public void testAll() throws Exception {
      String url = "file:///c:/Program 
Files/DeviceDeveloper5.6/workspace/SOMT_TestController/definitions/palettentest.xml";
      TestcaseFactory factory = new 
TestcaseFactory(this.getClass().getClassLoader());
//        Testcase testcase = factory.getTestcaseFromUrl(url);
//        Assert.assertNotNull(testcase);
//
//        factory.writeTestcaseToDatabase(testcase);
     
      Testcase testcase = factory.getTestcaseFromDatabase(url);
      Assert.assertNotNull(testcase);
      Assert.assertEquals(2, testcase.getTestcaseVariables().size());
  }
}

----------------------------------------------------------------------------------------------
package com.ibm.rfid.testcontroller.testcase;
import java.util.Iterator;
import java.util.Vector;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.exolab.castor.jdo.TimeStampable;
import com.ibm.rfid.testcontroller.PersistenceException;
import com.ibm.rfid.testcontroller.TestRun;
/**
* @author Axel Mueller
*/
public class Testcase implements TimeStampable {
private static Log logger = LogFactory.getLog(Testcase.class);
private Integer id;
private String source;
  private String description;
private long timeStamp;
//
// Begin Castor managed relations
//
private Vector testcaseVariables;
private Vector testRuns;
/**
 * @return
 */
public Vector getTestcaseVariables() {
  return this.testcaseVariables;
}
/**
 * @param vector
 */
public void setTestcaseVariables(Vector testcaseVariables) {
  this.testcaseVariables = testcaseVariables;
  if (testcaseVariables != null) {
    Iterator itTestcaseVariables = this.testcaseVariables.iterator();
    while (itTestcaseVariables.hasNext()) {
      TestcaseVariable testcaseVariable = (TestcaseVariable) 
itTestcaseVariables.next();
      testcaseVariable.setTestcase(this);
    }
  }
}

public Vector getTestRuns() {
  return this.testRuns;
}
/**
 * @param vector
 */
public void setTestRuns(Vector testRuns) {
  this.testRuns = testRuns;
  Iterator itTestRuns = this.testRuns.iterator();
  while (itTestRuns.hasNext()) {
    TestRun testRun = (TestRun) itTestRuns.next();
    testRun.setTestcase(this);
  }
}
public TestRun createTestRun() throws PersistenceException {
  TestRun testRun = new TestRun();
  testRun.setTestcase(this);
  if (this.testRuns == null) {
    this.testRuns = new Vector();
  }
  this.testRuns.add(testRun);
  return testRun;
}
//
// End Castor managed relations
//
/**
 * @return
 */
public Integer getId() {
  return this.id;
}
/**
 * @param i
 */
public void setId(Integer id) {
  this.id = id;
}
  /**
   * @return
   */
  public String getSource() {
      return source;
  }
  /**
   * @param string
   */
  public void setSource(String string) {
      source = string;
  }
/**
 * @return
 */
public String getDescription() {
  return description;
}
/**
 * @param string
 */
public void setDescription(String string) {
  description = string;
}
/* (non-Javadoc)
 * @see org.exolab.castor.jdo.TimeStampable#jdoSetTimeStamp(long)
 */
public void jdoSetTimeStamp(long timeStamp) {
  this.timeStamp = timeStamp;
}
/* (non-Javadoc)
 * @see org.exolab.castor.jdo.TimeStampable#jdoGetTimeStamp()
 */
public long jdoGetTimeStamp() {
  return this.timeStamp;
}
  public String toString() {
      return " [ID] " + id + " [SOURCE] " + source + " [DESCRIPTION] " 
+ description;
  }

}
----------------------------------------------------------------------------------------------
package com.ibm.rfid.testcontroller.testcase;
import org.exolab.castor.jdo.TimeStampable;
/**
* @author Axel Mueller
*/
public class TestcaseVariable implements TimeStampable {
  private Integer id;
  private int testcaseId;
  private String label;
  private String description;
  private long timeStamp;
 

  //
  // Begin Castor managed relations
  //
private Testcase testcase;
  private ValueRange valueRange;
  /**
   * @return
   */
  public Testcase getTestcase() {
      return testcase;
  }
  /**
   * @param testcase
   */
  public void setTestcase(Testcase testcase) {
      this.testcase = testcase;
  }
  /**
   * @return
   */
  public ValueRange getValueRange() {
      return this.valueRange;
  }
  /**
   * @param vector
   */
  public void setValueRange(ValueRange valueRange) {
      this.valueRange = valueRange;
      valueRange.setTestcaseVariable(this);
  }
  //
  // End Castor managed relations
  //
  /**
   * @return
   */
  public int getId() {
      return this.id.intValue();
  }
  /**
   * @param i
   */
  public void setId(int id) {
      this.id = new Integer(id);
  }
  /**
   * @return
   */
  public int getTestcaseId() {
      return testcaseId;
  }
  /**
   * @param i
   */
  public void setTestcaseId(int testcaseId) {
      this.testcaseId = testcaseId;
  }
  /**
   * @return
   */
  public String getLabel() {
      return this.label;
  }
  /**
   * @param string
   */
  public void setLabel(String label) {
      this.label = label;
  }
  /**
   * @return
   */
  public String getDescription() {
      return this.description;
  }
  /**
   * @param string
   */
  public void setDescription(String description) {
      this.description = description;
  }
  public String toString() {
          return
                  " [ID] "
              + id
              + " [LABEL]"
              + label
              + " [DESCRIPTION] "
              + description;
      }
  /* (non-Javadoc)
   * @see org.exolab.castor.jdo.TimeStampable#jdoSetTimeStamp(long)
   */
  public void jdoSetTimeStamp(long timeStamp) {
      this.timeStamp = timeStamp;
  }
  /* (non-Javadoc)
   * @see org.exolab.castor.jdo.TimeStampable#jdoGetTimeStamp()
   */
  public long jdoGetTimeStamp() {
      return this.timeStamp;
  }
}
I would be happy if you could provide some hint to solve this problem :-)
Axel

     


       

Isn't this 1:n relation thing a very basic feature for any O/R mapping 
tool? 
  

         

Yes, it is, and it might as well turn out that the mistake is with 'you' ... 
configuration-wise or something else.

       

The only O/R tools I used myself are JBoss EJB 2.0 CMR and Object 
Relation Bridge.
However, I consider Castor a mature tool in this area ...
  

         

So would I, to be honest, despite some minor deficiencies.

       

and would expect 
problems rather on the user side than on the tool side. I choose Castor 
for this project since I need XML binding as well as O/R mapping.

The statements needed to replay the case:
CREATE TABLE `testcase` (
`id` int(10) unsigned NOT NULL default '0',
`source` varchar(255) default NULL,
`description` varchar(255) default NULL,
PRIMARY KEY  (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `testcase`
#
INSERT INTO `testcase` VALUES (1, 'file:///c:/Program 
         

Files/DeviceDeveloper5.6/workspace/SOMT_TestController/definitions/palettentest.xml', 
 

  

         

'Einfluss der Geschwindigkeit des Palettendurchgangs');
       

CREATE TABLE `testcase_variable` (
`id` int(10) unsigned NOT NULL default '0',
`testcase_id` int(10) unsigned NOT NULL default '0',
`label` varchar(20) default NULL,
`description` varchar(255) default NULL,
PRIMARY KEY  (`id`),
KEY `testcase_variable_FKIndex1` (`testcase_id`)
) TYPE=MyISAM;
#
# Dumping data for table `testcase_variable`
#
INSERT INTO `testcase_variable` VALUES (1, 1, 'Geschwindigkeit', 'Palettengeschwindigkeit');
INSERT INTO `testcase_variable` VALUES (2, 1, 'Versuch', 'Versuch');
 

About iteration:  I forgot to mention it in my original post but I was 
surprised to see that results.size() is 2 but only ONE iteration is 
performed using a similar code snipped like below.
After digging around I turned caching off yesterday already (prior my 
post) but the behaviour was still the same.
Anyway - below is the snippet's output you asked for:

2004-08-07 09:01:55,366 DEBUG [main] engine.KeyGeneratorRegistry 
(KeyGeneratorRegistry.java:114) - Key generator MAX has been 
instantiated, parameters: {}
2004-08-07 09:01:55,496 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1221) - Creating class: 
com.ibm.rfid.testcontroller.testcase.Testcase using SQL: INSERT INTO 
testcase (id,source,description) VALUES (?,?,?)
2004-08-07 09:01:55,496 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1229) - Removing class: 
com.ibm.rfid.testcontroller.testcase.Testcase using SQL: DELETE FROM 
testcase WHERE id=?
2004-08-07 09:01:55,496 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1262) - Updating class: 
com.ibm.rfid.testcontroller.testcase.Testcase using SQL: UPDATE testcase 
SET source=?,description=? WHERE id=? AND source=? AND description=?
2004-08-07 09:01:55,506 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1336) - Loading class: 
com.ibm.rfid.testcontroller.testcase.Testcase using SQL: SELECT 
testcase_variable.id,testcase.source,testcase.description FROM testcase 
LEFT OUTER JOIN testcase_variable ON 
testcase.id=testcase_variable.testcase_id WHERE testcase.id=?
2004-08-07 09:01:55,576 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1221) - Creating class: 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable using SQL: INSERT 
INTO testcase_variable (id,testcase_id,label,description) VALUES (?,?,?,?)
2004-08-07 09:01:55,576 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1229) - Removing class: 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable using SQL: DELETE 
  

         

FROM testcase_variable WHERE id=?

       

2004-08-07 09:01:55,576 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1262) - Updating class: 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable using SQL: UPDATE 
testcase_variable SET testcase_id=?,label=?,description=? WHERE id=? AND 
testcase_id=? AND label=? AND description=?
2004-08-07 09:01:55,576 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1336) - Loading class: 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable using SQL: SELECT 
testcase_variable.testcase_id,variable_value_range.id,testcase_variable.label,testcase_variable.description 
  

         

FROM testcase_variable LEFT OUTER JOIN variable_value_range ON 

       

testcase_variable.id=variable_value_range.id WHERE testcase_variable.id=?
2004-08-07 09:01:55,576 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1221) - Creating class: 
com.ibm.rfid.testcontroller.testcase.ValueRange using SQL: INSERT INTO 
variable_value_range 
(id,testcase_variable_id,minValue,maxValue,increment,unit) VALUES 
(?,?,?,?,?,?)
2004-08-07 09:01:55,586 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1229) - Removing class: 
com.ibm.rfid.testcontroller.testcase.ValueRange using SQL: DELETE FROM 
variable_value_range WHERE id=?
2004-08-07 09:01:55,586 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1262) - Updating class: 
com.ibm.rfid.testcontroller.testcase.ValueRange using SQL: UPDATE 
variable_value_range SET 
testcase_variable_id=?,minValue=?,maxValue=?,increment=?,unit=? WHERE 
id=? AND testcase_variable_id=? AND minValue=? AND maxValue=? AND 
increment=? AND unit=?
2004-08-07 09:01:55,586 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1336) - Loading class: 
com.ibm.rfid.testcontroller.testcase.ValueRange using SQL: SELECT 

         

variable_value_range.testcase_variable_id,variable_value_range.minValue,variable_value_range.maxValue,variable_value_range.increment,variable
   

  

         

_value_range.unit 
FROM variable_value_range WHERE variable_value_range.id=?

       

2004-08-07 09:01:55,626 DEBUG [main] cache.CacheFactory 
(CacheFactory.java:128) - Creating cache instance for type none
2004-08-07 09:01:55,636 DEBUG [main] cache.CacheFactory 
(CacheFactory.java:128) - Creating cache instance for type none
2004-08-07 09:01:55,636 DEBUG [main] cache.CacheFactory 
(CacheFactory.java:128) - Creating cache instance for type none
2004-08-07 09:01:55,837 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:384) - Create SQL: SELECT 
testcase.id,testcase_variable.id,testcase.source,testcase.description 
  

         

FROM testcase LEFT OUTER JOIN testcase_variable ON 

       

testcase.id=testcase_variable.testcase_id WHERE (testcase.source = ?)
2004-08-07 09:01:57,099 DEBUG [main] engine.SQLEngine$SQLQuery 
(SQLEngine.java:1699) - jdo.executing
2004-08-07 09:01:57,289 DEBUG [main] testcase.TestcaseFactory 
(TestcaseFactory.java:58) - Number of testcases: 2
2004-08-07 09:01:57,309 DEBUG [main] cache.NoCache (NoCache.java:122) - 
Removing cache entry for key com.ibm.rfid.testcontroller.testcase.Testcase/1
2004-08-07 09:01:57,339 DEBUG [main] cache.NoCache (NoCache.java:122) - 
Removing cache entry for key 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1
2004-08-07 09:01:57,339 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1020) - Loading class: 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable using SQL: SELECT 
testcase_variable.testcase_id,variable_value_range.id,testcase_variable.label,testcase_variable.description 
  

         

FROM testcase_variable LEFT OUTER JOIN variable_value_range ON 

       

testcase_variable.id=variable_value_range.id WHERE testcase_variable.id=?
2004-08-07 09:01:57,369 DEBUG [main] cache.NoCache (NoCache.java:122) - 
Removing cache entry for key 
com.ibm.rfid.testcontroller.testcase.ValueRange/1
2004-08-07 09:01:57,369 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1020) - Loading class: 
com.ibm.rfid.testcontroller.testcase.ValueRange using SQL: SELECT 

         

variable_value_range.testcase_variable_id,variable_value_range.minValue,variable_value_range.maxValue,variable_value_range.increment,variable
   

  

         

_value_range.unit 
FROM variable_value_range WHERE variable_value_range.id=?

       

2004-08-07 09:01:57,399 DEBUG [main] persist.LockEngine 
(LockEngine.java:370) - Loading class: 
com.ibm.rfid.testcontroller.testcase.ValueRange with id: 1
2004-08-07 09:01:57,399 DEBUG [main] persist.LockEngine 
(LockEngine.java:370) - Loading class: 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable with id: 1
2004-08-07 09:01:57,409 DEBUG [main] persist.LockEngine 
(LockEngine.java:370) - Loading class: 
com.ibm.rfid.testcontroller.testcase.Testcase with id: 1
2004-08-07 09:01:57,409 DEBUG [main] testcase.TestcaseFactory 
(TestcaseFactory.java:61) - Number of testcase variables: 1
2004-08-07 09:01:57,409 DEBUG [main] testcase.TestcaseFactory 
(TestcaseFactory.java:65) -  [ID] 1 [LABEL]Geschwindigkeit [DESCRIPTION] 
Palettengeschwindigkeit
2004-08-07 09:01:57,419 DEBUG [main] persist.ObjectLock 
(ObjectLock.java:821) - Release 
com.ibm.rfid.testcontroller.testcase.Testcase/1/0 R/- by 
[EMAIL PROTECTED]
2004-08-07 09:01:57,419 DEBUG [main] cache.NoCache (NoCache.java:93) - 
Creating cache entry for key 
com.ibm.rfid.testcontroller.testcase.Testcase/1 with value 
com.ibm.rfid.testcontroller.testcase.Testcase/1/0 -/-
2004-08-07 09:01:57,419 DEBUG [main] cache.NoCache (NoCache.java:157) - 
Disposing object com.ibm.rfid.testcontroller.testcase.Testcase/1/0 -/-
2004-08-07 09:01:57,419 DEBUG [main] persist.ObjectLock 
(ObjectLock.java:821) - Release 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1/1 R/- by 
[EMAIL PROTECTED]
2004-08-07 09:01:57,429 DEBUG [main] cache.NoCache (NoCache.java:93) - 
Creating cache entry for key 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1 with value 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1/1 -/-
2004-08-07 09:01:57,429 DEBUG [main] cache.NoCache (NoCache.java:157) - 
Disposing object 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1/1 -/-
2004-08-07 09:01:57,429 DEBUG [main] persist.ObjectLock 
(ObjectLock.java:821) - Release 
com.ibm.rfid.testcontroller.testcase.ValueRange/1/2 R/- by 
[EMAIL PROTECTED]
2004-08-07 09:01:57,429 DEBUG [main] cache.NoCache (NoCache.java:93) - 
Creating cache entry for key 
com.ibm.rfid.testcontroller.testcase.ValueRange/1 with value 
com.ibm.rfid.testcontroller.testcase.ValueRange/1/2 -/-
2004-08-07 09:01:57,439 DEBUG [main] cache.NoCache (NoCache.java:157) - 
Disposing object com.ibm.rfid.testcontroller.testcase.ValueRange/1/2 -/-

Still hoping to solve the problem ;-)
Axel
Werner Guttmann wrote:
  

         

Axel,
can you please post the DDL you used to create the testcase and testcase_variable 
tables. I'd like to be able to replay what you've experienced.
Just out of curiosity, if you iterated through all testCaseVariables, do you at least get all of them returned ? Iow, if you changed 

OQLQuery oql = db.getOQLQuery("SELECT tc FROM com.ibm.rfid.testcontroller.testcase.Testcase 
tc WHERE source = $1");
oql.bind(urlString);
QueryResults results = oql.execute();
logger.debug("Number of testcases: " + results.size());
while(results.hasMore()) {
testcase = (Testcase) results.next();
logger.debug("Number of testcase variables: " + 
testcase.getTestcaseVariables().size());
Vector variables = testcase.getTestCaseVariables();
for (Iterator iter = variables.iterator(); iter.hasNext(); ) {
   TestCaseVariable variable = (TestCaseVariable) iter.next();
   logger.debug (variable);
}
}
what's the output ?
Werner
On Fri, 06 Aug 2004 18:20:54 +0200, Axel Mueller wrote:

    

           

Hi,
For two tables "testcase" (class Testcase) and "testcase_variable" 
(class TestcaseVariable) I have defined a 1:n relation and perform a 
OQLQuery on the "1" side of that relation (which is Testcase).
Table "testcase" contains only one row whereas the table 
"testcase_variables" contains 2 rows whose foreign key matches the 
primary key of the row in "testcase":

mysql> select id from testcase;
+----+
| id |
+----+
|  1 |
+----+
1 row in set (0.00 sec)
mysql> select * from testcase_variable;
+----+-------------+-----------------+-------------------------+
| id | testcase_id | label           | description             |
+----+-------------+-----------------+-------------------------+
|  1 |           1 | Geschwindigkeit | Palettengeschwindigkeit |
|  2 |           1 | Versuch         | Versuch                 |
+----+-------------+-----------------+-------------------------+
I would expect the query below to return ONE Testcase object and the 
testcase object to contain TWO TestcaseVariable objects.
Actually  results.size() returns 2 and 
testcase.getTestcaseVariables().size() returns 1 - exactly the opposite 
of what I would have expected.
What am I doing wrong??? I found some examples of 1:n relations but I'm 
doing the query the same way the do using the same kind of mapping to 
express the 1:n relation.

        OQLQuery oql = db.getOQLQuery("SELECT tc FROM 
com.ibm.rfid.testcontroller.testcase.Testcase tc WHERE source = $1");
        oql.bind(urlString);
        QueryResults results = oql.execute();
        logger.debug("Number of testcases: " + results.size());
        while(results.hasMore()) {
            testcase = (Testcase) results.next();
            logger.debug("Number of testcase variables: " + 
testcase.getTestcaseVariables().size());
        }

The relevant section of the mapping descriptor looks like this:
<class name="com.ibm.rfid.testcontroller.testcase.Testcase" 
identity="id" key-generator="MAX">
    <cache-type type="none"/>
    <map-to table="testcase" xml="testcase"/>
    <field name="testcaseVariables" 
type="com.ibm.rfid.testcontroller.testcase.TestcaseVariable" 
collection="vector">
        <sql many-key="testcase_id"/>
        <bind-xml name="testcase-variable" node="element"/>
    </field>
    <!-- field name="testRuns" 
type="com.ibm.rfid.testcontroller.TestRun" collection="vector">
        <sql many-key="testcase_id"/>
        <bind-xml name="testcase-run" node="element"/>
    </field -->
    <field name="id">
        <sql name="id"/>
        <bind-xml name="id" node="attribute"/>
    </field>
    <field name="source">
        <sql name="source"/>
        <bind-xml name="source" node="attribute"/>
    </field>
    <field name="description">
        <sql name="description"/>
        <bind-xml name="description" node="attribute"/>
    </field>
</class>

<class name="com.ibm.rfid.testcontroller.testcase.TestcaseVariable" 
identity="id" key-generator="MAX">
    <cache-type type="none"/>
    <map-to table="testcase_variable" xml="testcase-variable"/>
    <field name="testcase" 
type="com.ibm.rfid.testcontroller.testcase.Testcase">
        <sql name="testcase_id" />
        <bind-xml name="testcase-id" node="element" reference="true"/>
    </field>
    <field name="valueRange" 
type="com.ibm.rfid.testcontroller.testcase.ValueRange">
        <bind-xml name="value-range" node="element"/>
    </field>
    <field name="id">
        <sql name="id"/>
        <bind-xml name="id" node="attribute"/>
    </field>
    <field name="label">
        <sql name="label"/>
        <bind-xml name="label" node="attribute"/>
    </field>
    <field name="description">
        <sql name="description"/>
        <bind-xml name="description" node="attribute"/>
    </field>
</class>


Below is the logging of the query code snipped above:
2004-08-06 17:38:30,989 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:384) - Create SQL: SELECT 
testcase.id,testcase_variable.id,testcase.source,testcase.description 
 

      

             

FROM testcase LEFT OUTER JOIN testcase_variable ON 

    

           

testcase.id=testcase_variable.testcase_id WHERE (testcase.source = ?)
2004-08-06 17:38:31,380 DEBUG [main] engine.SQLEngine$SQLQuery 
(SQLEngine.java:1699) - jdo.executing
2004-08-06 17:38:31,410 DEBUG [main] testcase.TestcaseFactory 
(TestcaseFactory.java:57) - Number of testcases: 2
2004-08-06 17:38:31,420 DEBUG [main] cache.NoCache (NoCache.java:122) - 
Removing cache entry for key com.ibm.rfid.testcontroller.testcase.Testcase/1
2004-08-06 17:38:31,450 DEBUG [main] cache.NoCache (NoCache.java:122) - 
Removing cache entry for key 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1
2004-08-06 17:38:31,450 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1020) - Loading class: 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable using SQL: SELECT 
testcase_variable.testcase_id,variable_value_range.id,testcase_variable.label,testcase_variable.description 
 

      

             

FROM testcase_variable LEFT OUTER JOIN variable_value_range ON 

    

           

testcase_variable.id=variable_value_range.id WHERE testcase_variable.id=?
2004-08-06 17:38:31,460 DEBUG [main] cache.NoCache (NoCache.java:122) - 
Removing cache entry for key 
com.ibm.rfid.testcontroller.testcase.ValueRange/1
2004-08-06 17:38:31,460 DEBUG [main] engine.SQLEngine 
(SQLEngine.java:1020) - Loading class: 
com.ibm.rfid.testcontroller.testcase.ValueRange using SQL: SELECT 

      

             

variable_value_range.testcase_variable_id,variable_value_range.minValue,variable_value_range.maxValue,variable_value_range.increment,variable
   


       

 

      

             

_value_range.unit 
FROM variable_value_range WHERE variable_value_range.id=?

    

           

2004-08-06 17:38:31,470 DEBUG [main] persist.LockEngine 
(LockEngine.java:370) - Loading class: 
com.ibm.rfid.testcontroller.testcase.ValueRange with id: 1
2004-08-06 17:38:31,470 DEBUG [main] persist.LockEngine 
(LockEngine.java:370) - Loading class: 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable with id: 1
2004-08-06 17:38:31,470 DEBUG [main] persist.LockEngine 
(LockEngine.java:370) - Loading class: 
com.ibm.rfid.testcontroller.testcase.Testcase with id: 1
2004-08-06 17:38:31,490 DEBUG [main] testcase.TestcaseFactory 
(TestcaseFactory.java:60) - Number of testcase variables: 1
2004-08-06 17:38:31,500 DEBUG [main] persist.ObjectLock 
(ObjectLock.java:821) - Release 
com.ibm.rfid.testcontroller.testcase.Testcase/1/0 R/- by 
[EMAIL PROTECTED]
2004-08-06 17:38:31,500 DEBUG [main] cache.NoCache (NoCache.java:93) - 
Creating cache entry for key 
com.ibm.rfid.testcontroller.testcase.Testcase/1 with value 
com.ibm.rfid.testcontroller.testcase.Testcase/1/0 -/-
2004-08-06 17:38:31,510 DEBUG [main] cache.NoCache (NoCache.java:157) - 
Disposing object com.ibm.rfid.testcontroller.testcase.Testcase/1/0 -/-
2004-08-06 17:38:31,510 DEBUG [main] persist.ObjectLock 
(ObjectLock.java:821) - Release 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1/1 R/- by 
[EMAIL PROTECTED]
2004-08-06 17:38:31,510 DEBUG [main] cache.NoCache (NoCache.java:93) - 
Creating cache entry for key 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1 with value 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1/1 -/-
2004-08-06 17:38:31,520 DEBUG [main] cache.NoCache (NoCache.java:157) - 
Disposing object 
com.ibm.rfid.testcontroller.testcase.TestcaseVariable/1/1 -/-
2004-08-06 17:38:31,520 DEBUG [main] persist.ObjectLock 
(ObjectLock.java:821) - Release 
com.ibm.rfid.testcontroller.testcase.ValueRange/1/2 R/- by 
[EMAIL PROTECTED]
2004-08-06 17:38:31,520 DEBUG [main] cache.NoCache (NoCache.java:93) - 
Creating cache entry for key 
com.ibm.rfid.testcontroller.testcase.ValueRange/1 with value 
com.ibm.rfid.testcontroller.testcase.ValueRange/1/2 -/-
2004-08-06 17:38:31,520 DEBUG [main] cache.NoCache (NoCache.java:157) - 
Disposing object com.ibm.rfid.testcontroller.testcase.ValueRange/1/2 -/-


----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
    unsubscribe castor-user

 

      

             

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
     unsubscribe castor-user


    

           

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
     unsubscribe castor-user

  

         

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
      unsubscribe castor-user


       

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
      unsubscribe castor-user

     

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
      unsubscribe castor-user

   


----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
       unsubscribe castor-user

 


----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
       unsubscribe castor-user