When we try to do a simple native SQL query using hibernate we are getting the following error.
The field that we are returning is not a Date or timestamp so is there something that we are doing wrong?
A google search and a search of this forum did not find any other postings with this error.
Thank you,
David
b]Hibernate version:[/b] 2.1.8
Mapping documents:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1
http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->
<class
name="com.relevant.util.dao.Ona"
table="ona"
>
<meta attribute="class-description" inherit="false">
@hibernate.class
table="ona"
</meta>
<composite-id>
<meta attribute="field-description" inherit="false">
@hibernate.id
generator-class="assigned"
</meta>
<key-property
name="ona_div"
column="ona_div"
type="java.lang.String"
length="2"
>
<meta attribute="field-description">
@hibernate.property
column="ona_div"
length="2"
</meta>
</key-property>
<key-property
name="ona_orderno"
column="ona_orderno"
type="java.lang.String"
length="8"
>
<meta attribute="field-description">
@hibernate.property
column="ona_orderno"
length="8"
</meta>
</key-property>
</composite-id>
<property
name="ona_otype"
type="com.relevant.util.hibernate.StringType"
column="ona_otype"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_otype"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_ostats"
type="com.relevant.util.hibernate.StringType"
column="ona_ostats"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ostats"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_orddte"
type="java.sql.Timestamp"
column="ona_orddte"
length="23"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_orddte"
length="23"
</meta>
</property>
<property
name="ona_oterms"
type="com.relevant.util.hibernate.StringType"
column="ona_oterms"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_oterms"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_spersn"
type="com.relevant.util.hibernate.StringType"
column="ona_spersn"
not-null="true"
length="3"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_spersn"
length="3"
not-null="true"
</meta>
</property>
<property
name="ona_cust"
type="com.relevant.util.hibernate.StringType"
column="ona_cust"
not-null="true"
length="9"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_cust"
length="9"
not-null="true"
</meta>
</property>
<property
name="ona_oclass"
type="com.relevant.util.hibernate.StringType"
column="ona_oclass"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_oclass"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_cclass"
type="com.relevant.util.hibernate.StringType"
column="ona_cclass"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_cclass"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_canrsn"
type="com.relevant.util.hibernate.StringType"
column="ona_canrsn"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_canrsn"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_candte"
type="java.sql.Timestamp"
column="ona_candte"
length="23"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_candte"
length="23"
</meta>
</property>
<property
name="ona_prtflg"
type="com.relevant.util.hibernate.StringType"
column="ona_prtflg"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_prtflg"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_resp"
type="com.relevant.util.hibernate.StringType"
column="ona_resp"
not-null="true"
length="3"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_resp"
length="3"
not-null="true"
</meta>
</property>
<property
name="ona_bcno"
type="long"
column="ona_bcno"
not-null="true"
length="16"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_bcno"
length="16"
not-null="true"
</meta>
</property>
<property
name="ona_billto"
type="com.relevant.util.hibernate.StringType"
column="ona_billto"
not-null="true"
length="9"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_billto"
length="9"
not-null="true"
</meta>
</property>
<property
name="ona_bsite"
type="com.relevant.util.hibernate.StringType"
column="ona_bsite"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_bsite"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_scno"
type="long"
column="ona_scno"
not-null="true"
length="16"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_scno"
length="16"
not-null="true"
</meta>
</property>
<property
name="ona_shipto"
type="com.relevant.util.hibernate.StringType"
column="ona_shipto"
not-null="true"
length="9"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_shipto"
length="9"
not-null="true"
</meta>
</property>
<property
name="ona_ssite"
type="com.relevant.util.hibernate.StringType"
column="ona_ssite"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ssite"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_agreeno"
type="com.relevant.util.hibernate.StringType"
column="ona_agreeno"
not-null="true"
length="15"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_agreeno"
length="15"
not-null="true"
</meta>
</property>
<property
name="ona_refno"
type="com.relevant.util.hibernate.StringType"
column="ona_refno"
not-null="true"
length="15"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_refno"
length="15"
not-null="true"
</meta>
</property>
<property
name="ona_ackpnt"
type="com.relevant.util.hibernate.StringType"
column="ona_ackpnt"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ackpnt"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_ackdte"
type="java.sql.Timestamp"
column="ona_ackdte"
length="23"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ackdte"
length="23"
</meta>
</property>
<property
name="ona_lmdte"
type="java.sql.Timestamp"
column="ona_lmdte"
length="23"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_lmdte"
length="23"
</meta>
</property>
<property
name="ona_msgno"
type="com.relevant.util.hibernate.IntType"
column="ona_msgno"
not-null="true"
length="10"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_msgno"
length="10"
not-null="true"
</meta>
</property>
<property
name="ona_nme"
type="com.relevant.util.hibernate.StringType"
column="ona_nme"
not-null="true"
length="25"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_nme"
length="25"
not-null="true"
</meta>
</property>
<property
name="ona_fob"
type="com.relevant.util.hibernate.StringType"
column="ona_fob"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_fob"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_carier"
type="com.relevant.util.hibernate.StringType"
column="ona_carier"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_carier"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_txemp"
type="com.relevant.util.hibernate.StringType"
column="ona_txemp"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_txemp"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_taxloc"
type="com.relevant.util.hibernate.StringType"
column="ona_taxloc"
not-null="true"
length="6"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_taxloc"
length="6"
not-null="true"
</meta>
</property>
<property
name="ona_ovrbt"
type="com.relevant.util.hibernate.StringType"
column="ona_ovrbt"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ovrbt"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_ovrst"
type="com.relevant.util.hibernate.StringType"
column="ona_ovrst"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ovrst"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_region"
type="com.relevant.util.hibernate.StringType"
column="ona_region"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_region"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_ftype"
type="com.relevant.util.hibernate.StringType"
column="ona_ftype"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ftype"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_credrsp"
type="com.relevant.util.hibernate.StringType"
column="ona_credrsp"
not-null="true"
length="3"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_credrsp"
length="3"
not-null="true"
</meta>
</property>
<property
name="ona_imsgno"
type="short"
column="ona_imsgno"
not-null="true"
length="5"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_imsgno"
length="5"
not-null="true"
</meta>
</property>
<property
name="ona_disc"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_disc"
not-null="true"
length="18"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_disc"
length="18"
not-null="true"
</meta>
</property>
<property
name="ona_ordamt"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_ordamt"
not-null="true"
length="18"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ordamt"
length="18"
not-null="true"
</meta>
</property>
<property
name="ona_bseqno"
type="short"
column="ona_bseqno"
not-null="true"
length="5"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_bseqno"
length="5"
not-null="true"
</meta>
</property>
<property
name="ona_sseqno"
type="short"
column="ona_sseqno"
not-null="true"
length="5"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_sseqno"
length="5"
not-null="true"
</meta>
</property>
<property
name="ona_projno"
type="com.relevant.util.hibernate.StringType"
column="ona_projno"
not-null="true"
length="6"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_projno"
length="6"
not-null="true"
</meta>
</property>
<property
name="ona_spersn2"
type="com.relevant.util.hibernate.StringType"
column="ona_spersn2"
not-null="true"
length="3"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_spersn2"
length="3"
not-null="true"
</meta>
</property>
<property
name="ona_spersn3"
type="com.relevant.util.hibernate.StringType"
column="ona_spersn3"
not-null="true"
length="3"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_spersn3"
length="3"
not-null="true"
</meta>
</property>
<property
name="ona_comm"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_comm"
not-null="true"
length="18"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_comm"
length="18"
not-null="true"
</meta>
</property>
<property
name="ona_comm2"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_comm2"
not-null="true"
length="18"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_comm2"
length="18"
not-null="true"
</meta>
</property>
<property
name="ona_comm3"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_comm3"
not-null="true"
length="18"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_comm3"
length="18"
not-null="true"
</meta>
</property>
<property
name="ona_totwght"
type="com.relevant.util.hibernate.StringType"
column="ona_totwght"
not-null="true"
length="8"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_totwght"
length="8"
not-null="true"
</meta>
</property>
<property
name="ona_noshplbls"
type="long"
column="ona_noshplbls"
not-null="true"
length="16"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_noshplbls"
length="16"
not-null="true"
</meta>
</property>
<property
name="ona_preamt"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_preamt"
not-null="true"
length="18"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_preamt"
length="18"
not-null="true"
</meta>
</property>
<property
name="ona_invamt"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_invamt"
not-null="true"
length="18"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_invamt"
length="18"
not-null="true"
</meta>
</property>
<property
name="ona_noteflag"
type="com.relevant.util.hibernate.StringType"
column="ona_noteflag"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_noteflag"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_jbdsc"
type="com.relevant.util.hibernate.StringType"
column="ona_jbdsc"
not-null="true"
length="30"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_jbdsc"
length="30"
not-null="true"
</meta>
</property>
<property
name="ona_jbtyp"
type="com.relevant.util.hibernate.StringType"
column="ona_jbtyp"
not-null="true"
length="4"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_jbtyp"
length="4"
not-null="true"
</meta>
</property>
<property
name="ona_xmsgno"
type="com.relevant.util.hibernate.IntType"
column="ona_xmsgno"
not-null="true"
length="10"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_xmsgno"
length="10"
not-null="true"
</meta>
</property>
<property
name="ona_comovr"
type="com.relevant.util.hibernate.StringType"
column="ona_comovr"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_comovr"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_compct"
type="com.relevant.util.hibernate.StringType"
column="ona_compct"
not-null="true"
length="5"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_compct"
length="5"
not-null="true"
</meta>
</property>
<property
name="ona_fchg"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_fchg"
not-null="true"
length="18"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_fchg"
length="18"
not-null="true"
</meta>
</property>
<property
name="ona_ordtyp"
type="com.relevant.util.hibernate.StringType"
column="ona_ordtyp"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ordtyp"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_fill1"
type="com.relevant.util.hibernate.StringType"
column="ona_fill1"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_fill1"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_fll"
type="com.relevant.util.hibernate.StringType"
column="ona_fll"
not-null="true"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_fll"
length="1"
not-null="true"
</meta>
</property>
<property
name="ona_ivcdiv"
type="com.relevant.util.hibernate.StringType"
column="ona_ivcdiv"
not-null="true"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ivcdiv"
length="2"
not-null="true"
</meta>
</property>
<property
name="ona_bterrno"
type="java.lang.Short"
column="ona_bterrno"
length="5"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_bterrno"
length="5"
</meta>
</property>
<property
name="ona_bsic"
type="com.relevant.util.hibernate.StringType"
column="ona_bsic"
length="4"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_bsic"
length="4"
</meta>
</property>
<property
name="ona_sregion"
type="com.relevant.util.hibernate.StringType"
column="ona_sregion"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_sregion"
length="2"
</meta>
</property>
<property
name="ona_sterrno"
type="java.lang.Short"
column="ona_sterrno"
length="5"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_sterrno"
length="5"
</meta>
</property>
<property
name="ona_sclass"
type="com.relevant.util.hibernate.StringType"
column="ona_sclass"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_sclass"
length="2"
</meta>
</property>
<property
name="ona_ssic"
type="com.relevant.util.hibernate.StringType"
column="ona_ssic"
length="4"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ssic"
length="4"
</meta>
</property>
<property
name="ona_slclass"
type="com.relevant.util.hibernate.StringType"
column="ona_slclass"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_slclass"
length="2"
</meta>
</property>
<property
name="ona_scclass"
type="com.relevant.util.hibernate.StringType"
column="ona_scclass"
length="2"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_scclass"
length="2"
</meta>
</property>
<property
name="ona_quoteno"
type="com.relevant.util.hibernate.StringType"
column="ona_quoteno"
length="8"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_quoteno"
length="8"
</meta>
</property>
<property
name="ona_srorder"
type="com.relevant.util.hibernate.StringType"
column="ona_srorder"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_srorder"
length="1"
</meta>
</property>
<property
name="ona_emailfax"
type="com.relevant.util.hibernate.StringType"
column="ona_emailfax"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_emailfax"
length="1"
</meta>
</property>
<property
name="ona_mroorder"
type="com.relevant.util.hibernate.StringType"
column="ona_mroorder"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_mroorder"
length="1"
</meta>
</property>
<property
name="ona_ratecurtax"
type="com.relevant.util.hibernate.BigDecimalType"
column="ona_ratecurtax"
length="24"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_ratecurtax"
length="24"
</meta>
</property>
<property
name="ona_currtypetax"
type="com.relevant.util.hibernate.StringType"
column="ona_currtypetax"
length="3"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_currtypetax"
length="3"
</meta>
</property>
<property
name="ona_xrefno"
type="com.relevant.util.hibernate.StringType"
column="ona_xrefno"
length="10"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_xrefno"
length="10"
</meta>
</property>
<property
name="ona_emailfaxpik"
type="com.relevant.util.hibernate.StringType"
column="ona_emailfaxpik"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_emailfaxpik"
length="1"
</meta>
</property>
<property
name="ona_emailfaxpak"
type="com.relevant.util.hibernate.StringType"
column="ona_emailfaxpak"
length="1"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_emailfaxpak"
length="1"
</meta>
</property>
<property
name="ona_comments"
type="com.relevant.util.hibernate.StringType"
column="ona_comments"
length="100"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="field-description">
@hibernate.property
column="ona_comments"
length="100"
</meta>
</property>
<!-- Associations -->
<!-- derived association(s) for compound key -->
<!-- end of derived association(s) -->
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():Full stack trace of any exception that occurs:Code:
13:55:59,206 INFO [STDOUT] Hibernate: select {t}.ona_div as {t.ona_div} from Ona {t}
13:55:59,207 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 22019
13:55:59,208 ERROR [JDBCExceptionReporter] Invalid JDBC time escape at line position 10.
13:55:59,210 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 22019
13:55:59,211 ERROR [JDBCExceptionReporter] Invalid JDBC time escape at line position 10.
13:55:59,225 INFO [STDOUT] net.sf.hibernate.exception.GenericJDBCException: error performing findBySQL
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.findBySQL(SessionImpl.java:3870)
at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
at com.relevant.BizWiz.ejb.family.FamilyBO.test(FamilyBO.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.relevant.e3.ejb.businesscontroller.BCSessionBean.execute(BCSessionBean.java:231)
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:584)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:123)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:294)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
Name and version of the database you are using: MS SQL 2000 SP3