2017-05-30 16:45:57,181 TRACE main [org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream] send: conn:635157(M) 99 03 00 00 03 53 45 4C 45 43 54 20 45 50 2E 49 .....SELECT EP.I 44 20 41 53 20 45 50 49 44 2C 20 45 50 2E 45 50 D AS EPID, EP.EP 49 53 4F 44 45 5F 49 44 20 41 53 20 45 50 49 53 ISODE_ID AS EPIS 4F 44 45 5F 49 44 2C 20 45 50 2E 54 49 54 4C 45 ODE_ID, EP.TITLE 20 41 53 20 45 50 49 53 4F 44 45 5F 54 49 54 4C AS EPISODE_TITL 45 2C 20 45 50 2E 44 55 52 41 54 49 4F 4E 20 41 E, EP.DURATION A 53 20 45 50 49 53 4F 44 45 5F 44 55 52 41 54 49 S EPISODE_DURATI 4F 4E 2C 20 45 50 2E 45 50 49 53 4F 44 45 5F 4E ON, EP.EPISODE_N 55 4D 42 45 52 20 41 53 20 45 50 49 53 4F 44 45 UMBER AS EPISODE 5F 4E 55 4D 42 45 52 2C 20 45 50 2E 45 50 49 53 _NUMBER, EP.EPIS 4F 44 45 5F 54 59 50 45 5F 49 44 2C 20 45 50 2E ODE_TYPE_ID, EP. 4C 41 53 54 5F 45 44 49 54 45 44 2C 20 45 54 2E LAST_EDITED, ET. 4E 41 4D 45 20 41 53 20 45 50 49 53 4F 44 45 5F NAME AS EPISODE_ 54 59 50 45 5F 4E 41 4D 45 2C 20 53 2E 49 44 20 TYPE_NAME, S.ID 41 53 20 53 45 52 49 44 2C 20 53 2E 53 45 52 49 AS SERID, S.SERI 45 53 5F 43 4F 44 45 20 41 53 20 53 45 52 49 45 ES_CODE AS SERIE 53 5F 43 4F 44 45 2C 20 53 2E 44 45 53 43 52 49 S_CODE, S.DESCRI 50 54 49 4F 4E 20 41 53 20 53 45 52 49 45 53 5F PTION AS SERIES_ 44 45 53 43 52 49 50 54 49 4F 4E 2C 20 53 2E 54 DESCRIPTION, S.T 49 54 4C 45 20 41 53 20 53 45 52 49 45 53 5F 54 ITLE AS SERIES_T 49 54 4C 45 2C 20 53 2E 53 45 52 49 45 53 5F 4E ITLE, S.SERIES_N 55 4D 42 45 52 2C 20 45 50 2E 53 54 41 54 45 5F UMBER, EP.STATE_ 49 44 2C 20 53 54 2E 4E 41 4D 45 20 41 53 20 53 ID, ST.NAME AS S 54 41 54 45 5F 4E 41 4D 45 2C 20 53 54 2E 4E 41 TATE_NAME, ST.NA 4D 45 5F 49 31 38 4E 20 41 53 20 53 54 41 54 45 ME_I18N AS STATE 5F 4E 41 4D 45 5F 49 31 38 4E 2C 20 45 50 2E 53 _NAME_I18N, EP.S 54 41 54 45 5F 4D 41 43 48 49 4E 45 5F 49 44 2C TATE_MACHINE_ID, 20 53 4D 2E 4E 41 4D 45 20 41 53 20 53 54 41 54 SM.NAME AS STAT 45 5F 4D 41 43 48 49 4E 45 5F 4E 41 4D 45 2C 20 E_MACHINE_NAME, 45 50 2E 55 53 45 52 5F 49 44 2C 20 4D 55 2E 4E EP.USER_ID, MU.N 41 4D 45 20 41 53 20 55 53 45 52 5F 4E 41 4D 45 AME AS USER_NAME 2C 20 46 52 2E 4E 41 4D 45 20 46 52 41 4D 45 5F , FR.NAME FRAME_ 52 41 54 45 2C 20 45 50 2E 57 4F 52 4B 46 4C 4F RATE, EP.WORKFLO 57 5F 43 4F 4D 50 4C 45 54 49 4F 4E 5F 44 41 54 W_COMPLETION_DAT 45 20 46 52 4F 4D 20 45 50 49 53 4F 44 45 20 45 E FROM EPISODE E 50 20 4C 45 46 54 20 4A 4F 49 4E 20 45 50 49 53 P LEFT JOIN EPIS 4F 44 45 5F 54 59 50 45 20 45 54 20 4F 4E 20 45 ODE_TYPE ET ON E 50 2E 45 50 49 53 4F 44 45 5F 54 59 50 45 5F 49 P.EPISODE_TYPE_I 44 20 3D 20 45 54 2E 49 44 20 4C 45 46 54 20 4A D = ET.ID LEFT J 4F 49 4E 20 53 45 52 49 45 53 20 53 20 4F 4E 20 OIN SERIES S ON 53 2E 49 44 20 3D 20 45 50 2E 53 45 52 49 45 53 S.ID = EP.SERIES 5F 49 44 20 4C 45 46 54 20 4A 4F 49 4E 20 53 54 _ID LEFT JOIN ST 41 54 45 20 53 54 20 4F 4E 20 45 50 2E 53 54 41 ATE ST ON EP.STA 54 45 5F 49 44 20 3D 20 53 54 2E 49 44 20 4C 45 TE_ID = ST.ID LE 46 54 20 4A 4F 49 4E 20 53 54 41 54 45 5F 4D 41 FT JOIN STATE_MA 43 48 49 4E 45 20 53 4D 20 4F 4E 20 45 50 2E 53 CHINE SM ON EP.S 54 41 54 45 5F 4D 41 43 48 49 4E 45 5F 49 44 20 TATE_MACHINE_ID 3D 20 53 4D 2E 49 44 20 4C 45 46 54 20 4A 4F 49 = SM.ID LEFT JOI 4E 20 4D 45 44 49 41 54 4F 52 5F 55 53 45 52 20 N MEDIATOR_USER 4D 55 20 4F 4E 20 45 50 2E 55 53 45 52 5F 49 44 MU ON EP.USER_ID 20 3D 20 4D 55 2E 49 44 20 4C 45 46 54 20 4A 4F = MU.ID LEFT JO 49 4E 20 46 52 41 4D 45 5F 52 41 54 45 20 46 52 IN FRAME_RATE FR 20 4F 4E 20 46 52 2E 49 44 20 3D 20 45 50 2E 46 ON FR.ID = EP.F 52 41 4D 45 5F 52 41 54 45 5F 49 44 20 57 48 45 RAME_RATE_ID WHE 52 45 20 45 50 2E 45 50 49 53 4F 44 45 5F 49 44 RE EP.EPISODE_ID 20 3D 20 27 54 65 73 74 45 70 69 73 6F 64 65 49 = 'TestEpisodeI 64 4F 6E 65 27 20 41 4E 44 20 45 50 2E 44 45 4C dOne' AND EP.DEL 45 54 45 5F 4D 41 52 4B 20 3D 20 30 20 ETE_MARK = 0 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 01 00 00 01 .... 16 . 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 2D 00 00 02 -... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 04 45 50 49 44 02 49 44 .EPISODE.EPID.ID 0C 3F 00 0B 00 00 00 03 03 42 00 00 00 .?.......B... 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 3B 00 00 03 ;... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 0A 45 50 49 53 4F 44 45 .EPISODE.EPISODE 5F 49 44 0A 45 50 49 53 4F 44 45 5F 49 44 0C 2E _ID.EPISODE_ID.. 00 FC 03 00 00 FD 8D 50 00 00 00 .......P... 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 39 00 00 04 9... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 0D 45 50 49 53 4F 44 45 .EPISODE.EPISODE 5F 54 49 54 4C 45 05 54 49 54 4C 45 0C 2E 00 00 _TITLE.TITLE.... 08 00 00 FD 80 00 00 00 00 ......... 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 3F 00 00 05 ?... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 10 45 50 49 53 4F 44 45 .EPISODE.EPISODE 5F 44 55 52 41 54 49 4F 4E 08 44 55 52 41 54 49 _DURATION.DURATI 4F 4E 0C 2E 00 2C 00 00 00 FD 80 00 00 00 00 ON...,......... 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 43 00 00 06 C... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 0E 45 50 49 53 4F 44 45 .EPISODE.EPISODE 5F 4E 55 4D 42 45 52 0E 45 50 49 53 4F 44 45 5F _NUMBER.EPISODE_ 4E 55 4D 42 45 52 0C 3F 00 0B 00 00 00 03 00 00 NUMBER.?........ 00 00 00 ... 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 45 00 00 07 E... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 0F 45 50 49 53 4F 44 45 .EPISODE.EPISODE 5F 54 59 50 45 5F 49 44 0F 45 50 49 53 4F 44 45 _TYPE_ID.EPISODE 5F 54 59 50 45 5F 49 44 0C 3F 00 0B 00 00 00 03 _TYPE_ID.?...... 08 40 00 00 00 .@... 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 3D 00 00 08 =... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 0B 4C 41 53 54 5F 45 44 .EPISODE.LAST_ED 49 54 45 44 0B 4C 41 53 54 5F 45 44 49 54 45 44 ITED.LAST_EDITED 0C 3F 00 1A 00 00 00 0C 80 00 06 00 00 .?........... 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 41 00 00 09 A... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 54 .def.unittest.ET 0C 45 50 49 53 4F 44 45 5F 54 59 50 45 11 45 50 .EPISODE_TYPE.EP 49 53 4F 44 45 5F 54 59 50 45 5F 4E 41 4D 45 04 ISODE_TYPE_NAME. 4E 41 4D 45 0C 2E 00 A0 00 00 00 FD 80 10 00 00 NAME............ 00 . 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 2C 00 00 0A ,... 03 64 65 66 08 75 6E 69 74 74 65 73 74 01 53 06 .def.unittest.S. 53 45 52 49 45 53 05 53 45 52 49 44 02 49 44 0C SERIES.SERID.ID. 3F 00 0B 00 00 00 03 03 42 00 00 00 ?.......B... 2017-05-30 16:45:57,182 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 3B 00 00 0B ;... 03 64 65 66 08 75 6E 69 74 74 65 73 74 01 53 06 .def.unittest.S. 53 45 52 49 45 53 0B 53 45 52 49 45 53 5F 43 4F SERIES.SERIES_CO 44 45 0B 53 45 52 49 45 53 5F 43 4F 44 45 0C 2E DE.SERIES_CODE.. 00 FC 03 00 00 FD 85 50 00 00 00 .......P... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 42 00 00 0C B... 03 64 65 66 08 75 6E 69 74 74 65 73 74 01 53 06 .def.unittest.S. 53 45 52 49 45 53 12 53 45 52 49 45 53 5F 44 45 SERIES.SERIES_DE 53 43 52 49 50 54 49 4F 4E 0B 44 45 53 43 52 49 SCRIPTION.DESCRI 50 54 49 4F 4E 0C 2E 00 00 10 00 00 FD 80 00 00 PTION........... 00 00 .. 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 36 00 00 0D 6... 03 64 65 66 08 75 6E 69 74 74 65 73 74 01 53 06 .def.unittest.S. 53 45 52 49 45 53 0C 53 45 52 49 45 53 5F 54 49 SERIES.SERIES_TI 54 4C 45 05 54 49 54 4C 45 0C 2E 00 00 08 00 00 TLE.TITLE....... FD 80 00 00 00 00 ...... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 3F 00 00 0E ?... 03 64 65 66 08 75 6E 69 74 74 65 73 74 01 53 06 .def.unittest.S. 53 45 52 49 45 53 0D 53 45 52 49 45 53 5F 4E 55 SERIES.SERIES_NU 4D 42 45 52 0D 53 45 52 49 45 53 5F 4E 55 4D 42 MBER.SERIES_NUMB 45 52 0C 3F 00 0B 00 00 00 03 00 00 00 00 00 ER.?........... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 37 00 00 0F 7... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 08 53 54 41 54 45 5F 49 .EPISODE.STATE_I 44 08 53 54 41 54 45 5F 49 44 0C 3F 00 0B 00 00 D.STATE_ID.?.... 00 03 08 40 00 00 00 ...@... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 33 00 00 10 3... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 53 54 .def.unittest.ST 05 53 54 41 54 45 0A 53 54 41 54 45 5F 4E 41 4D .STATE.STATE_NAM 45 04 4E 41 4D 45 0C 2E 00 20 03 00 00 FD 81 10 E.NAME... ...... 00 00 00 ... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 3D 00 00 11 =... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 53 54 .def.unittest.ST 05 53 54 41 54 45 0F 53 54 41 54 45 5F 4E 41 4D .STATE.STATE_NAM 45 5F 49 31 38 4E 09 4E 41 4D 45 5F 49 31 38 4E E_I18N.NAME_I18N 0C 2E 00 FC 03 00 00 FD 88 40 00 00 00 .........@... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 47 00 00 12 G... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 10 53 54 41 54 45 5F 4D .EPISODE.STATE_M 41 43 48 49 4E 45 5F 49 44 10 53 54 41 54 45 5F ACHINE_ID.STATE_ 4D 41 43 48 49 4E 45 5F 49 44 0C 3F 00 0B 00 00 MACHINE_ID.?.... 00 03 08 40 00 00 00 ...@... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 43 00 00 13 C... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 53 4D .def.unittest.SM 0D 53 54 41 54 45 5F 4D 41 43 48 49 4E 45 12 53 .STATE_MACHINE.S 54 41 54 45 5F 4D 41 43 48 49 4E 45 5F 4E 41 4D TATE_MACHINE_NAM 45 04 4E 41 4D 45 0C 2E 00 20 03 00 00 FD 85 50 E.NAME... .....P 00 00 00 ... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 35 00 00 14 5... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 07 55 53 45 52 5F 49 44 .EPISODE.USER_ID 07 55 53 45 52 5F 49 44 0C 3F 00 0B 00 00 00 03 .USER_ID.?...... 08 40 00 00 00 .@... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 3A 00 00 15 :... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 4D 55 .def.unittest.MU 0D 4D 45 44 49 41 54 4F 52 5F 55 53 45 52 09 55 .MEDIATOR_USER.U 53 45 52 5F 4E 41 4D 45 04 4E 41 4D 45 0C 2E 00 SER_NAME.NAME... 20 03 00 00 FD 84 40 00 00 00 .....@... 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 38 00 00 16 8... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 46 52 .def.unittest.FR 0A 46 52 41 4D 45 5F 52 41 54 45 0A 46 52 41 4D .FRAME_RATE.FRAM 45 5F 52 41 54 45 04 4E 41 4D 45 0C 2E 00 A0 00 E_RATE.NAME..... 00 00 FD 80 10 00 00 00 ........ 2017-05-30 16:45:57,183 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 57 00 00 17 W... 03 64 65 66 08 75 6E 69 74 74 65 73 74 02 45 50 .def.unittest.EP 07 45 50 49 53 4F 44 45 18 57 4F 52 4B 46 4C 4F .EPISODE.WORKFLO 57 5F 43 4F 4D 50 4C 45 54 49 4F 4E 5F 44 41 54 W_COMPLETION_DAT 45 18 57 4F 52 4B 46 4C 4F 57 5F 43 4F 4D 50 4C E.WORKFLOW_COMPL 45 54 49 4F 4E 5F 44 41 54 45 0C 3F 00 13 00 00 ETION_DATE.?.... 00 0C 80 00 00 00 00 ....... 2017-05-30 16:45:57,184 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 05 00 00 18 .... FE 00 00 01 00 ..... 2017-05-30 16:45:57,184 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) E4 00 00 19 .... 07 31 30 30 30 37 32 30 10 54 65 73 74 45 70 69 .1000720.TestEpi 73 6F 64 65 49 64 4F 6E 65 0E 74 65 73 74 20 65 sodeIdOne.test e 70 69 73 6F 64 65 20 31 FB 01 31 FB 1A 32 30 31 pisode 1..1..201 37 2D 30 35 2D 33 30 20 31 35 3A 34 35 3A 35 37 7-05-30 15:45:57 2E 30 30 30 30 30 30 FB 07 31 30 30 30 33 36 37 .000000..1000367 11 54 65 73 74 53 65 72 69 65 73 43 6F 64 65 4F .TestSeriesCodeO 6E 65 12 74 65 73 74 20 73 65 72 69 65 73 20 31 ne.test series 1 20 64 65 73 63 0D 53 65 72 69 65 73 20 74 65 73 desc.Series tes 74 20 31 01 31 01 31 0D 4E 6F 74 20 61 76 61 69 t 1.1.1.Not avai 6C 61 62 6C 65 12 73 74 61 74 65 2E 6E 6F 74 61 lable.state.nota 76 61 69 6C 61 62 6C 65 01 31 15 44 65 66 61 75 vailable.1.Defau 6C 74 20 73 74 61 74 65 20 6D 61 63 68 69 6E 65 lt state machine 01 31 0C 75 6E 69 74 74 65 73 74 75 73 65 72 FB .1.unittestuser. 13 32 30 31 31 2D 31 32 2D 33 30 20 30 30 3A 30 .2011-12-30 00:0 30 3A 30 30 0:00 2017-05-30 16:45:57,184 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 05 00 00 1A .... FE 00 00 01 00 ..... 2017-05-30 16:45:57,185 INFO main [com.pharos.db.dao.EpisodeDaoJdbc] Saving (inserting or updating) episode owner link by episode name Id: TestEpisodeIdOne owner:2 2017-05-30 16:45:57,187 TRACE main [org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream] send: conn:635157(M) 4B 00 00 00 03 53 45 4C 45 43 54 20 45 2E 49 44 K....SELECT E.ID 20 41 53 20 45 50 49 44 20 46 52 4F 4D 20 45 50 AS EPID FROM EP 49 53 4F 44 45 20 45 20 57 48 45 52 45 20 45 2E ISODE E WHERE E. 45 50 49 53 4F 44 45 5F 49 44 20 3D 20 27 54 65 EPISODE_ID = 'Te 73 74 45 70 69 73 6F 64 65 49 64 4F 6E 65 27 stEpisodeIdOne' 2017-05-30 16:45:57,188 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 01 00 00 01 .... 01 . 2017-05-30 16:45:57,188 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 2C 00 00 02 ,... 03 64 65 66 08 75 6E 69 74 74 65 73 74 01 45 07 .def.unittest.E. 45 50 49 53 4F 44 45 04 45 50 49 44 02 49 44 0C EPISODE.EPID.ID. 3F 00 0B 00 00 00 03 03 42 00 00 00 ?.......B... 2017-05-30 16:45:57,188 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 05 00 00 03 .... FE 00 00 01 00 ..... 2017-05-30 16:45:57,188 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 08 00 00 04 .... 07 31 30 30 30 37 32 30 .1000720 2017-05-30 16:45:57,188 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 05 00 00 05 .... FE 00 00 01 00 ..... 2017-05-30 16:45:57,190 TRACE main [org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream] send: conn:635157(M) 53 00 00 00 03 55 50 44 41 54 45 20 45 50 49 53 S....UPDATE EPIS 4F 44 45 5F 4F 57 4E 45 52 5F 4C 49 4E 4B 20 45 ODE_OWNER_LINK E 4F 4C 20 53 45 54 20 45 4F 4C 2E 4F 57 4E 45 52 OL SET EOL.OWNER 5F 49 44 20 3D 20 32 20 57 48 45 52 45 20 45 4F _ID = 2 WHERE EO 4C 2E 45 50 49 53 4F 44 45 5F 49 44 20 3D 20 31 L.EPISODE_ID = 1 30 30 30 37 32 30 20 000720 2017-05-30 16:45:57,191 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 30 00 00 01 0... 00 01 00 01 00 00 00 28 52 6F 77 73 20 6D 61 74 .......(Rows mat 63 68 65 64 3A 20 31 20 20 43 68 61 6E 67 65 64 ched: 1 Changed 3A 20 31 20 20 57 61 72 6E 69 6E 67 73 3A 20 30 : 1 Warnings: 0 2017-05-30 16:45:57,191 INFO main [com.pharos.db.dao.EpisodeDaoJdbc] Saving (inserting or updating) episode owner link by episode name Id: TestEpisodeIdOne owner:2 2017-05-30 16:45:57,191 TRACE main [org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream] send: conn:635157(M) 4B 00 00 00 03 53 45 4C 45 43 54 20 45 2E 49 44 K....SELECT E.ID 20 41 53 20 45 50 49 44 20 46 52 4F 4D 20 45 50 AS EPID FROM EP 49 53 4F 44 45 20 45 20 57 48 45 52 45 20 45 2E ISODE E WHERE E. 45 50 49 53 4F 44 45 5F 49 44 20 3D 20 27 54 65 EPISODE_ID = 'Te 73 74 45 70 69 73 6F 64 65 49 64 4F 6E 65 27 stEpisodeIdOne' 2017-05-30 16:45:57,192 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 01 00 00 01 .... 01 . 2017-05-30 16:45:57,192 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 2C 00 00 02 ,... 03 64 65 66 08 75 6E 69 74 74 65 73 74 01 45 07 .def.unittest.E. 45 50 49 53 4F 44 45 04 45 50 49 44 02 49 44 0C EPISODE.EPID.ID. 3F 00 0B 00 00 00 03 03 42 00 00 00 ?.......B... 2017-05-30 16:45:57,192 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 05 00 00 03 .... FE 00 00 01 00 ..... 2017-05-30 16:45:57,192 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 08 00 00 04 .... 07 31 30 30 30 37 32 30 .1000720 2017-05-30 16:45:57,192 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 05 00 00 05 .... FE 00 00 01 00 ..... 2017-05-30 16:45:57,192 TRACE main [org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream] send: conn:635157(M) 53 00 00 00 03 55 50 44 41 54 45 20 45 50 49 53 S....UPDATE EPIS 4F 44 45 5F 4F 57 4E 45 52 5F 4C 49 4E 4B 20 45 ODE_OWNER_LINK E 4F 4C 20 53 45 54 20 45 4F 4C 2E 4F 57 4E 45 52 OL SET EOL.OWNER 5F 49 44 20 3D 20 32 20 57 48 45 52 45 20 45 4F _ID = 2 WHERE EO 4C 2E 45 50 49 53 4F 44 45 5F 49 44 20 3D 20 31 L.EPISODE_ID = 1 30 30 30 37 32 30 20 000720 2017-05-30 16:45:57,193 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 30 00 00 01 0... 00 01 00 01 00 00 00 28 52 6F 77 73 20 6D 61 74 .......(Rows mat 63 68 65 64 3A 20 31 20 20 43 68 61 6E 67 65 64 ched: 1 Changed 3A 20 30 20 20 57 61 72 6E 69 6E 67 73 3A 20 30 : 0 Warnings: 0 2017-05-30 16:45:57,193 TRACE main [org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream] send: conn:635157(M) 09 00 00 00 03 52 4F 4C 4C 42 41 43 4B .....ROLLBACK 2017-05-30 16:45:57,197 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 07 00 00 01 .... 00 00 00 00 00 00 00 ....... 2017-05-30 16:45:57,197 TRACE main [org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream] send: conn:635157(M) 11 00 00 00 03 73 65 74 20 61 75 74 6F 63 6F 6D .....set autocom 6D 69 74 3D 31 mit=1 2017-05-30 16:45:57,197 TRACE main [org.mariadb.jdbc.internal.io.input.StandardPacketInputStream] read: conn:635157(M) 07 00 00 01 .... 00 00 00 02 00 00 00 ....... 2017-05-30 16:45:57,198 TRACE main [org.mariadb.jdbc.internal.io.output.AbstractPacketOutputStream] send: conn:635157(M) 01 00 00 00 01 ..... 2017-05-30 16:45:57,198 INFO main [org.springframework.test.context.transaction.TransactionContext] Rolled back transaction for test context [DefaultTestContext@27a6fef2 testClass = EpisodeDaoJdbcTest, testInstance = com.pharos.db.dao.EpisodeDaoJdbcTest@7fe8c7db, testMethod = testSaveEpisodeOwner@EpisodeDaoJdbcTest, testException = [null], mergedContextConfiguration = [MergedContextConfiguration@724bf25f testClass = EpisodeDaoJdbcTest, locations = '{classpath:/spring-test-dao-jdbc.xml, classpath:/spring-test-dao-jdbc-transactionmanager.xml, classpath:/WEB-INF/moxb.xml, classpath:/WEB-INF/moxb-domain-registry.xml, classpath:/WEB-INF/moxb-catalogued-errors.xml}', classes = '{}', contextInitializerClasses = '[]', activeProfiles = '{mariadb}', propertySourceLocations = '{}', propertySourceProperties = '{}', contextCustomizers = set[[empty]], contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader', parent = [null]]]. 2017-05-30 16:45:57,202 INFO Thread-1 [org.springframework.context.support.GenericApplicationContext] Closing org.springframework.context.support.GenericApplicationContext@49049a04: startup date [Tue May 30 16:45:51 BST 2017]; root of context hierarchy