These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 1 post ] 
  Previous topic | Next topic 
Author Message
dhannum
 Post subject: Invalid SQL with dynamic list of values passed to in clause
PostPosted: Wed May 31, 2006 12:56 pm 
Newbie

Joined: Wed May 31, 2006 11:17 am
Posts: 15
The issue I'm seeing is that Hibernate is generating invalid SQL when i try to bind a collection to an in clause. The relational structure is as follows:

Jobs have a FK to SendingApp and that FK is actually composite (2 columns: client id and sending app id)

I am trying to retrieve all Jobs where the job's associated sending app is in a provided dynamic list of SendingApp objects:

select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps)

I put all the information below. It appears that Hibernate is not binding the SendingApp list correctly. The SQL contains:

where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)

at the end. The first part is checking for the matches in SendingApp's two PK columns. The second part (9 question marks) is the nine items in the bound List. I think this is where the problem is. Am I not allowed to bind composite key collections in this way?

Hibernate version: 3.1.3

Mapping documents:

Job.hbm.xml

<hibernate-mapping package="com.carescience.dm.ui.beans">
<class name="Job" table="JOB_MAPPING">
<id name="jobId" column="JOB_ID" type="long">
<generator class="native"/>
</id>
<many-to-one name="sendingApp" class="SendingApp" lazy="false">
<column name="CLIENT_ID" not-null="true"/>
<column name="SENDING_APP_ID" not-null="true"/>
</many-to-one>
<!-- tons of other properties that don't matter in this example -->
</class>
</hibernate-mapping>

SendingApp.hbm.xml

<hibernate-mapping package="com.carescience.dm.ui.beans">
<class name="SendingApp" table="SENDING_APPLICATION">
<composite-id>
<key-many-to-one name="client" column="CLIENT_ID" class="com.carescience.dm.ui.beans.Client" lazy="false"/>
<key-property name="sendingAppId" column="SENDING_APP_ID" type="string"/>
</composite-id>

<set name="jobs" inverse="true" cascade="save-update" lazy="true" >
<key>
<column name="CLIENT_ID"/>
<column name="SENDING_APP_ID"/>
</key>
<one-to-many class="Job"/>
</set>
<!-- tons of other properties that don't matter in this example -->
</class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

final String getJobsHql = "select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps)";
HibernateCallback callback = new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query q = session.createQuery(getJobsHql);
q.setParameterList("sendingApps", sendingApps);***
return q.list();
}
};

List l = (List)getHibernateTemplate().execute(callback);

*** where sendingApps is a List<SendingApp> (fully populated)

Full stack trace of any exception that occurs:

I realize that this exception is actually from Spring because Spring is executing the SQL that Hibernate gives it (I use HibernateTemplate). The issue here is the SQL that hibernate is generating. It is invalid, though the fault may lie in my HQL

org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)]; nested exception is java.sql.SQLException: ORA-00920: invalid relational operator

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:88)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:370)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)
at com.carescience.dm.ui.data.HibernateDataServices.getJobsForSendingApps(HibernateDataServices.java:127)
at com.carescience.dm.ui.service.DefaultServiceManager.getJobsForSendingApps(DefaultServiceManager.java:173)
at com.carescience.dm.ui.web.managedbeans.MdsProgressReportBean.populateJobSelections(MdsProgressReportBean.java:585)
at com.carescience.dm.ui.web.managedbeans.MdsProgressReportBean.runReport(MdsProgressReportBean.java:719)
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 com.sun.el.parser.AstValue.invoke(AstValue.java:130)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
... 32 more
Caused by: java.sql.SQLException: ORA-00920: invalid relational operator

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
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:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at com.carescience.dm.ui.data.HibernateDataServices$1.doInHibernate(HibernateDataServices.java:123)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)
... 45 more

Name and version of the database you are using: Oracle 9i

The generated SQL (show_sql=true): select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)

Debug level Hibernate log excerpt:

