-->
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
  [ 13 posts ] 
  Previous topic | Next topic 
Author Message
ledomi
 Post subject: Join Left - without mapping many-to-one
PostPosted: Wed Jul 25, 2007 9:45 am 
Newbie

Joined: Wed Mar 14, 2007 6:25 am
Posts: 7
Hello,

I'm trying to do a left join without mapping java object (relation one-to-many in hibernate-mapping).

And I don't found any issue...

- I try to use specific operators: =* and (+)=

- I try "select ... from Table1 t1 left join Table2 t2 on t1.property=t2.property"

- I try "select ... from Table1 t1 left join Table2 t2 with t1.property=t2.property"


The last one seem to be the proper one but I found another unsolvable problem, probably cause of my lack of knoledge.

I'm turning crazy so if someone could help me...

Thanks a lot.

Hibernate version: 3

Mapping documents:

Code:
<hibernate-mapping package="caam.dao.idee.hibernate.impl.orderpf">
   <class name="OrderPf" table="ID_ORDR_PF">

      <composite-id>
         <key-property name="ordrNum" column="ORDR_NUM" />
         <key-property name="pfCod" column="PF_COD" />
      </composite-id>

      <property name="qtyRequested" column="QTY_REQUESTED" />
      <property name="custodianCod" column="CUSTODIAN_COD" />
      <property name="amtRequested" column="AMT_REQUESTED" />
      
      
   </class>
</hibernate-mapping>




Code:
<hibernate-mapping
   package="caam.dao.idee.hibernate.impl.orderpfstrat">
   <class name="OrderPfStrat" table="CA_ORDR_PF_STRAT">

      <composite-id>
         <key-property name="ordrNum" column="ORDR_NUM" />
         <key-property name="pfCod" column="PF_COD" />
      </composite-id>

      <property name="strategyCod" column="STRATEGY_COD" />
      <property name="qtyRequested" column="QTY_REQUESTED" />
      
   </class>
</hibernate-mapping>




Code:
<hibernate-mapping package="caam.dao.idee.hibernate.impl.order">
   <class name="Order" table="ID_ORDER">
   
      <id name="ordrNum" type="long" column="ORDR_NUM">
         <generator class="org.hibernate.id.TableHiLoGenerator">
            <param name="table">ID_ORDR_NUM</param>
            <param name="column">ORDR_NUM</param>
         </generator>
      </id>
      
      <property name="instNum" column="INST_NUM" />
      <property name="instShNam" column="INST_SH_NAM" />
      <property name="ordrValidDat" column="ORDR_VALID_DAT" />
      <property name="ordrCreMgrDat" column="ORDR_CRE_MGR_DAT" />
      <property name="ordrCreTraDat" column="ORDR_CRE_TRA_DAT" />
      <property name="ordrCreMgrTim" column="ORDR_CRE_MGR_TIM" />
      <property name="ordrCreTraTim" column="ORDR_CRE_TRA_TIM" />
      <property name="traNam" column="TRA_NAM" />
      <property name="xactSign" column="XACT_SIGN" />
      <property name="xactTyp" column="XACT_TYP" />
      <property name="ordrTyp" column="ORDR_TYP" />
      <property name="limitPrice" column="LIMIT_PRICE" />
      <property name="curCod" column="CUR_COD" />
      <property name="brokerCod" column="BROKER_COD" />
      <property name="qtyTot" column="QTY_TOT" />
      <property name="qtyXact" column="QTY_XACT" />
      <property name="qtyReturned" column="QTY_RETURNED" />
      <property name="stockCtrl" column="STOCK_CTRL" />
      <property name="receptStat" column="RECEPT_STAT" />
      <property name="ordrCanMgrNam" column="ORDR_CAN_MGR_NAM" />
      <property name="ordrCanMgrDat" column="ORDR_CAN_MGR_DAT" />
      <property name="ordrCanMgrTim" column="ORDR_CAN_MGR_TIM" />
      <property name="ordrStat" column="ORDR_STAT" />
      <property name="instCod" column="INST_COD" />
      <property name="instAcr" column="INST_ACR" />
      <property name="qtyExpr" column="QTY_EXPR" />
      <property name="quoteFrac" column="QUOTE_FRAC" />
      <property name="maxPrice" column="MAX_PRICE" />
      <property name="minPrice" column="MIN_PRICE" />
      <property name="ordrModMgrNam" column="ORDR_MOD_MGR_NAM" />
      <property name="ordrModMgrDat" column="ORDR_MOD_MGR_DAT" />
      <property name="ordrModMgrTim" column="ORDR_MOD_MGR_TIM" />
      <property name="ordrCreMgrNam" column="ORDR_CRE_MGR_NAM" />
      <property name="gerDesk" column="GER_DESK" />
      <property name="ordrBlock" column="ORDR_BLOCK" />
      <property name="instReqTyp" column="INST_REQ_TYP" />
      <property name="mktLocCod" column="MKT_LOC_COD" />
      <property name="mktLocNam" column="MKT_LOC_NAM" />
      <property name="quoteMod" column="QUOTE_MOD" />
      <property name="busNum" column="BUS_NUM" />
      <property name="busProcNum" column="BUS_PROC_NUM" />
      <property name="extRef" column="EXT_REF" />
      <property name="busState" column="BUS_STATE" />
      <property name="ordrBlockPf" column="ORDR_BLOCK_PF" />
      <property name="routeCod" column="ROUTE_COD" />
      <property name="commentCod" column="COMMENT_COD" />
      <property name="yield" column="YIELD" />
      <property name="settlCurCod" column="SETTL_CUR_COD" />
      <property name="fxFlg" column="FX_FLG" />
      <property name="ordrGenFlg" column="ORDR_GEN_FLG" />
      <property name="directedFlg" column="DIRECTED_FLG" />
      <property name="ordrNumOrig" column="ORDR_NUM_ORIG" />
      <property name="ordrOrig" column="ORDR_ORIG" />
      <property name="ordrModel" column="ORDR_MODEL" />
      <property name="contStartDat" column="CONT_START_DAT" />
      <property name="contEndDat" column="CONT_END_DAT" />
      <property name="contPriceSpot" column="CONT_PRICE_SPOT" />
      <property name="contTyp" column="CONT_TYP" />
      <property name="contBasis" column="CONT_BASIS" />
      <property name="irFlg" column="IR_FLG" />
      <property name="fxComment" column="FX_COMMENT" />
      <property name="ordrSndMgrNam" column="ORDR_SND_MGR_NAM" />
      <property name="ordrSndMgrDat" column="ORDR_SND_MGR_DAT" />
      <property name="ordrSndMgrTim" column="ORDR_SND_MGR_TIM" />
      <property name="deskId" column="DESK_ID" />
      <property name="amtTot" column="AMT_TOT" />
      <property name="ordrQtyOrigFace" column="ORDR_QTY_ORIG_FACE" />
      <property name="amtTotCur" column="AMT_TOT_CUR" />
      <property name="amtFlg" column="AMT_FLG" />
      <property name="ordrCanMgrGmtTim" column="ORDR_CAN_MGR_GMT_TIM" />
      <property name="ordrCanMgrGmtDat" column="ORDR_CAN_MGR_GMT_DAT" />
      <property name="ordrCanMgrTz" column="ORDR_CAN_MGR_TZ" />
      <property name="ordrCreMgrGmtTim" column="ORDR_CRE_MGR_GMT_TIM" />
      <property name="ordrCreMgrGmtDat" column="ORDR_CRE_MGR_GMT_DAT" />
      <property name="ordrCreMgrTz" column="ORDR_CRE_MGR_TZ" />
      <property name="ordrModMgrGmtTim" column="ORDR_MOD_MGR_GMT_TIM" />
      <property name="ordrModMgrGmtDat" column="ORDR_MOD_MGR_GMT_DAT" />
      <property name="ordrModMgrTz" column="ORDR_MOD_MGR_TZ" />
      <property name="ordrSndMgrGmtTim" column="ORDR_SND_MGR_GMT_TIM" />
      <property name="ordrSndMgrGmtDat" column="ORDR_SND_MGR_GMT_DAT" />
      <property name="ordrSndMgrTz" column="ORDR_SND_MGR_TZ" />
      <property name="ordrCreTraGmtTim" column="ORDR_CRE_TRA_GMT_TIM" />
      <property name="ordrCreTraGmtDat" column="ORDR_CRE_TRA_GMT_DAT" />
      <property name="ordrCreTraTz" column="ORDR_CRE_TRA_TZ" />
      <property name="custodianCod" column="CUSTODIAN_COD" />
      <property name="settleDat" column="SETTLE_DAT" />
      <property name="ordrValidTim" column="ORDR_VALID_TIM" />
      <property name="uvaloSite" column="UVALO_SITE" />
      <property name="settlDatFlg" column="SETTL_DAT_FLG" />
   </class>
