I've got a problem with large key values in Hibernate version: 2.1.
In my talbe I got a key field defined as follows:
Code:
<id
name="hausarztID"
column="AZNR"
unsaved-value="null"
access="field"
type="de.bsdwest.basweb.core.persistence.type.DRKLongType">
<meta attribute="property-type">Long</meta>
<generator class="de.bsdwest.basweb.core.persistence.sequence.BWSequenceGenerator">
<param name="schema">BASDTA</param>
</generator>
</id>
As you can see the field is defined as long. Everything works fine with values from 0 to 999999999. If the value is 1000000000 or greater the following error occurs:
Code:
[17.10.08 12:02:27:443 CEST] 1b3823a2 JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -99999, SQLState: 07006
[17.10.08 12:02:27:443 CEST] 1b3823a2 JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Data type mismatch.
[17.10.08 12:02:27:459 CEST] 1b3823a2 JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -99999, SQLState: 07006
[17.10.08 12:02:27:474 CEST] 1b3823a2 JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Data type mismatch.
[17.10.08 12:02:27:506 CEST] 1b3823a2 HausarztVerwa E de.bsdwest.basweb.hausarzt.control.HausarztVerwaltungSuchenAuslesenAction Unhandled technical exception:
[17.10.08 12:02:27:521 CEST] 1b3823a2 HausarztVerwa E de.bsdwest.basweb.hausarzt.control.HausarztVerwaltungSuchenAuslesenAction TRAS0014I: Die folgende Ausnahmebedingung wurde protokolliert: Exception-LogMessage:[4000] Fehler bei Query-Operation bzw. Erstellung
de.bsdwest.basweb.core.persistence.PersistenceException: Unable to perform find
at de.bsdwest.basweb.core.persistence.BasWebPersistenceManager.findUniqueByCriteria(BasWebPersistenceManager.java:347)
Is there some kind of maxvalue for hibernate ?
Ralf
Login
FAQ
Search