Re: Complex SQL queries with JDBI

2016-10-18 Thread Tim Bart
Thanks for sharing your approach Douglas, Kim. I was wondering what the most elegant way of making the handle available was when 99% of queries are well supported by the @SqlQuery("…"); On Tuesday, October 18, 2016 at 10:09:38 AM UTC-7, Kim Kantola wrote: > > Thank you so much Evan and Douglas

Re: Complex SQL queries with JDBI

2016-10-18 Thread Kim Kantola
Thank you so much Evan and Douglas for taking the time to help. I did end up going with your approach Douglas, I am using annotated SQL where I can, but for the dynamic queries, I am using the jdbi handle and executing the SQL that way. In case anyone else finds this thread looking for similar

Re: Complex SQL queries with JDBI

2016-10-15 Thread Evan Meagher
Hello Kim, Based on my understanding of your situation, I would advise the approach of using the simplest possible DAO methods and keeping the query complexity within your application code. For instance, if a GET endpoint takes name, age, id, etc as query parameters, your resource method could