</hibernate-mapping>




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



Code:
StringBuffer FOREX_SENT_NOTEXECUTED_NOTMATCHED_TOFINISH = new StringBuffer(
    "select new caam.london.extraction.forex.ForexTradeBean(o.ordrCreMgrNam,opf.pfCod,o.xactSign,opf.qtyRequested,o.instAcr,o.curCod,o.fxFlg,o.contTyp,o.ordrCreMgrDat,")
    .append("o.contStartDat,o.contEndDat,o.contPriceSpot,o.contBasis,'opstrat.strategyCod','Sent - Not executed - Not matched',o.ordrNum)")
    .append(" from OrderPf as opf, Order as o left join OrderPfStrat as opstrat with opstrat.ORDR_NUM=o.ordNum ")
    .append(" where o.busState in ('OR','ORS','ORR')")
    .append(" and o.contTyp in ('SPOT','TERME')")
    .append(" and opf.ordrNum = o.ordrNum")
    .append(" and o.ordrValidDat >= :dateMin")
    .append(" and not exists (select 1 from Execution e where e.ordrNum = o.ordrNum)");
   
    Query hqlQuery = currentSession.createQuery(FOREX_SENT_NOTEXECUTED_NOTMATCHED_TOFINISH.toString());
    hqlQuery.setDate("dateMin", sdf.parse("10/07/2007"));
    List<ForexTradeBean> forexTradeList = hqlQuery.list();

    for (ForexTradeBean forexTradeBean : forexTradeList) {
      logger.info(forexTradeBean.toString());
    }


Full stack trace of any exception that occurs:

Code:
SessionFactoryImpl.java: 353 - Checking 0 named HQL queries
SessionFactoryImpl.java: 373 - Checking 0 named SQL queries
ErrorCounter.java:  33 -  Path expected for join!
org.hibernate.hql.ast.QuerySyntaxException: Path expected for join! [select new caam.london.extraction.forex.ForexTradeBean(o.ordrCreMgrNam,opf.pfCod,o.xactSign,opf.qtyRequested,o.instAcr,o.curCod,o.fxFlg,o.contTyp,o.ordrCreMgrDat,o.contStartDat,o.contEndDat,o.contPriceSpot,o.contBasis,'opstrat.strategyCod','Sent - Not executed - Not matched',o.ordrNum) from caam.dao.idee.hibernate.impl.orderpf.OrderPf as opf, caam.dao.idee.hibernate.impl.order.Order as o left join OrderPfStrat as opstrat with opstrat.ORDR_NUM=o.ordNum  where o.busState in ('OR','ORS','ORR') and o.contTyp in ('SPOT','TERME') and opf.ordrNum = o.ordrNum and o.ordrValidDat >= :dateMin and not exists (select 1 from caam.dao.idee.hibernate.impl.execution.Execution e where e.ordrNum = o.ordrNum)]
   at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
   at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:225)
   at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158)
   at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:105)
   at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:74)
   at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:53)
   at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
   at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:108)
   at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:88)
   at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1540)
   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.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:292)
   at $Proxy0.createQuery(Unknown Source)
   at caam.london.extraction.forex.ForexTradeExtractBatch.execute(ForexTradeExtractBatch.java:57)
   at caam.london.extraction.forex.ForexTradeExtractBatch.main(ForexTradeExtractBatch.java:70)
