Well, I should'a done.
[7/19/04 11:19:12:598 EDT] 1c7463a0 SystemOut O Hibernate: select timers0_.WRKFL_TIMER_ID as WRKFL_TI1___, timers0_.PARENT_ID as PARENT_ID__, workflowtr1_.WRKFL_ID as XACTN_ID0_, workflowtr1_.legacyFAA_Id as legacyFA2_4_0_, workflowtr1_.busComment as busComment4_0_, workflowtr1_.creationTypeId as creation4_4_0_, workflowtr1_.from_prfl_id as from_prf5_4_0_, workflowtr1_.to_prfl_id as to_prfl_id4_0_, workflowtr1_.by_prfl_id as by_prfl_id4_0_, workflowtr1_.xactn_type as xactn_type4_0_, workflowtr1_.bsnss_actn_id as bsnss_ac9_4_0_, workflowtr1__1_.action as action1_0_, workflowtr1__1_.tdate as tdate1_0_, workflowtr1__1_.scope as scope1_0_, workflowtr1__1_.uiAlertID as uiAlertID1_0_, workflowtr2_.WRKFL_ID as XACTN_ID1_, workflowtr2_.legacyFAA_Id as legacyFA2_4_1_, workflowtr2_.busComment as busComment4_1_, workflowtr2_.creationTypeId as creation4_4_1_, workflowtr2_.from_prfl_id as from_prf5_4_1_, workflowtr2_.to_prfl_id as to_prfl_id4_1_, workflowtr2_.by_prfl_id as by_prfl_id4_1_, workflowtr2_.xactn_type as xactn_type4_1_, workflowtr2_.bsnss_actn_id as bsnss_ac9_4_1_, workflowtr2__1_.action as action1_1_, workflowtr2__1_.tdate as tdate1_1_, workflowtr2__1_.scope as scope1_1_, workflowtr2__1_.uiAlertID as uiAlertID1_1_, workflowco3_.wrkfl_cntxt_id as wrkfl_cn1_2_, workflowco3_.cntxt_prnt_id as cntxt_pr2_2_, workflowco3_.xactn_type as xactn_type2_, workflowco3_.crtn_type as crtn_type2_, workflowco3_.scope as scope2_, workflowco3_.ui_alert_id as ui_alert6_2_, workflowco3_.wrkfl_state as wrkfl_st7_2_, workflowco3_.from_prfl_id as from_prf8_2_, workflowco3_.to_prfl_id as to_prfl_id2_, workflowco3_.by_prfl_id as by_prfl_id2_, workflowco3_.bsnss_actn_rqrd_id as bsnss_a11_2_, workflowco3_.bsnss_actn_tx as bsnss_a12_2_, workflowco3_.bsnss_actn_taken_id as bsnss_a13_2_, workflowco3_.bsnss_actn_taken_tx as bsnss_a14_2_, workflowco3_.alert_rlse_dt as alert_r15_2_, workflowco3_.faf_crtn_dt as faf_crt16_2_, workflowco3_.init_dt as init_dt2_, workflowco3_.due_dt as due_dt2_, workflowco3_.read_dt as read_dt2_, workflowco3_.ac_asgnmt_dt as ac_asgn20_2_, workflowco3_.elgbl_cls_dt as elgbl_c21_2_, workflowco3_.cmplt_cls_dt as cmplt_c22_2_, workflowco3_.out_assign as out_assign2_, workflowco3_.desc_assign as desc_as24_2_, workflowco3_.faa_id as faa_id2_, workflowco4_.wrkfl_cntxt_id as wrkfl_cn1_3_, workflowco4_.cntxt_prnt_id as cntxt_pr2_3_, workflowco4_.xactn_type as xactn_type3_, workflowco4_.crtn_type as crtn_type3_, workflowco4_.scope as scope3_, workflowco4_.ui_alert_id as ui_alert6_3_, workflowco4_.wrkfl_state as wrkfl_st7_3_, workflowco4_.from_prfl_id as from_prf8_3_, workflowco4_.to_prfl_id as to_prfl_id3_, workflowco4_.by_prfl_id as by_prfl_id3_, workflowco4_.bsnss_actn_rqrd_id as bsnss_a11_3_, workflowco4_.bsnss_actn_tx as bsnss_a12_3_, workflowco4_.bsnss_actn_taken_id as bsnss_a13_3_, workflowco4_.bsnss_actn_taken_tx as bsnss_a14_3_, workflowco4_.alert_rlse_dt as alert_r15_3_, workflowco4_.faf_crtn_dt as faf_crt16_3_, workflowco4_.init_dt as init_dt3_, workflowco4_.due_dt as due_dt3_, workflowco4_.read_dt as read_dt3_, workflowco4_.ac_asgnmt_dt as ac_asgn20_3_, workflowco4_.elgbl_cls_dt as elgbl_c21_3_, workflowco4_.cmplt_cls_dt as cmplt_c22_3_, workflowco4_.out_assign as out_assign3_, workflowco4_.desc_assign as desc_as24_3_, workflowco4_.faa_id as faa_id3_, timers0_.WRKFL_TIMER_ID as MYAPP_J1_4_, timers0__1_.CREAT_XACTN_ID as CREAT_XA2_7_4_, timers0__1_.COMPL_XACTN_ID as COMPL_XA3_7_4_, timers0__1_.parent_id as parent_id7_4_ from WRKFL_TIMER timers0_ inner join MYAPP_JOB timers0__1_ on timers0_.WRKFL_TIMER_ID=timers0__1_.MYAPP_JOB_ID left outer join XACTN_WRKFL workflowtr1_ on timers0__1_.CREAT_XACTN_ID=workflowtr1_.WRKFL_ID left outer join XACTN workflowtr1__1_ on workflowtr1_.WRKFL_ID=workflowtr1__1_.XACTN_ID left outer join XACTN_WRKFL workflowtr2_ on timers0__1_.COMPL_XACTN_ID=workflowtr2_.WRKFL_ID left outer join XACTN workflowtr2__1_ on workflowtr2_.WRKFL_ID=workflowtr2__1_.XACTN_ID left outer join WRKFL_CNTXT workflowco3_ on timers0__1_.parent_id=workflowco3_.wrkfl_cntxt_id left outer join WRKFL_CNTXT workflowco4_ on workflowco3_.cntxt_prnt_id=workflowco4_.wrkfl_cntxt_id where timers0_.PARENT_ID=?
[7/19/04 11:19:13:066 EDT] 1c7463a0 JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 904, SQLState: 42000
[7/19/04 11:19:13:082 EDT] 1c7463a0 JDBCException E net.sf.hibernate.util.JDBCExceptionReporter ORA-00904: "TIMERS0_"."PARENT_ID": invalid identifier
gavin wrote:
TIMERS0_ is probably an alias of the JOB table. But we can't tell. 'Cos you didn't post the SQL.