Hi All,

I have a table 'user_application_map' with NO PRIMARY KEY. This table has 2 columns (user_id & application_id). Both these columns are primary key in another table. user_id is primary key of "m_its_users" table & application_id is primary key of "m_applications".
From front-end when I am trying to insert data then 2(or duplicate) rows are getting inserted.

Here is my mapping XML. For some reason I can't change the mapping :(
I tried to use <bag> instead of <set> but it still gives me the same problem.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping auto-import="true" default-lazy="false">

<class name="com.cgi.its.model.User" table="m_its_users">
<id name="id" column="user_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="fname" column="fname"/>
<property name="lname" column="lname"/>
<property name="loginId" column="login_id" unique="true"/>
<property name="password" column="password"/>
<property name="lastLoggedIn" column="last_logged_in"/>
<property name="mail_id" column="mail_id"/>
<property name="role" column="role_id"/>
<property name="type" column="type"/>
<property name="active" column="isactive"/>
<set name="assignedTickets" table="tkt_ticket_assignment">
<key column="user_id"/>
<many-to-many class="com.cgi.its.model.Ticket" column="its_id"/>
</set>
<set name="applications" table="user_application_map">
<key column="user_id" unique="true"/>
<many-to-many class="com.cgi.its.model.Application" column="application_id"/>
</set>
</class>
</hibernate-mapping>

Please help me show that I could insert only 1 row & not duplicate row.
Thanks in advance.

The <set> mapping seems to be ok. It is not this that is causing a duplicate insert. Have you also mapped the inverse direction from Application to User? If so, have you mapped it with inverse="true"?

Can you show the code were you create the link between the user and application?

Hi nordborg,
Thanks for the reply. Here is my complete XML file. I don't have any inverse mapping from Application to User.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping auto-import="true" default-lazy="false">

<class name="com.cgi.its.model.Complexity" table="m_tkt_complexity">
<id name="id" column="complexity_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
</class>

<class name="com.cgi.its.model.Status" table="m_tkt_status">
<id name="id" column="status_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
</class>

<class name="com.cgi.its.model.AnalysisStatus" table="m_tkt_analysis_status">
<id name="id" column="status_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
</class>

<class name="com.cgi.its.model.AnalysisSolutionStatus" table="m_tkt_analysis_solution_status">
<id name="id" column="status_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
</class>

<class name="com.cgi.its.model.DevelopmentStatus" table="m_tkt_development_status">
<id name="id" column="status_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
<property name="field1" column="field1"/>
</class>

<class name="com.cgi.its.model.TestingStatus" table="m_tkt_testing_status">
<id name="id" column="status_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
</class>

<class name="com.cgi.its.model.Source" table="m_tkt_source">
<id name="id" column="source_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
<property name="sourceUrl" column="url"/>
<property name="field1" column="field1"/>
</class>


<class name="com.cgi.its.model.Application" table="m_applications">
<id name="id" column="application_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
<property name="sourceURL" column="source_url"/>
<property name="shortName" column="short_name"/>
<set name="components" table="m_application_components" inverse="true" cascade="save-update">
<key column="application_id"/>
<one-to-many class="com.cgi.its.model.Component"/>
</set>
</class>
<class name="com.cgi.its.model.Component" table="m_application_components">
<id name="id" column="component_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
<many-to-one name="application" column="application_id" class="com.cgi.its.model.Application"/>
<set name="subComponents" table="m_application_subcomponents" inverse="true" cascade="save-update">
<key column="component_id"/>
<one-to-many class="com.cgi.its.model.SubComponent"/>
</set>
</class>
<class name="com.cgi.its.model.SubComponent" table="m_application_subcomponents">
<id name="id" column="sub_component_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
<many-to-one name="component" column="component_id" class="com.cgi.its.model.Component"/>
</class>

<class name="com.cgi.its.model.Priority" table="m_tkt_priorities">
<id name="id" column="priority_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="name" column="name"/>
</class>