2006-05-31 12:53:23,912 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4706690678423552
2006-05-31 12:53:23,912 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4706690678423552
2006-05-31 12:53:23,928 DEBUG [org.hibernate.engine.query.QueryPlanCache] unable to locate HQL query plan in cache; generating (select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps))
2006-05-31 12:53:23,928 DEBUG [org.hibernate.engine.query.QueryPlanCache] unable to locate HQL query plan in cache; generating (select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps))
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: select distinct j from com.carescience.dm.ui.beans.Job j join j.sendingApp sa where sa in (:sendingApps)
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: select distinct j from com.carescience.dm.ui.beans.Job j join j.sendingApp sa where sa in (:sendingApps)
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'from'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[DOT] '.'
| | | | | | | | +-[IDENT] 'com'
| | | | | | | | \-[IDENT] 'carescience'
| | | | | | | \-[IDENT] 'dm'
| | | | | | \-[IDENT] 'ui'
| | | | | \-[IDENT] 'beans'
| | | | \-[IDENT] 'Job'
| | | \-[ALIAS] 'j'
| | \-[JOIN] 'join'
| | +-[DOT] '.'
| | | +-[IDENT] 'j'
| | | \-[IDENT] 'sendingApp'
| | \-[ALIAS] 'sa'
| \-[SELECT] 'select'
| +-[DISTINCT] 'distinct'
| \-[IDENT] 'j'
\-[WHERE] 'where'
\-[IN] 'in'
+-[IDENT] 'sa'
\-[IN_LIST] 'inList'
\-[COLON] ':'
\-[IDENT] 'sendingApps'

2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'from'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[DOT] '.'
| | | | | | | | +-[IDENT] 'com'
| | | | | | | | \-[IDENT] 'carescience'
| | | | | | | \-[IDENT] 'dm'
| | | | | | \-[IDENT] 'ui'
| | | | | \-[IDENT] 'beans'
| | | | \-[IDENT] 'Job'
| | | \-[ALIAS] 'j'
| | \-[JOIN] 'join'
| | +-[DOT] '.'
| | | +-[IDENT] 'j'
| | | \-[IDENT] 'sendingApp'
| | \-[ALIAS] 'sa'
| \-[SELECT] 'select'
| +-[DISTINCT] 'distinct'
| \-[IDENT] 'j'
\-[WHERE] 'where'
\-[IN] 'in'
+-[IDENT] 'sa'
\-[IN_LIST] 'inList'
\-[COLON] ':'
\-[IDENT] 'sendingApps'

2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.carescience.dm.ui.beans.Job (j) -> job0_
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.carescience.dm.ui.beans.Job (j) -> job0_
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j -> job0_.JOB_ID
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j -> job0_.JOB_ID
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : sendingApp -> org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : sendingApp -> org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceEntityJoin() : generating join for sendingApp in com.carescience.dm.ui.beans.Job (sa) parent = [ {null} ]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceEntityJoin() : generating join for sendingApp in com.carescience.dm.ui.beans.Job (sa) parent = [ {null} ]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.carescience.dm.ui.beans.SendingApp (sa) -> sendingapp1_
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.carescience.dm.ui.beans.SendingApp (sa) -> sendingapp1_
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : j.sendingApp -> SENDING_APPLICATION sendingapp1_
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : j.sendingApp -> SENDING_APPLICATION sendingapp1_
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j.sendingApp -> job0_.CLIENT_ID, job0_.SENDING_APP_ID
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j.sendingApp -> job0_.CLIENT_ID, job0_.SENDING_APP_ID
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'SENDING_APPLICATION sendingapp1_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=sa,role=null,tableName=SENDING_APPLICATION,tableAlias=sendingapp1_,origin=JOB_MAPPING job0_,colums={job0_.CLIENT_ID job0_.SENDING_APP_ID ,className=com.carescience.dm.ui.beans.SendingApp}}

