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]
