I have some new information.
I coded the result.size() after the first result.next() operation. Now I get
the correct size of the resultset (3 records). But when I code a
result.hasMore() directly after the first result.next() then I get false.
I think this means that the resultset doesn't seem to be scrollable. I
already tried the OQLQueryImpl with the option true, but this also doesn't
work.
Any thoughts ?
BR,
Konni
Konni wrote:
>
> ooopps, the rest of my reply hes been ignored. Here is my mapping file
> again:
>
> <mapping>
> <description>Mapping zur DATEI EDILBEPO</description>
>
> <class name="bestellung.EDILBEPO" identity="AUFN">
> <map-to table="EDILBEPO" />
>
> <field name="FINR" type="big-decimal" >
> <sql name="EPFINR" type="numeric"/>
> </field>
> <field name="AUFN" type="big-decimal" >
> <sql name="EPAUFN" type="numeric"/>
> </field>
> <field name="POS" type="big-decimal" >
> <sql name="EPPOS" type="numeric"/>
> </field>
> <field name="BMENG" type="big-decimal" >
> <sql name="EPBMENG" type="numeric"/>
> </field>
> <field name="WDATU" type="big-decimal" >
> <sql name="EPWDATU" type="numeric"/>
> </field>
> <field name="ARTND" type="string" >
> <sql name="EPARTND" type="char"/>
> </field>
> <field name="BEZGD" type="string" >
> <sql name="EPBEZGD" type="char"/>
> </field>
> <field name="ARTNL" type="string" >
> <sql name="EPARTNL" type="char"/>
> </field>
> <field name="BEZGL" type="string" >
> <sql name="EPBEZGL" type="char"/>
> </field>
> <field name="PTXT" type="string" >
> <sql name="EPPTXT" type="char"/>
> </field>
>
> </class>
>
> </mapping>
>
>
> Konni wrote:
>>
>> Here is my answer:
>>
>> which version of Castor do you use?
>> castor-1.1.2.1
>>
>> which database, database version, driver and driver version do you use?
>> here is my jdo_config.xml with the requested information:
>>
>> <?xml version="1.0"?>
>> <jdo-conf name="Castor JDO Konfiguration">
>>
>> <database name="DENTAL" engine="db2">
>> <driver class-name="com.ibm.as400.access.AS400JDBCDriver"
>> url="jdbc:as400://server/lib">
>> user"/>
>> pwd"/>
>> </driver>
>> <mapping href="Mapping_EDILBEKO.xml"/>
>> <mapping href="Mapping_EDILBEPO.xml"/>
>> </database>
>>
>> <transaction-demarcation mode="local"/>
>> </jdo-conf>
>>
>>
>> do your EDILBEPO class have a identity defined in mapping?
>> here is the mapping:
>>
>> <mapping>
>> <description>Mapping zur DATEI EDILBEPO</description>
>>
>> <class name="bestellung.EDILBEPO" identity="AUFN">
>> <map-to table="EDILBEPO" />
>>
>> <field name="FINR" type="big-decimal" >
>> <sql name="EPFINR" type="numeric"/>
>> </field>
>> <field name="AUFN" type="big-decimal" >
>> <sql name="EPAUFN" type="numeric"/>
>> </field>
>> <field name="POS" type="big-decimal" >
>> <sql name="EPPOS" type="numeric"/>
>> </field>
>> <field name="BMENG" type="big-decimal" >
>> <sql name="EPBMENG" type="numeric"/>
>> </field>
>> <field name="WDATU" type="big-decimal" >
>> <sql name="EPWDATU" type="numeric"/>
>> </field>
>> <field name="ARTND" type="string" >
>> <sql name="EPARTND" type="char"/>
>> </field>
>> <field name="BEZGD" type="string" >
>> <sql name="EPBEZGD" type="char"/>
>> </field>
>> <field name="ARTNL" type="string" >
>> <sql name="EPARTNL" type="char"/>
>> </field>
>> <field name="BEZGL" type="string" >
>> <sql name="EPBEZGL" type="char"/>
>> </field>
>> <field name="PTXT" type="string" >
>> <sql name="EPPTXT" type="char"/>
>> </field>
>>
>> </class>
>>
>> </mapping>
>>
>> do you use Castor caching for EDILBEPO?
>> no
>>
>> does EDILBEPO implement Timestampable interface?
>> no
>>
>>
>>
>> Ralf Joachim-2 wrote:
>>>
>>> Hi Konni,
>>>
>>> I've never seen that problem. Please give us some more info to get an
>>> idea of what may be going wrong.
>>>
>>> which version of Castor do you use?
>>> which database, database version, driver and driver version do you use?
>>> do your EDILBEPO class have a identity defined in mapping?
>>> do you use Castor caching for EDILBEPO?
>>> does EDILBEPO implement Timestampable interface?
>>>
>>> Regards
>>> Ralf
>>>
>>> Konni schrieb:
>>>> I have 3 records with the same FINR and AUFN in my table EDILBEPO. When
>>>> I
>>>> read the resultset, I only get the first record. What could be wrong ?
>>>> The
>>>> result_p.size() ended in a PersistenceException: Cursor not in a valid
>>>> state.
>>>>
>>>> Here is the code:
>>>>
>>>>
>>>> // Positionen verarbeiten
>>>> oql_p = db.getOQLQuery("SELECT P FROM bestellung.EDILBEPO
>>>> P
>>>> WHERE P.FINR=$1 AND P.AUFN=$2");
>>>> oql_p.bind(new BigDecimal(finr));
>>>> oql_p.bind(new BigDecimal(aufnr));
>>>>
>>>> result_p = oql_p.execute();
>>>> // System.out.println("Anzahl Positionen: " +
>>>> result_p.size());
>>>> while (result_p.hasMore()) {
>>>> bepo = (EDILBEPO) result_p.next();
>>>> eppos = bepo.getPOS();
>>>> epbmeng = bepo.getBMENG();
>>>> epwdatu = bepo.getWDATU();
>>>> epartnd = bepo.getARTND();
>>>> epbezgd = bepo.getBEZGD();
>>>> epartnl = bepo.getARTNL();
>>>> epbezgl = bepo.getBEZGL();
>>>> epptxt = bepo.getPTXT();
>>>> .
>>>> .
>>>> .
>>>> }
>>>
>>> --
>>>
>>> Syscon Ingenieurbüro für Meß- und Datentechnik GmbH
>>> Ralf Joachim
>>> Raiffeisenstraße 11
>>> 72127 Kusterdingen
>>> Germany
>>>
>>> Tel. +49 7071 3690 52
>>> Mobil: +49 173 9630135
>>> Fax +49 7071 3690 98
>>>
>>> Internet: www.syscon.eu
>>> E-Mail: [EMAIL PROTECTED]
>>>
>>> Sitz der Gesellschaft: D-72127 Kusterdingen
>>> Registereintrag: Amtsgericht Stuttgart, HRB 382295
>>> Geschäftsleitung: Jens Joachim, Ralf Joachim
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe from this list please visit:
>>>
>>> http://xircles.codehaus.org/manage_email
>>>
>>>
>>>
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Only-one-result-from-resultset-tf4645829.html#a13272196
Sent from the Castor - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
