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 ?
>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
