nelson christos

Thanks for your reply Mark

The problem was with the OSIV filter mapping.
I had given singleSession as false
so it was creating a session on get* and another on save*. I changed it to
true and alls well

The controller function for saving the voyage

public ModelAndView addVoyage(HttpServletRequest req,HttpServletResponse res){ DateFormat sdf= new SimpleDateFormat("dd/MM/yyyy"); String lineupNo=req.getParameter("lineupNo"); Voyage voyage=voyageService.getVoyage(Integer.parseInt(lineupNo)); String deparmentSelected=req.getParameter("departmentSelected"); String cargoSelected=req.getParameter("cargo"); String activity=req.getParameter("activity"); String activityStartDate=req.getParameter("activityStartDate"); String activityEndDate=req.getParameter("activityEndDate"); Department department= new Department(); department.setDepartmentId(Integer.parseInt(deparmentSelected)); Cargo cargo=new Cargo();cargo.setCargoId(Integer.parseInt(cargoSelected)); voyage.setDepartment(department); voyage.setCargo(cargo); voyage.setActivity(activity); voyage.setActivityStartDate(sdf.parse(activityStartDate)); voyage.setActivityEndDate(sdf.parse(activityEndDate)); voyage.setDailyCargo(voyage.getDailyCargo()); [B]voyage=voyageService.saveVoyage(voyage);[/B]List departments= voyageService.getDepartments(); List cargoList= voyageService.getCargo(); Map model = new HashMap(); model.put("departments", departments); model.put("cargo", cargoList); model.put("voyage", voyage); return new ModelAndView("voyageDetails","model",model); }

The service function is

public Voyage saveVoyage( Voyage voyage) { voyageDao.saveVoyage(voyage); }

and lastly the dao layer

public void saveVoyage(Voyage voyage) { getHibernateTemplate().saveOrUpdate(voyage); }

I dont see any new session getting opened in here. Is this something to
do with transactions
Thanks

These are the mapping files
<hibernate-mapping package="com.jmbaxi.model.agencyops"> <class name="com.jmbaxi.model.agencyops.Voyage" table="DAILY_VSL_DATA" lazy="false"> <id name="lineupNo" column="LINEUP_NO"> <generator class="assigned"></generator> </id> <property name="arrivalDate" column="ETA_ARR" type="date"/> <property name="departureDate" column="ETD_DEP" type="date"/> <property name="berthDate" column="ANCH_BERTH_DT"type="date"/> <property name="manifestQty" column="TOT_CARGO_QTY"/> <many-to-one name="port" column="PORT_CODE" class="Port"/> <many-to-one name="vessel" column="VSL_CODE" class="Vessel"/> <set name="dailyCargo" inverse="true" order-by="REP_NO"> <key column="LINEUP_NO" update="false"></key> <one-to-many class="DailyCargo"/> </set> <join table="AOPS_VSLVOY_AUX_DTLS" optional="true"> <key column="LINEUP_NO"></key> <many-to-one name="department" column="DEPT_CODE" class="Department" /> <property name="activity" column="OPS_ACTVT_CODE" type="string"/> <property name="activityStartDate" column="ACTVT_START_DT" type="date"/> <property name="activityEndDate" column="ACTVT_COMPL_DT" type="date"/> <property name="departureTime" column="DEP_TIME" type="string" not-null="false" /> <property name="arrivalTime" column="ARR_TIME" type="string" not-null="false"/> <property name="hatchCount" column="HATCH_COUNT" type="integer" not-null="false"/> <many-to-one name="cargo" column="CGO_TYPE" class="Cargo"/> </join> </class> </hibernate-mapping>


<hibernate-mapping package="com.jmbaxi.model.agencyops" > <class name="DailyCargo" table="AOPS_CDLP_MAIN" lazy="true" > <id name="dailyCargoId" column="CDLP_MAIN_ID" > <generator class="increment"></generator> </id> <property name="reportNumber" column="REP_NO"></property> <property name="reportDate" column="REP_DATE"></property> <property name="activity" column="ACTVT_CODE"></property> <many-to-one name="voyage" class="Voyage" column="LINEUP_NO" /> <many-to-one name="auxiliaryDetail" class="AuxiliaryDetail" column="CDLP_MAIN_ID" update="false" insert="false" /> </class> </hibernate-mapping>

Hi,

