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 : <!-- Definitions for de.omm.daten.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(JdbcOdbcPreparedStatem ent.java:1194) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatem ent.java:1078) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatemen t(Unknown Source) at org.apache.ojb.broker.platforms.PlatformMsAccessImpl.setObjectForStateme 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.getSequen ce(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUnique Long(Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId( Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueVal 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(JdbcOdbcPreparedStatem ent.java:1194) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatem ent.java:1078) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatemen t(Unknown Source) at org.apache.ojb.broker.platforms.PlatformMsAccessImpl.setObjectForStateme 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.getSequen ce(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUnique Long(Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId( Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueVal 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.getSequen ce(Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUnique Long(Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId( Unknown Source) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueVal 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]