Caused by:  Path expected for join!
   at org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:305)
   at org.hibernate.hql.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3258)
   at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3050)
   at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2928)
   at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:686)
   at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:542)
   at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:279)
   at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:227)
   at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218)
   ... 16 more



Name and version of the database you are using:

Sybase 12.0


The generated SQL (show_sql=true):

There is no sql, the exception occures during sql generation.

Debug level Hibernate log excerpt:

[code] 25/07/2007 15:22 - INFO (caam.sits.gp.commons.hibernate.HibernateSessionFactory: 92) - Fichier de configuration d'une session hibernate absent: hibernate.perfsigp.cfg.xml
25/07/2007 15:22 - INFO (caam.sits.gp.commons.hibernate.HibernateSessionFactory: 92) - Fichier de configuration d'une session hibernate absent: hibernate.sigp.cfg.xml
25/07/2007 15:22 - INFO (caam.sits.gp.commons.hibernate.HibernateSessionFactory: 92) - Fichier de configuration d'une session hibernate absent: hibernate.refgp.cfg.xml
25/07/2007 15:22 - INFO (caam.sits.gp.commons.hibernate.HibernateSessionFactory: 92) - Fichier de configuration d'une session hibernate absent: hibernate.bip.cfg.xml
25/07/2007 15:22 - INFO (caam.sits.gp.commons.hibernate.HibernateSessionFactory: 86) - Configuration d'une session hibernate: hibernate.idee.cfg.xml
25/07/2007 15:22 - INFO (org.hibernate.cfg.Environment: 479) - Hibernate 3.1
25/07/2007 15:22 - INFO (org.hibernate.cfg.Environment: 479) - Hibernate 3.1
25/07/2007 15:22 - INFO (org.hibernate.cfg.Environment: 509) - hibernate.properties not found
25/07/2007 15:22 - INFO (org.hibernate.cfg.Environment: 509) - hibernate.properties not found
25/07/2007 15:22 - INFO (org.hibernate.cfg.Environment: 525) - using CGLIB reflection optimizer
25/07/2007 15:22 - INFO (org.hibernate.cfg.Environment: 525) - using CGLIB reflection optimizer
25/07/2007 15:22 - INFO (org.hibernate.cfg.Environment: 555) - using JDK 1.4 java.sql.Timestamp handling
25/07/2007 15:22 - INFO (org.hibernate.cfg.Environment: 555) - using JDK 1.4 java.sql.Timestamp handling
25/07/2007 15:22 - INFO (org.hibernate.cfg.Configuration:1320) - configuring from file: hibernate.idee.cfg.xml
25/07/2007 15:22 - INFO (org.hibernate.cfg.Configuration:1320) - configuring from file: hibernate.idee.cfg.xml
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 42) - trying to locate http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in classpath under org/hibernate/
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 42) - trying to locate http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in classpath under org/hibernate/
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 56) - found http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in classpath
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 56) - found http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in classpath
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.connection.driver_class=com.sybase.jdbc3.jdbc.SybDriver
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.connection.driver_class=com.sybase.jdbc3.jdbc.SybDriver
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.connection.url=jdbc:sybase:Tds:v880d-02:5220
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.connection.url=jdbc:sybase:Tds:v880d-02:5220
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.connection.username=etmgf
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.connection.username=etmgf
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.connection.password=etgespor
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.connection.password=etgespor
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.dialect=org.hibernate.dialect.SybaseDialect
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.dialect=org.hibernate.dialect.SybaseDialect
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.c3p0.min_size=5
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.c3p0.min_size=5
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.c3p0.max_size=20
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.c3p0.max_size=20
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.c3p0.timeout=1800
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.c3p0.timeout=1800
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.c3p0.max_statements=50
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.c3p0.max_statements=50
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - show_sql=true
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - show_sql=true
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - current_session_context_class=thread
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - current_session_context_class=thread
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.jdbc.batch_size=1000
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1247) - hibernate.jdbc.batch_size=1000
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1442) - idee<-org.dom4j.tree.DefaultAttribute@116471f [Attribute: name resource value "caam/dao/idee/hibernate/mapping/Contract.hbm.xml"]
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1442) - idee<-org.dom4j.tree.DefaultAttribute@116471f [Attribute: name resource value "caam/dao/idee/hibernate/mapping/Contract.hbm.xml"]
25/07/2007 15:22 - INFO (org.hibernate.cfg.Configuration: 468) - Reading mappings from resource: caam/dao/idee/hibernate/mapping/Contract.hbm.xml
25/07/2007 15:22 - INFO (org.hibernate.cfg.Configuration: 468) - Reading mappings from resource: caam/dao/idee/hibernate/mapping/Contract.hbm.xml
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 42) - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 42) - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 56) - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 56) - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
25/07/2007 15:22 - INFO (org.hibernate.cfg.HbmBinder: 265) - Mapping class: caam.dao.idee.hibernate.impl.contract.Contract -> ID_CONT
25/07/2007 15:22 - INFO (org.hibernate.cfg.HbmBinder: 265) - Mapping class: caam.dao.idee.hibernate.impl.contract.Contract -> ID_CONT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contNum -> CONT_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contNum -> CONT_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contNam -> CONT_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contNam -> CONT_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: posTyp -> POS_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: posTyp -> POS_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: status -> STATUS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: status -> STATUS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contStartDat -> CONT_START_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contStartDat -> CONT_START_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contEndDat -> CONT_END_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contEndDat -> CONT_END_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: freq -> FREQ
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: freq -> FREQ
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: undrlygInstNum -> UNDRLYG_INST_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: undrlygInstNum -> UNDRLYG_INST_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: undrlygQty -> UNDRLYG_QTY
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: undrlygQty -> UNDRLYG_QTY
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contAmt -> CONT_AMT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contAmt -> CONT_AMT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: curCod -> CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: curCod -> CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: intCalcMod -> INT_CALC_MOD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: intCalcMod -> INT_CALC_MOD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: valoMod -> VALO_MOD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: valoMod -> VALO_MOD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: rate -> RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: rate -> RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: rateTyp -> RATE_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: rateTyp -> RATE_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: idxCod -> IDX_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: idxCod -> IDX_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: marginAdd -> MARGIN_ADD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: marginAdd -> MARGIN_ADD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: marginMult -> MARGIN_MULT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: marginMult -> MARGIN_MULT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: basis -> BASIS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: basis -> BASIS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pledgeFlag -> PLEDGE_FLAG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pledgeFlag -> PLEDGE_FLAG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pledgeAmt -> PLEDGE_AMT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pledgeAmt -> PLEDGE_AMT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pledgeInstCod -> PLEDGE_INST_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pledgeInstCod -> PLEDGE_INST_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pledgeQty -> PLEDGE_QTY
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pledgeQty -> PLEDGE_QTY
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contReducedAmt -> CONT_REDUCED_AMT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contReducedAmt -> CONT_REDUCED_AMT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contIndemnRate -> CONT_INDEMN_RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contIndemnRate -> CONT_INDEMN_RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contForexTyp -> CONT_FOREX_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contForexTyp -> CONT_FOREX_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactForexTyp -> XACT_FOREX_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactForexTyp -> XACT_FOREX_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: priceSpot -> PRICE_SPOT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: priceSpot -> PRICE_SPOT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: priceFuture -> PRICE_FUTURE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: priceFuture -> PRICE_FUTURE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contMargin -> CONT_MARGIN
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contMargin -> CONT_MARGIN
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instLotsize -> INST_LOTSIZE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instLotsize -> INST_LOTSIZE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contRefNum -> CONT_REF_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contRefNum -> CONT_REF_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pfCod -> PF_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: pfCod -> PF_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contTyp -> CONT_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contTyp -> CONT_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreOrig -> REC_CRE_ORIG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreOrig -> REC_CRE_ORIG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreDat -> REC_CRE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreDat -> REC_CRE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreUsr -> REC_CRE_USR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreUsr -> REC_CRE_USR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModOrig -> REC_MOD_ORIG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModOrig -> REC_MOD_ORIG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModDat -> REC_MOD_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModDat -> REC_MOD_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModUsr -> REC_MOD_USR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModUsr -> REC_MOD_USR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: accrInt -> ACCR_INT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: accrInt -> ACCR_INT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: brokerCod -> BROKER_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: brokerCod -> BROKER_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: cntrptyCod -> CNTRPTY_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: cntrptyCod -> CNTRPTY_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: custodianCod -> CUSTODIAN_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: custodianCod -> CUSTODIAN_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contDat -> CONT_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contDat -> CONT_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: extRef -> EXT_REF
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: extRef -> EXT_REF
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreTim -> REC_CRE_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreTim -> REC_CRE_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModTim -> REC_MOD_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModTim -> REC_MOD_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: strategyCod -> STRATEGY_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: strategyCod -> STRATEGY_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: noticeTim -> NOTICE_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: noticeTim -> NOTICE_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: redemptionPrice -> REDEMPTION_PRICE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: redemptionPrice -> REDEMPTION_PRICE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: renewal -> RENEWAL
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: renewal -> RENEWAL
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteClose -> QUOTE_CLOSE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteClose -> QUOTE_CLOSE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: sensitivity -> SENSITIVITY
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: sensitivity -> SENSITIVITY
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteDat -> QUOTE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteDat -> QUOTE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteOpen -> QUOTE_OPEN
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteOpen -> QUOTE_OPEN
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: duration -> DURATION
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: duration -> DURATION
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: lastPricingDat -> LAST_PRICING_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: lastPricingDat -> LAST_PRICING_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contAllocNum -> CONT_ALLOC_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contAllocNum -> CONT_ALLOC_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execNum -> EXEC_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execNum -> EXEC_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: fwdPrice -> FWD_PRICE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: fwdPrice -> FWD_PRICE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: fwdAccrInt -> FWD_ACCR_INT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: fwdAccrInt -> FWD_ACCR_INT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: undrlygInstNum2 -> UNDRLYG_INST_NUM2
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: undrlygInstNum2 -> UNDRLYG_INST_NUM2
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: shiftDays -> SHIFT_DAYS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: shiftDays -> SHIFT_DAYS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: shiftDaysTyp -> SHIFT_DAYS_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: shiftDaysTyp -> SHIFT_DAYS_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreGmtTim -> REC_CRE_GMT_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreGmtTim -> REC_CRE_GMT_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreGmtDat -> REC_CRE_GMT_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreGmtDat -> REC_CRE_GMT_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreTz -> REC_CRE_TZ
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recCreTz -> REC_CRE_TZ
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModGmtTim -> REC_MOD_GMT_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModGmtTim -> REC_MOD_GMT_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModGmtDat -> REC_MOD_GMT_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModGmtDat -> REC_MOD_GMT_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModTz -> REC_MOD_TZ
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: recModTz -> REC_MOD_TZ
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1442) - idee<-org.dom4j.tree.DefaultAttribute@82701e [Attribute: name resource value "caam/dao/idee/hibernate/mapping/Execution.hbm.xml"]
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.Configuration:1442) - idee<-org.dom4j.tree.DefaultAttribute@82701e [Attribute: name resource value "caam/dao/idee/hibernate/mapping/Execution.hbm.xml"]
25/07/2007 15:22 - INFO (org.hibernate.cfg.Configuration: 468) - Reading mappings from resource: caam/dao/idee/hibernate/mapping/Execution.hbm.xml
25/07/2007 15:22 - INFO (org.hibernate.cfg.Configuration: 468) - Reading mappings from resource: caam/dao/idee/hibernate/mapping/Execution.hbm.xml
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 42) - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 42) - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 56) - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
25/07/2007 15:22 - DEBUG (org.hibernate.util.DTDEntityResolver: 56) - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
25/07/2007 15:22 - INFO (org.hibernate.cfg.HbmBinder: 265) - Mapping class: caam.dao.idee.hibernate.impl.execution.Execution -> ID_EXEC
25/07/2007 15:22 - INFO (org.hibernate.cfg.HbmBinder: 265) - Mapping class: caam.dao.idee.hibernate.impl.execution.Execution -> ID_EXEC
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execNum -> EXEC_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execNum -> EXEC_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: ordrNum -> ORDR_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: ordrNum -> ORDR_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instNum -> INST_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instNum -> INST_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instShNam -> INST_SH_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instShNam -> INST_SH_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execDat -> EXEC_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execDat -> EXEC_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: realDat -> REAL_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: realDat -> REAL_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreDat -> EXEC_CRE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreDat -> EXEC_CRE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreTim -> EXEC_CRE_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreTim -> EXEC_CRE_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: mgrNam -> MGR_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: mgrNam -> MGR_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: traNam -> TRA_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: traNam -> TRA_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactSign -> XACT_SIGN
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactSign -> XACT_SIGN
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactTyp -> XACT_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactTyp -> XACT_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instPrice -> INST_PRICE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instPrice -> INST_PRICE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: accrInt -> ACCR_INT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: accrInt -> ACCR_INT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: brokerCod -> BROKER_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: brokerCod -> BROKER_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: cntrptyCod -> CNTRPTY_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: cntrptyCod -> CNTRPTY_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: qtyTot -> QTY_TOT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: qtyTot -> QTY_TOT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtGrossPf -> AMT_GROSS_PF
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtGrossPf -> AMT_GROSS_PF
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtNetPf -> AMT_NET_PF
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtNetPf -> AMT_NET_PF
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: curCod -> CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: curCod -> CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactCurRate -> XACT_CUR_RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactCurRate -> XACT_CUR_RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtBroker -> AMT_BROKER
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtBroker -> AMT_BROKER
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtVat -> AMT_VAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtVat -> AMT_VAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtTaxes -> AMT_TAXES
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtTaxes -> AMT_TAXES
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleFreeCod -> SCALE_FREE_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleFreeCod -> SCALE_FREE_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtOtherPfCur -> AMT_OTHER_PF_CUR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtOtherPfCur -> AMT_OTHER_PF_CUR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtFees -> AMT_FEES
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtFees -> AMT_FEES
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instCod -> INST_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instCod -> INST_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instAcr -> INST_ACR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instAcr -> INST_ACR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: qtyExpr -> QTY_EXPR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: qtyExpr -> QTY_EXPR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleBrokerCod -> SCALE_BROKER_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleBrokerCod -> SCALE_BROKER_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleTaxCod -> SCALE_TAX_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleTaxCod -> SCALE_TAX_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleVatCod -> SCALE_VAT_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleVatCod -> SCALE_VAT_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleFeeCod -> SCALE_FEE_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: scaleFeeCod -> SCALE_FEE_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteFrac -> QUOTE_FRAC
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteFrac -> QUOTE_FRAC
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: settleDat -> SETTLE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: settleDat -> SETTLE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: cpnSettleDat -> CPN_SETTLE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: cpnSettleDat -> CPN_SETTLE_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execStat -> EXEC_STAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execStat -> EXEC_STAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: mktLocCod -> MKT_LOC_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: mktLocCod -> MKT_LOC_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: mktLocNam -> MKT_LOC_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: mktLocNam -> MKT_LOC_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtGrossXact -> AMT_GROSS_XACT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtGrossXact -> AMT_GROSS_XACT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtNetXact -> AMT_NET_XACT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: amtNetXact -> AMT_NET_XACT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: settleCur -> SETTLE_CUR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: settleCur -> SETTLE_CUR
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: settleCurRate -> SETTLE_CUR_RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: settleCurRate -> SETTLE_CUR_RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execModTraNam -> EXEC_MOD_TRA_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execModTraNam -> EXEC_MOD_TRA_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execModDat -> EXEC_MOD_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execModDat -> EXEC_MOD_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: heurModifExec -> HEUR_MODIF_EXEC
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: heurModifExec -> HEUR_MODIF_EXEC
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCanTraNam -> EXEC_CAN_TRA_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCanTraNam -> EXEC_CAN_TRA_NAM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCanDat -> EXEC_CAN_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCanDat -> EXEC_CAN_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCanTim -> EXEC_CAN_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCanTim -> EXEC_CAN_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: accrIntDays -> ACCR_INT_DAYS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: accrIntDays -> ACCR_INT_DAYS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteTyp -> QUOTE_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: quoteTyp -> QUOTE_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: err3Dat -> ERR_3_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: err3Dat -> ERR_3_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: busNum -> BUS_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: busNum -> BUS_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: busProcNum -> BUS_PROC_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: busProcNum -> BUS_PROC_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: extRef -> EXT_REF
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: extRef -> EXT_REF
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: busState -> BUS_STATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: busState -> BUS_STATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: openOrdrNum -> OPEN_ORDR_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: openOrdrNum -> OPEN_ORDR_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: commentCod -> COMMENT_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: commentCod -> COMMENT_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: reasonFlg -> REASON_FLG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: reasonFlg -> REASON_FLG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: cstrBroken -> CSTR_BROKEN
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: cstrBroken -> CSTR_BROKEN
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: custodianCod -> CUSTODIAN_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: custodianCod -> CUSTODIAN_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: netPrice -> NET_PRICE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: netPrice -> NET_PRICE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: flgIsNet -> FLG_IS_NET
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: flgIsNet -> FLG_IS_NET
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: princCod -> PRINC_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: princCod -> PRINC_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: whtAmt -> WHT_AMT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: whtAmt -> WHT_AMT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: whtRate -> WHT_RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: whtRate -> WHT_RATE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: benchInstNum -> BENCH_INST_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: benchInstNum -> BENCH_INST_NUM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: rdyFlg -> RDY_FLG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: rdyFlg -> RDY_FLG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contStartDat -> CONT_START_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contStartDat -> CONT_START_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contEndDat -> CONT_END_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contEndDat -> CONT_END_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contPriceSpot -> CONT_PRICE_SPOT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contPriceSpot -> CONT_PRICE_SPOT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: brokerCurCod -> BROKER_CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: brokerCurCod -> BROKER_CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: feesCurCod -> FEES_CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: feesCurCod -> FEES_CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: taxesCurCod -> TAXES_CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: taxesCurCod -> TAXES_CUR_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: strategyCod -> STRATEGY_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: strategyCod -> STRATEGY_COD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contTyp -> CONT_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contTyp -> CONT_TYP
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: fxFlg -> FX_FLG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: fxFlg -> FX_FLG
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contBasis -> CONT_BASIS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: contBasis -> CONT_BASIS
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactYield -> XACT_YIELD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactYield -> XACT_YIELD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactSpread -> XACT_SPREAD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: xactSpread -> XACT_SPREAD
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instQtyOrigFace -> INST_QTY_ORIG_FACE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: instQtyOrigFace -> INST_QTY_ORIG_FACE
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreGmtTim -> EXEC_CRE_GMT_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreGmtTim -> EXEC_CRE_GMT_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreGmtDat -> EXEC_CRE_GMT_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreGmtDat -> EXEC_CRE_GMT_DAT
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreTz -> EXEC_CRE_TZ
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCreTz -> EXEC_CRE_TZ
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCanGmtTim -> EXEC_CAN_GMT_TIM
25/07/2007 15:22 - DEBUG (org.hibernate.cfg.HbmBinder:1196) - Mapped property: execCanGmtTim -> EXEC_CAN_GMT_TIM
25/07/20
Top
 Profile  
 
