Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: hibernate-3.2.1.ga

Mapping documents:



Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

6895 [http-8080-Processor24] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - schema update complete
Hibernate: select this_.id as id1_0_, this_.name as name1_0_, this_.arrivalStation as arrivalS3_1_0_, this_.departureStation as departur4_1_0_, this_.arrivalDate as arrivalD5_1_0_, this_.departureDate as departur6_1_0_, this_.isCancel as isCancel1_0_ from flight this_ where this_.arrivalDate like ? order by this_.arrivalDate asc
8511 [http-8080-Processor24] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/stma].[jsp] - Servlet.service() for servlet jsp threw exception
java.lang.ClassCastException: java.lang.String
at org.hibernate.type.CalendarType.toString(CalendarType.java:58)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:87)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:65)
at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1514)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1576)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at de.dlh.fra.lcag.bl.StationManager.getAllFlightsForDay(Unknown Source)
at de.dlh.fra.lcag.util.StMaCalendarDecorator.getDay(Unknown Source)
at org.calendartag.tags.CalendarTag.doEndTag(CalendarTag.java:530)
at org.apache.jsp.WEB_002dINF.jsps.calendar_005fmonth_005fview_jsp._jspx_meth_calendartag_calendar_0(calendar_005fmonth_005fview_jsp.java:94)
at org.apache.jsp.WEB_002dINF.jsps.calendar_005fmonth_005fview_jsp._jspService(calendar_005fmonth_005fview_jsp.java:64)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:386)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
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 com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
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)
8517 [http-8080-Processor24] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/stma].[action] - Servlet.service() for servlet action threw exception
java.lang.ClassCastException: java.lang.String
at org.hibernate.type.CalendarType.toString(CalendarType.java:58)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:87)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:65)
at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1514)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1576)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at de.dlh.fra.lcag.bl.StationManager.getAllFlightsForDay(Unknown Source)
at de.dlh.fra.lcag.util.StMaCalendarDecorator.getDay(Unknown Source)
at org.calendartag.tags.CalendarTag.doEndTag(CalendarTag.java:530)
at org.apache.jsp.WEB_002dINF.jsps.calendar_005fmonth_005fview_jsp._jspx_meth_calendartag_calendar_0(calendar_005fmonth_005fview_jsp.java:94)
at org.apache.jsp.WEB_002dINF.jsps.calendar_005fmonth_005fview_jsp._jspService(calendar_005fmonth_005fview_jsp.java:64)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:386)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
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 com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
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.0.27

The generated SQL (show_sql=true):

Yes

Debug level Hibernate log excerpt:


Does anybody has an idea about this exception. In my opinion comparing the date does not work. If I // crit.add(Restrictions.like("arrivalDate", restriction)); this the query works. Otherwise I am receiving this java.lang.ClassCastException.

The SQL Table looks like this:

CREATE TABLE `flight` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`arrivalStation` varchar(255) default NULL,
`departureStation` varchar(255) default NULL,
`departureDate` timestamp NULL default NULL,
`isCancel` varchar(1) default '0',
`arrivalDate` timestamp NULL default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Please give me a helping hand :)

Does nobody has an idea how to solve this problem?

Hi,
It's normal to take a ClassCastException because you can't compar a String with an a Date object , If I undertsand you probleme you can use something like :
Calendar c = Calendar.getInstance()
c.set(Calendar.YEAR,2007);
c.set(Calendar.MONTH,Calendar.JANUARY);
c.set(Calendar.DAY_OF_MONTH,1);
Date lo = c.getTime();
c.set(Calendar.YEAR,2007);
c.set(Calendar.MONTH,Calendar.JANUARY);
c.set(Calendar.DAY_OF_MONTH,1);
Date hi = c.getTime();
...
criteria.add(Restrictions.between("arrivalDate", lo,hi));
--
Try this and keep me informed

sorry I make a mistake ,
for hi Date :
set the day of the months to 2 , to filter just the Data of 01/01/2007

Good luck !

Hi Aldwin,
I have some follow up questions. Suppose I have an Oracle 9i database, that stores Timestamps in the form (2007-01-01 15:23:56.776), however i wanted to get objects between dates from a web form which uses selects.

I would therefore have a string object like "2007-01-01" and i could add "00:00:00.000" at the end to make it the same format. Could I not convert it to a date or a Timestamp and use it to search?

I have tried doing this but I still get ClassCastException because of Timestamp. I dont understand why this is happening. Can you help?

Hi Aldwin,
I have some follow up questions. Suppose I have an Oracle 9i database, that stores Timestamps in the form (2007-01-01 15:23:56.776), however i wanted to get objects between dates from a web form which uses selects.

I would therefore have a string object like "2007-01-01" and i could add "00:00:00.000" at the end to make it the same format. Could I not convert it to a date or a Timestamp and use it to search?

I have tried doing this but I still get ClassCastException because of Timestamp. I dont understand why this is happening. Can you help?

In order to compare date field using criteria api, you need to convert the date string to java.sql.Timestamp and then pass the converted value to Restriction.

Please ensure that your string is in porper format
i.e. yyyy-mm-dd hh:mm:ss.fffffffff, before converting it to timestamp.