Hello Castor developers,
I would like to present a strange thing that occures while using the
PostgreSQL 7.1.3 database. My mapping.xml file includes (among other
things):
<class name="nl.london.dsl.jdo.TariffFamilyLiability" identity="id">
<map-to table="tariff_family_liability"/>
<field name="id" type="string">
<sql name="id" type="char"/>
</field>
<field name="tariff" type="big-decimal">
<sql name="tariff" type="decimal"/>
</field>
<field name="lastModified" type="date">
<sql name="last_modified" type="timestamp"/>
</field>
</class>
The problem is in the 'tariff' field. If I use jdbc7.1-1.2.jar I get the
following error:
>org.exolab.castor.jdo.PersistenceException:
>Nested error: Bad BigDecimal 24.50
>Bad BigDecimal 24.50 at
>org.postgresql.jdbc2.ResultSet.getBigDecimal(ResultSet.java:373)
> at >org.postgresql.jdbc2.ResultSet.getBigDecimal(ResultSet.java:949)
> at >org.exolab.castor.jdo.engine.SQLTypes.getObject(SQLTypes.java:319)
> at
>org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadSingleField(SQLEngine.java:1706)
If I use the newer jdbc7.2b1-1.2.jar driver everything works well. The
reason I find this strange is that the Castor docs say that PostgreSQL
7.1 is fully supported. I assume that is PostgreSQL 7.1 with the
corresponding 7.1 JDBC driver, instead of the beta release of the 7.2
driver. Am I missing something here?
Greetx,
Marcel
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