2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'SENDING_APPLICATION sendingapp1_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=sa,role=null,tableName=SENDING_APPLICATION,tableAlias=sendingapp1_,origin=JOB_MAPPING job0_,colums={job0_.CLIENT_ID job0_.SENDING_APP_ID ,className=com.carescience.dm.ui.beans.SendingApp}}

2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j -> job0_.JOB_ID
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j -> job0_.JOB_ID
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : sa -> (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID)
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : sa -> (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID)
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} distinct job0_.JOB_ID ) ( FromClause{level=1} ( JOB_MAPPING job0_ SENDING_APPLICATION sendingapp1_ ) ) ( where ( in (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) ( inList ? ) ) ) )
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} distinct job0_.JOB_ID ) ( FromClause{level=1} ( JOB_MAPPING job0_ SENDING_APPLICATION sendingapp1_ ) ) ( where ( in (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) ( inList ? ) ) ) )
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [JOB_MAPPING job0_]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [JOB_MAPPING job0_]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=1, statement=select]
2006-05-31 12:53:23,943 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=1, statement=select]
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (SENDING_APPLICATION,JOB_MAPPING)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[DISTINCT] SqlNode: 'distinct'
| +-[ALIAS_REF] IdentNode: 'job0_.JOB_ID as JOB1_4_' {alias=j, className=com.carescience.dm.ui.beans.Job, tableAlias=job0_}
| \-[SQL_TOKEN] SqlFragment: 'job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=2, fromElements=2, fromElementByClassAlias=[sa, j], fromElementByTableAlias=[sendingapp1_, job0_], fromElementsByPath=[j.sendingApp], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'JOB_MAPPING job0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=j,role=null,tableName=JOB_MAPPING,tableAlias=job0_,origin=null,colums={,className=com.carescience.dm.ui.beans.Job}}
| \-[JOIN_FRAGMENT] FromElement: 'inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=sa,role=null,tableName=SENDING_APPLICATION,tableAlias=sendingapp1_,origin=JOB_MAPPING job0_,colums={job0_.CLIENT_ID job0_.SENDING_APP_ID ,className=com.carescience.dm.ui.beans.SendingApp}}
\-[WHERE] SqlNode: 'where'
\-[IN] InLogicOperatorNode: 'in'
+-[ALIAS_REF] IdentNode: '(sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID)' {alias=sa, className=com.carescience.dm.ui.beans.SendingApp, tableAlias=sendingapp1_}
\-[IN_LIST] SqlNode: 'inList'
\-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}

2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (SENDING_APPLICATION,JOB_MAPPING)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[DISTINCT] SqlNode: 'distinct'
| +-[ALIAS_REF] IdentNode: 'job0_.JOB_ID as JOB1_4_' {alias=j, className=com.carescience.dm.ui.beans.Job, tableAlias=job0_}
| \-[SQL_TOKEN] SqlFragment: 'job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=2, fromElements=2, fromElementByClassAlias=[sa, j], fromElementByTableAlias=[sendingapp1_, job0_], fromElementsByPath=[j.sendingApp], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'JOB_MAPPING job0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=j,role=null,tableName=JOB_MAPPING,tableAlias=job0_,origin=null,colums={,className=com.carescience.dm.ui.beans.Job}}
| \-[JOIN_FRAGMENT] FromElement: 'inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=sa,role=null,tableName=SENDING_APPLICATION,tableAlias=sendingapp1_,origin=JOB_MAPPING job0_,colums={job0_.CLIENT_ID job0_.SENDING_APP_ID ,className=com.carescience.dm.ui.beans.SendingApp}}
\-[WHERE] SqlNode: 'where'
\-[IN] InLogicOperatorNode: 'in'
+-[ALIAS_REF] IdentNode: '(sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID)' {alias=sa, className=com.carescience.dm.ui.beans.SendingApp, tableAlias=sendingapp1_}
\-[IN_LIST] SqlNode: 'inList'
\-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}