I have a Voyage.hbm like this

<hibernate-mapping package="com.jmbaxi.model.agencyops">
<class name="com.jmbaxi.model.agencyops.Voyage" table="DAILY_VSL_DATA" lazy="false">
<id name="lineupNo" column="LINEUP_NO">
<generator class="assigned"></generator>
</id>
..........

<join table="AOPS_VSLVOY_AUX_DTLS" optional="true">
<key column="LINEUP_NO"></key>
..........
</join>
</class>
</hibernate-mapping>

So when i am saving a voyage everything goes well
however when i added a
<set name="dailyCargo" inverse="true" order-by="REP_NO">
<key column="LINEUP_NO"></key>
<one-to-many class="DailyCargo"/>
</set>
it started giving me this exception

org.springframework.orm.hibernate3.HibernateSystemException: Illegal attempt to associate a collection with two open sessions; nested exception is org.hibernate.HibernateException: Illegal attempt to associate a collection with two open sessions

i am using Spring OSIV filter.

Thanks

I was wondering whether its a good idea to have a composite key in our table.
Our case is like this
A voyage can have a lot of dailyCargoReports associated to it.
Now the dailyCargoReport table can have 2 columns
voyage_id <pk>
sr_no <pk>
which represents the composite key
OR
one id column represnting the PK and one FK to voyage_id

which is a better way to go for from hibernate perspective.

Thanks

this is our first project in hibernate, so we are not going fully on a top down approach. we are creating the objects in UML and then we will be trying to create the tables in dB and later auto generate the hbm from ddl

Thanks

Nelson
[ March 28, 2008: Message edited by: nelson christos ]

you have to get hibernate tools plugin.
This might help you

http://www.hibernate.org/255.html

In the previous post BULK and TANKER are 2 types of cargo and
HATCH is associated only to bulk

Thanks

we are using Hibernate and came up with a model like this.
Each Vessel
---- has a Set of Positions
----------Each Position has a Set of Hatches.

So three tables to represent this . This looks fine.
However the the data to be stored differs on cargo type.
If it is a bulk cargo we have hatches , for petrol we have no hatches.

VESSEL
|
|
CARGODETAIL
^ ^
| |
BULK TANKER
|
HATCH

bulk and tanker are two categories of info we need to store
Should we go for table per class hierarchy to store both BULK AND TANKER
using a discriminator or go for table per subclass.

Thanks

I need to create a table for the data being captured. The data is captured in the following format.

This data is for each vessel

SrNo LoadingPosition Hatch1 Hatch2 Hatch3 Hatch4 Hatch5 Total
A PRE STOWAGE PLAN
B LAST 24 HRS
C PREVIOUS
D TOTAL
E BALANCE


These are the details i need to store for different hatches and the hatches
are dynamic depending on the vessel. I need a data model or some object model to represent this.

Thanks in advance

i have a inheritance hierarchy like this

Employee
|
|__Assessee
|
|__Appraiser
|
|__Reviewer

and there is one table Employee representing all the information.
when i am trying to map Employee.hbm its saying that no discriminator
found for Assessee (single table per class). I am not sure whether to put a dcriminator column(Employee_Type) in database because the type might change at runtime. Is there a other way to do it without discriminator.

Thanks

when installing oracle 10g its getting installed onto /usr/lib directory.
can i install that onto some other directory

thanks stephen, you got the point.
about dreamweaver, before getting started i needed
to know whether i being a beginner, can i leran to use it fast

Originally posted by Roger F. Gay:
OK. Now you're really leaving me confused. The next question is whether or not you actually want client side html - I mean, interacting in a sophisticated way with your back-end processes. Or is your html page just supposed to look good and have the occassional response to click sort of thing: do you rely on JSP for anything up-scale?

i didnt get what it means by "JSP for anything up-scale".
we are using jsp' for rendering our html response' back to the client.
and it contains lots of operations to do. like we create CRM applications,
appraisal systems...so there you go, its not that confusing

we are a team of 3 to 4 java programmers who are developing inhouse softwares.we dont have much of html expereince. much of our time is spend on creating buisness logic. and our projects are not that huge too. so we dont have too much time to spend on html coding. we surely meeting the deadlines but you know the end result(look and feel) is okey dokey.so we would like to get the design fast and good as possible so that we can do the programming stuff. thanks