thatmikewilliams
 Post subject:
PostPosted: Wed Jul 25, 2007 9:53 pm 
Expert
Expert

Joined: Fri Jul 13, 2007 8:18 am
Posts: 370
Location: london
I've read a few older posts suggesting that you can't join tables (ANSI style) that don't have a defined relationship within the hibernate mapping files. The solution is to fall back on theta style joins. Oddly, you've already used a theta style join between OrderPf and Order.

The following is an adjustment to your query to use theta style for the left join. It doesn't give an error but please check it produces the expected data.

Mike


Code:
StringBuffer FOREX_SENT_NOTEXECUTED_NOTMATCHED_TOFINISH = new StringBuffer(
    "select new caam.london.extraction.forex.ForexTradeBean(o.ordrCreMgrNam,opf.pfCod,o.xactSign,opf.qtyRequested,o.instAcr,o.curCod,o.fxFlg,o.contTyp,o.ordrCreMgrDat,")
    .append("o.contStartDat,o.contEndDat,o.contPriceSpot,o.contBasis,'opstrat.strategyCod','Sent - Not executed - Not matched',o.ordrNum)")

// Add "OrderPfStrat as opstrat" to list of theta style join tables
    .append(" from OrderPf as opf, Order as o, OrderPfStrat as opstrat ")