<class name="com.cgi.its.model.Ticket" table="tickets">
<id name="id" column="its_id">
<generator class="identity"/>
</id>
<property name="gppiId" column="ticket_id"/>
<property name="createdBy" column="created_by"/>
<property name="createdDate" column="created_date"/>
<property name="summary" column="summary"/>
<property name="description" column="description"/>
<property name="assignedDate" column="assigned_date"/>
<property name="startDate" column="start_date"/>
<property name="endDate" column="end_date"/>
<property name="version" column="version"/>
<property name="build" column="build"/>
<property name="application" column="application"/>
<property name="component" column="component"/>
<property name="subComponent" column="sub_component"/>
<property name="estimatedEffort" column="estimated_effort" type="java.lang.Double"/>
<property name="clientEstimate" column="client_estimate" type="java.lang.Double"/>
<property name="effortVarianceCause" column="effort_variance_cause"/>
<many-to-one name="priority" column="priority_id" not-null="true" class="com.cgi.its.model.Priority"/>
<many-to-one name="source" column="source_id" not-null="true" class="com.cgi.its.model.Source"/>
<many-to-one name="status" column="status_id" not-null="true" class="com.cgi.its.model.Status"/>
<many-to-one name="complexity" column="complexity_id" not-null="true" class="com.cgi.its.model.Complexity"/>
<set name="assignedDevelopers" table="tkt_ticket_assignment" cascade="save-update">
<key column="its_id"/>
<many-to-many class="com.cgi.its.model.Developer" column="user_id"/>
</set>
<set name="analysisItemsInternal" inverse="true" cascade="all">
<key column="its_id"/>
<one-to-many class="com.cgi.its.model.AnalysisItem"/>
</set>
<set name="developmentItemsInternal" inverse="true" cascade="all">
<key column="its_id"/>
<one-to-many class="com.cgi.its.model.DevelopmentItem"/>
</set>
<set name="testingItemsInternal" inverse="true" cascade="all">
<key column="its_id"/>
<one-to-many class="com.cgi.its.model.TestingItem"/>
</set>
<set name="AttachmentsInternal" inverse="true" cascade="all">
<key column="its_id"/>
<one-to-many class="com.cgi.its.model.Attachment"/>
</set>
</class>

<class name="com.cgi.its.model.Developer" table="m_its_users">
<id name="id" column="user_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="fname" column="fname"/>
<property name="lname" column="lname"/>
<property name="loginId" column="login_id"/>
</class>

<class name="com.cgi.its.model.User" table="m_its_users">
<id name="id" column="user_id" type="java.lang.Integer">
<generator class="identity"/>
</id>
<property name="fname" column="fname"/>
<property name="lname" column="lname"/>
<property name="loginId" column="login_id" unique="true"/>
<property name="password" column="password"/>
<property name="lastLoggedIn" column="last_logged_in"/>
<property name="mail_id" column="mail_id"/>
<property name="role" column="role_id"/>
<property name="type" column="type"/>
<property name="active" column="isactive"/>
<set name="assignedTickets" table="tkt_ticket_assignment">
<key column="user_id"/>
<many-to-many class="com.cgi.its.model.Ticket" column="its_id"/>
</set>
<set name="applications" table="user_application_map">
<key column="user_id" unique="true" />
<many-to-many class="com.cgi.its.model.Application" column="application_id" />
</set>

</class>

<class name="com.cgi.its.model.AnalysisItem" table="tkt_analysis">
<id name="id" column="iteration" type="java.lang.Integer">
<generator class="identity"></generator>
</id>
<property name="developer" column="developer"/>
<property name="start_date" column="start_date"/>
<property name="end_date" column="end_date"/>
<property name="actual_hours" column="actual_hours" type="java.lang.Double"/>
<property name="size" column="size"/>
<property name="percent_dev_complete" column="percent_dev_complete"/>
<property name="analysis_comments" column="analysis_comments"/>
<property name="state" column="state"/>
<property name="solution_proposed_date" column="solution_proposed_date"/>
<property name="solution_approvedate" column="solution_approvedate"/>
<property name="analysis_status" column="status"/>
<property name="solution_comments" column="solution_comments"/>
<property name="hasOnsite" column="has_onsite" type="java.lang.Boolean"/>
<property name="onsiteMember" column="onsite_member"/>
<property name="dependencySummary" column="dependency_summary"/>
<property name="odRaisedDate" column="raised_date"/>
<property name="odResolutionDate" column="resolution_date"/>
<property name="odTimeInHours" column="time_in_hours" type="java.lang.Double"/>
<property name="filesAnalysed" column="files_analysed"/>
<many-to-one name="ticket" column="its_id" class="com.cgi.its.model.Ticket"/>
</class>

