Skip to content
Advertisement

Tag: jdbi

How to return deleted rows using jdbi?

How do I return the deleted rows using jdbi? For example, I’d like to do something like this: Answer Postgresql has a returning keyword… https://dbfiddle.uk/?rdbms=postgres_13&fiddle=25d284309745e40c8ea29945481d1aa2 You can then execute that query in the same way as you would a normal SELECT statement, and get a result set back; containing the records deleted.

Full SQL statement logging on Dropwizard

I’ve a Dropwizard application using JDBI and SQL Server. I would like to get all SQL statements logged with their parameters but I don’t seem to be able to. This is what’s usually recommended to do: logging: level: INFO loggers: “org.skife”: TRACE “com.microsoft.sqlserver.jdbc”: TRACE But this only logs statements, without the parameters: TRACE [2016-07-08 16:40:27,711] org.skife.jdbi.v2.DBI: statement:[/* LocationDAO.detail */ EXEC

Advertisement