// Don't use ANSI style join
//left join OrderPfStrat as opstrat with opstrat.ORDR_NUM=o.ordNum ")

// Include "left join" (theta style) in where clause
    .append(" where (opstrat.ordrNum=o.ordrNum or opstrat.ordrNum is null)")

    .append(" and o.busState in ('OR','ORS','ORR')")
    .append(" and o.contTyp in ('SPOT','TERME')")
    .append(" and opf.ordrNum = o.ordrNum")
    .append(" and o.ordrValidDat >= :dateMin")
    .append(" and not exists (select 1 from Execution e where e.ordrNum = o.ordrNum)");


Top
 Profile  
 
ledomi
 Post subject:
PostPosted: Thu Jul 26, 2007 5:16 am 
Newbie

Joined: Wed Mar 14, 2007 6:25 am
Posts: 7
Thanks for try help but it's definitely different. I also found the solution for an Inner join but not for left join.

Your condition give to much or not enough information.

A left join mean: I want to join if it's possible. And the "if it's possible" is more complex than a null test.

Here are some script to create on Oracle and Sybase. And I give at the end the equivalence between (+) *= =* LEFT JOIN and RIGHT JOIN.

Oracle Script
Code:
DROP TABLE TABLE_TEST_ONE_TTO CASCADE CONSTRAINTS ;
CREATE TABLE TABLE_TEST_ONE_TTO (
  TTO_ID              NUMBER        NOT NULL,
  TTT_ID              NUMBER,
  TTO_TEXT           VARCHAR2(50),
  CONSTRAINT PK_TTO
  PRIMARY KEY ( TTO_ID )
    USING INDEX
  );
 
  DROP TABLE TABLE_TEST_TWO_TTT CASCADE CONSTRAINTS ;
  CREATE TABLE TABLE_TEST_TWO_TTT (
  TTT_ID              NUMBER        NOT NULL,
  TTT_TEXT           VARCHAR2(50),
    CONSTRAINT PK_TTT
  PRIMARY KEY ( TTT_ID )
    USING INDEX
  );
 
