Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
hibernate version 3
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated May 23, 2006 3:01:42 PM by Hibernate Tools 3.1.0.beta5 -->
<hibernate-mapping>
<class name="com.tsd.model.entitybean.setup.FleetCarriage" table="fleet_carriage" >
<comment></comment>
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="assigned" />
</id>
<many-to-one name="fleetCorridorType" class="com.tsd.model.entitybean.setup.FleetCorridorType" fetch="join">
<column name="fleet_corridor_type_id" not-null="true">
<comment></comment>
</column>
</many-to-one>
<!-- <many-to-one name="location" class="com.tsd.model.entitybean.setup.Location" fetch="join">
<column name="host_location_id">
<comment></comment>
</column>
</many-to-one> -->
<property name="name" type="java.lang.String">
<column name="name" length="50" not-null="true">
<comment></comment>
</column>
</property>
<property name="registrationNumber" type="java.lang.String">
<column name="registration_number" length="10">
<comment></comment>
</column>
</property>
<property name="fleetModel" type="java.lang.String">
<column name="fleet_model" length="15">
<comment></comment>
</column>
</property>
<property name="make" type="java.lang.String">
<column name="make" length="15">
<comment></comment>
</column>
</property>
<property name="volumetricCapacity" type="java.lang.String">
<column name="volumetric_capacity" length="10">
<comment></comment>
</column>
</property>
<property name="weightCapacity" type="java.lang.String">
<column name="weight_capacity" length="10">
<comment></comment>
</column>
</property>
<property name="ownership" type="java.lang.Character">
<column name="ownership" length="1" not-null="true">
<comment></comment>
</column>
</property>
<property name="rentedFromId" type="java.lang.Integer">
<column name="rented_from_id">
<comment></comment>
</column>
</property>
<property name="photoUrl" type="java.lang.String">
<column name="photo_url" length="65535">
<comment></comment>
</column>
</property>
<property name="photoDate" type="java.util.Date">
<column name="photo_date" length="10">
<comment></comment>
</column>
</property>
<property name="lastServiceDate" type="java.util.Date">
<column name="last_service_date" length="10">
<comment></comment>
</column>
</property>
<property name="createdBy" type="java.lang.Integer">
<column name="created_by" not-null="true">
<comment></comment>
</column>
</property>
<property name="createdOn" type="java.util.Date">
<column name="created_on" length="19" not-null="true">
<comment></comment>
</column>
</property>
<property name="modifiedBy" type="java.lang.Integer">
<column name="modified_by">
<comment></comment>
</column>
</property>
<property name="modifiedOn" type="java.util.Date">
<column name="modified_on" length="19">
<comment></comment>
</column>
</property>
<property name="deleted" type="java.lang.Byte">
<column name="deleted" not-null="true">
<comment></comment>
</column>
</property>
<set name="interLocationCorridorDetails" inverse="true" >
<key>
<column name="fleet_carriage_id" not-null="true">
<comment></comment>
</column>
</key>
<one-to-many class="com.tsd.model.entitybean.setup.InterLocationCorridorDetail" />
</set>
<set name="carriageRoutes" inverse="false" cascade="persist,save-update">
<key>
<column name="fleet_carriage_id" not-null="true">
<comment></comment>
</column>
</key>
<one-to-many class="com.tsd.model.entitybean.setup.CarriageRoute" />
<[b]filter name="carriageRouteDate"
condition=":carriageRoutes.effectiveFrom > carriageRoutes.effectiveFrom"/>
</set>
<set name="carriageServices" inverse="false" cascade="persist,save-update">
<key>
<column name="fleet_carriage_id" not-null="true">
<comment></comment>
</column>
</key>
<one-to-many class="com.tsd.model.entitybean.setup.CarriageService" />
<!-- <filter name="effectiveDate"
condition=":latestDate > carriageServices.effectiveFrom"/> -->
</set>
</class>
<fileter-def name="carriageRouteDate">
<filter-param name="carriageRoutes.effectiveFrom" type="date"/>
</fileter-def>
</hibernate-mapping>
[/b]
Code between sessionFactory.openSession() and session.close():
[b]java.lang.reflect.InvocationTargetException
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 org.jbullet.controller.ControllerServlet.dispatch(ControllerServlet.java:147)
at org.jbullet.controller.ControllerServlet.processRequest(ControllerServlet.java:77)
at org.jbullet.controller.ControllerServlet.doGet(ControllerServlet.java:39)
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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
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: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:595)
Caused by: java.lang.ExceptionInInitializerError
at com.tsd.jmvc.utils.HibernateUtil.<clinit>(HibernateUtil.java:57)
at com.tsd.view.controller.STFleetCarriageController.list(STFleetCarriageController.java:50)
... 23 more
Caused by: org.hibernate.MappingException: Could not read mappings from resource: com/tsd/model/entitybean/setup/FleetCarriage.hbm.xml
at org.hibernate.cfg.Configuration.addResource(Configuration.java:518)
at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1506)
at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1474)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1453)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1427)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1347)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1333)
at com.tsd.jmvc.utils.HibernateUtil.<clinit>(HibernateUtil.java:51)
... 24 more
Caused by: org.hibernate.MappingException: invalid mapping
at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:458)
at org.hibernate.cfg.Configuration.addResource(Configuration.java:515)
... 31 more
Caused by: org.xml.sax.SAXParseException: Element type "fileter-def" must be declared.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:236)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:172)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:382)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:316)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1960)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:795)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:330)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1693)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)
at org.dom4j.io.SAXReader.read(SAXReader.java:465)
at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:455)
... 32 more
java.lang.reflect.InvocationTargetException
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 org.jbullet.controller.ControllerServlet.dispatch(ControllerServlet.java:147)
at org.jbullet.controller.ControllerServlet.processRequest(ControllerServlet.java:77)
at org.jbullet.controller.ControllerServlet.doGet(ControllerServlet.java:39)
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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
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: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:595)
Caused by: java.lang.NoClassDefFoundError
at com.tsd.view.controller.STFleetCarriageController.list(STFleetCarriageController.java:50)
... 23 more/b]
Dear all
i m new to hibernate ,the problem which i m facing is that i have Master and detail tables
its one to many relation ship now i have listing page where i want to show only those record wose childs effective date is Maximum