Guest User

Debugging w/ No In Clauses

a guest
Dec 24th, 2014
230
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [debug] application - New EventFilter created.
  2. [debug] application - beginDate: 2012-12-01
  3. [debug] application - endDate: 2013-01-01
  4. [debug] application - closestCountry: []
  5. [debug] application - territorialWaterStatus: []
  6. [debug] application - vesselCountry: []
  7. [debug] o.a.i.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
  8. [debug] o.a.i.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
  9. [debug] o.a.i.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
  10. [debug] o.a.i.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
  11. [debug] o.a.i.t.j.JdbcTransaction - Opening JDBC Connection
  12. [debug] o.a.i.d.p.PooledDataSource - Created connection 1177124095.
  13. [debug] o.a.i.t.j.JdbcTransaction - Setting autocommit to false on JDBC Connection [org.postgresql.jdbc4.Jdbc4Connection@46297cff]
  14. [debug] d.E.getEventsWithFilter - ==> Preparing: SELECT ev.id, to_char(ev.occurred_on, 'YYYY-MM-DD') AS occurred_on_date, to_char(ev.occurred_on, 'HH24:MI:SS') AS occurred_on_time, ST_X(ev.location) AS longitude, ST_Y(ev.location) AS latitude, COALESCE(co01.name, 'Unspecified') AS closest_country, COALESCE(co02.name, 'Unspecified') AS territorial_water_status, COALESCE(co03.name, 'Unspecified') AS vessel_flag_country FROM event AS ev LEFT JOIN country AS co01 ON co01.cow_id = ev.location_closest_country_id LEFT JOIN country AS co02 ON co02.cow_id = ev.location_water_status_country_id LEFT JOIN country AS co03 ON co03.cow_id = ev.vessel_flag_country_id WHERE ev.occurred_on >= ?::timestamp AND ev.occurred_on <= ?::timestamp ORDER BY ev.occurred_on ASC;
  15. [debug] d.E.getEventsWithFilter - ==> Parameters: 2012-12-01(String), 2013-01-01(String)
  16. [trace] d.E.getEventsWithFilter - <== Columns: id, occurred_on_date, occurred_on_time, longitude, latitude, closest_country, territorial_water_status, vessel_flag_country
  17. [trace] d.E.getEventsWithFilter - <== Row: 5818, 2012-12-01, 21:00:00, 116.9833, -1.3833, Indonesia, Indonesia, Panama
  18. [trace] d.E.getEventsWithFilter - <== Row: 5819, 2012-12-05, 03:00:00, 98.700699999999998, 3.7837000000000001, Indonesia, Indonesia, Panama
  19. [trace] d.E.getEventsWithFilter - <== Row: 5820, 2012-12-08, 11:35:00, 98.791700000000006, 3.9182999999999999, Indonesia, Indonesia, Russia
  20. [trace] d.E.getEventsWithFilter - <== Row: 5821, 2012-12-10, 23:45:00, 114.44, -3.73, Indonesia, Indonesia, Panama
  21. [trace] d.E.getEventsWithFilter - <== Row: 5822, 2012-12-11, 01:50:00, 104.0059, 1.2931999999999999, Singapore, Singapore, St. Kitts and Nevis
  22. [trace] d.E.getEventsWithFilter - <== Row: 5823, 2012-12-11, 03:00:00, 1.2722, 6.0738000000000003, Togo, Togo, Luxembourg
  23. [trace] d.E.getEventsWithFilter - <== Row: 5824, 2012-12-13, 23:10:00, 5.3300000000000001, 4.2667000000000002, Nigeria, Nigeria, Honduras
  24. [trace] d.E.getEventsWithFilter - <== Row: 5825, 2012-12-14, 21:05:00, 120.7593, 32.003999999999998, China, China, Indonesia
  25. [trace] d.E.getEventsWithFilter - <== Row: 5827, 2012-12-15, 04:30:00, 59.133299999999998, 24.166699999999999, Oman, Oman, Liberia
  26. [trace] d.E.getEventsWithFilter - <== Row: 5826, 2012-12-15, 14:58:00, 57.5383, 24.600000000000001, Oman, Oman, Denmark
  27. [trace] d.E.getEventsWithFilter - <== Row: 5828, 2012-12-17, 12:00:00, 4.3499999999999996, 5.3600000000000003, Nigeria, Nigeria, Nigeria
  28. [trace] d.E.getEventsWithFilter - <== Row: 5829, 2012-12-17, 12:45:00, 5.6212, 3.7347999999999999, Nigeria, Nigeria, Marshall Islands
  29. [trace] d.E.getEventsWithFilter - <== Row: 5830, 2012-12-18, 10:30:00, 49.154299999999999, 11.300000000000001, Somalia, Somalia, North Korea
  30. [trace] d.E.getEventsWithFilter - <== Row: 5831, 2012-12-20, 09:50:00, 57.9133, 24.781700000000001, Iran, Iran, Panama
  31. [trace] d.E.getEventsWithFilter - <== Row: 5832, 2012-12-20, 22:35:00, 98.781700000000001, 3.9500000000000002, Indonesia, Indonesia, Bahamas
  32. [trace] d.E.getEventsWithFilter - <== Row: 5834, 2012-12-23, 00:30:00, -4, 5.2931999999999997, Ivory Coast, Unspecified, Panama
  33. [trace] d.E.getEventsWithFilter - <== Row: 5833, 2012-12-23, 19:45:00, 5.2332999999999998, 4.0167000000000002, Nigeria, Nigeria, Italy
  34. [trace] d.E.getEventsWithFilter - <== Row: 5836, 2012-12-29, 23:00:00, 114.46169999999999, -3.7183000000000002, Indonesia, Indonesia, Liberia
  35. [trace] d.E.getEventsWithFilter - <== Row: 5835, 2012-12-29, 23:20:00, 114.4267, -3.7383000000000002, Indonesia, Indonesia, Panama
  36. [debug] d.E.getEventsWithFilter - <== Total: 19
RAW Paste Data