Could this actually be a problem of the JDBC driver for DB2 on AS400 ?
What version of the JDBC driver are you using for DB2, and what version
of the JDBC spec does it actually implement ?
Werner
Konni wrote:
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
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
