Hi,

I get the folowing exception when trying to use a java.lang.Date as the indexing column for a list. Please find the mapping and exception below. Does anyone have a clue why the type is not recognized and keeps defaulding back to int?

Thank you,
Joost

Hibernate version: 3

Mapping documents:
<list name="employments" lazy="true" inverse="true" cascade="all">
<key>
<column name="userId" />
</key>
<index column="start" type="java.lang.Date" />
<one-to-many class="com.jsportal.projectportal.portalBeans.Employment"/>
</list>

Full stack trace of any exception that occurs:
java.sql.SQLException: Invalid value for getInt() - '2002-01-01' in column 3
at com.mysql.jdbc.ResultSet.getIntFromString(ResultSet.java:2419)
at com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3727)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2338)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2353)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2677)
at org.hibernate.type.IntegerType.get(IntegerType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(AbstractCollectionPersister.java:650)
at org.hibernate.collection.PersistentList.readFrom(PersistentList.java:358)
at org.hibernate.loader.Loader.readCollectionElement(Loader.java:994)
at org.hibernate.loader.Loader.readCollectionElements(Loader.java:635)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1676)
at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:109)
at org.hibernate.collection.PersistentList.size(PersistentList.java:91)
at com.jsportal.projectportal.portalBeans.User.getEmployment(User.java:594)
at com.jsportal.projectportal.portalBeans.User.getEmployment(User.java:589)
at com.jsportal.projectportal.portalBeans.User.getCompany(User.java:350)
at com.jsportal.projectportal.web.JSFaces.logon.logon(logon.java:90)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
at org.apache.shale.view.faces.ViewActionListener.processAction(ViewActionListener.java:73)
at javax.faces.component.UICommand.broadcast(UICommand.java:106)
at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.jsportal.projectportal.web.SessionFilter.doFilter(SessionFilter.java:197)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.shale.faces.ShaleApplicationFilter.doFilter(ShaleApplicationFilter.java:268)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.jsportal.web.LocaleFilter.doFilter(LocaleFilter.java:149)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
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:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
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(Unknown Source)


Name and version of the database you are using: MySQL 5

I have a very simple suggestion but it is not a solution as I'm having a very similar problem: in the mapping document "class" and "type" are not the same. The former expects a (fully qualified) classname, where the latter expects a "basic value type". So rather than "java.lang.Date" I think you should have "date" (and you'll have to investigate separately whether that is java.lang.Date or java.sql.Date).

All that said, I'm still having basically the same problem that you are. My column is of hibernate type "timestamp" (java.sql.Timestamp). My map (generated by xdoclet) looks very similar to yours:



I'm using Hibernate version 3.1.3 and a PostgreSQL 8.1.4 database.
Here is the relevant portion of the exception and call stack:

type="date" did the trick!

Thanks,
Joost

Ok, I was tired yesterday and am mistaken as all that happened was that another exception hid the one I was working on. I still have the same problem where it defaults to retreiving an int, in stead of a date.

So still working to find a solution...

Joost

Hi guys.

Well, a list index is, by nature, an integral value.
You're trying to stuff it with a temporal value...

May be what you need is a map instead of a list, don't you ?

You seem to be absolutely right. You brought me two log lines futher to my next non hibernate exception!

Thanks,
Joost

I really want a bag, but I want to be able to have the elements of that bag get sorted into a useful order by the DB rather than the JVM. The hibernate bag accepts an "order-by" attribute, but it expects to find the specified column in the wrong table (for my schema, anyway).

-Dale