Re: One more Problem

Brian McCallister Tue, 14 Oct 2003 12:49:53 -0700

First suggestion is to use an Integer instead of an int as your primary key.

Second, what type of database are you using? As it looks like the ODBC bridge I am going to guess MS SQL. I have never worked with that myself, but what is the bit length of a default INTEGER in MS SQL? It looks like it is conflicting on a Long (64 bit) to Integer (32 bit) conversion.

-Brian

On Tuesday, October 14, 2003, at 03:35 PM, Alireza Salemi wrote:

Hi,
I have a problem with following exception. I don't know what is going
wrong.
I have a class named Adresse look like this :
...
    private int adresseId; // Primary Key of the table Adresse
    private String adressname;
    private String postleitzahl;
...
repository_user.xml of adresse :

<class-descriptor class="de.omm.daten.Adresse" proxy="dynamic"
table="Adresse" >
<field-descriptor name="adresseId"  column="adresseId"
jdbc-type="INTEGER"  primarykey="true"  autoincrement="true" />
<field-descriptor name="adressname"  column="adressname"
jdbc-type="VARCHAR" />
<field-descriptor name="postleitzahl"  column="postleitzahl"
jdbc-type="VARCHAR" />
...
</class-descriptor>
And the table :
CREATE TABLE `Adresse`
(
`adresseId` INTEGER PRIMARY KEY ,
`adressname` VARCHAR(50),
`postleitzahl` VARCHAR(50),
...)
Could ypu please help me?

Thanx

Alireza
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the insert (for a
org.apache.ojb.broker.util.sequence.HighLowSequence): Object type and
JDBC SQL type mismatch. java.lang.Long
Object type and JDBC SQL type mismatch. java.lang.Long

java.sql.SQLException: Object type and JDBC SQL type mismatch. java.lang.Long at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedState m ent.java:1194) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedState m ent.java:1078) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStateme n t(Unknown Source) at org.apache.ojb.broker.platforms.PlatformMsAccessImpl.setObjectForStatem e nt(Unknown Source) at org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSeque n ce(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqu e Long(Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId ( Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueVa l ue(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source) at org.apache.ojb.broker.Identity.init(Unknown Source) at org.apache.ojb.broker.Identity.<init>(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at de.omm.start.TestOjb.createData(TestOjb.java:32) at de.omm.start.TestOjb.<init>(TestOjb.java:18) at de.omm.start.TestOjb.main(TestOjb.java:23) java.sql.SQLException: Object type and JDBC SQL type mismatch. java.lang.Long at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedState m ent.java:1194) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedState m ent.java:1078) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStateme n t(Unknown Source) at org.apache.ojb.broker.platforms.PlatformMsAccessImpl.setObjectForStatem e nt(Unknown Source) at org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSeque n ce(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqu e Long(Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId ( Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueVa l ue(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source) at org.apache.ojb.broker.Identity.init(Unknown Source) at org.apache.ojb.broker.Identity.<init>(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at de.omm.start.TestOjb.createData(TestOjb.java:32) at de.omm.start.TestOjb.<init>(TestOjb.java:18) at de.omm.start.TestOjb.main(TestOjb.java:23) rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: Object type and JDBC SQL type mismatch. java.lang.Long at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSeque n ce(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqu e Long(Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId ( Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueVa l ue(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(Unknown Source) at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source) at org.apache.ojb.broker.Identity.init(Unknown Source) at org.apache.ojb.broker.Identity.<init>(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at de.omm.start.TestOjb.createData(TestOjb.java:32) at de.omm.start.TestOjb.<init>(TestOjb.java:18) at de.omm.start.TestOjb.main(TestOjb.java:23) rethrown as org.apache.ojb.broker.metadata.ClassNotPersistenceCapableException: Could not init Identity for given object class e.omm.daten.Adresse: Object type and JDBC SQL type mismatch. java.lang.Long at org.apache.ojb.broker.Identity.init(Unknown Source) at org.apache.ojb.broker.Identity.<init>(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at de.omm.start.TestOjb.createData(TestOjb.java:32) at de.omm.start.TestOjb.<init>(TestOjb.java:18) at de.omm.start.TestOjb.main(TestOjb.java:23) Exception in thread "main"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: One more Problem

Reply via email to