11-Jun-2021 20:02:27.551 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Loading sql.properties from URI: /WEB-INF/jstl-sql.properties
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Char_Fn_Query=SELECT {FN CHAR(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varchar_Tab_Null_Update=update Varchar_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_longPKTable_Select_PK=select KEY_ID from Deploy_Tab3 where KEY_ID = ?
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab1_MultiParam_Query=SELECT idNum, firstName, lastName from jstl_tab1 where idNum= ? and lastName = ?
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bigint_Query_Null=Select NULL_VAL from Bigint_Tab
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bit_Tab_Max_Update=update Bit_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Row_Query=INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (1, {d '1961-08-30'}, 'Clark', 'Kent', 1, 4.5)
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab1_Select=select * from Xa_Tab1
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Week_Fn_Query=SELECT {FN WEEK(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_intPKTable_Insert=insert into Deploy_Tab1 values(?, ?, ?)
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dayofyear_Fn_Query=SELECT {FN DAYOFYEAR(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Abs_Fn_Query=SELECT {FN ABS(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Tab1_Delete=delete from SEC_Tab1
11-Jun-2021 20:02:27.554 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Length_Fn_Query=SELECT {FN LENGTH(STRING1)} FROM ctstable3
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Float_Tab_Min_Update=update Float_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_FLOAT_PK_select_price=select PRICE from Coffee_FloatPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_LONG_PK_delete=delete from Coffee_LongPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bigint_Tab_Insert=insert into Bigint_Tab values(9223372036854775807,-9223372036854775808,null)
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab2_insert_init=insert into Xa_Tab2 values (1, 'Table2 Line one ', '2.0' )
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Escape_Seq_ChkQuery=select count(*) from ctstable2
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_intPKTable_Update=update Deploy_Tab1 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Numeric_Query_Null=Select NULL_VAL from Numeric_Tab
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdiffsecond_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_SECOND,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_LONG_PK_delete_all=delete from Coffee_LongPK_Table
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tinyint_Query_Min=Select MIN_VAL from Tinyint_Tab
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Update_Jstl_Tab2_Using_Param_Query=UPDATE jstl_tab2 SET lastName= ? WHERE idNum = ?
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dbschema_Tab1_Insert=insert into ctstable2 values(?, ?, ?, ?)
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_insert=insert into Coffee_Table values(?, ?, ?)
11-Jun-2021 20:02:27.555 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Float_Query_Min=Select MIN_VAL from Float_Tab
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdiffminute_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_MINUTE,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_COMPOUND_PK_select_price=select PRICE from Coffee_CompoundPK_Table where KEY_ID1 = ? and KEY_ID2 = ? and KEY_ID3 = ?
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Smallint_Query_Null=Select NULL_VAL from Smallint_Tab
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Acos_Fn_Query=SELECT {FN ACOS(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_select_pk_by_price_range=select KEY_ID from Coffee_Table where PRICE >= ? and PRICE <= ?
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Real_Tab_Delete=delete from Real_Tab
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_longPKTable_Cleanup=delete from Deploy_Tab3
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Float_Tab_Insert=insert into Float_Tab values(3.4028235E37,1.4E-45,null)
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SelCoffeeNull=select * from ctstable2 where TYPE_ID=0
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Numeric_Tab_Insert=insert into Numeric_Tab values(999999999999999,0.000000000000001, null)
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarchar_Tab_Name_Update=update Longvarchar_Tab set COFFEE_NAME=?
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Smallint_Tab_Null_Update=update Smallint_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Cot_Fn_Query=SELECT {FN COT(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_select_pk_by_pk_range=select KEY_ID from Coffee_Table where KEY_ID >= ? and KEY_ID <= ?
11-Jun-2021 20:02:27.556 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Smallint_Tab_Insert=insert into Smallint_Tab values(32767,-32768,null)
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab1_Delete1=delete from Xa_Tab1 where col1 = ?
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Round_Fn_Query=SELECT {FN ROUND(FLOATCOL,2)} FROM ctstable3
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Select_All=select * from Integration_Tab
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Time_Tab_Null_Update=update Time_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdiffday_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_DAY,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_compoundPKTable_Update=update Deploy_Tab5 set PRICE = ? where KEY_ID1 = ? and KEY_ID2 = ? and KEY_ID3 = ?
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Sel_Coffee_Tab=select PRICE from ctstable2 where KEY_ID>4
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Jstl_Tab2_Null_Query=INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (5, {d '1970-07-04'}, 'Peter', 'Parker', 5, null)
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab1_OneRow_Query=SELECT * FROM jstl_tab1 where idNum = 1
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Rand_Fn_Query=SELECT {FN RAND(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Select6=select PRICE from BB_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Select5=select KEY_ID from BB_Tab where KEY_ID >= ? and KEY_ID <= ?
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Select6=select PRICE  from SEC_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Select4=select KEY_ID from BB_Tab where PRICE >= ? and PRICE <= ?
11-Jun-2021 20:02:27.557 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab1_Select1=select KEY_ID,  COF_NAME, PRICE FROM JTA_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Select5=select KEY_ID from SEC_Tab1 where KEY_ID >= ? and KEY_ID <= ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Select3=select KEY_ID from BB_Tab where PRICE = ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Select4=select KEY_ID from SEC_Tab1 where PRICE >= ? and PRICE <= ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Insert=insert into Integration_Tab values(?, ?)
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Select2=select KEY_ID from BB_Tab where BRAND_NAME = ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Time_Tab_Delete=delete from Time_Tab
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Decimal_Query_Max=Select MAX_VAL from Decimal_Tab
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Select3=select KEY_ID from SEC_Tab1 where PRICE = ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Select1=select KEY_ID from BB_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Select2=select KEY_ID from SEC_Tab1 where BRAND = ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_Proc1_Delete=Drop procedure Coffee_Proc1
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Select1=select KEY_ID from SEC_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Select_Account=select * from Integration_Tab WHERE ACCOUNT = ?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Char_Tab_Null_Update=update Char_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.558 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tinyint_Tab_Null_Update=update Tinyint_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Double_Tab_Insert=insert into Double_Tab values(1.0E125,1.0E-130,null)
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_COMPOUND_PK_insert=insert into Coffee_CompoundPK_Table values(?, ?, ?, ?, ?)
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Decimal_Tab_Insert=insert into Decimal_Tab values(999999999999999,0.000000000000001, null)
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_UpdTab=update ctstable2 set PRICE=PRICE*20 where TYPE_ID=1
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarbinary_Tab_Delete=delete from Longvarbinary_Tab
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestamp_Tab_Insert=insert into Timestamp_Tab values({ts '1999-12-31 12:59:59'}, null)
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Space_Fn_Query=SELECT {FN SPACE(5)} FROM ctstable3
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Quarter_Fn_Query=SELECT {FN QUARTER(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varchar_Tab_Delete=delete from Varchar_Tab
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Trial_String=TrialSetting
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Delete=delete from Integration_Sec_Tab
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_strPKTable_Insert=insert into Deploy_Tab2 values(?, ?, ?)
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Sin_Fn_Query=SELECT {FN SIN(0)} FROM ctstable3
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tinyint_Query_Null=Select NULL_VAL from Tinyint_Tab
11-Jun-2021 20:02:27.559 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DateTime_Long_Val2=-86400001
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Upd_Coffee_Tab=update ctstable2 set PRICE=PRICE*20 where TYPE_ID=1
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DateTime_Long_Val1=86400001
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Double_Query_Max=Select MAX_VAL from Double_Tab
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_FLOAT_PK_update_price=update Coffee_FloatPK_Table set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab1_Select=select * from JTA_Tab1
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_intPKTable_Delete=delete from Deploy_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_update4=update TxBean_Tab2 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Real_Query_Null=Select NULL_VAL from Real_Tab
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_update3=update TxBean_Tab1 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_update2=update TxBean_Tab2 set TABTWO_NAME = ? where KEY_ID = ?
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Curdate_Fn_Query=SELECT {FN CURDATE()} FROM ctstable3
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_update1=update TxBean_Tab1 set TABONE_NAME = ? where KEY_ID = ?
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Pi_Fn_Query=SELECT {FN PI()} FROM ctstable3
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] User_Fn_Query=SELECT {FN USER()} FROM ctstable3
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab2_insert2=insert into Xa_Tab2 values (3, 'Table2 Line three ', '222.0' )
11-Jun-2021 20:02:27.560 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Update_numeric_tab=update Numeric_Tab set MAX_VAL=1.0, MIN_VAL=0.0, NULL_VAL=null
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab2_insert1=insert into Xa_Tab2 values (2, 'Table2 Line two ', '22.0' )
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Year_Fn_Query=SELECT {FN YEAR(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bigint_Tab_Delete=delete from Bigint_Tab
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tinyint_Tab_Insert=insert into Tinyint_Tab values(127,0,null)
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Decimal_Tab_Max_Update=update Decimal_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_compoundPKTable_Cleanup=delete from Deploy_Tab5
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_floatPKTable_Select_Price=select PRICE from Deploy_Tab4 where KEY_ID = ?
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dbschema_Tab1_Delete=delete from ctstable2
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Real_Tab_Insert=insert into Real_Tab values(3.402E38,1.4E-37, null)
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddday_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_DAY,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdiffhour_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_HOUR,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_delete=delete from Coffee_Table where KEY_ID = ?
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_select_price=select PRICE from Coffee_Table where KEY_ID = ?
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bigint_Tab_Max_Update=update Bigint_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_query4=select KEY_ID, TABTWO_NAME, PRICE from TxBean_Tab2 where KEY_ID = ?
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_query3=select KEY_ID, TABONE_NAME, PRICE from TxBean_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_query2=select * from TxBean_Tab2
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_query1=select * from TxBean_Tab1
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Failed_Insert_Query=INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (2, '1992-02-03'}, NULL,NULL, 2, 4.5)
11-Jun-2021 20:02:27.561 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert2_Row_Query=INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (2, {d '1980-12-30'}, 'Fred', 'Flinstone', 2, 4.5)
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Insert5=insert into Integration_Tab values(387, 1000000.0)
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Float_Tab_Delete=delete from Float_Tab
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Insert4=insert into Integration_Tab values(30564, 25000.0)
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_intPKTable_Cleanup=delete from Deploy_Tab1
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Insert3=insert into Integration_Tab values(40, 200.50)
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Insert2=insert into Integration_Tab values(1075, 10490.75)
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Insert1=insert into Integration_Tab values(1000, 50000.0)
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Fnschema_Tab1_Insert=INSERT INTO ctstable3 VALUES ('Java',' HotJava ','JAVA',100,0.5,{d '1993-07-13'},{t '10:30:55'},{ts '1996-05-10 10:07:04'},{ts '1996-05-10 10:07:05'})
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Numeric_Tab_Delete=delete from Numeric_Tab
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Real_Query_Min=Select MIN_VAL from Real_Tab
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_compoundPKTable_Select_Price=select PRICE from Deploy_Tab5 where KEY_ID1 = ? and KEY_ID2 = ? and KEY_ID3 = ?
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_floatPKTable_Insert=insert into Deploy_Tab4 values(?, ?, ?)
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ucase_Fn_Query=SELECT {FN UCASE(STRING1)} FROM ctstable3
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SelCoffeeAll=SELECT COF_NAME, PRICE FROM ctstable2
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Right_Oj_Query=SELECT * FROM {OJ ctstable3 RIGHT OUTER JOIN ctstable4 ON ctstable3.NUMCOL=ctstable4.NUMCOL}
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Smallint_Tab_Delete=delete from Smallint_Tab
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_Delete=delete from ctstable2 where KEY_ID=?
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Max_Set_Val=10
11-Jun-2021 20:02:27.562 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varchar_Query_Null=Select NULL_VAL from Varchar_Tab
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab1_Update2=update JTA_Tab1 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab1_Update1=update JTA_Tab1 set COF_NAME = ? where KEY_ID = ?
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_FLOAT_PK_insert=insert into Coffee_FloatPK_Table values(?, ?, ?)
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Now_Fn_Query=SELECT {FN NOW()} FROM ctstable3
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Update1=update BB_Tab set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Update1=update SEC_Tab1 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Tab_Delete=delete from Integration_Tab
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_longPKTable_Insert=insert into Deploy_Tab3 values(?, ?, ?)
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Right_Fn_Query=SELECT {FN RIGHT(STRING1,3)} FROM ctstable3
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab3_Date_Query=SELECT * from jstl_tab3 where aDate= ?
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Rtrim_Fn_Query=SELECT {FN RTRIM(STRING2)} FROM ctstable3
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_STRING_PK_delete_all=delete from Coffee_StringPK_Table
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddmonth_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_MONTH,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Numeric_Query_Min=Select MIN_VAL from Numeric_Tab
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Double_Tab_Delete=delete from Double_Tab
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Left_Fn_Query=SELECT {FN LEFT(STRING1,2)} FROM ctstable3
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarbinary_Tab_Insert=insert into Longvarbinary_Tab values(null)
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Substring_Fn_Query=SELECT {FN SUBSTR(STRING2,2,3)} FROM ctstable3
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Select5=select LINE_NO from Integration_Sec_Tab where LOG_NO = ? and LINE_NO= ?
11-Jun-2021 20:02:27.563 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Select4=select LOG_NO from Integration_Sec_Tab where MESSAGE = ? and LINE_NO = ?
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_strPKTable_Select_PK=select KEY_ID from Deploy_Tab2 where KEY_ID = ?
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab1_query=select col1 from Xa_Tab1 order by col1
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Select3=select MAX(LOG_NO) FROM Integration_Sec_Tab
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varchar_Query_Name=Select COFFEE_NAME from Varchar_Tab
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Select2=select MESSAGE FROM Integration_Sec_Tab where LOG_NO = ? and LINE_NO = ?
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_COMPOUND_PK_delete=delete from Coffee_CompoundPK_Table where KEY_ID1 = ? and KEY_ID2 = ? and KEY_ID3 = ?
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Log10_Fn_Query=SELECT {FN LOG10(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Select1=select MESSAGE, LINE_NO from Integration_Sec_Tab where LOG_NO = ? and not( LINE_NO= ? ) order by LINE_NO
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Tab_Delete=delete from BB_Tab
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_longPKTable_Update=update Deploy_Tab3 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddyear_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_YEAR,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Decimal_Tab_Delete=delete from Decimal_Tab
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Error_Query=select * from
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Exp_Fn_Query=SELECT {FN EXP(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tinyint_Tab_Max_Update=update Tinyint_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestamp_Tab_Delete=delete from Timestamp_Tab
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integer_Tab_Min_Update=update Integer_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ltrim_Fn_Query=SELECT {FN LTRIM(STRING2)} FROM ctstable3
11-Jun-2021 20:02:27.564 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bit_Query_Null=Select NULL_VAL from Bit_Tab
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Delete_Jstl_Tab2_Using_Param_Query=DELETE FROM jstl_tab2 where idNum = ?
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab1_Insert=insert into Xa_Tab1 values(?, ?, ?)
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_Proc1=create procedure Coffee_Proc1(keyid in Numeric) as begin update ctstable2 set KEY_ID=keyid,COF_NAME = 'Continue-1' where KEY_ID=1;end;
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Time_Tab_Brktime_Update=update Time_Tab set BRK_TIME=?
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_insert2=insert into TxBean_Tab2 values(?, ?, ?)
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_strPKTable_Delete=delete from Deploy_Tab2 where KEY_ID = ?
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TranSize_DataTrunc=50
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_insert1=insert into TxBean_Tab1 values(?, ?, ?)
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarchar_Tab_Null_Update=update Longvarcharnull_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddhour_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_HOUR,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdifffrac_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_floatPKTable_Select_PK=select KEY_ID from Deploy_Tab4 where KEY_ID = ?
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Del_Coffee_Tab=delete from ctstable2 where KEY_ID=9
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TSEIS_insert_init=1
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Float_Query_Null=Select NULL_VAL from Float_Tab
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dayname_Fn_Query=SELECT {FN DAYNAME(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Smallint_Tab_Min_Update=update Smallint_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Jstl_Tab3_Timestamp_Query=INSERT INTO jstl_tab3(idNum, aDate, aTime, aTimestamp) VALUES(1, {d '2001-08-30'}, {t '20:20:20'}, ?)
11-Jun-2021 20:02:27.565 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_Updcount_Query=select count(*) from ctstable2 where TYPE_ID=1
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Jstl_Tab3_Date_Query=INSERT INTO jstl_tab3(idNum, aDate, aTime, aTimestamp) VALUES(1, ?, {t '20:20:20'}, {ts '2001-08-30 20:20:20'})
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bit_Tab_Insert=insert into Bit_Tab values(true,false,null)
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_update_price=update Coffee_Table set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Tab_Delete=delete from BB_Tab
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarcharnull_Tab_Insert=insert into Longvarcharnull_Tab values(null)
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tinyint_Tab_Delete=delete from Tinyint_Tab
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SQLState_BatUpdExec=S100
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tinyint_Query_Max=Select MAX_VAL from Tinyint_Tab
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_floatPKTable_Cleanup=delete from Deploy_Tab4
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Float_Query_Max=Select MAX_VAL from Float_Tab
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Double_Tab_Min_Update=update Double_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_FLOAT_PK_delete_all=delete from Coffee_FloatPK_Table
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_InsTab=insert into ctstable2 values (9,'COFFEE-9',9.0,5)
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_select_pk_by_name=select KEY_ID from Coffee_Table where BRAND_NAME = ?
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_compoundPKTable_Insert=insert into Deploy_Tab5 values(?, ?, ?, ?, ?)
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Float_Tab_Max_Update=update Float_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Delete2=delete from JTA_Tab2 where KEY_ID = ?
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Delete1=delete from JTA_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.566 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Fnschema_Tab1_Delete=delete from ctstable3
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varbinary_Tab_Val_Update=update Varbinary_Tab set VARBINARY_VAL=?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Select6=select PRICE from BB_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DateTime_Str_Val2=1969-12-30 23:59:59.999
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Select5=select KEY_ID from BB_Tab where KEY_ID >= ? and KEY_ID <= ?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DateTime_Str_Val1=1970-01-02 00:00:00.001
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Select4=select KEY_ID from BB_Tab where PRICE >= ? and PRICE <= ?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Double_Query_Null=Select NULL_VAL from Double_Tab
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Select3=select KEY_ID from BB_Tab where PRICE = ?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Select2=select KEY_ID from BB_Tab where BRAND_NAME = ?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Select1=select KEY_ID from BB_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_floatPKTable_Delete=delete from Deploy_Tab4 where KEY_ID = ?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Double_Tab_Null_Update=update Double_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_delete_all=delete from Coffee_Table
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Jstl_Tab3_Query=INSERT INTO jstl_tab3(idNum, aDate, aTime, aTimestamp) VALUES(1, {d '2001-08-30'}, {t '20:20:20'}, {ts '2001-08-30 20:20:20'})
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Insert1=insert into BB_Tab values(?, ?, ?)
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Insert1=insert into SEC_Tab1 values(?, ?, ?)
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Decimal_Query_Null=Select NULL_VAL from Decimal_Tab
11-Jun-2021 20:02:27.567 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestamp_Query_Null=Select NULL_VAL from Timestamp_Tab
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dbschema_Tab2_Insert=insert into ctstable1 values(?, ?)
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Radians_Fn_Query=SELECT {FN RADIANS(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_Continue4=update ctstable2 set KEY_ID=2,COF_NAME = 'Continue-3' where COF_NAME='COFFEE-2'
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_Continue3=update ctstable2 set KEY_ID=1 ,COF_NAME = 'Invalid' where COF_NAME='COFFEE-3'
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_FLOAT_PK_delete=delete from Coffee_FloatPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_Continue2=update ctstable2 set KEY_ID=1,COF_NAME = 'Continue-1' where COF_NAME='COFFEE-1'
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Atan_Fn_Query=SELECT {FN ATAN(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_Continue1=update ctstable2 set KEY_ID=?, COF_NAME=? where COF_NAME=?
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_longPKTable_Delete=delete from Deploy_Tab3 where KEY_ID = ?
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BatchUpdate_Delete=delete from ctstable2
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Real_Tab_Null_Update=update Real_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bit_Query_Min=Select MIN_VAL from Bit_Tab
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Lcase_Fn_Query=SELECT {FN LCASE(STRING1)} FROM ctstable3
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ins_Coffee_Tab=insert into ctstable2 values (9,'COFFEE-9',9.0,5)
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_NoRows_Query=SELECT * FROM jstl_tab1 WHERE idNum = -9999
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddfrac_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_FRAC_SECOND,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_strPKTable_Cleanup=delete from Deploy_Tab2
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TSEIS_insert2=3
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varchar_Tab_Name_Update=update Varchar_Tab set COFFEE_NAME=?
11-Jun-2021 20:02:27.568 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Index_DataTrunc=1
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TSEIS_insert1=2
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab1_Using_Param_Query=SELECT * FROM jstl_tab1 WHERE idNum = ?
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_SelTab=select PRICE from ctstable2 where KEY_ID>4
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_COMPOUND_PK_delete_all=delete from Coffee_CompoundPK_Table
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Smallint_Query_Min=Select MIN_VAL from Smallint_Tab
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Truncate_Fn_Query=SELECT {FN TRUNCATE(FLOATCOL,1)} FROM ctstable3
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Update_char_tab2=update Char_Tab set COFFEE_NAME=0, NULL_VAL=null
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarchar_Query_Null=Select NULL_VAL from Longvarcharnull_Tab
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Update_char_tab1=update Char_Tab set COFFEE_NAME=1, NULL_VAL=null
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab1_Delete=delete from Xa_Tab1
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Param_DataTrunc=true
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Decimal_Tab_Null_Update=update Decimal_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ceiling_Fn_Query=SELECT {FN CEILING(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.569 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_select_pk_by_price=select KEY_ID from Coffee_Table where PRICE = ?
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab1_Insert=insert into JTA_Tab1 values(?, ?, ?)
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ifnull_Fn_Query=SELECT {FN IFNULL(STRING1,100)} FROM ctstable3
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab3_Time_Query=SELECT * from jstl_tab3 where aTime= ?
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarchar_Query_Name=Select COFFEE_NAME from Longvarchar_Tab
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarbinary_Query_Val=Select LONGVARBINARY_VAL from Longvarbinary_Tab
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarchar_Tab_Insert=insert into Longvarchar_Tab values('Test Coffee')
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bit_Tab_Delete=delete from Bit_Tab
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab2_Using_Param_Query=SELECT idNum, lastName FROM jstl_tab2 WHERE idNum = ?
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Soundex_Fn_Query=SELECT {FN SOUNDEX(STRING1)} FROM ctstable3
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_Delcount_Query=select count(*) from ctstable2 where KEY_ID=2
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Delete_Jstl_Tab3_AllRows_Query=DELETE FROM jstl_tab3
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Cos_Fn_Query=SELECT {FN COS(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarcharnull_Tab_Delete=delete from Longvarcharnull_Tab
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddquarter_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_QUARTER,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Jstl_Tab3_Null_Query=INSERT INTO jstl_tab3(idNum, aDate, aTime, aTimestamp) VALUES(99, null, null, null)
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_STRING_PK_select=select KEY_ID from Coffee_StringPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BatchUpdate_Query=select count(*) from ctstable2 where TYPE_ID=?
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_STRING_PK_insert=insert into Coffee_StringPK_Table values(?, ?, ?)
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integer_Query_Min=Select MIN_VAL from Integer_Tab
11-Jun-2021 20:02:27.570 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Degrees_Fn_Query=SELECT {FN DEGREES(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Hour_Fn_Query=SELECT {FN HOUR(TIMECOL)} FROM ctstable3
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Binary_Query_Val=Select BINARY_VAL from Binary_Tab
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab2_Delete=delete from Xa_Tab2
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Numeric_Tab_Null_Update=update Numeric_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BatchInsert_String=insert into ctstable2 values(?,?,?,?)
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab2_Select1=select KEY_ID,  CHOC_NAME, PRICE FROM JTA_Tab2 where KEY_ID = ?
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Real_Tab_Min_Update=update Real_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dayofweek_Fn_Query=SELECT {FN DAYOFWEEK(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab2_Select=select * from JTA_Tab2
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bigint_Query_Min=Select MIN_VAL from Bigint_Tab
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_compoundPKTable_Delete=delete from Deploy_Tab5 where KEY_ID1 = ? and KEY_ID2 = ? and KEY_ID3 = ?
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_STRING_PK_select_price=select PRICE from Coffee_StringPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Real_Query_Max=Select MAX_VAL from Real_Tab
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Simple_Select_Query=SELECT * FROM jstl_tab1
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bigint_Tab_Null_Update=update Bigint_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Update1=update BB_Tab set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Jstl_Tab3_Time_Query=INSERT INTO jstl_tab3(idNum, aDate, aTime, aTimestamp) VALUES(1, {d '2001-08-30'}, ?, {ts '2001-08-30 20:20:20'})
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JDBCLogstream_Message=Hello World
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Floor_Fn_Query=SELECT {FN FLOOR(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.571 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Jstl_Tab2_NullParam_Query=INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (5, {d '1970-07-04'}, 'Peter', 'Parker', 5, ?)
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_intPKTable_Select_Price=select PRICE from Deploy_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert4_Row_Query=INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (4, {d '1990-03-15'}, 'Bruce', 'Wayne', 3, 4.5)
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dbschema_Tab2_Delete=delete from ctstable1
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_updateString3=update TxEBean_Tab set BRAND_NAME = ?, PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Database_Fn_Query=SELECT {FN DATABASE()} FROM ctstable3
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_LONG_PK_select=select KEY_ID from Coffee_LongPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_updateString2=delete from TxEBean_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_updateString1=insert into TxEBean_Tab values(?, ?, ?)
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Char_Tab_Name_Update=update Char_Tab set COFFEE_NAME=?
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddsecond_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_SECOND,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_DelTab=delete from ctstable2 where KEY_ID=2
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ref_Nano_Val2=1000000
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Numeric_Query_Max=Select MAX_VAL from Numeric_Tab
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Fnschema_Tab2_Insert=INSERT INTO ctstable4 VALUES ('STRING3',100)
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ref_Milli_Val=86400000
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varbinary_Tab_Insert=insert into Varbinary_Tab values(null)
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Month_Fn_Query=SELECT {FN MONTH(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert_Fn_Query=SELECT {FN INSERT(STRING1,2,4,STRING2)} FROM ctstable3
11-Jun-2021 20:02:27.572 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_delete2=delete from TxBean_Tab2 where KEY_ID = ?
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_delete1=delete from TxBean_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Update_Account=update Integration_Tab set BALANCE = ? where ACCOUNT = ?
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varbinary_Query_Val=Select VARBINARY_VAL from Varbinary_Tab
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Repeat_Fn_Query=SELECT {FN REPEAT(STRING1,3)} FROM ctstable3
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Coffee_Inscount_Query=select count(*) from ctstable2 where KEY_ID=9
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Date_Query_Mfg=Select MFG_DATE from Date_Tab
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Date_Query_Null=Select NULL_VAL from Date_Tab
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_LONG_PK_update_price=update Coffee_LongPK_Table set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab1_Delete=delete from JTA_Tab1
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Update_decimal_tab=update Decimal_Tab set MAX_VAL=1.0, MIN_VAL=0.0, NULL_VAL=null
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integer_Tab_Max_Update=update Integer_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab2_AllRows_Query=SELECT * from jstl_tab2
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Replace_Fn_Query=SELECT {FN REPLACE(STRING2,STRING1,STRING3)} FROM ctstable3
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarchar_Tab_Delete=delete from Longvarchar_Tab
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bit_Tab_Min_Update=update Bit_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dbschema_Concur_Insert=insert into concurrencetable values(?, ?)
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Date_Tab_Insert=insert into Date_Tab values({d '1999-05-05'}, null)
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_queryStr1=select KEY_ID from TxEBean_Tab  where KEY_ID = ?
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Sqrt_Fn_Query=SELECT {FN SQRT(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.573 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ref_Nano_Val=999999999
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Full_Oj_Query=SELECT * FROM {OJ ctstable3 FULL OUTER JOIN ctstable4 ON ctstable3.NUMCOL=ctstable4.NUMCOL}
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_STRING_PK_delete=delete from Coffee_StringPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_STRING_PK_update_price=update Coffee_StringPK_Table set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Invalid_SQL_Query=This Will Fail on Any RDBMS I Hope!
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Log_Fn_Query=SELECT {FN LOG(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab2_Update2=update JTA_Tab2 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Smallint_Tab_Max_Update=update Smallint_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab2_Update1=update JTA_Tab2 set CHOC_NAME = ? where KEY_ID = ?
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Insert1=insert into BB_Tab values(?, ?, ?)
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab1_By_Id_Query=SELECT * FROM jstl_tab1 ORDER BY idNum
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Reason_BatUpdExec=Message
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integer_Query_Null=Select NULL_VAL from Integer_Tab
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Mod_Fn_Query=SELECT {FN MOD(NUMCOL,7)} FROM ctstable3
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] BB_Delete1=delete from BB_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] SEC_Delete1=delete from SEC_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdiffweek_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_WEEK,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Boolean_Tab_Insert=insert into Boolean_Tab values(true,false,null)
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_Tab1_Delete=delete from TxBean_Tab1
11-Jun-2021 20:02:27.574 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Monthname_Fn_Query=SELECT {FN MONTHNAME(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integer_Tab_Null_Update=update Integer_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] UpdCoffee_Proc=create method alias UpdCoffee_Proc for com.sun.ts.lib.tests.jdbc.CS_Procs.UpdCoffee_Proc
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Asin_Fn_Query=SELECT {FN ASIN(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Binary_Tab_Val_Update=update Binary_Tab set BINARY_VAL=?
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Char_Query_Null=Select NULL_VAL from Char_Tab
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Double_Tab_Max_Update=update Double_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Update=update Integration_Sec_Tab set MESSAGE= ? where LOG_NO = ? and LINE_NO = ?
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_Query=select COF_NAME,PRICE from ctstable2 where TYPE_ID=?
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integer_Tab_Insert=insert into Integer_Tab values(2147483647,-2147483648,null)
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdiffmonth_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_MONTH,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Ascii_Fn_Query=SELECT {FN ASCII(STRING1)} FROM ctstable3
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Char_Query_Name=Select COFFEE_NAME from Char_Tab
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] IntialValue_BatUpdExec={1,1,1}
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_select=select BRAND_NAME, PRICE from Coffee_Table where KEY_ID = ?
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Char_Tab_Insert=insert into Char_Tab values('Test Coffee', null)
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bit_Query_Max=Select MAX_VAL from Bit_Tab
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Fnschema_Tab2_Delete=delete from ctstable4
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Concat_Fn_Query=SELECT {FN CONCAT(STRING1,STRING2)} FROM ctstable3	
11-Jun-2021 20:02:27.575 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varbinary_Tab_Delete=delete from Varbinary_Tab
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Binary_Tab_Insert=insert into Binary_Tab values(null)
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Power_Fn_Query=SELECT {FN POWER(NUMCOL,2)} FROM ctstable3
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DataSize_DataTrunc=100
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_strPKTable_Select_Price=select PRICE from Deploy_Tab2 where KEY_ID = ?
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxBean_Tab2_Delete=delete from TxBean_Tab2
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab1_insert2=insert into Xa_Tab1 values (3, 'Table1 Line three ','111.0' )
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab1_insert1=insert into Xa_Tab1 values (2, 'Table1 Line two ', '11.0' )
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Delete_Account=delete from Integration_Tab where ACCOUNT = ?
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab3_Timestamp_Query=SELECT * from jstl_tab3 where aTimestamp= ?
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_update=update Coffee_Table set BRAND_NAME = ?, PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Longvarbinary_Tab_Val_Update=update Longvarbinary_Tab set LONGVARBINARY_VAL=?
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Smallint_Query_Max=Select MAX_VAL from Smallint_Tab
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DTrunc_Ins_Coffee=insert into ctstable2 values (10,'kumarjadjsjdhsjhdjsjdajhdjasdsdsdsd',21.00,1)
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestamp_Tab_Null_Update=update Timestamp_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab1_insert_init=insert into Xa_Tab1 values (1, 'Table1 Line one ', '1.0' )
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_Select=select PRICE from ctstable2 where KEY_ID=?
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] VendorCode_BatUpdExec=10 
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_LONG_PK_select_price=select PRICE from Coffee_LongPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Decimal_Query_Min=Select MIN_VAL from Decimal_Tab
11-Jun-2021 20:02:27.576 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddweek_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_WEEK,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_Update=update ctstable2 set PRICE=PRICE*20 where TYPE_ID=?
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Date_Tab_Delete=delete from Date_Tab
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dbschema_Concur_Delete=delete from concurrencetable
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Second_Fn_Query=SELECT {FN SECOND(TIMECOL)} FROM ctstable3
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_COMPOUND_PK_select=select KEY_ID1, KEY_ID2, KEY_ID3 from Coffee_CompoundPK_Table where KEY_ID1 = ? and KEY_ID2 = ? and KEY_ID3 = ?
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Dayofmonth_Fn_Query=SELECT {FN DAYOFMONTH(DATECOL)} FROM ctstable3
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] ConnectorTable_Insert=insert into Connector_Tab values(?, ?, ?)
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integer_Query_Max=Select MAX_VAL from Integer_Tab
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Minute_Fn_Query=SELECT {FN MINUTE(TIMECOL)} FROM ctstable3
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Read_DataTrunc=true
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab2_Insert=insert into JTA_Tab2 values(?, ?, ?)
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bigint_Query_Max=Select MAX_VAL from Bigint_Tab
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestamp_Query_In=Select IN_TIME from Timestamp_Tab
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Decimal_Tab_Min_Update=update Decimal_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Double_Query_Min=Select MIN_VAL from Double_Tab
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bigint_Tab_Min_Update=update Bigint_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Delete2=delete FROM Integration_Sec_Tab where LOG_NO=? and not ( LINE_NO = ? )
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Delete1=delete from Integration_Sec_Tab WHERE LOG_NO=?
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Delete_AllRows_Query=DELETE FROM jstl_tab2 
11-Jun-2021 20:02:27.577 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Difference_Fn_Query=SELECT {FN DIFFERENCE(STRING1,STRING2)} FROM ctstable3
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] CoffeeTab_ContinueSelect1=Select count(*) from ctstable2 where COF_NAME in ('Continue-1')
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Atan2_Fn_Query=SELECT {FN ATAN2(FLOATCOL,FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tan_Fn_Query=SELECT {FN TAN(FLOATCOL)} FROM ctstable3
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Delete_NoRows_Query=DELETE FROM jstl_tab2 WHERE idNum = -9999
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdiffyear_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_YEAR,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Numeric_Tab_Min_Update=update Numeric_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_intPKTable_Select_PK=select KEY_ID from Deploy_Tab1 where KEY_ID = ?
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_LONG_PK_insert=insert into Coffee_LongPK_Table values(?, ?, ?)
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_strPKTable_Update=update Deploy_Tab2 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integer_Tab_Delete=delete from Integer_Tab
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Xa_Tab2_query=select col1 from Xa_Tab2 order by col1
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Real_Tab_Max_Update=update Real_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampdiffquarter_Fn_Query=SELECT {FN TIMESTAMPDIFF(SQL_TSI_QUARTER,TSCOL1,TSCOL2)} FROM ctstable3
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Locate_Fn_Query=SELECT {FN LOCATE(STRING1,STRING2,2)} FROM ctstable3
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_COMPOUND_PK_update_price=update Coffee_CompoundPK_Table set PRICE = ? where KEY_ID1 = ? and KEY_ID2 = ? and KEY_ID3 = ?
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Insert3_Row_Query=INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (3, {d '1961-01-01'}, 'Scooby', 'Doo', 4, 4.5)
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_longPKTable_Select_Price=select PRICE from Deploy_Tab3 where KEY_ID = ?
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Bit_Tab_Null_Update=update Bit_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Date_Tab_Mfgdate_Update=update Date_Tab set MFG_DATE=?
11-Jun-2021 20:02:27.578 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestampaddminute_Fn_Query=SELECT {FN TIMESTAMPADD(SQL_TSI_MINUTE,2,TSCOL1)} FROM ctstable3
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Char_Tab_Delete=delete from Char_Tab
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_compoundPKTable_Select_PK=select KEY_ID1, KEY_ID2, KEY_ID3 from Deploy_Tab5 where KEY_ID1 = ? and KEY_ID2 = ? and KEY_ID3 = ?
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Binary_Tab_Delete=delete from Binary_Tab
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Numeric_Tab_Max_Update=update Numeric_Tab set MAX_VAL=?
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Time_Query_Null=Select NULL_VAL from Time_Tab
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Timestamp_Tab_Intime_Update=update Timestamp_Tab set IN_TIME=?
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Tinyint_Tab_Min_Update=update Tinyint_Tab set MIN_VAL=?
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Update_varchar_tab2=update Varchar_Tab set COFFEE_NAME=0, NULL_VAL=null
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Update_varchar_tab1=update Varchar_Tab set COFFEE_NAME=1, NULL_VAL=null
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Left_Oj_Query=SELECT * FROM {OJ ctstable3 LEFT OUTER JOIN ctstable4 ON ctstable3.NUMCOL=ctstable4.NUMCOL}
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Time_Tab_Insert=insert into Time_Tab values({t '12:59:59'}, null)
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_FLOAT_PK_select=select KEY_ID from Coffee_FloatPK_Table where KEY_ID = ?
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Float_Tab_Null_Update=update Float_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] DEPLOY_floatPKTable_Update=update Deploy_Tab4 set PRICE = ? where KEY_ID = ?
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_Delete=delete from TxEBean_Tab
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] COFFEE_BB_Delete1=delete from BB_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Sign_Fn_Query=SELECT {FN SIGN(NUMCOL)} FROM ctstable3
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Time_Query_Brk=Select BRK_TIME from Time_Tab
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Escape_Seq_Query=select count(*) from ctstable2 where cof_name like '%-%' { escape '\' }
11-Jun-2021 20:02:27.579 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] ConnectorTable_Delete=delete from Connector_Tab
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Delete_Jstl_Tab2_MultiParam_Query=DELETE FROM jstl_tab2 where idNum = ? and lastName = ?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Select_Jstl_Tab2_NullParam_Query=SELECT * FROM jstl_tab2 WHERE rank = ?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Varchar_Tab_Insert=insert into Varchar_Tab values('Test Coffee',null)
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_selectString6=select PRICE from TxEBean_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_selectString5=select BRAND_NAME from TxEBean_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_selectString4=select KEY_ID, BRAND_NAME, PRICE from TxEBean_Tab  where KEY_ID = ?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_selectString3=select KEY_ID from TxEBean_Tab where PRICE = ?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_selectString2=select KEY_ID from TxEBean_Tab where BRAND_NAME = ?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Date_Tab_Null_Update=update Date_Tab set NULL_VAL=?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Integration_Sec_Tab_Insert=insert into Integration_Sec_Tab values(?, ?, ?)
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] TxEBean_selectString1=select KEY_ID from TxEBean_Tab where KEY_ID = ?
11-Jun-2021 20:02:27.580 INFO [http-nio-40919-exec-3] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] JTA_Tab2_Delete=delete from JTA_Tab2
11-Jun-2021 20:02:43.906 INFO [main] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Removed jstlDS from context.
11-Jun-2021 20:02:43.906 INFO [main] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Removed logDS from context.
11-Jun-2021 20:02:43.906 INFO [main] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Removed sqlProps from context.
11-Jun-2021 20:02:43.906 INFO [main] org.apache.catalina.core.ApplicationContext.log [SQLContextListener] Removed JSTL_TAB1_ROWS from context.