API tools faq
paste
Advertisement
Guest User

Debugging w/ No In Clauses

a guest
Dec 24th, 2014
385
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.55 KB | None | 0 0
raw download clone embed print report
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!