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
