Hi devs,
changing from 1.2 to 1.3RC1 release of Castor we recognized the following
failure. As I'm out off office at the moment I can not verify this now but will
look into it on friday. In my opinon this would be a critical problem that need
to resolved before 1.3GA.
Regards
Ralf
Hi Ralf,
mit dem neuen Castor-Release 1.3 scheint es noch ein Problem zu geben.
Folgende Abfrage schlägt seit dem Wechsel fehl:
private Date _loadDate;
String oql = "select t from " + RtSord.class.getName() + " t " +
" where t.loadDate=$1";
Query qry = _promisDb.getOQLQuery(oql);
qry.bind(_loadDate);
QueryResults qrs = qry.execute(AccessMode.ReadOnly);
Das sieht dann wie folgt aus:
org.exolab.castor.jdo.PersistenceException: Nested error:
java.sql.SQLException: Ungültiger Spaltentyp while executing SELECT
"RT_SORD"."PARTNAME","RT_SORD"
."LOADDATE","RT_SORD"."ORIGDATEREQD","RT_SORD"."CUSTORDERNUMBER" FROM
"RT_SORD" WHERE ("RT_SORD"."LOADDATE" = ?1): Ungültiger Spaltentyp
at org.exolab.castor.jdo.engine.SQLQuery.execute(SQLQuery.java:218)
at
org.castor.persist.AbstractTransactionContext.query(AbstractTransactionContext.j
ava:679)
at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:503)
at
org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:465)
at
de.jsci.apkon.promis.PromisOrdersHelper.loadRtSord(PromisOrdersHelper.java:242)
at
de.jsci.apkon.promis.PromisOrdersHelper.load(PromisOrdersHelper.java:217)
at
de.jsci.apkon.adas.AbrufeAdapter.synchronize(AbrufeAdapter.java:400)
at
de.jsci.apkon.adas.AbrufeAdapter.synchronize(AbrufeAdapter.java:327)
at de.jsci.apkon.adas.AbrufeAdapter.execute(AbrufeAdapter.java:293)
at de.jsci.cron.CronTask.run(CronTask.java:266)
at de.jsci.cron.CronThread.mainLoop(CronThread.java:138)
at de.jsci.cron.CronThread.run(CronThread.java:81)
Caused by: java.sql.SQLException: Ungültiger Spaltentyp
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at
oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedState
ment.java:9209)
at
oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedState
ment.java:8790)
at
oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedState
ment.java:9512)
at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.jav
a:9495)
at
org.exolab.castor.jdo.engine.SqlBindParser.bindJdbcValues(SqlBindParser.java:261
)
at org.exolab.castor.jdo.engine.SQLQuery.execute(SQLQuery.java:196)
... 11 more
Das zugehörige Mapping sieht so aus:
<class name="de.jsci.apkon.promis.entity.RtSord">
<description>RT_SORD from PROMIS</description>
<cache-type type="none"/>
<map-to table="RT_SORD"/>
<field name="partName" type="string" identity="true">
<sql name="PARTNAME" type="varchar"/>
</field>
<field name="loadDate" type="date" identity="true">
<sql name="LOADDATE" type="date"/>
</field>
<field name="requestDate" type="date" identity="true">
<sql name="ORIGDATEREQD" type="date"/>
</field>
<field name="orderNumberText" type="string">
<sql name="CUSTORDERNUMBER" type="varchar"/>
</field>
</class>
Also, kannst du mir erklären was hier los ist?
Mit freundlichen Grüßen / Best regards
Jens Joachim
- Geschäftsführer / Managing Director -
Syscon Ingenieurbüro für Mess- und Datentechnik GmbH
Raiffeisenstr. 11, D-72127 Kusterdingen
Internet: syscon.eu
E-Mail: [EMAIL PROTECTED]
Tel.: +49 (70 71) 36 90-51
Fax: +49 (70 71) 36 90-98
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