2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: select distinct j from com.carescience.dm.ui.beans.Job j join j.sendingApp sa where sa in (:sendingApps)
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: select distinct j from com.carescience.dm.ui.beans.Job j join j.sendingApp sa where sa in (:sendingApps)
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (?)
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (?)
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,959 DEBUG [org.hibernate.engine.query.HQLQueryPlan] HQL param location recognition took 0 mills (select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps))
2006-05-31 12:53:23,959 DEBUG [org.hibernate.engine.query.HQLQueryPlan] HQL param location recognition took 0 mills (select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps))
2006-05-31 12:53:23,959 DEBUG [org.hibernate.engine.query.QueryPlanCache] unable to locate HQL query plan in cache; generating (select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_))
2006-05-31 12:53:23,959 DEBUG [org.hibernate.engine.query.QueryPlanCache] unable to locate HQL query plan in cache; generating (select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_))
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: select distinct j from com.carescience.dm.ui.beans.Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_)
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: select distinct j from com.carescience.dm.ui.beans.Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_)
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'from'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[DOT] '.'
| | | | | | | | +-[IDENT] 'com'
| | | | | | | | \-[IDENT] 'carescience'
| | | | | | | \-[IDENT] 'dm'
| | | | | | \-[IDENT] 'ui'
| | | | | \-[IDENT] 'beans'
| | | | \-[IDENT] 'Job'
| | | \-[ALIAS] 'j'
| | \-[JOIN] 'join'
| | +-[DOT] '.'
| | | +-[IDENT] 'j'
| | | \-[IDENT] 'sendingApp'
| | \-[ALIAS] 'sa'
| \-[SELECT] 'select'
| +-[DISTINCT] 'distinct'
| \-[IDENT] 'j'
\-[WHERE] 'where'
\-[IN] 'in'
+-[IDENT] 'sa'
\-[IN_LIST] 'inList'
+-[COLON] ':'
| \-[IDENT] 'sendingApps0_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps1_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps2_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps3_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps4_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps5_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps6_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps7_'
\-[COLON] ':'
\-[IDENT] 'sendingApps8_'

2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| +-[FROM] 'from'
| | +-[RANGE] 'RANGE'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[DOT] '.'
| | | | | | +-[DOT] '.'
| | | | | | | +-[DOT] '.'
| | | | | | | | +-[IDENT] 'com'
| | | | | | | | \-[IDENT] 'carescience'
| | | | | | | \-[IDENT] 'dm'
| | | | | | \-[IDENT] 'ui'
| | | | | \-[IDENT] 'beans'
| | | | \-[IDENT] 'Job'
| | | \-[ALIAS] 'j'
| | \-[JOIN] 'join'
| | +-[DOT] '.'
| | | +-[IDENT] 'j'
| | | \-[IDENT] 'sendingApp'
| | \-[ALIAS] 'sa'
| \-[SELECT] 'select'
| +-[DISTINCT] 'distinct'
| \-[IDENT] 'j'
\-[WHERE] 'where'
\-[IN] 'in'
+-[IDENT] 'sa'
\-[IN_LIST] 'inList'
+-[COLON] ':'
| \-[IDENT] 'sendingApps0_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps1_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps2_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps3_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps4_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps5_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps6_'
+-[COLON] ':'
| \-[IDENT] 'sendingApps7_'
\-[COLON] ':'
\-[IDENT] 'sendingApps8_'

