Sysbase converson pb

[Emmanuel DUPONT <em...@jwaretechnologies.com>]

All,

 

 

I have tried to use FieldConversion pb in order to prevent conversion error
between ; BIGINT/java Long object. The trouble is that I still have the
error below:

 

java.sql.SQLException: JZ0TE: Tentative de conversion non admise entre deux
types. Les types de données admis pour la base sont : 'Double, Float,
BigDecimal, Boolean, Integer, Long, byte[], String'

      at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:534)

      at com.sybase.jdbc2.jdbc.Convert.objectToLongValue(Convert.java:294)

      at com.sybase.jdbc2.jdbc.Convert.objectToInt(Convert.java:137)

      at
com.sybase.jdbc2.jdbc.SybPreparedStatement.setObject(SybPreparedStatement.ja
va:460)

      at
com.sybase.jdbc2.jdbc.SybPreparedStatement.setObject(SybPreparedStatement.ja
va:526)

      at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Pl
atformDefaultImpl.java:227)

      at
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(StatementManag
er.java:449)

      at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImp
l.java:194)

      at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroker
Impl.java:1625)

      at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
.java:1542)

      at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
.java:1493)

      at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi
stenceBroker.java:180)

      at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi
stenceBroker.java:180)

      at
org.apache.ojb.odmg.states.StateNewDirty.commit(StateNewDirty.java:109)

      at
org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(ObjectEnvelopeTab
le.java:201)

      at
org.apache.ojb.odmg.ObjectEnvelopeTable.commit(ObjectEnvelopeTable.java:155)

      at
org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(TransactionImpl.java:3
09)

      at
org.apache.ojb.odmg.TransactionImpl.prepare(TransactionImpl.java:644)

      at
org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:601)

      at

 

 

I do not understand. I have Long java object I convert it to BIGDECIMAL in
my Field conversion class. I also change the BIGINT to NUMERIC. But anyway,
the trouble is there.

 

Any idea please ?