Hmm, isn't this similar to what we have seen recently with postgreSQL
where postgreSQL internally changed to disable auto-casts during SQL
queries ?
And yes, I am more than happy to not ship 1.3 this week.
Werner
[EMAIL PROTECTED] wrote:
> 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
>
>
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