INSERT INTO TABLE_TEST_TWO_TTT (TTT_ID, TTT_TEXT)VALUES (1,'TTT 1');
INSERT INTO TABLE_TEST_TWO_TTT (TTT_ID, TTT_TEXT)VALUES (2,'TTT 1');
INSERT INTO TABLE_TEST_TWO_TTT (TTT_ID, TTT_TEXT)VALUES (3,'TTT 1');
INSERT INTO TABLE_TEST_TWO_TTT (TTT_ID, TTT_TEXT)VALUES (4,'TTT 1'); 
 
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 1,1 ,'TTO 1' );
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 2,2 ,'TTO 2' );
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 3,NULL ,'TTO 3' );
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 4,5 ,'TTO 4' );
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 5,2 ,'TTO 5' );


Sybase
Code:
DROP TABLE TABLE_TEST_ONE_TTO ;
CREATE TABLE TABLE_TEST_ONE_TTO (
  TTO_ID              NUMERIC(20,0)        PRIMARY KEY,
  TTT_ID              NUMERIC(20,0) NULL,
  TTO_TEXT            VARCHAR(50),
  );
 
  DROP TABLE TABLE_TEST_TWO_TTT;
  CREATE TABLE TABLE_TEST_TWO_TTT (
  TTT_ID              NUMERIC(20,0)        PRIMARY KEY,
  TTT_TEXT         VARCHAR(50),
  );
 
