Hibernate version:3.0
I just upgraded to Hibernate 3. For some reason I am having a problem with a Query that always returns a "Session closed" error. I have gone as far as checking that my session is connection (session.isConnected) and also that it is open (session.isOpen). Both are true just before I run my query. Any ideas?
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" >
<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1
http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->
<class
name="com.sys.dao.bean.TdocumtBean"
table="@TDOCUMT"
mutable="false"
>
<id name="xdid" column="@XDID#" unsaved-value="0">
<generator class="assigned">
</generator>
</id>
<property
name="xdact"
column="@XDACT"
type="java.lang.Integer"
length="6"
/>
<many-to-one
name="mastdocBean"
column="@XDDR#"
class="com.sys.dao.bean.MastdocBean"
unique="true"/>
<many-to-one
name="tmpmstBean"
column="@XDTEM"
class="com.sys.dao.bean.TmpmstBean"
unique="true"/>
.... other mappings
Code:
Here is the hibernate log from the beginning of the sessionCode:
21 Apr 2005 13:04:56,172 DEBUG http-8180-Processor25 org.hibernate.impl.SessionImpl - opened session at timestamp: 4563366281920512
21 Apr 2005 13:04:56,172 DEBUG http-8180-Processor25 org.hibernate.impl.SessionImpl - find: FROM com.sys.dao.bean.TdocumtBean as tdocumtBean left join fetch tdocumtBean.mastdocBean left join fetch tdocumtBean.tmpmstBean WHERE tdocumtBean.xdact = :acct0 AND tdocumtBean.xdpat = :pat0 Order by tdocumtBean.xddat DESC
21 Apr 2005 13:04:56,188 DEBUG http-8180-Processor25 org.hibernate.engine.QueryParameters - named parameters: {acct0=145674, pat0=1}
21 Apr 2005 13:04:56,188 DEBUG http-8180-Processor25 org.hibernate.hql.ast.QueryTranslatorImpl - parse() - HQL: FROM com.sys.dao.bean.TdocumtBean as tdocumtBean left join fetch tdocumtBean.mastdocBean left join fetch tdocumtBean.tmpmstBean WHERE tdocumtBean.xdact = :acct0 AND tdocumtBean.xdpat = :pat0 Order by tdocumtBean.xddat DESC
21 Apr 2005 13:04:56,235 DEBUG http-8180-Processor25 org.hibernate.hql.AST - --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| \-[FROM] 'FROM'
| +-[DOT] '.'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[IDENT] 'com'
| | | | | \-[IDENT] 'sys'
| | | | \-[IDENT] 'dao'
| | | \-[IDENT] 'bean'
| | \-[IDENT] 'TdocumtBean'
| +-[ALIAS] 'tdocumtBean'
| +-[JOIN] 'join'
| | +-[LEFT] 'left'
| | +-[FETCH] 'fetch'
| | \-[DOT] '.'
| | +-[IDENT] 'tdocumtBean'
| | \-[IDENT] 'mastdocBean'
| \-[JOIN] 'join'
| +-[LEFT] 'left'
| +-[FETCH] 'fetch'
| \-[DOT] '.'
| +-[IDENT] 'tdocumtBean'
| \-[IDENT] 'tmpmstBean'
+-[WHERE] 'WHERE'
| \-[AND] 'AND'
| +-[EQ] '='
| | +-[DOT] '.'
| | | +-[IDENT] 'tdocumtBean'
| | | \-[IDENT] 'xdact'
| | \-[COLON] ':'
| | \-[IDENT] 'acct0'
| \-[EQ] '='
| +-[DOT] '.'
| | +-[IDENT] 'tdocumtBean'
| | \-[IDENT] 'xdpat'
| \-[COLON] ':'
| \-[IDENT] 'pat0'
\-[ORDER] 'Order'
+-[DOT] '.'
| +-[IDENT] 'tdocumtBean'
| \-[IDENT] 'xddat'
\-[DESCENDING] 'DESC'
21 Apr 2005 13:04:56,235 DEBUG http-8180-Processor25 org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
21 Apr 2005 13:04:56,235 DEBUG http-8180-Processor25 org.hibernate.hql.antlr.HqlSqlBaseWalker - query() << begin, level = 1
21 Apr 2005 13:04:56,235 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromElement - FromClause{level=1} : com.sys.dao.bean.TdocumtBean (tdocumtBean) -> tdocumtbea0_
21 Apr 2005 13:04:56,235 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean -> tdocumtbea0_.@XDID#
21 Apr 2005 13:04:56,235 DEBUG http-8180-Processor25 org.hibernate.hql.ast.DotNode - getDataType() : mastdocBean -> org.hibernate.type.ManyToOneType(com.sys.dao.bean.MastdocBean)
21 Apr 2005 13:04:56,235 DEBUG http-8180-Processor25 org.hibernate.hql.ast.DotNode - dereferenceEntityJoin() : generating join for mastdocBean in com.sys.dao.bean.TdocumtBean {no alias} parent = [ {null} ]
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromElement - FromClause{level=1} : com.sys.dao.bean.MastdocBean (no alias) -> mastdocbea1_
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromClause - addJoinByPathMap() : tdocumtBean.mastdocBean -> @MASTDOC mastdocbea1_
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean.mastdocBean -> tdocumtbea0_.@XDDR#
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.HqlSqlWalker - createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: '@MASTDOC mastdocbea1_' FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=@MASTDOC,tableAlias=mastdocbea1_,colums={tdocumtbea0_.@XDDR# ,className=com.sys.dao.bean.MastdocBean}}
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean -> tdocumtbea0_.@XDID#
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.DotNode - getDataType() : tmpmstBean -> org.hibernate.type.ManyToOneType(com.sys.dao.bean.TmpmstBean)
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.DotNode - dereferenceEntityJoin() : generating join for tmpmstBean in com.sys.dao.bean.TdocumtBean {no alias} parent = [ {null} ]
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromElement - FromClause{level=1} : com.sys.dao.bean.TmpmstBean (no alias) -> tmpmstbean2_
21 Apr 2005 13:04:56,250 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromClause - addJoinByPathMap() : tdocumtBean.tmpmstBean -> @TMPMST tmpmstbean2_
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean.tmpmstBean -> tdocumtbea0_.@XDTEM
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.HqlSqlWalker - createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: '@TMPMST tmpmstbean2_' FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=@TMPMST,tableAlias=tmpmstbean2_,colums={tdocumtbea0_.@XDTEM ,className=com.sys.dao.bean.TmpmstBean}}
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean -> tdocumtbea0_.@XDID#
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.DotNode - getDataType() : xdact -> org.hibernate.type.IntegerType@1ece626
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean.xdact -> tdocumtbea0_.@XDACT
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean -> tdocumtbea0_.@XDID#
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.DotNode - getDataType() : xdpat -> org.hibernate.type.IntegerType@1ece626
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean.xdpat -> tdocumtbea0_.@XDPAT
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean -> tdocumtbea0_.@XDID#
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.DotNode - getDataType() : xddat -> org.hibernate.type.IntegerType@1ece626
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.FromReferenceNode - Resolved : tdocumtBean.xddat -> tdocumtbea0_.@XDDAT
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.antlr.HqlSqlBaseWalker - query() : finishing up , level = 1
21 Apr 2005 13:04:56,266 DEBUG http-8180-Processor25 org.hibernate.hql.ast.HqlSqlWalker - processQuery() : ( SELECT ( FromClause{level=1} ( @TDOCUMT tdocumtbea0_ @MASTDOC mastdocbea1_ @TMPMST tmpmstbean2_ ) ) ( WHERE ( AND ( = ( tdocumtbea0_.@XDACT tdocumtbea0_.@XDID# xdact ) ? ) ( = ( tdocumtbea0_.@XDPAT tdocumtbea0_.@XDID# xdpat ) ? ) ) ) ( Order ( tdocumtbea0_.@XDDAT tdocumtbea0_.@XDID# xddat ) DESC ) )
21 Apr 2005 13:04:56,281 DEBUG http-8180-Processor25 org.hibernate.hql.ast.HqlSqlWalker - Derived SELECT clause created.
21 Apr 2005 13:04:56,281 DEBUG http-8180-Processor25 org.hibernate.hql.ast.JoinProcessor - Using FROM fragment [left outer join @TMPMST tmpmstbean2_ on tdocumtbea0_.@XDTEM=tmpmstbean2_.@XPCOD]
21 Apr 2005 13:04:56,281 DEBUG http-8180-Processor25 org.hibernate.hql.ast.JoinProcessor - Using FROM fragment [left outer join @MASTDOC mastdocbea1_ on tdocumtbea0_.@XDDR#=mastdocbea1_.@MDOC#]
21 Apr 2005 13:04:56,281 DEBUG http-8180-Processor25 org.hibernate.hql.ast.JoinProcessor - Using FROM fragment [@TDOCUMT tdocumtbea0_]
21 Apr 2005 13:04:56,281 DEBUG http-8180-Processor25 org.hibernate.hql.antlr.HqlSqlBaseWalker - query() >> end, level = 1
21 Apr 2005 13:04:56,313 DEBUG http-8180-Processor25 org.hibernate.hql.AST - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (@TMPMST,@MASTDOC,@TDOCUMT)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'tdocumtbea0_.@XDID# as column1_0_' {FromElement{explicit,not a collection join,classAlias=tdocumtBean,role=null,tableName=@TDOCUMT,tableAlias=tdocumtbea0_,colums={,className=com.sys.dao.bean.TdocumtBean}}}
| +-[SELECT_EXPR] SelectExpressionImpl: 'mastdocbea1_.@MDOC# as column1_1_' {FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=@MASTDOC,tableAlias=mastdocbea1_,colums={tdocumtbea0_.@XDDR# ,className=com.sys.dao.bean.MastdocBean}}}
| +-[SELECT_EXPR] SelectExpressionImpl: 'tmpmstbean2_.@XPCOD as column1_2_' {FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=@TMPMST,tableAlias=tmpmstbean2_,colums={tdocumtbea0_.@XDTEM ,className=com.sys.dao.bean.TmpmstBean}}}
| +-[SQL_TOKEN] SqlFragment: 'tdocumtbea0_.@XDACT as column2_11_0_, tdocumtbea0_.@XDDR# as column3_11_0_, tdocumtbea0_.@XDTEM as column4_11_0_, tdocumtbea0_.@XDPAT as column5_11_0_, tdocumtbea0_.@XDDAT as column6_11_0_, tdocumtbea0_.@XDTIM as column7_11_0_, tdocumtbea0_.@XDSLP as column8_11_0_, tdocumtbea0_.@XDLOC as column9_11_0_, tdocumtbea0_.@XDATY as column10_11_0_, tdocumtbea0_.@XDCAS as column11_11_0_, tdocumtbea0_.@XDCID as column12_11_0_, tdocumtbea0_.@XDUSR as column13_11_0_, tdocumtbea0_.@XDTDT as column14_11_0_, tdocumtbea0_.@XDTTM as column15_11_0_, tdocumtbea0_.@XDDUR as column16_11_0_, tdocumtbea0_.@XDWRD as column17_11_0_, tdocumtbea0_.@XDTWC as column18_11_0_, tdocumtbea0_.@XDCHR as column19_11_0_, tdocumtbea0_.@XDSTS as column20_11_0_, tdocumtbea0_.@XDACD as column21_11_0_, tdocumtbea0_.@XDADT as column22_11_0_, tdocumtbea0_.@XDSEC as column23_11_0_, tdocumtbea0_.@XDFNM as column24_11_0_, tdocumtbea0_.@XDFLC as column25_11_0_, tdocumtbea0_.@XDVER as column26_11_0_, tdocumtbea0_.@XCHGI as column27_11_0_, tdocumtbea0_.@XTFLC as column28_11_0_, tdocumtbea0_.@XMSC1 as column29_11_0_, tdocumtbea0_.@XMSC2 as column30_11_0_, tdocumtbea0_.@XMSC3 as column31_11_0_'
| +-[SQL_TOKEN] SqlFragment: 'mastdocbea1_.@MNAME as column2_10_1_, mastdocbea1_.@MFNAM as column3_10_1_, mastdocbea1_.@MMIDI as column4_10_1_, mastdocbea1_.@MLNAM as column5_10_1_, mastdocbea1_.@MINIT as column6_10_1_, mastdocbea1_.@MPTYP as column7_10_1_, mastdocbea1_.@MAAPS as column8_10_1_, mastdocbea1_.@MASNM as column9_10_1_, mastdocbea1_.@MLIC# as column10_10_1_, mastdocbea1_.@MMCR# as column11_10_1_, mastdocbea1_.@MMCD# as column12_10_1_, mastdocbea1_.@MPHP# as column13_10_1_, mastdocbea1_.@MLOC as column14_10_1_, mastdocbea1_.@MDIV as column15_10_1_, mastdocbea1_.@MHPHN as column16_10_1_, mastdocbea1_.@MWPHN as column17_10_1_, mastdocbea1_.@MEXTN as column18_10_1_, mastdocbea1_.@MSDAT as column19_10_1_, mastdocbea1_.@MPDAT as column20_10_1_, mastdocbea1_.@MVRUN as column21_10_1_, mastdocbea1_.@MINTV as column22_10_1_, mastdocbea1_.@MMAXP as column23_10_1_, mastdocbea1_.@MSPCT as column24_10_1_, mastdocbea1_.@MPCT2 as column25_10_1_, mastdocbea1_.@MPCT3 as column26_10_1_, mastdocbea1_.@MPCT4 as column27_10_1_, mastdocbea1_.@MPCT5 as column28_10_1_, mastdocbea1_.@MPCT6 as column29_10_1_, mastdocbea1_.@MDOF1 as column30_10_1_, mastdocbea1_.@MDOF2 as column31_10_1_, mastdocbea1_.@MDOF3 as column32_10_1_, mastdocbea1_.@MDOF4 as column33_10_1_, mastdocbea1_.@MDOF5 as column34_10_1_, mastdocbea1_.@MDOF6 as column35_10_1_, mastdocbea1_.@MDOF7 as column36_10_1_, mastdocbea1_.@MBOOK as column37_10_1_, mastdocbea1_.@MVSLP as column38_10_1_, mastdocbea1_.@MATRN as column39_10_1_, mastdocbea1_.@MACID as column40_10_1_, mastdocbea1_.@MSTAT as column41_10_1_, mastdocbea1_.@MSPEC as column42_10_1_, mastdocbea1_.@MNPI# as column43_10_1_, mastdocbea1_.@MDEA# as column44_10_1_, mastdocbea1_.@MSSN# as column45_10_1_, mastdocbea1_.@MFLG as column46_10_1_, mastdocbea1_.@MSREQ as column47_10_1_, mastdocbea1_.@MPTOP as column48_10_1_, mastdocbea1_.@MPINH as column49_10_1_, mastdocbea1_.@MPRTY as column50_10_1_, mastdocbea1_.@MHOSP as column51_10_1_, mastdocbea1_.@MCELL as column52_10_1_, mastdocbea1_.@MPAGE as column53_10_1_, mastdocbea1_.@MBCS# as column54_10_1_, mastdocbea1_.@MF01 as column55_10_1_, mastdocbea1_.@MF02 as column56_10_1_, mastdocbea1_.@MF03 as column57_10_1_, mastdocbea1_.@MF04 as column58_10_1_, mastdocbea1_.@MF05 as column59_10_1_, mastdocbea1_.@MF06 as column60_10_1_, mastdocbea1_.@MTAX2 as column61_10_1_'
| \-[SQL_TOKEN] SqlFragment: 'tmpmstbean2_.@XPDSC as column2_13_2_, tmpmstbean2_.@XPFNM as column3_13_2_, tmpmstbean2_.@XPPFC as column4_13_2_, tmpmstbean2_.@XPTLC as column5_13_2_, tmpmstbean2_.@XPFLC as column6_13_2_, tmpmstbean2_.@XPXLC as column7_13_2_, tmpmstbean2_.@XPFTY as column8_13_2_, tmpmstbean2_.@XPTVW as column9_13_2_, tmpmstbean2_.@XPVER as column10_13_2_, tmpmstbean2_.@XPWRD as column11_13_2_, tmpmstbean2_.@XPCHR as column12_13_2_, tmpmstbean2_.@XPSEC as column13_13_2_, tmpmstbean2_.@XPDST as column14_13_2_, tmpmstbean2_.@XPRDC as column15_13_2_, tmpmstbean2_.@XPRID as column16_13_2_, tmpmstbean2_.@XPDEL as column17_13_2_'
+-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=3, fromElements=3, fromElementByClassAlias=[tdocumtBean], fromElementByTableAlias=[mastdocbea1_, tmpmstbean2_, tdocumtbea0_], fromElementsByPath=[tdocumtBean.mastdocBean, tdocumtBean.tmpmstBean], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: '@TDOCUMT tdocumtbea0_' FromElement{explicit,not a collection join,classAlias=tdocumtBean,role=null,tableName=@TDOCUMT,tableAlias=tdocumtbea0_,colums={,className=com.sys.dao.bean.TdocumtBean}}
| +-[JOIN_FRAGMENT] FromElement: 'left outer join @MASTDOC mastdocbea1_ on tdocumtbea0_.@XDDR#=mastdocbea1_.@MDOC#' FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=@MASTDOC,tableAlias=mastdocbea1_,colums={tdocumtbea0_.@XDDR# ,className=com.sys.dao.bean.MastdocBean}}
| \-[JOIN_FRAGMENT] FromElement: 'left outer join @TMPMST tmpmstbean2_ on tdocumtbea0_.@XDTEM=tmpmstbean2_.@XPCOD' FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=@TMPMST,tableAlias=tmpmstbean2_,colums={tdocumtbea0_.@XDTEM ,className=com.sys.dao.bean.TmpmstBean}}
+-[WHERE] SqlNode: 'WHERE'
| \-[AND] SqlNode: 'AND'
| +-[EQ] SqlNode: '='
| | +-[DOT] DotNode: 'tdocumtbea0_.@XDACT' {propertyName=xdact,dereferenceType=4,propertyPath=xdact,path=tdocumtBean.xdact,tableAlias=tdocumtbea0_,className=com.sys.dao.bean.TdocumtBean,classAlias=tdocumtBean}
| | | +-[ALIAS_REF] IdentNode: 'tdocumtbea0_.@XDID#' {alias=tdocumtBean, className=com.sys.dao.bean.TdocumtBean, tableAlias=tdocumtbea0_}
| | | \-[IDENT] IdentNode: 'xdact' {originalText=xdact}
| | \-[NAMED_PARAM] SqlNode: '?'
| \-[EQ] SqlNode: '='
| +-[DOT] DotNode: 'tdocumtbea0_.@XDPAT' {propertyName=xdpat,dereferenceType=4,propertyPath=xdpat,path=tdocumtBean.xdpat,tableAlias=tdocumtbea0_,className=com.sys.dao.bean.TdocumtBean,classAlias=tdocumtBean}
| | +-[ALIAS_REF] IdentNode: 'tdocumtbea0_.@XDID#' {alias=tdocumtBean, className=com.sys.dao.bean.TdocumtBean, tableAlias=tdocumtbea0_}
| | \-[IDENT] IdentNode: 'xdpat' {originalText=xdpat}
| \-[NAMED_PARAM] SqlNode: '?'
\-[ORDER] OrderByClause: 'Order'
+-[DOT] DotNode: 'tdocumtbea0_.@XDDAT' {propertyName=xddat,dereferenceType=4,propertyPath=xddat,path=tdocumtBean.xddat,tableAlias=tdocumtbea0_,className=com.sys.dao.bean.TdocumtBean,classAlias=tdocumtBean}
| +-[ALIAS_REF] IdentNode: 'tdocumtbea0_.@XDID#' {alias=tdocumtBean, className=com.sys.dao.bean.TdocumtBean, tableAlias=tdocumtbea0_}
| \-[IDENT] IdentNode: 'xddat' {originalText=xddat}
\-[DESCENDING] SqlNode: 'DESC'
21 Apr 2005 13:04:56,328 DEBUG http-8180-Processor25 org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
21 Apr 2005 13:04:56,328 DEBUG http-8180-Processor25 org.hibernate.hql.ast.QueryTranslatorImpl - HQL: FROM com.sys.dao.bean.TdocumtBean as tdocumtBean left join fetch tdocumtBean.mastdocBean left join fetch tdocumtBean.tmpmstBean WHERE tdocumtBean.xdact = :acct0 AND tdocumtBean.xdpat = :pat0 Order by tdocumtBean.xddat DESC
21 Apr 2005 13:04:56,328 DEBUG http-8180-Processor25 org.hibernate.hql.ast.QueryTranslatorImpl - SQL: select tdocumtbea0_.@XDID# as column1_0_, mastdocbea1_.@MDOC# as column1_1_, tmpmstbean2_.@XPCOD as column1_2_, tdocumtbea0_.@XDACT as column2_11_0_, tdocumtbea0_.@XDDR# as column3_11_0_, tdocumtbea0_.@XDTEM as column4_11_0_, tdocumtbea0_.@XDPAT as column5_11_0_, tdocumtbea0_.@XDDAT as column6_11_0_, tdocumtbea0_.@XDTIM as column7_11_0_, tdocumtbea0_.@XDSLP as column8_11_0_, tdocumtbea0_.@XDLOC as column9_11_0_, tdocumtbea0_.@XDATY as column10_11_0_, tdocumtbea0_.@XDCAS as column11_11_0_, tdocumtbea0_.@XDCID as column12_11_0_, tdocumtbea0_.@XDUSR as column13_11_0_, tdocumtbea0_.@XDTDT as column14_11_0_, tdocumtbea0_.@XDTTM as column15_11_0_, tdocumtbea0_.@XDDUR as column16_11_0_, tdocumtbea0_.@XDWRD as column17_11_0_, tdocumtbea0_.@XDTWC as column18_11_0_, tdocumtbea0_.@XDCHR as column19_11_0_, tdocumtbea0_.@XDSTS as column20_11_0_, tdocumtbea0_.@XDACD as column21_11_0_, tdocumtbea0_.@XDADT as column22_11_0_, tdocumtbea0_.@XDSEC as column23_11_0_, tdocumtbea0_.@XDFNM as column24_11_0_, tdocumtbea0_.@XDFLC as column25_11_0_, tdocumtbea0_.@XDVER as column26_11_0_, tdocumtbea0_.@XCHGI as column27_11_0_, tdocumtbea0_.@XTFLC as column28_11_0_, tdocumtbea0_.@XMSC1 as column29_11_0_, tdocumtbea0_.@XMSC2 as column30_11_0_, tdocumtbea0_.@XMSC3 as column31_11_0_, mastdocbea1_.@MNAME as column2_10_1_, mastdocbea1_.@MFNAM as column3_10_1_, mastdocbea1_.@MMIDI as column4_10_1_, mastdocbea1_.@MLNAM as column5_10_1_, mastdocbea1_.@MINIT as column6_10_1_, mastdocbea1_.@MPTYP as column7_10_1_, mastdocbea1_.@MAAPS as column8_10_1_, mastdocbea1_.@MASNM as column9_10_1_, mastdocbea1_.@MLIC# as column10_10_1_, mastdocbea1_.@MMCR# as column11_10_1_, mastdocbea1_.@MMCD# as column12_10_1_, mastdocbea1_.@MPHP# as column13_10_1_, mastdocbea1_.@MLOC as column14_10_1_, mastdocbea1_.@MDIV as column15_10_1_, mastdocbea1_.@MHPHN as column16_10_1_, mastdocbea1_.@MWPHN as column17_10_1_, mastdocbea1_.@MEXTN as column18_10_1_, mastdocbea1_.@MSDAT as column19_10_1_, mastdocbea1_.@MPDAT as column20_10_1_, mastdocbea1_.@MVRUN as column21_10_1_, mastdocbea1_.@MINTV as column22_10_1_, mastdocbea1_.@MMAXP as column23_10_1_, mastdocbea1_.@MSPCT as column24_10_1_, mastdocbea1_.@MPCT2 as column25_10_1_, mastdocbea1_.@MPCT3 as column26_10_1_, mastdocbea1_.@MPCT4 as column27_10_1_, mastdocbea1_.@MPCT5 as column28_10_1_, mastdocbea1_.@MPCT6 as column29_10_1_, mastdocbea1_.@MDOF1 as column30_10_1_, mastdocbea1_.@MDOF2 as column31_10_1_, mastdocbea1_.@MDOF3 as column32_10_1_, mastdocbea1_.@MDOF4 as column33_10_1_, mastdocbea1_.@MDOF5 as column34_10_1_, mastdocbea1_.@MDOF6 as column35_10_1_, mastdocbea1_.@MDOF7 as column36_10_1_, mastdocbea1_.@MBOOK as column37_10_1_, mastdocbea1_.@MVSLP as column38_10_1_, mastdocbea1_.@MATRN as column39_10_1_, mastdocbea1_.@MACID as column40_10_1_, mastdocbea1_.@MSTAT as column41_10_1_, mastdocbea1_.@MSPEC as column42_10_1_, mastdocbea1_.@MNPI# as column43_10_1_, mastdocbea1_.@MDEA# as column44_10_1_, mastdocbea1_.@MSSN# as column45_10_1_, mastdocbea1_.@MFLG as column46_10_1_, mastdocbea1_.@MSREQ as column47_10_1_, mastdocbea1_.@MPTOP as column48_10_1_, mastdocbea1_.@MPINH as column49_10_1_, mastdocbea1_.@MPRTY as column50_10_1_, mastdocbea1_.@MHOSP as column51_10_1_, mastdocbea1_.@MCELL as column52_10_1_, mastdocbea1_.@MPAGE as column53_10_1_, mastdocbea1_.@MBCS# as column54_10_1_, mastdocbea1_.@MF01 as column55_10_1_, mastdocbea1_.@MF02 as column56_10_1_, mastdocbea1_.@MF03 as column57_10_1_, mastdocbea1_.@MF04 as column58_10_1_, mastdocbea1_.@MF05 as column59_10_1_, mastdocbea1_.@MF06 as column60_10_1_, mastdocbea1_.@MTAX2 as column61_10_1_, tmpmstbean2_.@XPDSC as column2_13_2_, tmpmstbean2_.@XPFNM as column3_13_2_, tmpmstbean2_.@XPPFC as column4_13_2_, tmpmstbean2_.@XPTLC as column5_13_2_, tmpmstbean2_.@XPFLC as column6_13_2_, tmpmstbean2_.@XPXLC as column7_13_2_, tmpmstbean2_.@XPFTY as column8_13_2_, tmpmstbean2_.@XPTVW as column9_13_2_, tmpmstbean2_.@XPVER as column10_13_2_, tmpmstbean2_.@XPWRD as column11_13_2_, tmpmstbean2_.@XPCHR as column12_13_2_, tmpmstbean2_.@XPSEC as column13_13_2_, tmpmstbean2_.@XPDST as column14_13_2_, tmpmstbean2_.@XPRDC as column15_13_2_, tmpmstbean2_.@XPRID as column16_13_2_, tmpmstbean2_.@XPDEL as column17_13_2_ from @TDOCUMT tdocumtbea0_ left outer join @MASTDOC mastdocbea1_ on tdocumtbea0_.@XDDR#=mastdocbea1_.@MDOC# left outer join @TMPMST tmpmstbean2_ on tdocumtbea0_.@XDTEM=tmpmstbean2_.@XPCOD where (tdocumtbea0_.@XDACT=? and tdocumtbea0_.@XDPAT=?) order by tdocumtbea0_.@XDDAT DESC
21 Apr 2005 13:04:56,344 DEBUG http-8180-Processor25 org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
21 Apr 2005 13:04:56,344 DEBUG http-8180-Processor25 org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21 Apr 2005 13:04:56,344 DEBUG http-8180-Processor25 org.hibernate.impl.SessionImpl - closing session
21 Apr 2005 13:04:58,971 DEBUG Finalizer org.hibernate.jdbc.JDBCContext - running Session.finalize()
Login
FAQ
Search
