Using
Seam 2.0.0.GA
Hibernate 3.2.4.sp1
JBoss 4.2.1.GA
Oracle 10g
I am trying to create a JPA query (backed by Hibernate as persistence provider). The query is dynamic as it supports a multi-criteria search JSF. Multiple tables are involved.
I first started with the native query approach but then learned that when more than one entity is in the result list, you must use the @SqlResultSetMapping annotation to specify which entities will be returned. Also, I would like to take advantage of the OO capabilities of Hibernate/JPA in terms of path expressions (this seems easier than using relational SQL).
The following query is returning 0 rows in the list even when no criteria from the search JSF is passed (i.e. no appenders to query construction). Anybody know why? Is it ok to use path expressions in the select clause? In the EJB3 in action book it states that the path expressions are normally used in the WHERE clause and ORDER BY. In the Bauer book it states that you can use path expression in the SELECT clause (pg. 646). So if you do that, do you not need to join the tables and what happens if you do?
Any help would be much appreciated. thx.
Code:
StringBuffer query = new StringBuffer("SELECT tbb.login, "+
"tmus.superInfo.lastname, "+
"n.disapprovalType.description, "+
"ia.site.name, "+
"ia.description, "+
"e.auditStatus.description "+
"FROM Employee e, "+
"Tbuser tbu, "+
"Tmuserbilling tmub, "+
"Tbbilling tbb, "+
"AuditStatus ast, "+
"Tmusersupervisor tmus, "+
"Note n, "+
"Activity a, "+
"IcomsAudit ia "+
"WHERE e.idmUserId = tbu.userkey "+
"and e.auditStatus.auditStatusId = ast.auditStatusId "+
"and e.icomsAudit.auditId = ia.auditId "+
"and tbu.userkey = tmub.userkey "+
"and tmub.billingkey = tbb.billingkey "+
"and tbu.userkey = tmus.userkey "+
"and e.employeeId = a.employee.employeeId "+
"and a.activityId = n.activity.activityId ");
//add appenders
if (selectedSite != null && selectedSite.trim().length() > 0) {
query.append(" AND ia.site.siteId = ? ");
}
if (icomsUser != null && icomsUser.trim().length() > 0) {
query.append(" AND tbb.login like ? ");
}
String queryString = query.toString();
//create NativeQuery
Query q = entityManager.createQuery(query.toString());
//set params
if (selectedSite != null && selectedSite.trim().length() > 0) {
q.setParameter(ctr++, Integer.parseInt(getSelectedSite().trim()));
}
if (icomsUser != null && icomsUser.trim().length() > 0) {
q.setParameter(ctr++, getIcomsUser().trim());
}
list = q.getResultList();
return list;
When I run the following SQL, I get 1 row:
Code:
select *
from EMPLOYEE e,
TBUSER tbu,
TMUSERBILLING tmub,
TBBILLING tbb,
AUDIT_STATUS ast,
TMUSERSUPERVISOR tmus,
NOTE n,
ACTIVITY a,
ICOMS_AUDIT ia
where
e.idm_User_Id = tbu.userkey
and e.audit_Status_Id = ast.audit_Status_Id
and e.audit_Id = ia.audit_Id
and tbu.userkey = tmub.userkey
and tmub.billingkey = tbb.billingkey
and tbu.userkey = tmus.userkey
and e.employee_Id = a.employee_Id
and a.activity_Id = n.activity_Id
There are no errors in the server.log:
Code:
2008-04-03 11:37:15,175 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: SELECT e FROM com.cox.ICOMSSecurityAudit.model.Employee e, com.cox.ICOMSSecurityAudit.model.Tbuser tbu, com.cox.ICOMSSecurityAudit.model.Tmuserbilling tmub, com.cox.ICOMSSecurityAudit.model.Tbbilling tbb, com.cox.ICOMSSecurityAudit.model.AuditStatus ast, com.cox.ICOMSSecurityAudit.model.Tmusersupervisor tmus, com.cox.ICOMSSecurityAudit.model.Note n, com.cox.ICOMSSecurityAudit.model.Activity a, com.cox.ICOMSSecurityAudit.model.IcomsAudit ia WHERE e.idmUserId = tbu.userkey and e.auditStatus.auditStatusId = ast.auditStatusId and e.icomsAudit.auditId = ia.auditId and tbu.userkey = tmub.userkey and tmub.billingkey = tbb.billingkey and tbu.userkey = tmus.userkey and e.employeeId = a.employee.employeeId and a.activityId = n.activity.activityId
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'FROM'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'cox'
| | | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | | \-[IDENT] 'model'
| | | | \-[IDENT] 'Employee'
| | | \-[ALIAS] 'e'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'cox'
| | | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | | \-[IDENT] 'model'
| | | | \-[IDENT] 'Tbuser'
| | | \-[ALIAS] 'tbu'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'cox'
| | | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | | \-[IDENT] 'model'
| | | | \-[IDENT] 'Tmuserbilling'
| | | \-[ALIAS] 'tmub'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'cox'
| | | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | | \-[IDENT] 'model'
| | | | \-[IDENT] 'Tbbilling'
| | | \-[ALIAS] 'tbb'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'cox'
| | | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | | \-[IDENT] 'model'
| | | | \-[IDENT] 'AuditStatus'
| | | \-[ALIAS] 'ast'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'cox'
| | | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | | \-[IDENT] 'model'
| | | | \-[IDENT] 'Tmusersupervisor'
| | | \-[ALIAS] 'tmus'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'cox'
| | | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | | \-[IDENT] 'model'
| | | | \-[IDENT] 'Note'
| | | \-[ALIAS] 'n'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'cox'
| | | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | | \-[IDENT] 'model'
| | | | \-[IDENT] 'Activity'
| | | \-[ALIAS] 'a'
| | \-[RANGE] 'RANGE'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[IDENT] 'com'
| | | | | | \-[IDENT] 'cox'
| | | | | \-[IDENT] 'ICOMSSecurityAudit'
| | | | \-[IDENT] 'model'
| | | \-[IDENT] 'IcomsAudit'
| | \-[ALIAS] 'ia'
| \-[SELECT] 'SELECT'
| \-[IDENT] 'e'
\-[WHERE] 'WHERE'
\-[AND] 'and'
+-[AND] 'and'
| +-[AND] 'and'
| | +-[AND] 'and'
| | | +-[AND] 'and'
| | | | +-[AND] 'and'
| | | | | +-[AND] 'and'
| | | | | | +-[EQ] '='
| | | | | | | +-[DOT] '.'
| | | | | | | | +-[IDENT] 'e'
| | | | | | | | \-[IDENT] 'idmUserId'
| | | | | | | \-[DOT] '.'
| | | | | | | +-[IDENT] 'tbu'
| | | | | | | \-[IDENT] 'userkey'
| | | | | | \-[EQ] '='
| | | | | | +-[DOT] '.'
| | | | | | | +-[DOT] '.'
| | | | | | | | +-[IDENT] 'e'
| | | | | | | | \-[IDENT] 'auditStatus'
| | | | | | | \-[IDENT] 'auditStatusId'
| | | | | | \-[DOT] '.'
| | | | | | +-[IDENT] 'ast'
| | | | | | \-[IDENT] 'auditStatusId'
| | | | | \-[EQ] '='
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'e'
| | | | | | | \-[IDENT] 'icomsAudit'
| | | | | | \-[IDENT] 'auditId'
| | | | | \-[DOT] '.'
| | | | | +-[IDENT] 'ia'
| | | | | \-[IDENT] 'auditId'
| | | | \-[EQ] '='
| | | | +-[DOT] '.'
| | | | | +-[IDENT] 'tbu'
| | | | | \-[IDENT] 'userkey'
| | | | \-[DOT] '.'
| | | | +-[IDENT] 'tmub'
| | | | \-[IDENT] 'userkey'
| | | \-[EQ] '='
| | | +-[DOT] '.'
| | | | +-[IDENT] 'tmub'
| | | | \-[IDENT] 'billingkey'
| | | \-[DOT] '.'
| | | +-[IDENT] 'tbb'
| | | \-[IDENT] 'billingkey'
| | \-[EQ] '='
| | +-[DOT] '.'
| | | +-[IDENT] 'tbu'
| | | \-[IDENT] 'userkey'
| | \-[DOT] '.'
| | +-[IDENT] 'tmus'
| | \-[IDENT] 'userkey'
| \-[EQ] '='
| +-[DOT] '.'
| | +-[IDENT] 'e'
| | \-[IDENT] 'employeeId'
| \-[DOT] '.'
| +-[DOT] '.'
| | +-[IDENT] 'a'
| | \-[IDENT] 'employee'
| \-[IDENT] 'employeeId'
\-[EQ] '='
+-[DOT] '.'
| +-[IDENT] 'a'
| \-[IDENT] 'activityId'
\-[DOT] '.'
+-[DOT] '.'
| +-[IDENT] 'n'
| \-[IDENT] 'activity'
\-[IDENT] 'activityId'
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.Employee (e) -> employee0_
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.Tbuser (tbu) -> tbuser1_
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.Tmuserbilling (tmub) -> tmuserbill2_
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.Tbbilling (tbb) -> tbbilling3_
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.AuditStatus (ast) -> auditstatu4_
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.Tmusersupervisor (tmus) -> tmusersupe5_
2008-04-03 11:37:15,237 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.Note (n) -> note6_
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.Activity (a) -> activity7_
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.cox.ICOMSSecurityAudit.model.IcomsAudit (ia) -> icomsaudit8_
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e -> employee0_.EMPLOYEE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e -> employee0_.EMPLOYEE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : idmUserId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e.idmUserId -> employee0_.IDM_USER_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tbu -> tbuser1_.USERKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : userkey -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tbu.userkey -> tbuser1_.USERKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e -> employee0_.EMPLOYEE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : auditStatus -> org.hibernate.type.ManyToOneType(com.cox.ICOMSSecurityAudit.model.AuditStatus)
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property auditStatusId in com.cox.ICOMSSecurityAudit.model.Employee does not require a join.
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'auditStatus.auditStatusId'
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e.auditStatus -> employee0_.AUDIT_STATUS_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : auditStatus.auditStatusId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e.auditStatus.auditStatusId -> employee0_.AUDIT_STATUS_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : ast -> auditstatu4_.AUDIT_STATUS_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : auditStatusId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : ast.auditStatusId -> auditstatu4_.AUDIT_STATUS_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e -> employee0_.EMPLOYEE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : icomsAudit -> org.hibernate.type.ManyToOneType(com.cox.ICOMSSecurityAudit.model.IcomsAudit)
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property auditId in com.cox.ICOMSSecurityAudit.model.Employee does not require a join.
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'icomsAudit.auditId'
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e.icomsAudit -> employee0_.AUDIT_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : icomsAudit.auditId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e.icomsAudit.auditId -> employee0_.AUDIT_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : ia -> icomsaudit8_.AUDIT_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : auditId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : ia.auditId -> icomsaudit8_.AUDIT_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tbu -> tbuser1_.USERKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : userkey -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tbu.userkey -> tbuser1_.USERKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tmub -> tmuserbill2_.USERBILLINGKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : userkey -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tmub.userkey -> tmuserbill2_.USERKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tmub -> tmuserbill2_.USERBILLINGKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : billingkey -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tmub.billingkey -> tmuserbill2_.BILLINGKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tbb -> tbbilling3_.BILLINGKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : billingkey -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tbb.billingkey -> tbbilling3_.BILLINGKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tbu -> tbuser1_.USERKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : userkey -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tbu.userkey -> tbuser1_.USERKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tmus -> tmusersupe5_.USERSUPERVISORKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : userkey -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : tmus.userkey -> tmusersupe5_.USERKEY
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e -> employee0_.EMPLOYEE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : employeeId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : e.employeeId -> employee0_.EMPLOYEE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : a -> activity7_.ACTIVITY_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : employee -> org.hibernate.type.ManyToOneType(com.cox.ICOMSSecurityAudit.model.Employee)
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property employeeId in com.cox.ICOMSSecurityAudit.model.Activity does not require a join.
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'employee.employeeId'
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : a.employee -> activity7_.EMPLOYEE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : employee.employeeId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : a.employee.employeeId -> activity7_.EMPLOYEE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : a -> activity7_.ACTIVITY_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : activityId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : a.activityId -> activity7_.ACTIVITY_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : n -> note6_.NOTE_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : activity -> org.hibernate.type.ManyToOneType(com.cox.ICOMSSecurityAudit.model.Activity)
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceShortcut() : property activityId in com.cox.ICOMSSecurityAudit.model.Note does not require a join.
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] Unresolved property path is now 'activity.activityId'
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : n.activity -> note6_.ACTIVITY_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : activity.activityId -> org.hibernate.type.IntegerType@185c1a4
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : n.activity.activityId -> note6_.ACTIVITY_ID
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
2008-04-03 11:37:15,253 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} employee0_.EMPLOYEE_ID ) ( FromClause{level=1} EMPLOYEE employee0_ TBUSER tbuser1_ TMUSERBILLING tmuserbill2_ TBBILLING tbbilling3_ AUDIT_STATUS auditstatu4_ TMUSERSUPERVISOR tmusersupe5_ NOTE note6_ ACTIVITY activity7_ ICOMS_AUDIT icomsaudit8_ ) ( WHERE ( and ( and ( and ( and ( and ( and ( and ( = ( employee0_.IDM_USER_ID employee0_.EMPLOYEE_ID idmUserId ) ( tbuser1_.USERKEY tbuser1_.USERKEY userkey ) ) ( = ( employee0_.AUDIT_STATUS_ID ( employee0_.AUDIT_STATUS_ID employee0_.EMPLOYEE_ID auditStatus ) auditStatusId ) ( auditstatu4_.AUDIT_STATUS_ID auditstatu4_.AUDIT_STATUS_ID auditStatusId ) ) ) ( = ( employee0_.AUDIT_ID ( employee0_.AUDIT_ID employee0_.EMPLOYEE_ID icomsAudit ) auditId ) ( icomsaudit8_.AUDIT_ID icomsaudit8_.AUDIT_ID auditId ) ) ) ( = ( tbuser1_.USERKEY tbuser1_.USERKEY userkey ) ( tmuserbill2_.USERKEY tmuserbill2_.USERBILLINGKEY userkey ) ) ) ( = ( tmuserbill2_.BILLINGKEY tmuserbill2_.USERBILLINGKEY billingkey ) ( tbbilling3_.BILLINGKEY tbbilling3_.BILLINGKEY billingkey ) ) ) ( = ( tbuser1_.USERKEY tbuser1_.USERKEY userkey ) ( tmusersupe5_.USERKEY tmusersupe5_.USERSUPERVISORKEY userkey ) ) ) ( = ( employee0_.EMPLOYEE_ID employee0_.EMPLOYEE_ID employeeId ) ( activity7_.EMPLOYEE_ID ( activity7_.EMPLOYEE_ID activity7_.ACTIVITY_ID employee ) employeeId ) ) ) ( = ( activity7_.ACTIVITY_ID activity7_.ACTIVITY_ID activityId ) ( note6_.ACTIVITY_ID ( note6_.ACTIVITY_ID note6_.NOTE_ID activity ) activityId ) ) ) ) )
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [EMPLOYEE employee0_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [TBUSER tbuser1_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [TMUSERBILLING tmuserbill2_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [TBBILLING tbbilling3_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [AUDIT_STATUS auditstatu4_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [TMUSERSUPERVISOR tmusersupe5_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [NOTE note6_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [ACTIVITY activity7_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [ICOMS_AUDIT icomsaudit8_]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=1, statement=select]
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (ACTIVITY,AUDIT_STATUS,TMUSERBILLING,NOTE,ICOMS_AUDIT,TBUSER,EMPLOYEE,TBBILLING,TMUSERSUPERVISOR)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[ALIAS_REF] IdentNode: 'employee0_.EMPLOYEE_ID as EMPLOYEE1_64_' {alias=e, className=com.cox.ICOMSSecurityAudit.model.Employee, tableAlias=employee0_}
| \-[SQL_TOKEN] SqlFragment: 'employee0_.AUDIT_ID as AUDIT3_64_, employee0_.AUDIT_STATUS_ID as AUDIT4_64_, employee0_.IDM_USER_ID as IDM2_64_'
+-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=9, fromElements=9, fromElementByClassAlias=[tbu, ast, a, tbb, tmus, n, tmub, ia, e], fromElementByTableAlias=[tmusersupe5_, tbuser1_, auditstatu4_, tmuserbill2_, activity7_, icomsaudit8_, tbbilling3_, employee0_, note6_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| +-[FROM_FRAGMENT] FromElement: 'EMPLOYEE employee0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=e,role=null,tableName=EMPLOYEE,tableAlias=employee0_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.Employee}}
| +-[FROM_FRAGMENT] FromElement: 'TBUSER tbuser1_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=tbu,role=null,tableName=TBUSER,tableAlias=tbuser1_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.Tbuser}}
| +-[FROM_FRAGMENT] FromElement: 'TMUSERBILLING tmuserbill2_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=tmub,role=null,tableName=TMUSERBILLING,tableAlias=tmuserbill2_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.Tmuserbilling}}
| +-[FROM_FRAGMENT] FromElement: 'TBBILLING tbbilling3_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=tbb,role=null,tableName=TBBILLING,tableAlias=tbbilling3_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.Tbbilling}}
| +-[FROM_FRAGMENT] FromElement: 'AUDIT_STATUS auditstatu4_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=ast,role=null,tableName=AUDIT_STATUS,tableAlias=auditstatu4_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.AuditStatus}}
| +-[FROM_FRAGMENT] FromElement: 'TMUSERSUPERVISOR tmusersupe5_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=tmus,role=null,tableName=TMUSERSUPERVISOR,tableAlias=tmusersupe5_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.Tmusersupervisor}}
| +-[FROM_FRAGMENT] FromElement: 'NOTE note6_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=n,role=null,tableName=NOTE,tableAlias=note6_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.Note}}
| +-[FROM_FRAGMENT] FromElement: 'ACTIVITY activity7_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=a,role=null,tableName=ACTIVITY,tableAlias=activity7_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.Activity}}
| \-[FROM_FRAGMENT] FromElement: 'ICOMS_AUDIT icomsaudit8_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=ia,role=null,tableName=ICOMS_AUDIT,tableAlias=icomsaudit8_,origin=null,colums={,className=com.cox.ICOMSSecurityAudit.model.IcomsAudit}}
\-[WHERE] SqlNode: 'WHERE'
\-[AND] SqlNode: 'and'
+-[AND] SqlNode: 'and'
| +-[AND] SqlNode: 'and'
| | +-[AND] SqlNode: 'and'
| | | +-[AND] SqlNode: 'and'
| | | | +-[AND] SqlNode: 'and'
| | | | | +-[AND] SqlNode: 'and'
| | | | | | +-[EQ] BinaryLogicOperatorNode: '='
| | | | | | | +-[DOT] DotNode: 'employee0_.IDM_USER_ID' {propertyName=idmUserId,dereferenceType=4,propertyPath=idmUserId,path=e.idmUserId,tableAlias=employee0_,className=com.cox.ICOMSSecurityAudit.model.Employee,classAlias=e}
| | | | | | | | +-[ALIAS_REF] IdentNode: 'employee0_.EMPLOYEE_ID' {alias=e, className=com.cox.ICOMSSecurityAudit.model.Employee, tableAlias=employee0_}
| | | | | | | | \-[IDENT] IdentNode: 'idmUserId' {originalText=idmUserId}
| | | | | | | \-[DOT] DotNode: 'tbuser1_.USERKEY' {propertyName=userkey,dereferenceType=4,propertyPath=userkey,path=tbu.userkey,tableAlias=tbuser1_,className=com.cox.ICOMSSecurityAudit.model.Tbuser,classAlias=tbu}
| | | | | | | +-[ALIAS_REF] IdentNode: 'tbuser1_.USERKEY' {alias=tbu, className=com.cox.ICOMSSecurityAudit.model.Tbuser, tableAlias=tbuser1_}
| | | | | | | \-[IDENT] IdentNode: 'userkey' {originalText=userkey}
| | | | | | \-[EQ] BinaryLogicOperatorNode: '='
| | | | | | +-[DOT] DotNode: 'employee0_.AUDIT_STATUS_ID' {propertyName=auditStatusId,dereferenceType=4,propertyPath=auditStatus.auditStatusId,path=e.auditStatus.auditStatusId,tableAlias=employee0_,className=com.cox.ICOMSSecurityAudit.model.Employee,classAlias=e}
| | | | | | | +-[DOT] DotNode: 'employee0_.AUDIT_STATUS_ID' {propertyName=auditStatusId,dereferenceType=ROOT_LEVEL,propertyPath=auditStatus.auditStatusId,path=e.auditStatus,tableAlias=employee0_,className=com.cox.ICOMSSecurityAudit.model.Employee,classAlias=e}
| | | | | | | | +-[ALIAS_REF] IdentNode: 'employee0_.EMPLOYEE_ID' {alias=e, className=com.cox.ICOMSSecurityAudit.model.Employee, tableAlias=employee0_}
| | | | | | | | \-[IDENT] IdentNode: 'auditStatus' {originalText=auditStatus}
| | | | | | | \-[IDENT] IdentNode: 'auditStatusId' {originalText=auditStatusId}
| | | | | | \-[DOT] DotNode: 'auditstatu4_.AUDIT_STATUS_ID' {propertyName=auditStatusId,dereferenceType=4,propertyPath=auditStatusId,path=ast.auditStatusId,tableAlias=auditstatu4_,className=com.cox.ICOMSSecurityAudit.model.AuditStatus,classAlias=ast}
| | | | | | +-[ALIAS_REF] IdentNode: 'auditstatu4_.AUDIT_STATUS_ID' {alias=ast, className=com.cox.ICOMSSecurityAudit.model.AuditStatus, tableAlias=auditstatu4_}
| | | | | | \-[IDENT] IdentNode: 'auditStatusId' {originalText=auditStatusId}
| | | | | \-[EQ] BinaryLogicOperatorNode: '='
| | | | | +-[DOT] DotNode: 'employee0_.AUDIT_ID' {propertyName=auditId,dereferenceType=4,propertyPath=icomsAudit.auditId,path=e.icomsAudit.auditId,tableAlias=employee0_,className=com.cox.ICOMSSecurityAudit.model.Employee,classAlias=e}
| | | | | | +-[DOT] DotNode: 'employee0_.AUDIT_ID' {propertyName=auditId,dereferenceType=ROOT_LEVEL,propertyPath=icomsAudit.auditId,path=e.icomsAudit,tableAlias=employee0_,className=com.cox.ICOMSSecurityAudit.model.Employee,classAlias=e}
| | | | | | | +-[ALIAS_REF] IdentNode: 'employee0_.EMPLOYEE_ID' {alias=e, className=com.cox.ICOMSSecurityAudit.model.Employee, tableAlias=employee0_}
| | | | | | | \-[IDENT] IdentNode: 'icomsAudit' {originalText=icomsAudit}
| | | | | | \-[IDENT] IdentNode: 'auditId' {originalText=auditId}
| | | | | \-[DOT] DotNode: 'icomsaudit8_.AUDIT_ID' {propertyName=auditId,dereferenceType=4,propertyPath=auditId,path=ia.auditId,tableAlias=icomsaudit8_,className=com.cox.ICOMSSecurityAudit.model.IcomsAudit,classAlias=ia}
| | | | | +-[ALIAS_REF] IdentNode: 'icomsaudit8_.AUDIT_ID' {alias=ia, className=com.cox.ICOMSSecurityAudit.model.IcomsAudit, tableAlias=icomsaudit8_}
| | | | | \-[IDENT] IdentNode: 'auditId' {originalText=auditId}
| | | | \-[EQ] BinaryLogicOperatorNode: '='
| | | | +-[DOT] DotNode: 'tbuser1_.USERKEY' {propertyName=userkey,dereferenceType=4,propertyPath=userkey,path=tbu.userkey,tableAlias=tbuser1_,className=com.cox.ICOMSSecurityAudit.model.Tbuser,classAlias=tbu}
| | | | | +-[ALIAS_REF] IdentNode: 'tbuser1_.USERKEY' {alias=tbu, className=com.cox.ICOMSSecurityAudit.model.Tbuser, tableAlias=tbuser1_}
| | | | | \-[IDENT] IdentNode: 'userkey' {originalText=userkey}
| | | | \-[DOT] DotNode: 'tmuserbill2_.USERKEY' {propertyName=userkey,dereferenceType=4,propertyPath=userkey,path=tmub.userkey,tableAlias=tmuserbill2_,className=com.cox.ICOMSSecurityAudit.model.Tmuserbilling,classAlias=tmub}
| | | | +-[ALIAS_REF] IdentNode: 'tmuserbill2_.USERBILLINGKEY' {alias=tmub, className=com.cox.ICOMSSecurityAudit.model.Tmuserbilling, tableAlias=tmuserbill2_}
| | | | \-[IDENT] IdentNode: 'userkey' {originalText=userkey}
| | | \-[EQ] BinaryLogicOperatorNode: '='
| | | +-[DOT] DotNode: 'tmuserbill2_.BILLINGKEY' {propertyName=billingkey,dereferenceType=4,propertyPath=billingkey,path=tmub.billingkey,tableAlias=tmuserbill2_,className=com.cox.ICOMSSecurityAudit.model.Tmuserbilling,classAlias=tmub}
| | | | +-[ALIAS_REF] IdentNode: 'tmuserbill2_.USERBILLINGKEY' {alias=tmub, className=com.cox.ICOMSSecurityAudit.model.Tmuserbilling, tableAlias=tmuserbill2_}
| | | | \-[IDENT] IdentNode: 'billingkey' {originalText=billingkey}
| | | \-[DOT] DotNode: 'tbbilling3_.BILLINGKEY' {propertyName=billingkey,dereferenceType=4,propertyPath=billingkey,path=tbb.billingkey,tableAlias=tbbilling3_,className=com.cox.ICOMSSecurityAudit.model.Tbbilling,classAlias=tbb}
| | | +-[ALIAS_REF] IdentNode: 'tbbilling3_.BILLINGKEY' {alias=tbb, className=com.cox.ICOMSSecurityAudit.model.Tbbilling, tableAlias=tbbilling3_}
| | | \-[IDENT] IdentNode: 'billingkey' {originalText=billingkey}
| | \-[EQ] BinaryLogicOperatorNode: '='
| | +-[DOT] DotNode: 'tbuser1_.USERKEY' {propertyName=userkey,dereferenceType=4,propertyPath=userkey,path=tbu.userkey,tableAlias=tbuser1_,className=com.cox.ICOMSSecurityAudit.model.Tbuser,classAlias=tbu}
| | | +-[ALIAS_REF] IdentNode: 'tbuser1_.USERKEY' {alias=tbu, className=com.cox.ICOMSSecurityAudit.model.Tbuser, tableAlias=tbuser1_}
| | | \-[IDENT] IdentNode: 'userkey' {originalText=userkey}
| | \-[DOT] DotNode: 'tmusersupe5_.USERKEY' {propertyName=userkey,dereferenceType=4,propertyPath=userkey,path=tmus.userkey,tableAlias=tmusersupe5_,className=com.cox.ICOMSSecurityAudit.model.Tmusersupervisor,classAlias=tmus}
| | +-[ALIAS_REF] IdentNode: 'tmusersupe5_.USERSUPERVISORKEY' {alias=tmus, className=com.cox.ICOMSSecurityAudit.model.Tmusersupervisor, tableAlias=tmusersupe5_}
| | \-[IDENT] IdentNode: 'userkey' {originalText=userkey}
| \-[EQ] BinaryLogicOperatorNode: '='
| +-[DOT] DotNode: 'employee0_.EMPLOYEE_ID' {propertyName=employeeId,dereferenceType=4,propertyPath=employeeId,path=e.employeeId,tableAlias=employee0_,className=com.cox.ICOMSSecurityAudit.model.Employee,classAlias=e}
| | +-[ALIAS_REF] IdentNode: 'employee0_.EMPLOYEE_ID' {alias=e, className=com.cox.ICOMSSecurityAudit.model.Employee, tableAlias=employee0_}
| | \-[IDENT] IdentNode: 'employeeId' {originalText=employeeId}
| \-[DOT] DotNode: 'activity7_.EMPLOYEE_ID' {propertyName=employeeId,dereferenceType=4,propertyPath=employee.employeeId,path=a.employee.employeeId,tableAlias=activity7_,className=com.cox.ICOMSSecurityAudit.model.Activity,classAlias=a}
| +-[DOT] DotNode: 'activity7_.EMPLOYEE_ID' {propertyName=employeeId,dereferenceType=ROOT_LEVEL,propertyPath=employee.employeeId,path=a.employee,tableAlias=activity7_,className=com.cox.ICOMSSecurityAudit.model.Activity,classAlias=a}
| | +-[ALIAS_REF] IdentNode: 'activity7_.ACTIVITY_ID' {alias=a, className=com.cox.ICOMSSecurityAudit.model.Activity, tableAlias=activity7_}
| | \-[IDENT] IdentNode: 'employee' {originalText=employee}
| \-[IDENT] IdentNode: 'employeeId' {originalText=employeeId}
\-[EQ] BinaryLogicOperatorNode: '='
+-[DOT] DotNode: 'activity7_.ACTIVITY_ID' {propertyName=activityId,dereferenceType=4,propertyPath=activityId,path=a.activityId,tableAlias=activity7_,className=com.cox.ICOMSSecurityAudit.model.Activity,classAlias=a}
| +-[ALIAS_REF] IdentNode: 'activity7_.ACTIVITY_ID' {alias=a, className=com.cox.ICOMSSecurityAudit.model.Activity, tableAlias=activity7_}
| \-[IDENT] IdentNode: 'activityId' {originalText=activityId}
\-[DOT] DotNode: 'note6_.ACTIVITY_ID' {propertyName=activityId,dereferenceType=4,propertyPath=activity.activityId,path=n.activity.activityId,tableAlias=note6_,className=com.cox.ICOMSSecurityAudit.model.Note,classAlias=n}
+-[DOT] DotNode: 'note6_.ACTIVITY_ID' {propertyName=activityId,dereferenceType=ROOT_LEVEL,propertyPath=activity.activityId,path=n.activity,tableAlias=note6_,className=com.cox.ICOMSSecurityAudit.model.Note,classAlias=n}
| +-[ALIAS_REF] IdentNode: 'note6_.NOTE_ID' {alias=n, className=com.cox.ICOMSSecurityAudit.model.Note, tableAlias=note6_}
| \-[IDENT] IdentNode: 'activity' {originalText=activity}
\-[IDENT] IdentNode: 'activityId' {originalText=activityId}
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: SELECT e FROM com.cox.ICOMSSecurityAudit.model.Employee e, com.cox.ICOMSSecurityAudit.model.Tbuser tbu, com.cox.ICOMSSecurityAudit.model.Tmuserbilling tmub, com.cox.ICOMSSecurityAudit.model.Tbbilling tbb, com.cox.ICOMSSecurityAudit.model.AuditStatus ast, com.cox.ICOMSSecurityAudit.model.Tmusersupervisor tmus, com.cox.ICOMSSecurityAudit.model.Note n, com.cox.ICOMSSecurityAudit.model.Activity a, com.cox.ICOMSSecurityAudit.model.IcomsAudit ia WHERE e.idmUserId = tbu.userkey and e.auditStatus.auditStatusId = ast.auditStatusId and e.icomsAudit.auditId = ia.auditId and tbu.userkey = tmub.userkey and tmub.billingkey = tbb.billingkey and tbu.userkey = tmus.userkey and e.employeeId = a.employee.employeeId and a.activityId = n.activity.activityId
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select employee0_.EMPLOYEE_ID as EMPLOYEE1_64_, employee0_.AUDIT_ID as AUDIT3_64_, employee0_.AUDIT_STATUS_ID as AUDIT4_64_, employee0_.IDM_USER_ID as IDM2_64_ from EMPLOYEE employee0_, TBUSER tbuser1_, TMUSERBILLING tmuserbill2_, TBBILLING tbbilling3_, AUDIT_STATUS auditstatu4_, TMUSERSUPERVISOR tmusersupe5_, NOTE note6_, ACTIVITY activity7_, ICOMS_AUDIT icomsaudit8_ where employee0_.IDM_USER_ID=tbuser1_.USERKEY and employee0_.AUDIT_STATUS_ID=auditstatu4_.AUDIT_STATUS_ID and employee0_.AUDIT_ID=icomsaudit8_.AUDIT_ID and tbuser1_.USERKEY=tmuserbill2_.USERKEY and tmuserbill2_.BILLINGKEY=tbbilling3_.BILLINGKEY and tbuser1_.USERKEY=tmusersupe5_.USERKEY and employee0_.EMPLOYEE_ID=activity7_.EMPLOYEE_ID and activity7_.ACTIVITY_ID=note6_.ACTIVITY_ID
2008-04-03 11:37:15,269 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2008-04-03 11:37:15,284 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2008-04-03 11:37:15,284 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2008-04-03 11:37:15,284 DEBUG [org.hibernate.SQL]
select
employee0_.EMPLOYEE_ID as EMPLOYEE1_64_,
employee0_.AUDIT_ID as AUDIT3_64_,
employee0_.AUDIT_STATUS_ID as AUDIT4_64_,
employee0_.IDM_USER_ID as IDM2_64_
from
EMPLOYEE employee0_,
TBUSER tbuser1_,
TMUSERBILLING tmuserbill2_,
TBBILLING tbbilling3_,
AUDIT_STATUS auditstatu4_,
TMUSERSUPERVISOR tmusersupe5_,
NOTE note6_,
ACTIVITY activity7_,
ICOMS_AUDIT icomsaudit8_
where
employee0_.IDM_USER_ID=tbuser1_.USERKEY
and employee0_.AUDIT_STATUS_ID=auditstatu4_.AUDIT_STATUS_ID
and employee0_.AUDIT_ID=icomsaudit8_.AUDIT_ID
and tbuser1_.USERKEY=tmuserbill2_.USERKEY
and tmuserbill2_.BILLINGKEY=tbbilling3_.BILLINGKEY
and tbuser1_.USERKEY=tmusersupe5_.USERKEY
and employee0_.EMPLOYEE_ID=activity7_.EMPLOYEE_ID
and activity7_.ACTIVITY_ID=note6_.ACTIVITY_ID
2008-04-03 11:37:15,284 INFO [STDOUT] Hibernate:
select
employee0_.EMPLOYEE_ID as EMPLOYEE1_64_,
employee0_.AUDIT_ID as AUDIT3_64_,
employee0_.AUDIT_STATUS_ID as AUDIT4_64_,
employee0_.IDM_USER_ID as IDM2_64_
from
EMPLOYEE employee0_,
TBUSER tbuser1_,
TMUSERBILLING tmuserbill2_,
TBBILLING tbbilling3_,
AUDIT_STATUS auditstatu4_,
TMUSERSUPERVISOR tmusersupe5_,
NOTE note6_,
ACTIVITY activity7_,
ICOMS_AUDIT icomsaudit8_
where
employee0_.IDM_USER_ID=tbuser1_.USERKEY
and employee0_.AUDIT_STATUS_ID=auditstatu4_.AUDIT_STATUS_ID
and employee0_.AUDIT_ID=icomsaudit8_.AUDIT_ID
and tbuser1_.USERKEY=tmuserbill2_.USERKEY
and tmuserbill2_.BILLINGKEY=tbbilling3_.BILLINGKEY
and tbuser1_.USERKEY=tmusersupe5_.USERKEY
and employee0_.EMPLOYEE_ID=activity7_.EMPLOYEE_ID
and activity7_.ACTIVITY_ID=note6_.ACTIVITY_ID
2008-04-03 11:37:15,409 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2008-04-03 11:37:15,409 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2008-04-03 11:37:15,409 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2008-04-03 11:37:15,409 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
2008-04-03 11:37:15,409 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2008-04-03 11:37:15,409 DEBUG [org.hibernate.engine.StatefulPersistenceContext] initializing non-lazy collections
2008-04-03 11:37:15,409 DEBUG [org.jboss.seam.Component] instantiating Seam component: org.jboss.seam.core.interpolator
2008-04-03 11:37:15,409 DEBUG [org.jboss.seam.Component] initializing new instance of: org.jboss.seam.core.interpolator
2008-04-03 11:37:15,409 DEBUG [org.jboss.seam.Component] done initializing: org.jboss.seam.core.interpolator
2008-04-03 11:37:15,409 INFO [com.cox.ICOMSSecurityAudit.action.AuditedUsersSearchingAction] viewAuditUsersList.size() = 0
Login
FAQ
Search