2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.carescience.dm.ui.beans.Job (j) -> job0_
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.carescience.dm.ui.beans.Job (j) -> job0_
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j -> job0_.JOB_ID
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j -> job0_.JOB_ID
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : sendingApp -> org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)
2006-05-31 12:53:23,959 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : sendingApp -> org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceEntityJoin() : generating join for sendingApp in com.carescience.dm.ui.beans.Job (sa) parent = [ {null} ]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.DotNode] dereferenceEntityJoin() : generating join for sendingApp in com.carescience.dm.ui.beans.Job (sa) parent = [ {null} ]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.carescience.dm.ui.beans.SendingApp (sa) -> sendingapp1_
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : com.carescience.dm.ui.beans.SendingApp (sa) -> sendingapp1_
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : j.sendingApp -> SENDING_APPLICATION sendingapp1_
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromClause] addJoinByPathMap() : j.sendingApp -> SENDING_APPLICATION sendingapp1_
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j.sendingApp -> job0_.CLIENT_ID, job0_.SENDING_APP_ID
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j.sendingApp -> job0_.CLIENT_ID, job0_.SENDING_APP_ID
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'SENDING_APPLICATION sendingapp1_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=sa,role=null,tableName=SENDING_APPLICATION,tableAlias=sendingapp1_,origin=JOB_MAPPING job0_,colums={job0_.CLIENT_ID job0_.SENDING_APP_ID ,className=com.carescience.dm.ui.beans.SendingApp}}

2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] createFromJoinElement() : -- join tree --
\-[JOIN_FRAGMENT] FromElement: 'SENDING_APPLICATION sendingapp1_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=sa,role=null,tableName=SENDING_APPLICATION,tableAlias=sendingapp1_,origin=JOB_MAPPING job0_,colums={job0_.CLIENT_ID job0_.SENDING_APP_ID ,className=com.carescience.dm.ui.beans.SendingApp}}

2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j -> job0_.JOB_ID
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : j -> job0_.JOB_ID
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : sa -> (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : sa -> (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} distinct job0_.JOB_ID ) ( FromClause{level=1} ( JOB_MAPPING job0_ SENDING_APPLICATION sendingapp1_ ) ) ( where ( in (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) ( inList ? ? ? ? ? ? ? ? ? ) ) ) )
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( {select clause} distinct job0_.JOB_ID ) ( FromClause{level=1} ( JOB_MAPPING job0_ SENDING_APPLICATION sendingapp1_ ) ) ( where ( in (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) ( inList ? ? ? ? ? ? ? ? ? ) ) ) )
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [JOB_MAPPING job0_]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [JOB_MAPPING job0_]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=1, statement=select]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=1, statement=select]
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (SENDING_APPLICATION,JOB_MAPPING)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[DISTINCT] SqlNode: 'distinct'
| +-[ALIAS_REF] IdentNode: 'job0_.JOB_ID as JOB1_4_' {alias=j, className=com.carescience.dm.ui.beans.Job, tableAlias=job0_}
| \-[SQL_TOKEN] SqlFragment: 'job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=2, fromElements=2, fromElementByClassAlias=[sa, j], fromElementByTableAlias=[sendingapp1_, job0_], fromElementsByPath=[j.sendingApp], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'JOB_MAPPING job0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=j,role=null,tableName=JOB_MAPPING,tableAlias=job0_,origin=null,colums={,className=com.carescience.dm.ui.beans.Job}}
| \-[JOIN_FRAGMENT] FromElement: 'inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=sa,role=null,tableName=SENDING_APPLICATION,tableAlias=sendingapp1_,origin=JOB_MAPPING job0_,colums={job0_.CLIENT_ID job0_.SENDING_APP_ID ,className=com.carescience.dm.ui.beans.SendingApp}}
\-[WHERE] SqlNode: 'where'
\-[IN] InLogicOperatorNode: 'in'
+-[ALIAS_REF] IdentNode: '(sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID)' {alias=sa, className=com.carescience.dm.ui.beans.SendingApp, tableAlias=sendingapp1_}
\-[IN_LIST] SqlNode: 'inList'
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps0_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps1_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps2_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps3_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps4_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps5_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps6_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps7_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
\-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps8_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}

