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#a13271497
Sent from the Castor - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
