Re: Named Queries and SQL that doesn't fetch mapped objects

2015-01-15 Thread dollj
1) If I have several parameters specified in the SQL and I don't provide values for each in the map I pass in what happens to those values? Bad idea. Raw SQL is not like Expressions where you can omit parameters. A "bare" parameter will remain unparsed in the SQL and will be passed to the DB a

Re: Named Queries and SQL that doesn't fetch mapped objects

2015-01-14 Thread Andrus Adamchik
> 1) If I have several parameters specified in the SQL and I don't provide > values for each in the map I pass in what happens to those values? Bad idea. Raw SQL is not like Expressions where you can omit parameters. A "bare" parameter will remain unparsed in the SQL and will be passed to the D

Named Queries and SQL that doesn't fetch mapped objects

2015-01-14 Thread Tony Giaccone
I have a table that represents log data, and I want to group that data time, by using SQL rather then pulling back 65000 rows and aggregating in the java app. The intent is to look at how many transactions occurred over time in a bucket of transactions. So you might look at the hours worth of tran