Hi guys,
I'm getting this exception and really I don't know how to do:
Code:
DEBUG [JDBCExceptionReporter] could not execute query [select verstorben0_.kvnr as kvnr4_, verstorben0_.VERS_ID as VERS2_4_, ve
rstorben0_.TOD_KZ as TOD3_4_, verstorben0_.TODESTAG as TODESTAG4_ from AP_VERSTORBENE verstorben0_ where verstorben0_.VERS_ID=?]
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:595)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1600)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:322)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:280)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:137)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
at org.hibernate.loader.Loader.doList(Loader.java:2147)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
at org.hibernate.loader.Loader.list(Loader.java:2021)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:296)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:992)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:837)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:828)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:824)
at de.medent.dao.ErgebnisListenDAOImp.getDeathDay(ErgebnisListenDAOImp.java:153)
at de.medent.delegate.ErgebnisDelegate.getDeathDay(ErgebnisDelegate.java:123)
at de.medent.controller.ErgebnisController.getDeathDay(ErgebnisController.java:147)
at de.medent.controller.ErgebnisController.writeAPVSTFile(ErgebnisController.java:454)
at de.medent.controller.ErgebnisController.start(ErgebnisController.java:190)
at de.medent.ClientMain.LoginFrame.CheckConnect(LoginFrame.java:219)
at de.medent.ClientMain.LoginFrame.access$0(LoginFrame.java:199)
at de.medent.ClientMain.LoginFrame$2.keyPressed(LoginFrame.java:169)
at java.awt.Component.processKeyEvent(Component.java:5446)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2713)
at java.awt.Component.processEvent(Component.java:5265)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1810)
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:672)
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:920)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:798)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:636)
at java.awt.Component.dispatchEventImpl(Component.java:3841)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
05:45:54,835 WARN [JDBCExceptionReporter] SQL Error: 932, SQLState: 42000
05:45:54,835 ERROR [JDBCExceptionReporter] ORA-00932: inconsistent datatypes: expected NUMBER got BINARY
this is the table schema:
Column Name.....ID.......Pk.....Null?....Data Type
KVNR..................1.........1.......N........VARCHAR2 (12 Byte)
TOD_KZ..............2..................N........NUMBER
TODESTAG..........3..................Y........DATE
VERS_ID.............4..................Y........NUMBER (8)
this this pojo class:
Code:
public class VerstorbeneBO implements Serializable {
/** Field kvnr of type String. */
private String mKvnr;
/** Field tod_kz of type int. */
private Integer mTod_kz;
/** Field todestag of type Date. */
private Date mTodestag;
/** Field mVersID of type long. */
private Long mVersID;
/**
* Default constructor for VerstorbeneBO.class.
*/
public VerstorbeneBO() {
}
/**
* Gets the VersID.
*
* @return Returns the VersID.
*
* @hibernate.property column="VERS_ID" type = "java.lang.Long"
*/
public Long getVersID() {
return mVersID;
}
/**
* Gets this.Kvnr.
*
* @hibernate.id column = "kvnr" type = "java.lang.String"
* generator-class="assigned"
* @return this.Kvnr.
*/
public String getKvnr() {
return mKvnr;
}
/**
* Gets the tod_kz.
*
* @return Returns the mTod_kz.
*
* @hibernate.property column="TOD_KZ" type = "java.lang.Integer"
*/
public Integer getTod_kz() {
return mTod_kz;
}
/**
* Gets the todestag.
*
* @return Returns the mTodestag.
*
* @hibernate.property column="TODESTAG" type = "java.util.Date"
*/
public Date getTodestag() {
return mTodestag;
}
/**
* Sets the kvnr.
*
* @param pKvnr The kvnr to set.
*/
public void setKvnr(String pKvnr) {
this.mKvnr = pKvnr;
}
/**
* Sets the tod_kz.
*
* @param pTod_kz The tod_kz to set.
*/
public void setTod_kz(Integer pTod_kz) {
this.mTod_kz = pTod_kz;
}
/**
* Sets the todestag.
*
* @param pTodestag The todestag to set.
*/
public void setTodestag(Date pTodestag) {
this.mTodestag = pTodestag;
}
/**
* Sets this.VersID to pVersID.
*
* @param pVersID of type VersID.
*/
public void setVersID(Long pVersID) {
mVersID = pVersID;
}
}
The Mapping File:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping
>
<class
name="de.medent.pojo.VerstorbeneBO"
table="AP_VERSTORBENE"
>
<id
name="kvnr"
column="kvnr"
type="java.lang.String"
>
<generator class="assigned">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-VerstorbeneBO.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>
<property
name="versID"
type="java.lang.Long"
update="true"
insert="true"
column="VERS_ID"
/>
<property
name="tod_kz"
type="java.lang.Integer"
update="true"
insert="true"
column="TOD_KZ"
/>
<property
name="todestag"
type="java.util.Date"
update="true"
insert="true"
column="TODESTAG"
/>
<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-VerstorbeneBO.xml
containing the additional properties and place it in your merge dir.
-->
</class>
<query name="getDeathDay"><![CDATA[
SELECT v FROM VerstorbeneBO as v WHERE v.versID = ?
]]></query>
</hibernate-mapping>
This is the query
SELECT v FROM VerstorbeneBO as v WHERE v.versID = ?
By the way I'm using spring framework
Login
FAQ
Search