Advertisement
Guest User

Debugging w/ lists of size 3 for IN clauses

a guest
Dec 24th, 2014
503
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. [debug] application - New EventFilter created.
  2. [debug] application - beginDate: 2012-12-01
  3. [debug] application - endDate: 2013-01-01
  4. [debug] application - closestCountry: [700, 339, 615]
  5. [debug] application - territorialWaterStatus: [700, 339, 615]
  6. [debug] application - vesselCountry: [700, 339, 615]
  7. [debug] o.a.i.l.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
  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.d.p.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
  12. [debug] o.a.i.t.j.JdbcTransaction - Opening JDBC Connection
  13. [debug] o.a.i.d.p.PooledDataSource - Created connection 1034402031.
  14. [debug] o.a.i.t.j.JdbcTransaction - Setting autocommit to false on JDBC Connection [org.postgresql.jdbc4.Jdbc4Connection@3da7b8ef]
  15. [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;
  16. [debug] d.E.getEventsWithFilter - ==> Parameters: 2012-12-01(String), 2013-01-01(String), null, null, null
  17. [debug] d.E.getEventsWithFilter - <== Total: 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement