Exception: java.lang.Integer vs BINARY.

[Barry Nauta]

Hi,

I had to take over a project written by someone else and stumble into a few problems. The application is a web front-end to a db using jtds and Hibernate.

I receive the following error message:
Unable to convert between java.lang.Integer and BINARY.

I let HIbernate print the queries it executes and when I perform this query manually, I receive data. My guess is that there is some mapping problem ;-), but I cannot figure out whether this is hibernate of jtds related.

Any input is much appreciated.

Here is my stacktrace:

net.sf.hibernate.exception.GenericJDBCException: Unable to perform find at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80) at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3663)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at be.switchsoft.hg.service.provider.AdviceSearchProvider.process(AdviceSearchProvider.java:99) at be.switchsoft.hg.service.ServiceBroker.process(ServiceBroker.java:137)
at be.switchsoft.hg.struts.action.ListAdvicesAction.execute(ListAdvicesAction.java:98) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Unable to convert between java.lang.Integer and BINARY. at net.sourceforge.jtds.jdbc.Support.convert(Support.java:565)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getBytes(JtdsResultSet.java:729) at net.sourceforge.jtds.jdbc.JtdsResultSet.getBytes(JtdsResultSet.java:1000)
at net.sf.hibernate.type.BinaryType.get(BinaryType.java:63)
at net.sf.hibernate.type.SerializableType.get(SerializableType.java:33)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67)
at net.sf.hibernate.loader.Loader.hydrate(Loader.java:690)
at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631)
at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590)
at net.sf.hibernate.loader.Loader.getRow(Loader.java:505)
at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:285)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3660)
... 25 more

Additionally, here is my hibernate config file for advices:

<hibernate-mapping auto-import="false">
<class name="be.switchsoft.hg.persistence.Advice"
table="tb_hg_advice">

    <id name="adviceID" type="java.lang.Long"
        column="pk_hg_advice">
        <generator class="native" />
    </id>

    <property name="requestDate" type="date" column="requestdate"
        not-null="true" />

    <property name="newMsdsInfo" type="java.lang.String"
        column="newmsdsinfo" not-null="false" length="255"/>

    <property name="avgUsage" type="java.lang.Integer" column="avgusage"
        not-null="true" />

    <property name="maxStorage" type="java.lang.Integer" column="maxstorage"
        not-null="true" />

    <property name="packaging" type="text"
        column="packaging" not-null="true"/>

    <property name="commentRequester" type="text"
        column="commentrequester" not-null="false"/>

    <property name="commentApprover" type="text"
        column="commentapprover" not-null="false"/>

    <property name="checkHS"
        type="be.switchsoft.hg.persistence.helper.Progress" column="checkhs"
        not-null="true" />

    <property name="checkFES"
        type="be.switchsoft.hg.persistence.helper.Progress" column="checkfes"
        not-null="true" />

    <property name="checkENV"
        type="be.switchsoft.hg.persistence.helper.Progress" column="checkenv"
        not-null="true" />

    <property name="approvalDate" type="date" column="approvaldate"
        not-null="false" />

    <property name="inStockDate" type="date" column="instockdate"
        not-null="false" />

    <property name="outStockDate" type="date" column="outstockdate"
        not-null="false" />

    <property name="locationDescription" type="java.lang.String"
        column="locationdescription" not-null="false" length="255" />

    <property name="purposeDetail" type="java.lang.String"
        column="purposedetail" not-null="false" length="255" />

    <many-to-one name="role" class="be.switchsoft.hg.persistence.Group"
        column="fk_hg_role" not-null="true"/>

    <property name="closeExtend"
        type="be.switchsoft.hg.persistence.helper.Extended"
        column="closeextend" not-null="true" />

    <property name="closeExtendDate" type="date"
        column="closeextenddate" not-null="false" />

    <many-to-one name="hazardousGood" column="fk_hg_hazardousgoodid"
        class="be.switchsoft.hg.persistence.HazardousGood"
        cascade="none" />

    <many-to-one name="supplier" column="fk_hg_supplierid"
        class="be.switchsoft.hg.persistence.Supplier" cascade="none" />

    <many-to-one name="location" column="fk_hg_locationid"
        class="be.switchsoft.hg.persistence.Location" cascade="save-update" />

    <list name="contacts" inverse="false" cascade="all">
        <key column="fk_hg_advice"/>
        <index column="nr"/>
        <one-to-many class="be.switchsoft.hg.persistence.Contact"/>
    </list>

    <many-to-one name="department" column="fk_hg_departmentid"
        class="be.switchsoft.hg.persistence.Department"
        cascade="save-update" />

    <many-to-one name="purpose" column="fk_hg_purposeid"
        class="be.switchsoft.hg.persistence.Purpose" cascade="none" />

</class>

</hibernate-mapping>

Thanks!!!