INSERT INTO TABLE_TEST_TWO_TTT (TTT_ID, TTT_TEXT)VALUES (1,'TTT 1');
INSERT INTO TABLE_TEST_TWO_TTT (TTT_ID, TTT_TEXT)VALUES (2,'TTT 1');
INSERT INTO TABLE_TEST_TWO_TTT (TTT_ID, TTT_TEXT)VALUES (3,'TTT 1');
INSERT INTO TABLE_TEST_TWO_TTT (TTT_ID, TTT_TEXT)VALUES (4,'TTT 1'); 
 
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 1,1 ,'TTO 1' );
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 2,2 ,'TTO 2' );
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 3,NULL ,'TTO 3' );
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 4,5 ,'TTO 4' );
INSERT INTO TABLE_TEST_ONE_TTO (TTO_ID, TTT_ID, TTO_TEXT) VALUES ( 5,2 ,'TTO 5' );


Code:
---------------------------------------
- Equivalence entre
- ... =* ... et ...(+)= ...
---------------------------------------

Sybase:
> select * from TABLE_TEST_ONE_TTO tto, TABLE_TEST_TWO_TTT ttt where ttt.TTT_ID =* tto.TTT_ID
> select * from TABLE_TEST_ONE_TTO tto LEFT JOIN TABLE_TEST_TWO_TTT ttt ON tto.TTT_ID = ttt.TTT_ID

Oracle:
> select * from TABLE_TEST_ONE_TTO tto, TABLE_TEST_TWO_TTT ttt where ttt.ttt_id(+)= tto.ttt_id

---------------------------------------
- Equivalence entre
- ... *= ... et ...= ...(+)
---------------------------------------

Sybase:
> select * from TABLE_TEST_ONE_TTO tto, TABLE_TEST_TWO_TTT ttt where ttt.TTT_ID*= tto.TTT_ID
> select * from TABLE_TEST_ONE_TTO tto RIGHT JOIN TABLE_TEST_TWO_TTT ttt ON tto.TTT_ID = ttt.TTT_ID

Oracle:
> select * from TABLE_TEST_ONE_TTO tto, TABLE_TEST_TWO_TTT ttt where ttt.ttt_id = tto.ttt_id(+)
Top
 Profile  
 
thatmikewilliams
 Post subject:
PostPosted: Thu Jul 26, 2007 7:59 am 
Expert
Expert

Joined: Fri Jul 13, 2007 8:18 am
Posts: 370
Location: london
Yes that was a bit naive of me. Ok, I have another suggestion which appears to generate the correct sql.

Fix the "Path expected for join" error by creating a path between Order and OrderPfStrat. I've assumed its a one to many relationship.

In Order.hbm.xml defined a relationship to OrderPfStrat:
Code:
  <set name="orderPfStrats" cascade="none">
    <key column="ORDR_NUM"/>
    <one-to-many class="OrderPfStrat"/>
  </set>


Add a getter/setter to Order.java - these can remain private (for hibernate use only) so not to affect the public interface of the Order class.

Order.java
Code:
  private Set orderPfStrats;
   
  private Set getOrderPfStrats() {
    return orderPfStrats;
  }
  public void setOrderPfStrats(Set orderPfStrats) {
    this.orderPfStrats = orderPfStrats;
  }


Then change the join as follows:
Code:
.append(" from OrderPf as opf, Order as o left join o.orderPfStrats as opstrat ")


Hibernate takes care of matching the ORDR_NUM columns of Order and OrderPfSrtat.

Mike
Top
 Profile  
 
ledomi
 Post subject:
PostPosted: Thu Jul 26, 2007 9:32 am 
Newbie

Joined: Wed Mar 14, 2007 6:25 am
Posts: 7
Ok,

Thanks.

It works but I dislike being forced to have a Set in my Object Order... And I don't understand why we're forced to. In one year each of my Object will have thousand of Set... I feel it dirty. I'll choose to make a second request.

Thanks for you help!

Regards.
Top
 Profile  
 
thatmikewilliams
 Post subject:
PostPosted: Fri Jul 27, 2007 5:34 am 
Expert
Expert

Joined: Fri Jul 13, 2007 8:18 am
Posts: 370
Location: london
You're not "forced" to but remember that fundamentally hibernate is an ORM tool. The documentation says:

ORM refers to the technique of mapping a data representation from an object model to a relational data model...

In your case you have relationships in the database that are not represented in your object model. When you try to navigate these database only relationships using hibernate its not really surprising it fails.

If you're just using hibernate to persist objects on a per table basis and not defining the relationships between the tables in your object model then hibernate might be the wrong tool for you.
Top
 Profile  
 
ledomi
 Post subject:
PostPosted: Fri Jul 27, 2007 5:41 am 
Newbie

Joined: Wed Mar 14, 2007 6:25 am
Posts: 7
Hi,

Yes I agree your point of view. But I prefer having a very simple Object per table. And when I need a very complex data from joined request, I'd like to create a specific object related to the request. And I don't want to redefine hibernate-maping.xml but reuse existing ones.

Like you said, I may be too close of database. But I feel it more efficient. It's my point of view.

Thanks again for you help.

Regards,
Top
 Profile  
 
