I need to be able to ORDER BY the firstName, middleName, and lastName properties using one property 'fullName'. The mapping file below works without the "<properties name=fullName>" tag, but when I added the tag, the HQL "select count(*)" on the subclass "Staff" broke. See below...
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version: 3.1.2
Mapping documents:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Simplified version of my mapping file. -->
<hibernate-mapping>
<class name="com.nkics.socialworkprn.swan.domain.Resource" table="RESOURCE">
<cache usage="read-write"/>
<id name="id" type="int">
<column name="RESOURCE_ID" />
<generator class="native" />
</id>
<properties name="fullName">
<property name="firstName" type="string">
<column name="RESOURCE_FIRST_NAME" length="40" not-null="true" />
</property>
<property name="middleName" type="string">
<column name="RESOURCE_MIDDLE_NAME" length="40" />
</property>
<property name="lastName" type="string">
<column name="RESOURCE_LAST_NAME" length="40" not-null="true" />
</property>
</properties>
<joined-subclass name="com.nkics.socialworkprn.swan.domain.Staff" table="STAFF">
<key column="RESOURCE_ID" />
<property name="left" type="timestamp">
<column name="STAFF_LEFT" length="23" />
</property>
</joined-subclass>
</class>
</hibernate-mapping>
Code:
Query query = session.createQuery("from Resource as resource where ( upper(firstName) like '%T%' AND resource.class = Resource )"); // works fine
query.setFirstResult(20);
query.setMaxResults(10);
List results = query.list();
int classCount = (Integer)session.createQuery("select count(*) from Resource as resource where ( upper(firstName) like '%T%' )").uniqueResult(); // works fine
int subclassCount = (Integer)session.createQuery("select count(*) from Staff as staff where ( upper(firstName) like '%T%' )").uniqueResult(); // generates invalid SQL which causes a SQLException to be thrown.
int realResultCount = classCount - subclassCount;
Full stack trace of any exception that occurs:Code:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'RESOURCE_FIRST_NAME'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1129)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:749)
at com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil.getTotalResults(HibernateSearchUtil.java:304)
at com.nkics.socialworkprn.swan.persistence.hibernate.HibernateResourceDao.search(HibernateResourceDao.java:313)
at com.nkics.socialworkprn.swan.service.defaults.DefaultSearchService.candidateSearch(DefaultSearchService.java:109)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy13.candidateSearch(Unknown Source)
at com.nkics.socialworkprn.swan.mvc.search.provider.CandidateSearchProvider.search(CandidateSearchProvider.java:117)
at com.nkics.socialworkprn.swan.mvc.search.SearchController.updateCandidateSearchResults(SearchController.java:197)
at com.nkics.socialworkprn.swan.mvc.search.SearchController.onFormChange(SearchController.java:184)
at org.springframework.web.servlet.mvc.SimpleFormController.onFormChange(SimpleFormController.java:308)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:253)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:249)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:79)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:382)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:143)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:138)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:207)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
2006-11-20 13:35:32,319 ERROR [org.hibernate.util.JDBCExceptionReporter] logExceptions - Invalid column name 'RESOURCE_FIRST_NAME'.
2006-11-20 13:35:32,319 ERROR [com.nkics.socialworkprn.swan.persistence.hibernate.HibernateResourceDao] search - search failed
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1129)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:749)
at com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil.getTotalResults(HibernateSearchUtil.java:304)
at com.nkics.socialworkprn.swan.persistence.hibernate.HibernateResourceDao.search(HibernateResourceDao.java:313)
at com.nkics.socialworkprn.swan.service.defaults.DefaultSearchService.candidateSearch(DefaultSearchService.java:109)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy13.candidateSearch(Unknown Source)
at com.nkics.socialworkprn.swan.mvc.search.provider.CandidateSearchProvider.search(CandidateSearchProvider.java:117)
at com.nkics.socialworkprn.swan.mvc.search.SearchController.updateCandidateSearchResults(SearchController.java:197)
at com.nkics.socialworkprn.swan.mvc.search.SearchController.onFormChange(SearchController.java:184)
at org.springframework.web.servlet.mvc.SimpleFormController.onFormChange(SimpleFormController.java:308)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:253)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:249)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:79)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:382)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:143)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:138)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:207)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'RESOURCE_FIRST_NAME'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 72 more
Name and version of the database you are using: MS SQL Server Desktop Edition
The generated SQL (show_sql=true):Code:
Hibernate: select count(*) as col_0_0_ from STAFF staff0_ inner join RESOURCE staff0_1_ on staff0_.RESOURCE_ID=staff0_1_.RESOURCE_ID where upper(staff0_.RESOURCE_FIRST_NAME) like '%T%'
Debug level Hibernate log excerpt:
[code]2006-11-20 13:49:35,147 DEBUG [com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil] createFromHQL - START
2006-11-20 13:49:35,147 DEBUG [com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil] createFromHQL - Generated HQL: from Staff as staff
2006-11-20 13:49:35,147 DEBUG [com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil] createFromHQL - END
2006-11-20 13:49:35,147 DEBUG [com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil] createWhereHQL - START
2006-11-20 13:49:35,147 DEBUG [com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil] createWhereHQL - Generated HQL: where ( upper(firstName) like '%T%' )
2006-11-20 13:49:35,147 DEBUG [com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil] createWhereHQL - END
2006-11-20 13:49:35,147 DEBUG [com.nkics.socialworkprn.swan.persistence.hibernate.HibernateSearchUtil] getTotalResults - HQL: select count(*) from Staff as staff where ( upper(firstName) like '%T%' )
2006-11-20 13:49:35,147 DEBUG [org.hibernate.engine.query.QueryPlanCache] getHQLQueryPlan - unable to locate HQL query plan in cache; generating (select count(*) from Staff as staff where ( upper(firstName) like '%T%' ) )
2006-11-20 13:49:35,147 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse - parse() - HQL: select count(*) from com.nkics.socialworkprn.swan.domain.Staff as staff where ( upper(firstName) like '%T%' )
2006-11-20 13:49:35,163 DEBUG [org.hibernate.hql.ast.AST] showHqlAst - --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'from'
| | \-[RANGE] 'RANGE'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[IDENT] 'com'
| | | | | | | \-[IDENT] 'nkics'
| | | | | | \-[IDENT] 'socialworkprn'
| | | | | \-[IDENT] 'swan'
| | | | \-[IDENT] 'domain'
| | | \-[IDENT] 'Staff'
| | \-[ALIAS] 'staff'
| \-[SELECT] 'select'
| \-[COUNT] 'count'
| \-[ROW_STAR] '*'
\-[WHERE] 'where'
\-[LIKE] 'like'
+-[METHOD_CALL] '('
| +-[IDENT] 'upper'
| \-[EXPR_LIST] 'exprList'
| \-[IDENT] 'firstName'
\-[QUOTED_STRING] ''%T%''
2006-11-20 13:49:35,163 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException - throwQueryException() : no errors
2006-11-20 13:49:35,163 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] beforeStatement - select << begin [level=1, statement=select]
2006-11-20 13:49:35,179 DEBUG [org.hibernate.hql.ast.tree.FromElement] doInitialize - FromClause{level=1} : com.nkics.socialworkprn.swan.domain.Staff (staff) -> staff0_
2006-11-20 13:49:35,179 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] isNonQualifiedPropertyRef - attempting to resolve property [firstName] as a non-qualified ref
2006-11-20 13:49:35,179 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] setResolved - Resolved : {synthetic-alias} -> {synthetic-alias}
2006-11-20 13:49:35,179 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType - getDataType() : firstName -> org.hibernate.type.StringType@66db4e
2006-11-20 13:49:35,179 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] setResolved - Resolved : {synthetic-alias}.firstName -> staff0_.RESOURCE_FIRST_NAME
2006-11-20 13:49:35,179 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] beforeStatementCompletion - select : finishing up [level=1, statement=select]
2006-11-20 13:49:35,179 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery - processQuery() : ( SELECT ( {select clause} ( count * ) ) ( FromClause{level=1} STAFF staff0_ ) ( where ( like ( ( upper ( exprList ( staff0_.RESOURCE_FIRST_NAME {synthetic-alias} firstName ) ) ) '%T%' ) ) )
2006-11-20 13:49:35,194 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] addJoinNodes - Using FROM fragment [STAFF staff0_ inner join RESOURCE staff0_1_ on staff0_.RESOURCE_ID=staff0_1_.RESOURCE_ID]
2006-11-20 13:49:35,194 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] afterStatementCompletion - select >> end [level=1, statement=select]
2006-11-20 13:49:35,194 DEBUG [org.hibernate.hql.ast.AST] analyze - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (STAFF,RESOURCE)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[COUNT] CountNode: 'count'
| | \-[ROW_STAR] SqlNode: '*'
| \-[SELECT_COLUMNS] SqlNode: ' as col_0_0_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[staff], fromElementByTableAlias=[staff0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'STAFF staff0_ inner join RESOURCE staff0_1_ on staff0_.RESOURCE_ID=staff0_1_.RESOURCE_ID' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=staff,role=null,tableName=STAFF,tableAlias=staff0_,origin=null,colums={,className=com.nkics.socialworkprn.swan.domain.Staff}}
\-[WHERE] SqlNode: 'where'
\-[LIKE] BinaryLogicOperatorNode: 'like'
+-[METHOD_CALL] MethodNode: '('
| +-[METHOD_NAME] IdentNode: 'upper' {originalText=upper}
| \-[EXPR_LIST] SqlNode: 'exprList'
| \-[DOT] DotNode: 'staff0_.RESOURCE_FIRST_NAME' {propertyName=firstName,dereferenceType=4,propertyPath=firstName,path={synthetic-alias}.firstName,tableAlias=staff0_,className=com.nkics.socialworkprn.swan.domain.Staff,classAlias=staff}
| +-[IDENT] IdentNode: '{synthetic-alias}' {originalText={synthetic-alias}}
| \-[IDENT] IdentNode: 'firstName' {originalText=firstName}
\-[QUOTED_STRING] LiteralNode: ''%T%''
2006-11-20 13:49:35,194 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException - throwQueryException() : no errors
2006-11-20 13:49:35,194 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] generate - HQL: select count(*) from com.nkics.socialworkprn.swan.domain.Staff as staff where ( upper(firstName) like '%T%' )
2006-11-20 13:49:35,194 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] generate - SQL: select count(*) as col_0_0_ from STAFF staff0_ inner join RESOURCE staff0_1_ on staff0_.RESOURCE_ID=staff0_1_.RESOURCE_ID where upper(staff0_.RESOURCE_FIRST_NAME) like '%T%'
2006-11-20 13:49:35,194 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException - throwQueryException() : no errors
2006-11-20 13:49:35,194 DEBUG [org.hibernate.engine.query.HQLQueryPlan] buildParameterMetadata - HQL param location recognition took 0 mills (select count(*) from Staff as staff where ( upper(firstName) like '%T%' ) )
2006-11-20 13:49:35,194 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] flushEverythingToExecutions - flushing session
2006-11-20 13:49:35,194 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] prepareEntityFlushes - processing flush-time cascades
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.Cascade] cascade - processing cascade ACTION_SAVE_UPDATE for: com.nkics.socialworkprn.swan.domain.Resource
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.CascadingAction] cascade - cascading to saveOrUpdate: com.nkics.socialworkprn.swan.domain.User
2006-11-20 13:49:35,210 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] getEntityState - persistent instance of: com.nkics.socialworkprn.swan.domain.User
2006-11-20 13:49:35,210 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] entityIsPersistent - ignoring persistent instance
2006-11-20 13:49:35,210 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] entityIsPersistent - object already associated with session: [com.nkics.socialworkprn.swan.domain.User#16]
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.activities
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.activities
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.dayOfWeeks
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.dayOfWeeks
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.experiences
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.experiences
2006-11-20 13:49:35,210 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.languages
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.languages
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,226 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,241 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascade - done processing cascade ACTION_SAVE_UPDATE for: com.nkics.socialworkprn.swan.domain.Resource
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascade - processing cascade ACTION_SAVE_UPDATE for: com.nkics.socialworkprn.swan.domain.Resource
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.CascadingAction] cascade - cascading to saveOrUpdate: com.nkics.socialworkprn.swan.domain.User
2006-11-20 13:49:35,257 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] getEntityState - persistent instance of: com.nkics.socialworkprn.swan.domain.User
2006-11-20 13:49:35,257 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] entityIsPersistent - ignoring persistent instance
2006-11-20 13:49:35,257 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] entityIsPersistent - object already associated with session: [com.nkics.socialworkprn.swan.domain.User#50]
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.activities
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.activities
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.dayOfWeeks
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.dayOfWeeks
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.experiences
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.experiences
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.languages
2006-11-20 13:49:35,257 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.languages
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,272 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascade - done processing cascade ACTION_SAVE_UPDATE for: com.nkics.socialworkprn.swan.domain.Resource
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.Cascade] cascade - processing cascade ACTION_SAVE_UPDATE for: com.nkics.socialworkprn.swan.domain.Resource
2006-11-20 13:49:35,288 DEBUG [org.hibernate.engine.CascadingAction] cascade - cascading to saveOrUpdate: com.nkics.socialworkprn.swan.domain.User
2006-11-20 13:49:35,304 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] getEntityState - persistent instance of: com.nkics.socialworkprn.swan.domain.User
2006-11-20 13:49:35,304 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] entityIsPersistent - ignoring persistent instance
2006-11-20 13:49:35,304 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] entityIsPersistent - object already associated with session: [com.nkics.socialworkprn.swan.domain.User#51]
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.activities
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.activities
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.dayOfWeeks
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.dayOfWeeks
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.experiences
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.experiences
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.languages
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.languages
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,304 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,319 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,335 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascade - done processing cascade ACTION_SAVE_UPDATE for: com.nkics.socialworkprn.swan.domain.Resource
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascade - processing cascade ACTION_SAVE_UPDATE for: com.nkics.socialworkprn.swan.domain.Resource
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.CascadingAction] cascade - cascading to saveOrUpdate: com.nkics.socialworkprn.swan.domain.User
2006-11-20 13:49:35,351 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] getEntityState - persistent instance of: com.nkics.socialworkprn.swan.domain.User
2006-11-20 13:49:35,351 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] entityIsPersistent - ignoring persistent instance
2006-11-20 13:49:35,351 DEBUG [org.hibernate.event.def.DefaultSaveOrUpdateEventListener] entityIsPersistent - object already associated with session: [com.nkics.socialworkprn.swan.domain.User#53]
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.activities
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.activities
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.dayOfWeeks
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.dayOfWeeks
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.experiences
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.experiences
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.languages
2006-11-20 13:49:35,351 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.languages
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourcePhones
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.interviews
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceMeetings
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.workHistories
2006-11-20 13:49:35,366 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.educationHistories
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.resourceStateCredentials
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done cascade ACTION_SAVE_UPDATE for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascadeCollectionElements - done deleting orphans for collection: com.nkics.socialworkprn.swan.domain.Resource.references
2006-11-20 13:49:35,382 DEBUG [org.hibernate.engine.Cascade] cascade - done processing cascade ACTION_SAVE_UPDATE for: com.nkics.socialworkprn.swan.domain.Resource
2006-11-20 13:49:35,382 DEB
Login
FAQ
Search