<class name="com.cgi.its.model.DevelopmentItem" table="tkt_development">
<id name="id" column="iteration" type="java.lang.Integer">
<generator class="identity"></generator>
</id>
<property name="developer" column="developer"></property>
<property name="startDate" column="start_date"></property>
<property name="endDate" column="end_date"></property>
<property name="actualDevhours" column="actual_dev_hours" type="java.lang.Double"></property>
<property name="size" column="size"></property>
<property name="filesModified" column="files_modified"></property>
<property name="comments" column="comments"></property>
<property name="status" column="status"></property>
<property name="hasOnsite" column="has_onsite" type="java.lang.Boolean"/>
<property name="onsiteMember" column="onsite_member"/>
<property name="dependencySummary" column="dependency_summary"/>
<property name="odRaisedDate" column="raised_date"/>
<property name="odResolutionDate" column="resolution_date"/>
<property name="odTimeInHours" column="time_in_hours" type="java.lang.Double"/>
<property name="unitTestingEffort" column="unit_testing_effort" type="java.lang.Double"/>
<property name="peerReviewId" column="peer_review_id" type="java.lang.Integer"/>
<property name="peerReviewer" column="peer_reviewer" />
<many-to-one name="ticket" column="its_id" class="com.cgi.its.model.Ticket"/>
</class>

<class name="com.cgi.its.model.TestingItem" table="tkt_testing">
<id name="id" column="iteration" type="java.lang.Integer">
<generator class="identity"></generator>
</id>
<property name="tester_name" column="tester_name"></property>
<property name="start_date" column="start_date"></property>
<property name="end_date" column="end_date"></property>
<property name="environment" column="environment"></property>
<property name="status" column="status"></property>
<property name="comments" column="comments"></property>
<property name="hasOnsite" column="has_onsite" type="java.lang.Boolean"/>
<property name="onsiteMember" column="onsite_member"/>
<property name="dependencySummary" column="dependency_summary"/>
<property name="odRaisedDate" column="raised_date"/>
<property name="odResolutionDate" column="resolution_date"/>
<property name="odTimeInHours" column="time_in_hours" type="java.lang.Double"/>
<property name="testingHours" column="testing_hours" type="java.lang.Double"/>
<many-to-one name="ticket" column="its_id" class="com.cgi.its.model.Ticket"/>
</class>

<class name="com.cgi.its.model.AnalysisOD" table="tkt_analysis_onsite_dependency">
<id name="id" column="item_id" type="java.lang.Integer">
<generator class="identity"></generator>
</id>
<property name="analyisId" column="iteartion"></property>
<property name="onsiteMember" column="onsite_member"></property>
<property name="dependencySummary" column="dependency_summary"></property>
<property name="raisedDate" column="raised_date"></property>
<property name="resolutionDate" column="resolution_date"></property>
<property name="timeInHours" column="time_in_hours"></property>
</class>

<class name="com.cgi.its.model.OnsiteDependency" table="tkt_onsite_dependency">
<id name="id" column="onsite_id" type="java.lang.Integer">
<generator class="identity"></generator>
</id>
<property name="onsiteMember" column="onsite_member"></property>
<property name="dependencySummary" column="dependency_summary"></property>
<property name="raisedDate" column="raised_date"></property>
<property name="resolutionDate" column="resolution_date"></property>
<property name="timeInHours" column="time_in_hours"></property>
</class>
<class name="com.cgi.its.model.TestingEnvironment" table="m_tkt_testing_environments">
<id name="id" column="env_id" type="java.lang.Integer">
<generator class="identity"></generator>
</id>
<property name="applicationId" column="application_id"></property>
<property name="name" column="name"></property>
<property name="description" column="description"></property>
</class>
<class name="com.cgi.its.model.Attachment" table="m_tkt_attachments">
<id name="id" column="attachment_id" type="java.lang.Integer">
<generator class="identity"></generator>
</id>
<property name="itsId" column="its_id"></property>
<property name="name" column="name"></property>
<property name="category" column="category"></property>
<property name="description" column="description"></property>
<property name="location" column="location"></property>
</class>
<class name="com.cgi.its.model.Announcements" table="announcements">
<id name="id" column="id" type="java.lang.Integer">
<generator class="identity"></generator>
</id>
<property name="description" column="description"></property>
<property name="createdDate" column="created_date"></property>
<property name="expiryDate" column="expiry_date"></property>
</class>
</hibernate-mapping>

