Guest User

Debugging w/ only beginDate and endDate

a guest
Dec 24th, 2014
255
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 1769063405.
  13. [debug] o.a.i.t.j.JdbcTransaction - Setting autocommit to false on JDBC Connection [org.postgresql.jdbc4.Jdbc4Connection@6971c3ed]
  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 AND ev.location_closest_country_id IN ( ? ) AND ev.location_water_status_country_id IN ( ? ) AND ev.vessel_flag_country_id IN ( ? ) ORDER BY ev.occurred_on ASC;
  15. [debug] d.E.getEventsWithFilter - ==> Parameters: 2012-12-01(String), 2013-01-01(String), null, null, null
  16. [debug] d.E.getEventsWithFilter - <== Total: 0
RAW Paste Data