mxc4
 Post subject: Maybe you could just use inner joins?
PostPosted: Wed Aug 01, 2007 1:17 am 
Newbie

Joined: Tue Jul 27, 2004 1:33 pm
Posts: 18
Location: South Africa
Maybe you could use inner joins without a mapping file. See

http://www.jumpingbean.co.za/blogs/mark/hibernate_hql_inner_join_on_clause

_________________
http://www.jumpingbean.co.za
http://www.cyberconnect.co.za
http://www.ip-pbx.co.za
http://www.learndrupal.co.za

Top
 Profile  
 
ledomi
 Post subject:
PostPosted: Wed Aug 01, 2007 5:48 am 
Newbie

Joined: Wed Mar 14, 2007 6:25 am
Posts: 7
Hi,

It needs some change, using table name and column name, done. Then I execute the request and have a new exception.

Request
Code:
SELECT new caam.london.extraction.forex.ForexTradeBean(ord.ORDR_CRE_MGR_NAM, opf.PF_COD, ord.XACT_SIGN, opf.QTY_REQUESTED, ord.INST_ACR, ord.CUR_COD, ord.FX_FLG, ord.CONT_TYP, ord.ORDR_CRE_MGR_DAT, ord.CONT_START_DAT, ord.CONT_END_DAT, ord.CONT_PRICE_SPOT, ord.CONT_BASIS, ops.STRATEGY_COD,'SENT - NOT EXECUTED - NOT MATCHED', ord.ORDR_NUM)
FROM ID_ORDER ord, ID_ORDR_PF opf, CA_ORDR_PF_STRAT ops
WHERE ord.BUS_STATE in ('OR','ORS','ORR')
AND  ord.ORDR_NUM=*ops.ORDR_NUM
AND ord.CONT_TYP in ('SPOT','TERME')
AND opf.ORDR_NUM = ord.ORDR_NUM
AND ord.ORDR_VALID_DAT >= ?
AND not exists (select 1 from ID_EXEC e where e.ORDR_NUM = ord.ORDR_NUM)


Exception
Code:
org.hibernate.exception.GenericJDBCException: could not execute query
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.loader.Loader.doList(Loader.java:2153)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
   at org.hibernate.loader.Loader.list(Loader.java:2024)
   at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:117)
   at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1607)
   at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:121)
   at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:169)
   at caam.london.batch.extraction.forex.ForexTradeExtractBatch.executer(ForexTradeExtractBatch.java:126)
   ... 3 more
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Cannot run this command because Java services are not enabled. A user with System Administrator (SA) role must reconfigure the system to enable Java.

   at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:2942)
   at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2246)
   at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
   at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
   at com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
   at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(SybStatement.java:1698)
   at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(SybStatement.java:1683)
   at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:97)
   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:2150)
   ... 10 more
Top
 Profile  
 
thatmikewilliams
 Post subject:
PostPosted: Wed Aug 01, 2007 6:52 am 
Expert
Expert

Joined: Fri Jul 13, 2007 8:18 am
Posts: 370
Location: london
What's the generated sql for this query? Might be interesting to see because of this note on BEA website (which I'm sure you've already seen):
http://edocs.bea.com/liquiddata/docs85/ ... notes.html

Quote:
When using Sybase relational data as a data source, some SQL functions such as LTRIM and RTRIM work correctly in the database only when Java services are enabled by running the following in the SA role.

sp_configure, "enable_java", 1

The error message indicating this symptom is:

Cannot run this command because Java services are not enabled. A user with System Administrator (SA) role must reconfigure the system to enable Java.


Note: in the sybase docs is says to enable java use the following:
sp_configure, "enable java", 1
i.e. no underscore there.

I can't see why hibernate would generate functions in the sql for this query but lets take a look.
Top
 Profile  
 
ledomi
 Post subject:
PostPosted: Wed Aug 01, 2007 8:39 am 
Newbie

Joined: Wed Mar 14, 2007 6:25 am
Posts: 7
The exception was due to
Quote:
new caam.london.batch.extraction.forex.ForexTradeBean(
Then I put it off.

And I also correct my left join operator. But now I need to process a Object[]... not usefull. It work but it didn't take advantage of hibernate.

Code:
SELECT ord.ORDR_CRE_MGR_NAM, opf.PF_COD, ord.XACT_SIGN, opf.QTY_REQUESTED, ord.INST_ACR, ord.CUR_COD, ord.FX_FLG, ord.CONT_TYP, ord.ORDR_CRE_MGR_DAT, ord.CONT_START_DAT, ord.CONT_END_DAT, ord.CONT_PRICE_SPOT, ord.CONT_BASIS, ops.STRATEGY_COD,'SENT - NOT EXECUTED - NOT MATCHED', ord.ORDR_NUM)
FROM ID_ORDER ord, ID_ORDR_PF opf, CA_ORDR_PF_STRAT ops
WHERE ord.BUS_STATE in ('OR','ORS','ORR')
AND  ord.ORDR_NUM[b]*=[/b]ops.ORDR_NUM
AND ord.CONT_TYP in ('SPOT','TERME')
AND opf.ORDR_NUM = ord.ORDR_NUM
AND ord.ORDR_VALID_DAT >= ?
AND not exists (select 1 from ID_EXEC e where e.ORDR_NUM = ord.ORDR_NUM)
[/code]
Top
 Profile  
 
thatmikewilliams
 Post subject:
PostPosted: Wed Aug 01, 2007 10:38 am 
Expert
Expert

Joined: Fri Jul 13, 2007 8:18 am
Posts: 370
Location: london
Is that because you're executing this as an SQL query rather than a HQL query so its sending the "new ForexTradeBean" to the database?
Top
 Profile  
 
ledomi
 Post subject:
PostPosted: Wed Aug 01, 2007 10:42 am 
Newbie

Joined: Wed Mar 14, 2007 6:25 am
Posts: 7
Yes, I think so but not sure.
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
  [ 13 posts ] 

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.