I have a set called Application in User.java file(below is the code).
public class User extends BaseEntity{

private String fname ;
private String lname ;
private String loginId ;
private String password ;
private String mail_id ;
private Integer role;
private String type;
private String active ;
private Set<Ticket> assignedTickets;
private Date lastLoggedIn;
private boolean admin;
private boolean superUser;
private boolean manager;
private Set<Application> applications;

public Set<Application> getApplications() {
return applications;
}
public void setApplications(Set<Application> applications) {
this.applications = applications;
}
public Date getLastLoggedIn() {
return lastLoggedIn;
}
public void setLastLoggedIn(Date lastLoggedIn) {
this.lastLoggedIn = lastLoggedIn;
}
public Set<Ticket> getAssignedTickets() {
return assignedTickets;
}
public void setAssignedTickets(Set<Ticket> assignedTickets) {
this.assignedTickets = assignedTickets;
}
public String getFname() {
return fname;
}
public void setFname(String fname) {
this.fname = fname;
}
public String getLname() {
return lname;
}
public void setLname(String lname) {
this.lname = lname;
}
public String getLoginId() {
return loginId;
}
public void setLoginId(String loginId) {
this.loginId = loginId;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getMail_id() {
return mail_id;
}
public void setMail_id(String mail_id) {
this.mail_id = mail_id;
}
public Integer getRole() {
return role;
}
public void setRole(Integer role) {
this.role = role;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getActive() {
return active;
}
public void setActive(String active) {
this.active = active;
}

public String toString(){
//return getFname()+" "+getLname();
return getLoginId();
}
public boolean isAdmin() {
return (this.getRole() == 1 ? true:false);
}
public void setAdmin(boolean admin) {
this.admin = admin;
}
public boolean isSuperUser() {
return (this.isAdmin() && this.isManager());
}
public void setSuperUser(boolean superUser) {
this.superUser = superUser;
}
public boolean isManager() {
return (this.getRole() == 2 ? true:false);
}
public void setManager(boolean manager) {
this.manager = manager;
}

}
Here is my Application.java
public class Application extends NamedEntity {

private String sourceURL;
private String shortName;
private Set<Component> components;

public String getShortName() {
return shortName;
}
public void setShortName(String shortName) {
this.shortName = shortName;
}
public Set<Component> getComponents() {
return components;
}
public void setComponents(Set<Component> components) {
this.components = components;
}
public String getSourceURL() {
return sourceURL;
}
public void setSourceURL(String sourceURL) {
this.sourceURL = sourceURL;
}
}

My NamedEntity.java has compareTo method defined.

I think(but not sure) there is some problem with the XML file.
Please help me.

Thanks in Advance.

Can you show the code that is doing this? Please also enable and post the Hibernate SQL log and/or debug output. The debug output will be quite large so don't post the entire log here.

Hi Nordborg,
Thanks for the reply. Here is the Hibernate Log file & the Controller code that does this.
==================================
AdminContrller.java (Ref Method : userFormSubmit)
==================================
package com.cgi.its.web.controllers;

import java.util.Collection;
import java.util.Collections;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.SessionAttributes;
import org.springframework.web.bind.support.SessionStatus;
import org.springframework.web.servlet.ModelAndView;

import com.cgi.its.dataaccess.ITSDataAccess;
import com.cgi.its.model.Announcements;
import com.cgi.its.model.Application;
import com.cgi.its.model.Ticket;
import com.cgi.its.model.User;



@Controller
@SessionAttributes("user")
public class AdminContrller {

private final ITSDataAccess itsDataAccess;

@Autowired
public AdminContrller(ITSDataAccess itsDataAccess) {
this.itsDataAccess = itsDataAccess;
}


@RequestMapping("/userSetUpForm.do")
public String userSetUpForm(Model model,HttpServletRequest request) {
System.out.println("Inside userSetUpForm---------------------->");
Integer userId;
User user = new User();
if(request.getParameter("userId")!=null){
userId = Integer.parseInt(request.getParameter("userId"));
user = this.itsDataAccess.loadUser(userId);
}
//List<Application> applicationList = (List<Application>)this.itsDataAccess.loadApplications();
//Collections.sort(applicationList);

model.addAttribute(user);

return "userForm";
}

//Rajarshi
@ModelAttribute("applications")
public Collection<Application> populateApplications() {
List<Application> applicationList = (List<Application>)this.itsDataAccess.loadApplications();
//Collections.sort(applicationList);
return applicationList;
}

@RequestMapping("/userFormSubmit.do")
public String userFormSubmit(Model model,@ModelAttribute User user, BindingResult result,SessionStatus status,HttpServletRequest request) {
System.out.println("Inside userFormSubmit---------------------------->");
if (result.hasErrors()) {
System.out.println("Inside If------------------->");
return "userForm";
}else{
System.out.println("Inside else------------------->"+user.getApplications());
System.out.println("Inside else USER---------->"+user);
this.itsDataAccess.storeUser(user);
status.setComplete();
request.getSession().setAttribute("message", "User added successfully");
return "redirect:viewAllProfiles.do";
}
}


@RequestMapping("/deleteUser.do")
public String deleteUser(@RequestParam("userId") int id) {
User user = this.itsDataAccess.loadUser(id);
this.itsDataAccess.deleteUser(user);
return "redirect:viewAllProfiles.do";
}
}



=================
Hibernate Log
=================
Hibernate: select applicatio0_.application_id as applicat1_7_, applicatio0_.name as name7_, applicatio0_.source_url as source3_7_, applicatio0_.short_name as short4_7_ from m_applications applicatio0_
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select components0_.application_id as applicat3_1_, components0_.component_id as component1_1_, components0_.component_id as component1_8_0_, components0_.name as name8_0_, components0_.application_id as applicat3_8_0_ from m_application_components components0_ where components0_.application_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Hibernate: select subcompone0_.component_id as component3_1_, subcompone0_.sub_component_id as sub1_1_, subcompone0_.sub_component_id as sub1_9_0_, subcompone0_.name as name9_0_, subcompone0_.component_id as component3_9_0_ from m_application_subcomponents subcompone0_ where subcompone0_.component_id=?
Inside userSetUpForm---------------------->
Hibernate: select user0_.user_id as user1_13_0_, user0_.fname as fname13_0_, user0_.lname as lname13_0_, user0_.login_id as login4_13_0_, user0_.password as password13_0_, user0_.last_logged_in as last6_13_0_, user0_.mail_id as mail7_13_0_, user0_.role_id as role8_13_0_, user0_.type as type13_0_, user0_.isactive as isactive13_0_ from m_its_users user0_ where user0_.user_id=?
Hibernate: select applicatio0_.user_id as user1_1_, applicatio0_.application_id as applicat2_1_, applicatio1_.application_id as applicat1_7_0_, applicatio1_.name as name7_0_, applicatio1_.source_url as source3_7_0_, applicatio1_.short_name as short4_7_0_ from user_application_map applicatio0_ left outer join m_applications applicatio1_ on applicatio0_.application_id=applicatio1_.application_id where applicatio0_.user_id=?
Hibernate: select assignedti0_.user_id as user2_5_, assignedti0_.its_id as its1_5_, ticket1_.its_id as its1_11_0_, ticket1_.ticket_id as ticket2_11_0_, ticket1_.created_by as created3_11_0_, ticket1_.created_date as created4_11_0_, ticket1_.summary as summary11_0_, ticket1_.description as descript6_11_0_, ticket1_.assigned_date as assigned7_11_0_, ticket1_.start_date as start8_11_0_, ticket1_.end_date as end9_11_0_, ticket1_.version as version11_0_, ticket1_.build as build11_0_, ticket1_.application as applica12_11_0_, ticket1_.component as component11_0_, ticket1_.sub_component as sub14_11_0_, ticket1_.estimated_effort as estimated15_11_0_, ticket1_.client_estimate as client16_11_0_, ticket1_.effort_variance_cause as effort17_11_0_, ticket1_.priority_id as priority18_11_0_, ticket1_.source_id as source19_11_0_, ticket1_.status_id as status20_11_0_, ticket1_.complexity_id as complexity21_11_0_, priority2_.priority_id as priority1_10_1_, priority2_.name as name10_1_, source3_.source_id as source1_6_2_, source3_.name as name6_2_, source3_.url as url6_2_, source3_.field1 as field4_6_2_, status4_.status_id as status1_1_3_, status4_.name as name1_3_, complexity5_.complexity_id as complexity1_0_4_, complexity5_.name as name0_4_ from tkt_ticket_assignment assignedti0_ left outer join tickets ticket1_ on assignedti0_.its_id=ticket1_.its_id inner join m_tkt_priorities priority2_ on ticket1_.priority_id=priority2_.priority_id inner join m_tkt_source source3_ on ticket1_.source_id=source3_.source_id inner join m_tkt_status status4_ on ticket1_.status_id=status4_.status_id inner join m_tkt_complexity complexity5_ on ticket1_.complexity_id=complexity5_.complexity_id where assignedti0_.user_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.solution_proposed_date as solution10_15_0_, analysisit0_.solution_approvedate as solution11_15_0_, analysisit0_.status as status15_0_, analysisit0_.solution_comments as solution13_15_0_, analysisit0_.has_onsite as has14_15_0_, analysisit0_.onsite_member as onsite15_15_0_, analysisit0_.dependency_summary as dependency16_15_0_, analysisit0_.raised_date as raised17_15_0_, analysisit0_.resolution_date as resolution18_15_0_, analysisit0_.time_in_hours as time19_15_0_, analysisit0_.files_analysed as files20_15_0_, analysisit0_.its_id as its21_15_0_ from tkt_analysis analysisit0_ where analysisit0_.its_id=?
Hibernate: select assignedde0_.its_id as its1_1_, assignedde0_.user_id as user2_1_, developer1_.user_id as user1_13_0_, developer1_.fname as fname13_0_, developer1_.lname as lname13_0_, developer1_.login_id as login4_13_0_ from tkt_ticket_assignment assignedde0_ left outer join m_its_users developer1_ on assignedde0_.user_id=developer1_.user_id where assignedde0_.its_id=?
Hibernate: select attachment0_.its_id as its2_1_, attachment0_.attachment_id as attachment1_1_, attachment0_.attachment_id as attachment1_21_0_, attachment0_.its_id as its2_21_0_, attachment0_.name as name21_0_, attachment0_.category as category21_0_, attachment0_.description as descript5_21_0_, attachment0_.location as location21_0_ from m_tkt_attachments attachment0_ where attachment0_.its_id=?
Hibernate: select testingite0_.its_id as its15_1_, testingite0_.iteration as iteration1_, testingite0_.iteration as iteration17_0_, testingite0_.tester_name as tester2_17_0_, testingite0_.start_date as start3_17_0_, testingite0_.end_date as end4_17_0_, testingite0_.environment as environm5_17_0_, testingite0_.status as status17_0_, testingite0_.comments as comments17_0_, testingite0_.has_onsite as has8_17_0_, testingite0_.onsite_member as onsite9_17_0_, testingite0_.dependency_summary as dependency10_17_0_, testingite0_.raised_date as raised11_17_0_, testingite0_.resolution_date as resolution12_17_0_, testingite0_.time_in_hours as time13_17_0_, testingite0_.testing_hours as testing14_17_0_, testingite0_.its_id as its15_17_0_ from tkt_testing testingite0_ where testingite0_.its_id=?
Hibernate: select developmen0_.its_id as its19_1_, developmen0_.iteration as iteration1_, developmen0_.iteration as iteration16_0_, developmen0_.developer as developer16_0_, developmen0_.start_date as start3_16_0_, developmen0_.end_date as end4_16_0_, developmen0_.actual_dev_hours as actual5_16_0_, developmen0_.size as size16_0_, developmen0_.files_modified as files7_16_0_, developmen0_.comments as comments16_0_, developmen0_.status as status16_0_, developmen0_.has_onsite as has10_16_0_, developmen0_.onsite_member as onsite11_16_0_, developmen0_.dependency_summary as dependency12_16_0_, developmen0_.raised_date as raised13_16_0_, developmen0_.resolution_date as resolution14_16_0_, developmen0_.time_in_hours as time15_16_0_, developmen0_.unit_testing_effort as unit16_16_0_, developmen0_.peer_review_id as peer17_16_0_, developmen0_.peer_reviewer as peer18_16_0_, developmen0_.its_id as its19_16_0_ from tkt_development developmen0_ where developmen0_.its_id=?
Hibernate: select analysisit0_.its_id as its21_1_, analysisit0_.iteration as iteration1_, analysisit0_.iteration as iteration15_0_, analysisit0_.developer as developer15_0_, analysisit0_.start_date as start3_15_0_, analysisit0_.end_date as end4_15_0_, analysisit0_.actual_hours as actual5_15_0_, analysisit0_.size as size15_0_, analysisit0_.percent_dev_complete as percent7_15_0_, analysisit0_.analysis_comments as analysis8_15_0_, analysisit0_.state as state15_0_, analysisit0_.soluti