2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (SENDING_APPLICATION,JOB_MAPPING)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[DISTINCT] SqlNode: 'distinct'
| +-[ALIAS_REF] IdentNode: 'job0_.JOB_ID as JOB1_4_' {alias=j, className=com.carescience.dm.ui.beans.Job, tableAlias=job0_}
| \-[SQL_TOKEN] SqlFragment: 'job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=2, fromElements=2, fromElementByClassAlias=[sa, j], fromElementByTableAlias=[sendingapp1_, job0_], fromElementsByPath=[j.sendingApp], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'JOB_MAPPING job0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=j,role=null,tableName=JOB_MAPPING,tableAlias=job0_,origin=null,colums={,className=com.carescience.dm.ui.beans.Job}}
| \-[JOIN_FRAGMENT] FromElement: 'inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=sa,role=null,tableName=SENDING_APPLICATION,tableAlias=sendingapp1_,origin=JOB_MAPPING job0_,colums={job0_.CLIENT_ID job0_.SENDING_APP_ID ,className=com.carescience.dm.ui.beans.SendingApp}}
\-[WHERE] SqlNode: 'where'
\-[IN] InLogicOperatorNode: 'in'
+-[ALIAS_REF] IdentNode: '(sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID)' {alias=sa, className=com.carescience.dm.ui.beans.SendingApp, tableAlias=sendingapp1_}
\-[IN_LIST] SqlNode: 'inList'
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps0_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps1_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps2_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps3_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps4_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps5_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps6_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
+-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps7_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}
\-[NAMED_PARAM] ParameterNode: '?' {name=sendingApps8_, expectedType=org.hibernate.type.ManyToOneType(com.carescience.dm.ui.beans.SendingApp)}

