#349 Data Type Mismatch Occasionally when using positional params

Connection
closed-server-problem
None
5
2015-04-30
2014-03-05
Karim Assaf
No

This is the same as [bugs:#346] Data Type Mismatch Occasionally on String Data Type but for some reason I am unable to open it. The issue still occurs even after loading the latest PMR's. I believe I sent you all the logs in the past and you recommended waiting for the latest PMR. We have loaded this and still issue occurs "OCCASIONALLY". If we switch to named params the issue goes away (so thats how we solved it on our end)

Related

Bugs: #346
Bugs: #349

Discussion

  • Karim Assaf

    Karim Assaf - 2014-04-02

    Query Causes Error :

    014-04-02 10:48:46,208 DEBUG | http-bio-8080-exec-1 | com.imperialbag.sa.service.impl.CommonServiceImpl | [ABE001, ADV001, AIR003, ALB001, AMO001, AMS001, AMS005, ANE001, AQU004, ARA610, ARC010, ARC011, ARC012, ARC013, AROMA1, AROMA11, AROMA2, AROMA3, AROMA4, AROMA6, AROMA7, AROMA8, AROMA9, AROM08, AROM10, ARO003, ARO012, ART006, BAG003, BAG004, BAG014, BAG015, BAG034, BAG035, BAG064, BAG096, BAG097, BAG113, BAG125, BAG127, BAG144, BAG147, BAG151, BAG162, BAG172, BAG173, BAG179, BAG187, BAG193, BAG432, BAG544, BAG900, BAK006, BAL005, BAL007, BAR002, BAR006, BAR035, BAR046, BAT001, BAY004, BBPLG1, BBPMM1, BBPP01, BBPWS1, BBT002, BEA021, BEL012, BEL015, BER018, BES004, BFF051, BIG002, BIG034, BIM001, BIM002, BIS004, BLU001, BLU010, BLU011, BLU013, BLU015, BLU019, BLU020, BLU027, BLU038, BLU166, BOA005, BON003, BON007, BOO002, BOQ001, BOU001, BOU004, BRA008, BRE002, BRE011, BRE012, BRI028, BRO004, BRO015, BRO070, BRO072, BRO073, BRO074, BRO090, BRO103, BRO125, BUD005, BXL001, CAF013, CAF144, CAF180, CAN013, CAP022, CAR004, CAT006, CED002, CEN005, CEN006, CEN010, CEN032, CHA018, CHE007, CHE022, CHI051, CHO008, CIM003, CIR013, CIT012, CIT074, COF004, COMSTB, COM012, CON003, COO002, COO006, COR051, CRE036, CRI003, CRI004, CRI005, CRI006, CRI007, CRI008, CRI009, CRO012, CUC001, CUP008, DAN002, DAN011, DAV012, DEA003, DEA007, DEA008, DEL005, DEL014, DEL089, DET002, DIN210, DIST51, DOA001, DOG001, DOG010, DOM001, DON022, DOR009, DOU003, DPI001, DRA001, DRE001, DRI001, ECS001, EDE002, EDW003, EHI001, EHI002, ELC600, ELI002, ELI011, ELI012, ELI013, ELI014, ELL001, EMM002, EMP009, EUR012, FAM002, FAR003, FAR004, FAR176, FEA002, FIE005, FIG001, FIG002, FIG004, FIG005, FIG006, FIN000, FIN001, FIN002, FIN006, FIN010, FIN025, FIN035, FIN036, FIN037, FIN038, FIN039, FIN040, FIN041, FIN688, FIS004, FIV001, FIV002, FIV003, FIV004, FIV005, FIV006, FIV014, FLO004, FOO032, FOU002, FRA056, FRE002, FRE005, FRE006, FRE020, FRE055, FRE056, FRU016, GAB005, GAB006, GAB009, GAT003, GAT005, GEN229, GOA001, GOR001, GOT008, GOU021, GOU032, GOU035, GOU036, GOU037, GOU038, GOU049, GOU404, GRA018, GRA022, GRA034, GRE006, GRE066, GRO003, HAI111, HAM013, HAP007, HAR003, HOS003, HOU002, HOU004, HOU005, HUR001, HUR002, HYP001, IND001, INO003, INT004, JAM015, JAM021, JBRCM1, JBREB1, JBRFL2, JBRM02, JBRM03, JBRM04, JBRM05, JBRWB1, JBRZB1, JBR001, JBR002, JBR003, JBR006, JBR011, JEA006, JER002, JER007, JON001, JOS001, JUI000, JUI001, JUI002, JUI003, JUI004, JUI005, JUI006, JUI008, JUI009, JUI011, JUI018, KIN003, KIS003, KOF001, KOP001, KRO003, KUT001, LAB004, LAB012, LAB021, LAM005, LAM006, LAN015, LAR003, LEC001, LEC003, LEC009, LEG001, LEG003, LEG004, LEG006, LEG012, LEG013, LEG015, LEM007, LEN007, LEP001, LEP007, LEP010, LEP011, LEP012, LEP013, LEP015, LEP016, LEP017, LEP019, LEP020, LEP021, LEP022, LEP025, LEP026, LEP137, LEP147, LEP199, LET001, LET002, LEV000, LEV002, LEV004, LEV005, LEV006, LEV007, LEV009, LEV010, LEX002, LEX008, LIB018, LIN002, LIN013, LIT006, LIT777, LOB252, LOB531, LOR007, LOR011, LOX002, LPQ113, LPQ123, LPQ141, LPQ142, LPQ143, LPQ144, LPQ145, LPQ146, LPQ310, LPQ311, LPQ312, LPQ313, LPQ314, LPQ404, LPQ500, LUC003, LUC016, MAD001, MAD014, MAI000, MAI002, MAI004, MAI005, MAI006, MAI007, MAL003, MAL008, MAN010, MAN013, MAN014, MAN061, MAN076, MAN080, MAN082, MAN092, MAN200, MAN400, MAO001, MAO002, MAO003, MAO004, MAO005, MAO006, MAO007, MAO008, MAO009, MAO010, MAO011, MAO012, MAO013, MAO014, MAO015, MAO016, MAO017, MAR057, MAR090, MAR129, MAR140, MAR143, MAX001, MAX003, MAX004, MAX005, MAX009, MAX010, MAX013, MAX015, MAX016, MEE001, MEZ001, MGD001, MIK004, MIL005, MIL020, MIL033, MIL034, MOH002, MOM009, MOO004, MOO011, MSF002, MUR002, MUR005, MUR008, MUR011, MYC001, NAY004, NEW067, NEW133, NEW195, NIC006, NIK003, NIZ001, NOB001, NOB002, NOW001, NYU001, OBI001, OBI002, OLI001, OLI002, OLI003, ONC001, ONE002, ONE014, OSC001, OSS001, OSS004, OST001, OTG001, PAN011, PAN039, PAP002, PAP008, PAP016, PAP024, PAR071, PAR072, PEG002, PER028, PET011, PET023, PET025, PHI004, PIG002, PIN015, PLA033, POM001, PQA001, PQB002, PQB003, PQB138, PQC001, PQC002, PQC003, PQC004, PQF001, PQL002, PQL003, PQM001, PQM002, PQM315, PQN002, PQP001, PQR001, PQR002, PQS001, PQT001, PQT002, PQUN01, PQUW01, PQU001, PQW001, PQW002, PQW003, PQ1001, PRO003, PUT002, PYR002, PYR004, RAU001, REA010, RED002, RED006, RED025, RED026, RED028, RED029, RED030, RED031, RES002, RIC004, RIC016, RIC017, RIV001, ROC002, ROC005, ROS005, ROS006, ROT004, ROU007, RUE002, RYE006, SAL031, SAM002, SAR016, SAR031, SAU003, SAV002, SCH006, SCH011, SEA013, SEX001, SHU001, SIM014, SIM018, SIX630, SMI002, SMI003, SOH009, SOU002, SOU003, SOU011, SPI005, SPL002, SPO009, SPR013, STE007, STO025, STR039, STU001, STU011, STU013, STU016, STU019, SUB007, SUN002, SUN034, SWE001, SWE002, SWE004, SWE005, TAI002, TAK003, TAL001, TAL004, TAL005, TBA001, TEN004, TEQ001, TER002, THE006, THE031, THE103, THE139, THE152, THE162, THE274, THO001, TIT001, TOM014, TOP020, TRI001, TUM001, ULY001, UNI062, VAL001, VAM001, VEG001, VER003, VIN001, VVB001, WES025, WES052, WIL004, WIL011, WIL014, WIL019, WIL032, YOG012, 120001, 13T001]
    2014-04-02 10:48:46,208 DEBUG | http-bio-8080-exec-1 | com.imperialbag.sa.service.impl.CommonServiceImpl |
    Finished Customer Id List
    2014-04-02 10:48:46,360 DEBUG | http-bio-8080-exec-1 | org.hibernate.SQL | select vcormhd0_.otord as otord0_, vcormhd0_.otadv as otadv0_, vcormhd0_.otasrc as otasrc0_, vcormhd0_.otcctd as otcctd0_, vcormhd0_.otcctt as otcctt0_, vcormhd0_.otcmp as otcmp0_, vcormhd0_.otcusr as otcusr0_, vcormhd0_.otcust as otcust0_, vcormhd0_.otdel as otdel0_, vcormhd0_.otdesc as otdesc0_, vcormhd0_.otemal as otemal0_, vcormhd0_.otlcgd as otlcgd0_, vcormhd0_.otlcgt as otlcgt0_, vcormhd0_.otloc as otloc0_, vcormhd0_.otodte as otodte0_, vcormhd0_.otorwt as otorwt0_, vcormhd0_.otsdte as otsdte0_, vcormhd0_.otship as otship0_, vcormhd0_.ottype as ottype0_, vcormhd0_.otuser as otuser0_, vcormhd0_.otword as otword0_ from T50FILES.Vcormhd vcormhd0_ where (vcormhd0_.otcust in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and vcormhd0_.ottype=? and (vcormhd0_.otdel in (?)) fetch first 25 rows only
    Hibernate: select vcormhd0_.otord as otord0_, vcormhd0_.otadv as otadv0_, vcormhd0_.otasrc as otasrc0_, vcormhd0_.otcctd as otcctd0_, vcormhd0_.otcctt as otcctt0_, vcormhd0_.otcmp as otcmp0_, vcormhd0_.otcusr as otcusr0_, vcormhd0_.otcust as otcust0_, vcormhd0_.otdel as otdel0_, vcormhd0_.otdesc as otdesc0_, vcormhd0_.otemal as otemal0_, vcormhd0_.otlcgd as otlcgd0_, vcormhd0_.otlcgt as otlcgt0_, vcormhd0_.otloc as otloc0_, vcormhd0_.otodte as otodte0_, vcormhd0_.otorwt as otorwt0_, vcormhd0_.otsdte as otsdte0_, vcormhd0_.otship as otship0_, vcormhd0_.ottype as ottype0_, vcormhd0_.otuser as otuser0_, vcormhd0_.otword as otword0_ from T50FILES.Vcormhd vcormhd0_ where (vcormhd0_.otcust in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and vcormhd0_.ottype=? and (vcormhd0_.otdel in (?)) fetch first 25 rows only
    2014-04-02 10:48:46,360 TRACE | http-bio-8080-exec-1 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [1] as [VARCHAR] - ABE001
    2014-04-02 10:48:46,361 WARN | http-bio-8080-exec-1 | org.hibernate.engine.jdbc.spi.SqlExceptionHelper | SQL Error: -99999, SQLState: 07006
    2014-04-02 10:48:46,361 ERROR | http-bio-8080-exec-1 | org.hibernate.engine.jdbc.spi.SqlExceptionHelper | Data type mismatch.
    2014-04-02 10:48:46,383 WARN | http-bio-8080-exec-1 | error | Handler execution resulted in exception

     
  • Karim Assaf

    Karim Assaf - 2014-04-02

    No Error

    2014-04-02 11:25:03,376 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | !--REQUEST START--!
    2014-04-02 11:25:03,376 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | Request URL: http://localhost:8080/imperial-sa/views/list-open-web-orders-by-type
    2014-04-02 11:25:03,376 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:28.0) Gecko/20100101 Firefox/28.0
    2014-04-02 11:25:03,376 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | User name Associated With this request:LARSCH
    2014-04-02 11:25:03,376 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | Parameter name: customerId - Parameter value: all-customers
    2014-04-02 11:25:03,376 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | Parameter name: userToken - Parameter value: a465f789-4c7c-4f71-9959-ea6ec3cfe8a0
    2014-04-02 11:25:03,376 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | Parameter name: page - Parameter value: 0
    2014-04-02 11:25:03,376 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | Parameter name: type - Parameter value: ORDER
    2014-04-02 11:25:03,382 DEBUG | http-bio-8080-exec-6 | com.imperialbag.sa.service.impl.CommonServiceImpl | Customer Ids Returened From Cache:

    2014-04-02 11:25:03,382 DEBUG | http-bio-8080-exec-6 | com.imperialbag.sa.service.impl.CommonServiceImpl | [ABE001, ADV001, AIR003, ALB001, AMO001, AMS001, AMS005, ANE001, AQU004, ARA610, ARC010, ARC011, ARC012, ARC013, AROMA1, AROMA11, AROMA2, AROMA3, AROMA4, AROMA6, AROMA7, AROMA8, AROMA9, AROM08, AROM10, ARO003, ARO012, ART006, BAG003, BAG004, BAG014, BAG015, BAG034, BAG035, BAG064, BAG096, BAG097, BAG113, BAG125, BAG127, BAG144, BAG147, BAG151, BAG162, BAG172, BAG173, BAG179, BAG187, BAG193, BAG432, BAG544, BAG900, BAK006, BAL005, BAL007, BAR002, BAR006, BAR035, BAR046, BAT001, BAY004, BBPLG1, BBPMM1, BBPP01, BBPWS1, BBT002, BEA021, BEL012, BEL015, BER018, BES004, BFF051, BIG002, BIG034, BIM001, BIM002, BIS004, BLU001, BLU010, BLU011, BLU013, BLU015, BLU019, BLU020, BLU027, BLU038, BLU166, BOA005, BON003, BON007, BOO002, BOQ001, BOU001, BOU004, BRA008, BRE002, BRE011, BRE012, BRI028, BRO004, BRO015, BRO070, BRO072, BRO073, BRO074, BRO090, BRO103, BRO125, BUD005, BXL001, CAF013, CAF144, CAF180, CAN013, CAP022, CAR004, CAT006, CED002, CEN005, CEN006, CEN010, CEN032, CHA018, CHE007, CHE022, CHI051, CHO008, CIM003, CIR013, CIT012, CIT074, COF004, COMSTB, COM012, CON003, COO002, COO006, COR051, CRE036, CRI003, CRI004, CRI005, CRI006, CRI007, CRI008, CRI009, CRO012, CUC001, CUP008, DAN002, DAN011, DAV012, DEA003, DEA007, DEA008, DEL005, DEL014, DEL089, DET002, DIN210, DIST51, DOA001, DOG001, DOG010, DOM001, DON022, DOR009, DOU003, DPI001, DRA001, DRE001, DRI001, ECS001, EDE002, EDW003, EHI001, EHI002, ELC600, ELI002, ELI011, ELI012, ELI013, ELI014, ELL001, EMM002, EMP009, EUR012, FAM002, FAR003, FAR004, FAR176, FEA002, FIE005, FIG001, FIG002, FIG004, FIG005, FIG006, FIN000, FIN001, FIN002, FIN006, FIN010, FIN025, FIN035, FIN036, FIN037, FIN038, FIN039, FIN040, FIN041, FIN688, FIS004, FIV001, FIV002, FIV003, FIV004, FIV005, FIV006, FIV014, FLO004, FOO032, FOU002, FRA056, FRE002, FRE005, FRE006, FRE020, FRE055, FRE056, FRU016, GAB005, GAB006, GAB009, GAT003, GAT005, GEN229, GOA001, GOR001, GOT008, GOU021, GOU032, GOU035, GOU036, GOU037, GOU038, GOU049, GOU404, GRA018, GRA022, GRA034, GRE006, GRE066, GRO003, HAI111, HAM013, HAP007, HAR003, HOS003, HOU002, HOU004, HOU005, HUR001, HUR002, HYP001, IND001, INO003, INT004, JAM015, JAM021, JBRCM1, JBREB1, JBRFL2, JBRM02, JBRM03, JBRM04, JBRM05, JBRWB1, JBRZB1, JBR001, JBR002, JBR003, JBR006, JBR011, JEA006, JER002, JER007, JON001, JOS001, JUI000, JUI001, JUI002, JUI003, JUI004, JUI005, JUI006, JUI008, JUI009, JUI011, JUI018, KIN003, KIS003, KOF001, KOP001, KRO003, KUT001, LAB004, LAB012, LAB021, LAM005, LAM006, LAN015, LAR003, LEC001, LEC003, LEC009, LEG001, LEG003, LEG004, LEG006, LEG012, LEG013, LEG015, LEM007, LEN007, LEP001, LEP007, LEP010, LEP011, LEP012, LEP013, LEP015, LEP016, LEP017, LEP019, LEP020, LEP021, LEP022, LEP025, LEP026, LEP137, LEP147, LEP199, LET001, LET002, LEV000, LEV002, LEV004, LEV005, LEV006, LEV007, LEV009, LEV010, LEX002, LEX008, LIB018, LIN002, LIN013, LIT006, LIT777, LOB252, LOB531, LOR007, LOR011, LOX002, LPQ113, LPQ123, LPQ141, LPQ142, LPQ143, LPQ144, LPQ145, LPQ146, LPQ310, LPQ311, LPQ312, LPQ313, LPQ314, LPQ404, LPQ500, LUC003, LUC016, MAD001, MAD014, MAI000, MAI002, MAI004, MAI005, MAI006, MAI007, MAL003, MAL008, MAN010, MAN013, MAN014, MAN061, MAN076, MAN080, MAN082, MAN092, MAN200, MAN400, MAO001, MAO002, MAO003, MAO004, MAO005, MAO006, MAO007, MAO008, MAO009, MAO010, MAO011, MAO012, MAO013, MAO014, MAO015, MAO016, MAO017, MAR057, MAR090, MAR129, MAR140, MAR143, MAX001, MAX003, MAX004, MAX005, MAX009, MAX010, MAX013, MAX015, MAX016, MEE001, MEZ001, MGD001, MIK004, MIL005, MIL020, MIL033, MIL034, MOH002, MOM009, MOO004, MOO011, MSF002, MUR002, MUR005, MUR008, MUR011, MYC001, NAY004, NEW067, NEW133, NEW195, NIC006, NIK003, NIZ001, NOB001, NOB002, NOW001, NYU001, OBI001, OBI002, OLI001, OLI002, OLI003, ONC001, ONE002, ONE014, OSC001, OSS001, OSS004, OST001, OTG001, PAN011, PAN039, PAP002, PAP008, PAP016, PAP024, PAR071, PAR072, PEG002, PER028, PET011, PET023, PET025, PHI004, PIG002, PIN015, PLA033, POM001, PQA001, PQB002, PQB003, PQB138, PQC001, PQC002, PQC003, PQC004, PQF001, PQL002, PQL003, PQM001, PQM002, PQM315, PQN002, PQP001, PQR001, PQR002, PQS001, PQT001, PQT002, PQUN01, PQUW01, PQU001, PQW001, PQW002, PQW003, PQ1001, PRO003, PUT002, PYR002, PYR004, RAU001, REA010, RED002, RED006, RED025, RED026, RED028, RED029, RED030, RED031, RES002, RIC004, RIC016, RIC017, RIV001, ROC002, ROC005, ROS005, ROS006, ROT004, ROU007, RUE002, RYE006, SAL031, SAM002, SAR016, SAR031, SAU003, SAV002, SCH006, SCH011, SEA013, SEX001, SHU001, SIM014, SIM018, SIX630, SMI002, SMI003, SOH009, SOU002, SOU003, SOU011, SPI005, SPL002, SPO009, SPR013, STE007, STO025, STR039, STU001, STU011, STU013, STU016, STU019, SUB007, SUN002, SUN034, SWE001, SWE002, SWE004, SWE005, TAI002, TAK003, TAL001, TAL004, TAL005, TBA001, TEN004, TEQ001, TER002, THE006, THE031, THE103, THE139, THE152, THE162, THE274, THO001, TIT001, TOM014, TOP020, TRI001, TUM001, ULY001, UNI062, VAL001, VAM001, VEG001, VER003, VIN001, VVB001, WES025, WES052, WIL004, WIL011, WIL014, WIL019, WIL032, YOG012, 120001, 13T001]
    2014-04-02 11:25:03,382 DEBUG | http-bio-8080-exec-6 | com.imperialbag.sa.service.impl.CommonServiceImpl |
    Finished Customer Id List
    2014-04-02 11:25:03,455 DEBUG | http-bio-8080-exec-6 | org.hibernate.SQL | select vcormhd0_.otord as otord9_, vcormhd0_.otadv as otadv9_, vcormhd0_.otasrc as otasrc9_, vcormhd0_.otcctd as otcctd9_, vcormhd0_.otcctt as otcctt9_, vcormhd0_.otcmp as otcmp9_, vcormhd0_.otcusr as otcusr9_, vcormhd0_.otcust as otcust9_, vcormhd0_.otdel as otdel9_, vcormhd0_.otdesc as otdesc9_, vcormhd0_.otemal as otemal9_, vcormhd0_.otlcgd as otlcgd9_, vcormhd0_.otlcgt as otlcgt9_, vcormhd0_.otloc as otloc9_, vcormhd0_.otodte as otodte9_, vcormhd0_.otorwt as otorwt9_, vcormhd0_.otsdte as otsdte9_, vcormhd0_.otship as otship9_, vcormhd0_.ottype as ottype9_, vcormhd0_.otuser as otuser9_, vcormhd0_.otword as otword9_ from T50FILES.Vcormhd vcormhd0_ where (vcormhd0_.otcust in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and vcormhd0_.ottype=? and (vcormhd0_.otdel in (?)) fetch first 25 rows only
    Hibernate: select vcormhd0_.otord as otord9_, vcormhd0_.otadv as otadv9_, vcormhd0_.otasrc as otasrc9_, vcormhd0_.otcctd as otcctd9_, vcormhd0_.otcctt as otcctt9_, vcormhd0_.otcmp as otcmp9_, vcormhd0_.otcusr as otcusr9_, vcormhd0_.otcust as otcust9_, vcormhd0_.otdel as otdel9_, vcormhd0_.otdesc as otdesc9_, vcormhd0_.otemal as otemal9_, vcormhd0_.otlcgd as otlcgd9_, vcormhd0_.otlcgt as otlcgt9_, vcormhd0_.otloc as otloc9_, vcormhd0_.otodte as otodte9_, vcormhd0_.otorwt as otorwt9_, vcormhd0_.otsdte as otsdte9_, vcormhd0_.otship as otship9_, vcormhd0_.ottype as ottype9_, vcormhd0_.otuser as otuser9_, vcormhd0_.otword as otword9_ from T50FILES.Vcormhd vcormhd0_ where (vcormhd0_.otcust in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and vcormhd0_.ottype=? and (vcormhd0_.otdel in (?)) fetch first 25 rows only
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [1] as [VARCHAR] - ABE001
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [2] as [VARCHAR] - ADV001
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [3] as [VARCHAR] - AIR003
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [4] as [VARCHAR] - ALB001
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [5] as [VARCHAR] - AMO001
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [6] as [VARCHAR] - AMS001
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [7] as [VARCHAR] - AMS005
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [8] as [VARCHAR] - ANE001
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [9] as [VARCHAR] - AQU004
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [10] as [VARCHAR] - ARA610
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [11] as [VARCHAR] - ARC010
    2014-04-02 11:25:03,455 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [12] as [VARCHAR] - ARC011
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [13] as [VARCHAR] - ARC012
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [14] as [VARCHAR] - ARC013
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [15] as [VARCHAR] - AROMA1
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [16] as [VARCHAR] - AROMA11
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [17] as [VARCHAR] - AROMA2
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [18] as [VARCHAR] - AROMA3
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [19] as [VARCHAR] - AROMA4
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [20] as [VARCHAR] - AROMA6
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [21] as [VARCHAR] - AROMA7
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [22] as [VARCHAR] - AROMA8
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [23] as [VARCHAR] - AROMA9
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [24] as [VARCHAR] - AROM08
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [25] as [VARCHAR] - AROM10
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [26] as [VARCHAR] - ARO003
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [27] as [VARCHAR] - ARO012
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [28] as [VARCHAR] - ART006
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [29] as [VARCHAR] - BAG003
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [30] as [VARCHAR] - BAG004
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [31] as [VARCHAR] - BAG014
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [32] as [VARCHAR] - BAG015
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [33] as [VARCHAR] - BAG034
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [34] as [VARCHAR] - BAG035
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [35] as [VARCHAR] - BAG064
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [36] as [VARCHAR] - BAG096
    2014-04-02 11:25:03,456 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [37] as [VARCHAR] - BAG097
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [38] as [VARCHAR] - BAG113
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [39] as [VARCHAR] - BAG125
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [40] as [VARCHAR] - BAG127
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [41] as [VARCHAR] - BAG144
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [42] as [VARCHAR] - BAG147
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [43] as [VARCHAR] - BAG151
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [44] as [VARCHAR] - BAG162
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [45] as [VARCHAR] - BAG172
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [46] as [VARCHAR] - BAG173
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [47] as [VARCHAR] - BAG179
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [48] as [VARCHAR] - BAG187
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [49] as [VARCHAR] - BAG193
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [50] as [VARCHAR] - BAG432
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [51] as [VARCHAR] - BAG544
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [52] as [VARCHAR] - BAG900
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [53] as [VARCHAR] - BAK006
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [54] as [VARCHAR] - BAL005
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [55] as [VARCHAR] - BAL007
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [56] as [VARCHAR] - BAR002
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [57] as [VARCHAR] - BAR006
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [58] as [VARCHAR] - BAR035
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [59] as [VARCHAR] - BAR046
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [60] as [VARCHAR] - BAT001
    2014-04-02 11:25:03,457 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [61] as [VARCHAR] - BAY004
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [62] as [VARCHAR] - BBPLG1
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [63] as [VARCHAR] - BBPMM1
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [64] as [VARCHAR] - BBPP01
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [65] as [VARCHAR] - BBPWS1
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [66] as [VARCHAR] - BBT002
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [67] as [VARCHAR] - BEA021
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [68] as [VARCHAR] - BEL012
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [69] as [VARCHAR] - BEL015
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [70] as [VARCHAR] - BER018
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [71] as [VARCHAR] - BES004
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [72] as [VARCHAR] - BFF051
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [73] as [VARCHAR] - BIG002
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [74] as [VARCHAR] - BIG034
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [75] as [VARCHAR] - BIM001
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [76] as [VARCHAR] - BIM002
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [77] as [VARCHAR] - BIS004
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [78] as [VARCHAR] - BLU001
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [79] as [VARCHAR] - BLU010
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [80] as [VARCHAR] - BLU011
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [81] as [VARCHAR] - BLU013
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [82] as [VARCHAR] - BLU015
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [83] as [VARCHAR] - BLU019
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [84] as [VARCHAR] - BLU020
    2014-04-02 11:25:03,458 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [85] as [VARCHAR] - BLU027
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [86] as [VARCHAR] - BLU038
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [87] as [VARCHAR] - BLU166
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [88] as [VARCHAR] - BOA005
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [89] as [VARCHAR] - BON003
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [90] as [VARCHAR] - BON007
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [91] as [VARCHAR] - BOO002
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [92] as [VARCHAR] - BOQ001
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [93] as [VARCHAR] - BOU001
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [94] as [VARCHAR] - BOU004
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [95] as [VARCHAR] - BRA008
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [96] as [VARCHAR] - BRE002
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [97] as [VARCHAR] - BRE011
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [98] as [VARCHAR] - BRE012
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [99] as [VARCHAR] - BRI028
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [100] as [VARCHAR] - BRO004
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [101] as [VARCHAR] - BRO015
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [102] as [VARCHAR] - BRO070
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [103] as [VARCHAR] - BRO072
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [104] as [VARCHAR] - BRO073
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [105] as [VARCHAR] - BRO074
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [106] as [VARCHAR] - BRO090
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [107] as [VARCHAR] - BRO103
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [108] as [VARCHAR] - BRO125
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [109] as [VARCHAR] - BUD005
    2014-04-02 11:25:03,459 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [110] as [VARCHAR] - BXL001
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [111] as [VARCHAR] - CAF013
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [112] as [VARCHAR] - CAF144
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [113] as [VARCHAR] - CAF180
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [114] as [VARCHAR] - CAN013
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [115] as [VARCHAR] - CAP022
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [116] as [VARCHAR] - CAR004
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [117] as [VARCHAR] - CAT006
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [118] as [VARCHAR] - CED002
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [119] as [VARCHAR] - CEN005
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [120] as [VARCHAR] - CEN006
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [121] as [VARCHAR] - CEN010
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [122] as [VARCHAR] - CEN032
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [123] as [VARCHAR] - CHA018
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [124] as [VARCHAR] - CHE007
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [125] as [VARCHAR] - CHE022
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [126] as [VARCHAR] - CHI051
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [127] as [VARCHAR] - CHO008
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [128] as [VARCHAR] - CIM003
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [129] as [VARCHAR] - CIR013
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [130] as [VARCHAR] - CIT012
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [131] as [VARCHAR] - CIT074
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [132] as [VARCHAR] - COF004
    2014-04-02 11:25:03,460 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [133] as [VARCHAR] - COMSTB
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [134] as [VARCHAR] - COM012
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [135] as [VARCHAR] - CON003
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [136] as [VARCHAR] - COO002
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [137] as [VARCHAR] - COO006
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [138] as [VARCHAR] - COR051
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [139] as [VARCHAR] - CRE036
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [140] as [VARCHAR] - CRI003
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [141] as [VARCHAR] - CRI004
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [142] as [VARCHAR] - CRI005
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [143] as [VARCHAR] - CRI006
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [144] as [VARCHAR] - CRI007
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [145] as [VARCHAR] - CRI008
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [146] as [VARCHAR] - CRI009
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [147] as [VARCHAR] - CRO012
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [148] as [VARCHAR] - CUC001
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [149] as [VARCHAR] - CUP008
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [150] as [VARCHAR] - DAN002
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [151] as [VARCHAR] - DAN011
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [152] as [VARCHAR] - DAV012
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [153] as [VARCHAR] - DEA003
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [154] as [VARCHAR] - DEA007
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [155] as [VARCHAR] - DEA008
    2014-04-02 11:25:03,461 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [156] as [VARCHAR] - DEL005
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [157] as [VARCHAR] - DEL014
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [158] as [VARCHAR] - DEL089
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [159] as [VARCHAR] - DET002
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [160] as [VARCHAR] - DIN210
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [161] as [VARCHAR] - DIST51
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [162] as [VARCHAR] - DOA001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [163] as [VARCHAR] - DOG001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [164] as [VARCHAR] - DOG010
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [165] as [VARCHAR] - DOM001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [166] as [VARCHAR] - DON022
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [167] as [VARCHAR] - DOR009
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [168] as [VARCHAR] - DOU003
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [169] as [VARCHAR] - DPI001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [170] as [VARCHAR] - DRA001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [171] as [VARCHAR] - DRE001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [172] as [VARCHAR] - DRI001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [173] as [VARCHAR] - ECS001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [174] as [VARCHAR] - EDE002
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [175] as [VARCHAR] - EDW003
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [176] as [VARCHAR] - EHI001
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [177] as [VARCHAR] - EHI002
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [178] as [VARCHAR] - ELC600
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [179] as [VARCHAR] - ELI002
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [180] as [VARCHAR] - ELI011
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [181] as [VARCHAR] - ELI012
    2014-04-02 11:25:03,462 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [182] as [VARCHAR] - ELI013
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [183] as [VARCHAR] - ELI014
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [184] as [VARCHAR] - ELL001
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [185] as [VARCHAR] - EMM002
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [186] as [VARCHAR] - EMP009
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [187] as [VARCHAR] - EUR012
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [188] as [VARCHAR] - FAM002
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [189] as [VARCHAR] - FAR003
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [190] as [VARCHAR] - FAR004
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [191] as [VARCHAR] - FAR176
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [192] as [VARCHAR] - FEA002
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [193] as [VARCHAR] - FIE005
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [194] as [VARCHAR] - FIG001
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [195] as [VARCHAR] - FIG002
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [196] as [VARCHAR] - FIG004
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [197] as [VARCHAR] - FIG005
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [198] as [VARCHAR] - FIG006
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [199] as [VARCHAR] - FIN000
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [200] as [VARCHAR] - FIN001
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [201] as [VARCHAR] - FIN002
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [202] as [VARCHAR] - FIN006
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [203] as [VARCHAR] - FIN010
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [204] as [VARCHAR] - FIN025
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [205] as [VARCHAR] - FIN035
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [206] as [VARCHAR] - FIN036
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [207] as [VARCHAR] - FIN037
    2014-04-02 11:25:03,463 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [208] as [VARCHAR] - FIN038
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [209] as [VARCHAR] - FIN039
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [210] as [VARCHAR] - FIN040
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [211] as [VARCHAR] - FIN041
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [212] as [VARCHAR] - FIN688
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [213] as [VARCHAR] - FIS004
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [214] as [VARCHAR] - FIV001
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [215] as [VARCHAR] - FIV002
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [216] as [VARCHAR] - FIV003
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [217] as [VARCHAR] - FIV004
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [218] as [VARCHAR] - FIV005
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [219] as [VARCHAR] - FIV006
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [220] as [VARCHAR] - FIV014
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [221] as [VARCHAR] - FLO004
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [222] as [VARCHAR] - FOO032
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [223] as [VARCHAR] - FOU002
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [224] as [VARCHAR] - FRA056
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [225] as [VARCHAR] - FRE002
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [226] as [VARCHAR] - FRE005
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [227] as [VARCHAR] - FRE006
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [228] as [VARCHAR] - FRE020
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [229] as [VARCHAR] - FRE055
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [230] as [VARCHAR] - FRE056
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [231] as [VARCHAR] - FRU016
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [232] as [VARCHAR] - GAB005
    2014-04-02 11:25:03,464 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [233] as [VARCHAR] - GAB006
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [234] as [VARCHAR] - GAB009
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [235] as [VARCHAR] - GAT003
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [236] as [VARCHAR] - GAT005
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [237] as [VARCHAR] - GEN229
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [238] as [VARCHAR] - GOA001
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [239] as [VARCHAR] - GOR001
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [240] as [VARCHAR] - GOT008
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [241] as [VARCHAR] - GOU021
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [242] as [VARCHAR] - GOU032
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [243] as [VARCHAR] - GOU035
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [244] as [VARCHAR] - GOU036
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [245] as [VARCHAR] - GOU037
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [246] as [VARCHAR] - GOU038
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [247] as [VARCHAR] - GOU049
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [248] as [VARCHAR] - GOU404
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [249] as [VARCHAR] - GRA018
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [250] as [VARCHAR] - GRA022
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [251] as [VARCHAR] - GRA034
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [252] as [VARCHAR] - GRE006
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [253] as [VARCHAR] - GRE066
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [254] as [VARCHAR] - GRO003
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [255] as [VARCHAR] - HAI111
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [256] as [VARCHAR] - HAM013
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [257] as [VARCHAR] - HAP007
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [258] as [VARCHAR] - HAR003
    2014-04-02 11:25:03,465 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [259] as [VARCHAR] - HOS003
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [260] as [VARCHAR] - HOU002
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [261] as [VARCHAR] - HOU004
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [262] as [VARCHAR] - HOU005
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [263] as [VARCHAR] - HUR001
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [264] as [VARCHAR] - HUR002
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [265] as [VARCHAR] - HYP001
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [266] as [VARCHAR] - IND001
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [267] as [VARCHAR] - INO003
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [268] as [VARCHAR] - INT004
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [269] as [VARCHAR] - JAM015
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [270] as [VARCHAR] - JAM021
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [271] as [VARCHAR] - JBRCM1
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [272] as [VARCHAR] - JBREB1
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [273] as [VARCHAR] - JBRFL2
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [274] as [VARCHAR] - JBRM02
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [275] as [VARCHAR] - JBRM03
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [276] as [VARCHAR] - JBRM04
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [277] as [VARCHAR] - JBRM05
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [278] as [VARCHAR] - JBRWB1
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [279] as [VARCHAR] - JBRZB1
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [280] as [VARCHAR] - JBR001
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [281] as [VARCHAR] - JBR002
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [282] as [VARCHAR] - JBR003
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [283] as [VARCHAR] - JBR006
    2014-04-02 11:25:03,466 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [284] as [VARCHAR] - JBR011
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [285] as [VARCHAR] - JEA006
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [286] as [VARCHAR] - JER002
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [287] as [VARCHAR] - JER007
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [288] as [VARCHAR] - JON001
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [289] as [VARCHAR] - JOS001
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [290] as [VARCHAR] - JUI000
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [291] as [VARCHAR] - JUI001
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [292] as [VARCHAR] - JUI002
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [293] as [VARCHAR] - JUI003
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [294] as [VARCHAR] - JUI004
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [295] as [VARCHAR] - JUI005
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [296] as [VARCHAR] - JUI006
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [297] as [VARCHAR] - JUI008
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [298] as [VARCHAR] - JUI009
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [299] as [VARCHAR] - JUI011
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [300] as [VARCHAR] - JUI018
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [301] as [VARCHAR] - KIN003
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [302] as [VARCHAR] - KIS003
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [303] as [VARCHAR] - KOF001
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [304] as [VARCHAR] - KOP001
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [305] as [VARCHAR] - KRO003
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [306] as [VARCHAR] - KUT001
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [307] as [VARCHAR] - LAB004
    2014-04-02 11:25:03,467 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [308] as [VARCHAR] - LAB012
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [309] as [VARCHAR] - LAB021
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [310] as [VARCHAR] - LAM005
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [311] as [VARCHAR] - LAM006
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [312] as [VARCHAR] - LAN015
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [313] as [VARCHAR] - LAR003
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [314] as [VARCHAR] - LEC001
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [315] as [VARCHAR] - LEC003
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [316] as [VARCHAR] - LEC009
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [317] as [VARCHAR] - LEG001
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [318] as [VARCHAR] - LEG003
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [319] as [VARCHAR] - LEG004
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [320] as [VARCHAR] - LEG006
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [321] as [VARCHAR] - LEG012
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [322] as [VARCHAR] - LEG013
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [323] as [VARCHAR] - LEG015
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [324] as [VARCHAR] - LEM007
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [325] as [VARCHAR] - LEN007
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [326] as [VARCHAR] - LEP001
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [327] as [VARCHAR] - LEP007
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [328] as [VARCHAR] - LEP010
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [329] as [VARCHAR] - LEP011
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [330] as [VARCHAR] - LEP012
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [331] as [VARCHAR] - LEP013
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [332] as [VARCHAR] - LEP015
    2014-04-02 11:25:03,468 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [333] as [VARCHAR] - LEP016
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [334] as [VARCHAR] - LEP017
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [335] as [VARCHAR] - LEP019
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [336] as [VARCHAR] - LEP020
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [337] as [VARCHAR] - LEP021
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [338] as [VARCHAR] - LEP022
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [339] as [VARCHAR] - LEP025
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [340] as [VARCHAR] - LEP026
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [341] as [VARCHAR] - LEP137
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [342] as [VARCHAR] - LEP147
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [343] as [VARCHAR] - LEP199
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [344] as [VARCHAR] - LET001
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [345] as [VARCHAR] - LET002
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [346] as [VARCHAR] - LEV000
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [347] as [VARCHAR] - LEV002
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [348] as [VARCHAR] - LEV004
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [349] as [VARCHAR] - LEV005
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [350] as [VARCHAR] - LEV006
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [351] as [VARCHAR] - LEV007
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [352] as [VARCHAR] - LEV009
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [353] as [VARCHAR] - LEV010
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [354] as [VARCHAR] - LEX002
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [355] as [VARCHAR] - LEX008
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [356] as [VARCHAR] - LIB018
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [357] as [VARCHAR] - LIN002
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [358] as [VARCHAR] - LIN013
    2014-04-02 11:25:03,469 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [359] as [VARCHAR] - LIT006
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [360] as [VARCHAR] - LIT777
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [361] as [VARCHAR] - LOB252
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [362] as [VARCHAR] - LOB531
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [363] as [VARCHAR] - LOR007
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [364] as [VARCHAR] - LOR011
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [365] as [VARCHAR] - LOX002
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [366] as [VARCHAR] - LPQ113
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [367] as [VARCHAR] - LPQ123
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [368] as [VARCHAR] - LPQ141
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [369] as [VARCHAR] - LPQ142
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [370] as [VARCHAR] - LPQ143
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [371] as [VARCHAR] - LPQ144
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [372] as [VARCHAR] - LPQ145
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [373] as [VARCHAR] - LPQ146
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [374] as [VARCHAR] - LPQ310
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [375] as [VARCHAR] - LPQ311
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [376] as [VARCHAR] - LPQ312
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [377] as [VARCHAR] - LPQ313
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [378] as [VARCHAR] - LPQ314
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [379] as [VARCHAR] - LPQ404
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [380] as [VARCHAR] - LPQ500
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [381] as [VARCHAR] - LUC003
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [382] as [VARCHAR] - LUC016
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [383] as [VARCHAR] - MAD001
    2014-04-02 11:25:03,470 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [384] as [VARCHAR] - MAD014
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [385] as [VARCHAR] - MAI000
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [386] as [VARCHAR] - MAI002
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [387] as [VARCHAR] - MAI004
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [388] as [VARCHAR] - MAI005
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [389] as [VARCHAR] - MAI006
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [390] as [VARCHAR] - MAI007
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [391] as [VARCHAR] - MAL003
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [392] as [VARCHAR] - MAL008
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [393] as [VARCHAR] - MAN010
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [394] as [VARCHAR] - MAN013
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [395] as [VARCHAR] - MAN014
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [396] as [VARCHAR] - MAN061
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [397] as [VARCHAR] - MAN076
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [398] as [VARCHAR] - MAN080
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [399] as [VARCHAR] - MAN082
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [400] as [VARCHAR] - MAN092
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [401] as [VARCHAR] - MAN200
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [402] as [VARCHAR] - MAN400
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [403] as [VARCHAR] - MAO001
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [404] as [VARCHAR] - MAO002
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [405] as [VARCHAR] - MAO003
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [406] as [VARCHAR] - MAO004
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [407] as [VARCHAR] - MAO005
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [408] as [VARCHAR] - MAO006
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [409] as [VARCHAR] - MAO007
    2014-04-02 11:25:03,471 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [410] as [VARCHAR] - MAO008
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [411] as [VARCHAR] - MAO009
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [412] as [VARCHAR] - MAO010
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [413] as [VARCHAR] - MAO011
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [414] as [VARCHAR] - MAO012
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [415] as [VARCHAR] - MAO013
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [416] as [VARCHAR] - MAO014
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [417] as [VARCHAR] - MAO015
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [418] as [VARCHAR] - MAO016
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [419] as [VARCHAR] - MAO017
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [420] as [VARCHAR] - MAR057
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [421] as [VARCHAR] - MAR090
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [422] as [VARCHAR] - MAR129
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [423] as [VARCHAR] - MAR140
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [424] as [VARCHAR] - MAR143
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [425] as [VARCHAR] - MAX001
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [426] as [VARCHAR] - MAX003
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [427] as [VARCHAR] - MAX004
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [428] as [VARCHAR] - MAX005
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [429] as [VARCHAR] - MAX009
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [430] as [VARCHAR] - MAX010
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [431] as [VARCHAR] - MAX013
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [432] as [VARCHAR] - MAX015
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [433] as [VARCHAR] - MAX016
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [434] as [VARCHAR] - MEE001
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [435] as [VARCHAR] - MEZ001
    2014-04-02 11:25:03,472 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [436] as [VARCHAR] - MGD001
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [437] as [VARCHAR] - MIK004
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [438] as [VARCHAR] - MIL005
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [439] as [VARCHAR] - MIL020
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [440] as [VARCHAR] - MIL033
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [441] as [VARCHAR] - MIL034
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [442] as [VARCHAR] - MOH002
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [443] as [VARCHAR] - MOM009
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [444] as [VARCHAR] - MOO004
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [445] as [VARCHAR] - MOO011
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [446] as [VARCHAR] - MSF002
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [447] as [VARCHAR] - MUR002
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [448] as [VARCHAR] - MUR005
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [449] as [VARCHAR] - MUR008
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [450] as [VARCHAR] - MUR011
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [451] as [VARCHAR] - MYC001
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [452] as [VARCHAR] - NAY004
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [453] as [VARCHAR] - NEW067
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [454] as [VARCHAR] - NEW133
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [455] as [VARCHAR] - NEW195
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [456] as [VARCHAR] - NIC006
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [457] as [VARCHAR] - NIK003
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [458] as [VARCHAR] - NIZ001
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [459] as [VARCHAR] - NOB001
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [460] as [VARCHAR] - NOB002
    2014-04-02 11:25:03,473 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [461] as [VARCHAR] - NOW001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [462] as [VARCHAR] - NYU001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [463] as [VARCHAR] - OBI001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [464] as [VARCHAR] - OBI002
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [465] as [VARCHAR] - OLI001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [466] as [VARCHAR] - OLI002
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [467] as [VARCHAR] - OLI003
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [468] as [VARCHAR] - ONC001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [469] as [VARCHAR] - ONE002
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [470] as [VARCHAR] - ONE014
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [471] as [VARCHAR] - OSC001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [472] as [VARCHAR] - OSS001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [473] as [VARCHAR] - OSS004
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [474] as [VARCHAR] - OST001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [475] as [VARCHAR] - OTG001
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [476] as [VARCHAR] - PAN011
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [477] as [VARCHAR] - PAN039
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [478] as [VARCHAR] - PAP002
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [479] as [VARCHAR] - PAP008
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [480] as [VARCHAR] - PAP016
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [481] as [VARCHAR] - PAP024
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [482] as [VARCHAR] - PAR071
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [483] as [VARCHAR] - PAR072
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [484] as [VARCHAR] - PEG002
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [485] as [VARCHAR] - PER028
    2014-04-02 11:25:03,474 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [486] as [VARCHAR] - PET011
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [487] as [VARCHAR] - PET023
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [488] as [VARCHAR] - PET025
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [489] as [VARCHAR] - PHI004
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [490] as [VARCHAR] - PIG002
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [491] as [VARCHAR] - PIN015
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [492] as [VARCHAR] - PLA033
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [493] as [VARCHAR] - POM001
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [494] as [VARCHAR] - PQA001
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [495] as [VARCHAR] - PQB002
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [496] as [VARCHAR] - PQB003
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [497] as [VARCHAR] - PQB138
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [498] as [VARCHAR] - PQC001
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [499] as [VARCHAR] - PQC002
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [500] as [VARCHAR] - PQC003
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [501] as [VARCHAR] - PQC004
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [502] as [VARCHAR] - PQF001
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [503] as [VARCHAR] - PQL002
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [504] as [VARCHAR] - PQL003
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [505] as [VARCHAR] - PQM001
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [506] as [VARCHAR] - PQM002
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [507] as [VARCHAR] - PQM315
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [508] as [VARCHAR] - PQN002
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [509] as [VARCHAR] - PQP001
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [510] as [VARCHAR] - PQR001
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [511] as [VARCHAR] - PQR002
    2014-04-02 11:25:03,475 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [512] as [VARCHAR] - PQS001
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [513] as [VARCHAR] - PQT001
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [514] as [VARCHAR] - PQT002
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [515] as [VARCHAR] - PQUN01
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [516] as [VARCHAR] - PQUW01
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [517] as [VARCHAR] - PQU001
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [518] as [VARCHAR] - PQW001
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [519] as [VARCHAR] - PQW002
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [520] as [VARCHAR] - PQW003
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [521] as [VARCHAR] - PQ1001
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [522] as [VARCHAR] - PRO003
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [523] as [VARCHAR] - PUT002
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [524] as [VARCHAR] - PYR002
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [525] as [VARCHAR] - PYR004
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [526] as [VARCHAR] - RAU001
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [527] as [VARCHAR] - REA010
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [528] as [VARCHAR] - RED002
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [529] as [VARCHAR] - RED006
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [530] as [VARCHAR] - RED025
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [531] as [VARCHAR] - RED026
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [532] as [VARCHAR] - RED028
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [533] as [VARCHAR] - RED029
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [534] as [VARCHAR] - RED030
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [535] as [VARCHAR] - RED031
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [536] as [VARCHAR] - RES002
    2014-04-02 11:25:03,476 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [537] as [VARCHAR] - RIC004
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [538] as [VARCHAR] - RIC016
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [539] as [VARCHAR] - RIC017
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [540] as [VARCHAR] - RIV001
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [541] as [VARCHAR] - ROC002
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [542] as [VARCHAR] - ROC005
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [543] as [VARCHAR] - ROS005
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [544] as [VARCHAR] - ROS006
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [545] as [VARCHAR] - ROT004
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [546] as [VARCHAR] - ROU007
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [547] as [VARCHAR] - RUE002
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [548] as [VARCHAR] - RYE006
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [549] as [VARCHAR] - SAL031
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [550] as [VARCHAR] - SAM002
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [551] as [VARCHAR] - SAR016
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [552] as [VARCHAR] - SAR031
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [553] as [VARCHAR] - SAU003
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [554] as [VARCHAR] - SAV002
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [555] as [VARCHAR] - SCH006
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [556] as [VARCHAR] - SCH011
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [557] as [VARCHAR] - SEA013
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [558] as [VARCHAR] - SEX001
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [559] as [VARCHAR] - SHU001
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [560] as [VARCHAR] - SIM014
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [561] as [VARCHAR] - SIM018
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [562] as [VARCHAR] - SIX630
    2014-04-02 11:25:03,477 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [563] as [VARCHAR] - SMI002
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [564] as [VARCHAR] - SMI003
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [565] as [VARCHAR] - SOH009
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [566] as [VARCHAR] - SOU002
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [567] as [VARCHAR] - SOU003
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [568] as [VARCHAR] - SOU011
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [569] as [VARCHAR] - SPI005
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [570] as [VARCHAR] - SPL002
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [571] as [VARCHAR] - SPO009
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [572] as [VARCHAR] - SPR013
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [573] as [VARCHAR] - STE007
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [574] as [VARCHAR] - STO025
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [575] as [VARCHAR] - STR039
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [576] as [VARCHAR] - STU001
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [577] as [VARCHAR] - STU011
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [578] as [VARCHAR] - STU013
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [579] as [VARCHAR] - STU016
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [580] as [VARCHAR] - STU019
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [581] as [VARCHAR] - SUB007
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [582] as [VARCHAR] - SUN002
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [583] as [VARCHAR] - SUN034
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [584] as [VARCHAR] - SWE001
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [585] as [VARCHAR] - SWE002
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [586] as [VARCHAR] - SWE004
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [587] as [VARCHAR] - SWE005
    2014-04-02 11:25:03,478 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [588] as [VARCHAR] - TAI002
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [589] as [VARCHAR] - TAK003
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [590] as [VARCHAR] - TAL001
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [591] as [VARCHAR] - TAL004
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [592] as [VARCHAR] - TAL005
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [593] as [VARCHAR] - TBA001
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [594] as [VARCHAR] - TEN004
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [595] as [VARCHAR] - TEQ001
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [596] as [VARCHAR] - TER002
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [597] as [VARCHAR] - THE006
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [598] as [VARCHAR] - THE031
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [599] as [VARCHAR] - THE103
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [600] as [VARCHAR] - THE139
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [601] as [VARCHAR] - THE152
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [602] as [VARCHAR] - THE162
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [603] as [VARCHAR] - THE274
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [604] as [VARCHAR] - THO001
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [605] as [VARCHAR] - TIT001
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [606] as [VARCHAR] - TOM014
    2014-04-02 11:25:03,479 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [607] as [VARCHAR] - TOP020
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [608] as [VARCHAR] - TRI001
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [609] as [VARCHAR] - TUM001
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [610] as [VARCHAR] - ULY001
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [611] as [VARCHAR] - UNI062
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [612] as [VARCHAR] - VAL001
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [613] as [VARCHAR] - VAM001
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [614] as [VARCHAR] - VEG001
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [615] as [VARCHAR] - VER003
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [616] as [VARCHAR] - VIN001
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [617] as [VARCHAR] - VVB001
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [618] as [VARCHAR] - WES025
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [619] as [VARCHAR] - WES052
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [620] as [VARCHAR] - WIL004
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [621] as [VARCHAR] - WIL011
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [622] as [VARCHAR] - WIL014
    2014-04-02 11:25:03,480 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [623] as [VARCHAR] - WIL019
    2014-04-02 11:25:03,481 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [624] as [VARCHAR] - WIL032
    2014-04-02 11:25:03,481 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [625] as [VARCHAR] - YOG012
    2014-04-02 11:25:03,481 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [626] as [VARCHAR] - 120001
    2014-04-02 11:25:03,481 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [627] as [VARCHAR] - 13T001
    2014-04-02 11:25:03,481 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [628] as [VARCHAR] - SO
    2014-04-02 11:25:03,481 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicBinder | binding parameter [629] as [VARCHAR] -
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [875] as column [otord9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ ] as column [otadv9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [W] as column [otasrc9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [20140401] as column [otcctd9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [170246] as column [otcctt9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [1] as column [otcmp9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [LARSCH ] as column [otcusr9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ABE001 ] as column [otcust9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ ] as column [otdel9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ ] as column [otdesc9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [LARSCH ] as column [otemal9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [170246] as column [otlcgd9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [170246] as column [otlcgt9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [59 ] as column [otloc9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [20140401] as column [otodte9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [SYS] as column [otorwt9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [20140401] as column [otsdte9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ ] as column [otship9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [SO] as column [ottype9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [LARSCH ] as column [otuser9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [0] as column [otword9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [872] as column [otord9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ ] as column [otadv9_]
    2014-04-02 11:25:03,511 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [W] as column [otasrc9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [20140401] as column [otcctd9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [160106] as column [otcctt9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [1] as column [otcmp9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [LARSCH ] as column [otcusr9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ALB001 ] as column [otcust9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ ] as column [otdel9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ ] as column [otdesc9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [LARSCH ] as column [otemal9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [160106] as column [otlcgd9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [160106] as column [otlcgt9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [59 ] as column [otloc9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [20140401] as column [otodte9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [SYS] as column [otorwt9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [20140401] as column [otsdte9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [ ] as column [otship9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [SO] as column [ottype9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [LARSCH ] as column [otuser9_]
    2014-04-02 11:25:03,512 TRACE | http-bio-8080-exec-6 | org.hibernate.type.descriptor.sql.BasicExtractor | Found [0] as column [otword9_]
    2014-04-02 11:25:03,580 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | Requested completed in: 204ms
    2014-04-02 11:25:03,580 INFO | http-bio-8080-exec-6 | com.imperialbag.sa.filter.ImperialSaLoggingFilter | !--REQUEST END--!

     
  • Karim Assaf

    Karim Assaf - 2014-05-29

    Will we have resolution to this? This is happens every so often on the prepared statements. Seems like a character is represented as a numeric column which throws this mismatch. Is there anything i should be looking at on my end or do i call ibm or is this a bug? Please let me know how to proceed as it happens every so often!

     
  • John Eberhard

    John Eberhard - 2014-05-29

    I cannot open the other defect either.

    Is the definition of the vcormhd0_.otcust column changing frequently? If so, then the database engine could be getting confused.

    Otherwise, it is probably best to pursue this through IBM service, since this appears to be a fairly complex issue which only fails intermittently.

     
    • Karim Assaf

      Karim Assaf - 2014-05-29

      Hi,
      I am not sure where the other defect disappeared too which had the data stream and everything in it. The DB table is never changing and hasn't changed for awhile. I will pursue this with ivm but just wanted to get my facts straight so they can better find out the issue. It always breaks on the below lines:

      Caused by: java.sql.SQLException: Data type mismatch.
      at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:841) ~[jt400.jar:JTOpen 8.2]
      at com.ibm.as400.access.JDError.throwSQLException(JDError.java:404) ~[jt400.jar:JTOpen 8.2]
      at com.ibm.as400.access.SQLNumeric.set(SQLNumeric.java:123) ~[jt400.jar:JTOpen 8.2]
      at com.ibm.as400.access.AS400JDBCPreparedStatement.setValue(AS400JDBCPreparedStatement.java:3563) ~[jt400.jar:JTOpen 8.2]
      at com.ibm.as400.access.AS400JDBCPreparedStatement.setString(AS400JDBCPreparedStatement.java:3211) ~[jt400.jar:JTOpen 8.2]

      Seems like it is trying to convert a character into a string and hence the error. Not really sure why it is thinking that this character field has to be set on a numeric column

      Respectfully,
      Karim Assaf

      From: John Eberhard jeberhard@users.sf.net<mailto:jeberhard@users.sf.net>
      Reply-To: "[jt400:bugs]" 349@bugs.jt400.p.re.sf.net<mailto:349@bugs.jt400.p.re.sf.net>
      Date: Thursday, May 29, 2014 2:20 PM
      To: "[jt400:bugs]" 349@bugs.jt400.p.re.sf.net<mailto:349@bugs.jt400.p.re.sf.net>
      Subject: [jt400:bugs] #349 Data Type Mismatch Occasionally when using positional params

      I cannot open the other defect either.

      Is the definition of the vcormhd0_.otcust column changing frequently? If so, then the database engine could be getting confused.

      Otherwise, it is probably best to pursue this through IBM service, since this appears to be a fairly complex issue which only fails intermittently.


      [bugs:#349]http://sourceforge.net/p/jt400/bugs/349/ Data Type Mismatch Occasionally when using positional params

      Status: open
      Group: Connection
      Created: Wed Mar 05, 2014 04:45 PM UTC by Karim Assaf
      Last Updated: Thu May 29, 2014 05:52 PM UTC
      Owner: John Eberhard

      This is the same as [bugs:#346]http://sourceforge.net/p/jt400/bugs/346/ Data Type Mismatch Occasionally on String Data Type but for some reason I am unable to open it. The issue still occurs even after loading the latest PMR's. I believe I sent you all the logs in the past and you recommended waiting for the latest PMR. We have loaded this and still issue occurs "OCCASIONALLY". If we switch to named params the issue goes away (so thats how we solved it on our end)


      Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/jt400/bugs/349/

      To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

       

      Related

      Bugs: #346
      Bugs: #349

  • John Eberhard

    John Eberhard - 2014-07-22

    This is a server problem. A customer has opened PMR 94042,7TD,000 for investigation by IBM.

     
  • John Eberhard

    John Eberhard - 2014-07-22
    • status: open --> closed-server-problem
     
  • John Eberhard

    John Eberhard - 2015-03-16
     
  • Peter Suurküla

    Peter Suurküla - 2015-04-30

    Thanks for the fix, I hope our sysadmin will be able to install it soon, and that it fixes our problem too - we've had a very similar problem for years, every once in a while, without knowing where it came from.
    The only difference seems to be the datatype, BigInteger (or Long on the Java side) - it crashed with an Hibernate "in" criteria on a list of ids (chunks of 500 ids at a time).

    Below is the fixed link from the previous message (without the ":" at the end) :
    http://www-01.ibm.com/support/docview.wss?uid=nas21db02087e36fe1c286257df10041ecbb

     
    Last edit: Peter Suurküla 2015-04-30

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks