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