2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: select distinct j from com.carescience.dm.ui.beans.Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: select distinct j from com.carescience.dm.ui.beans.Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,975 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-05-31 12:53:23,975 DEBUG [org.hibernate.engine.query.HQLQueryPlan] HQL param location recognition took 0 mills (select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_))
2006-05-31 12:53:23,975 DEBUG [org.hibernate.engine.query.HQLQueryPlan] HQL param location recognition took 0 mills (select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_))
2006-05-31 12:53:23,975 DEBUG [org.hibernate.engine.query.HQLQueryPlan] find: select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.engine.query.HQLQueryPlan] find: select distinct j from Job j join j.sendingApp sa where sa in (:sendingApps0_, :sendingApps1_, :sendingApps2_, :sendingApps3_, :sendingApps4_, :sendingApps5_, :sendingApps6_, :sendingApps7_, :sendingApps8_)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.engine.QueryParameters] named parameters: {sendingApps3_=com.carescience.dm.ui.beans.SendingApp, sendingApps5_=com.carescience.dm.ui.beans.SendingApp, sendingApps0_=com.carescience.dm.ui.beans.SendingApp, sendingApps2_=com.carescience.dm.ui.beans.SendingApp, sendingApps4_=com.carescience.dm.ui.beans.SendingApp, sendingApps6_=com.carescience.dm.ui.beans.SendingApp, sendingApps1_=com.carescience.dm.ui.beans.SendingApp, sendingApps7_=com.carescience.dm.ui.beans.SendingApp, sendingApps8_=com.carescience.dm.ui.beans.SendingApp}
2006-05-31 12:53:23,975 DEBUG [org.hibernate.engine.QueryParameters] named parameters: {sendingApps3_=com.carescience.dm.ui.beans.SendingApp, sendingApps5_=com.carescience.dm.ui.beans.SendingApp, sendingApps0_=com.carescience.dm.ui.beans.SendingApp, sendingApps2_=com.carescience.dm.ui.beans.SendingApp, sendingApps4_=com.carescience.dm.ui.beans.SendingApp, sendingApps6_=com.carescience.dm.ui.beans.SendingApp, sendingApps1_=com.carescience.dm.ui.beans.SendingApp, sendingApps7_=com.carescience.dm.ui.beans.SendingApp, sendingApps8_=com.carescience.dm.ui.beans.SendingApp}
2006-05-31 12:53:23,975 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-05-31 12:53:23,975 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2006-05-31 12:53:23,975 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2006-05-31 12:53:23,975 DEBUG [org.springframework.jdbc.datasource.DriverManagerDataSource] Creating new JDBC Connection to [jdbc:oracle:thin:@dev-db01:1521:lcia]
2006-05-31 12:53:24,100 DEBUG [org.hibernate.SQL] select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)
2006-05-31 12:53:24,100 DEBUG [org.hibernate.SQL] select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)
2006-05-31 12:53:24,100 INFO [STDOUT] Hibernate: select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)
2006-05-31 12:53:24,100 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
2006-05-31 12:53:24,100 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@6b707286 -> sendingApps5_ [6]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@6b707286 -> sendingApps5_ [6]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 6
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 6
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'DMUmds6' to parameter: 7
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'DMUmds6' to parameter: 7
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@d603b68c -> sendingApps3_ [4]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@d603b68c -> sendingApps3_ [4]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 4
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 4
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'DMU' to parameter: 5
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'DMU' to parameter: 5
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@12cf2c92 -> sendingApps2_ [3]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@12cf2c92 -> sendingApps2_ [3]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 3
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 3
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'CreateNewMDS7_2' to parameter: 4
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'CreateNewMDS7_2' to parameter: 4
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@f980e49f -> sendingApps0_ [1]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@f980e49f -> sendingApps0_ [1]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 1
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 1
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'CreateNewMDS7' to parameter: 2
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'CreateNewMDS7' to parameter: 2
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@63bac4e3 -> sendingApps6_ [7]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@63bac4e3 -> sendingApps6_ [7]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 7
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 7
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'MDS7_DEV_1' to parameter: 8
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'MDS7_DEV_1' to parameter: 8
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@31048bf8 -> sendingApps4_ [5]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@31048bf8 -> sendingApps4_ [5]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 5
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 5
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'DMU_mds7cm' to parameter: 6
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'DMU_mds7cm' to parameter: 6
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@e64a0979 -> sendingApps8_ [9]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@e64a0979 -> sendingApps8_ [9]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 9
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 9
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'NewSendApp' to parameter: 10
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'NewSendApp' to parameter: 10
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@5d4ca565 -> sendingApps7_ [8]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@5d4ca565 -> sendingApps7_ [8]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 8
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 8
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'MDS7CM' to parameter: 9
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'MDS7CM' to parameter: 9
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@12cf2c91 -> sendingApps1_ [2]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() com.carescience.dm.ui.beans.SendingApp@12cf2c91 -> sendingApps1_ [2]
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.engine.IdentifierValue] id unsaved-value strategy UNDEFINED
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 2
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'TESTDMU' to parameter: 2
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'CreateNewMDS7_1' to parameter: 3
2006-05-31 12:53:24,115 DEBUG [org.hibernate.type.StringType] binding 'CreateNewMDS7_1' to parameter: 3
2006-05-31 12:53:24,146 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-05-31 12:53:24,146 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-05-31 12:53:24,146 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
2006-05-31 12:53:24,146 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
2006-05-31 12:53:24,146 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select distinct job0_.JOB_ID as JOB1_4_, job0_.CLIENT_ID as CLIENT2_4_, job0_.SENDING_APP_ID as SENDING3_4_, job0_.JOB_NAME as JOB4_4_, job0_.DATE_CREATED as DATE5_4_, job0_.IS_FIX as IS6_4_ from JOB_MAPPING job0_ inner join SENDING_APPLICATION sendingapp1_ on job0_.CLIENT_ID=sendingapp1_.CLIENT_ID and job0_.SENDING_APP_ID=sendingapp1_.SENDING_APP_ID where (sendingapp1_.CLIENT_ID, sendingapp1_.SENDING_APP_ID) in (? , ? , ? , ? , ? , ? , ? , ? , ?)]
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 1 post ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.