I don't think so. In this case I'm seeing a ResultSet in both log entries, which shouldn't show up in the part where it's being prepared.
Derek On Tue, Oct 13, 2009 at 6:09 PM, Jonathan Ferguson <j...@spiralarm.com>wrote: > Is this related to a previous query dated 15 Sept, the title was > [Lift] Mapper: Why is every SQL query sent twice? (second time with NULL > parameters) > The response from @dpp was > > "The SQL is not being sent twice. There are two different points (when the > Statement is created and after the Statement is executed) that the same > query is logged." > > > Cheers > Jono > > > 2009/10/14 Derek Chen-Becker <dchenbec...@gmail.com> > > OK, I'm seeing the same thing here. I'll open an issue and work on it. >> >> Derek >> >> >> On Tue, Oct 13, 2009 at 10:07 AM, harryh <har...@gmail.com> wrote: >> >>> >>> I'm also seeing this double logging behavior (using PostgreSQL. I was >>> under the impression that it was happening because the SQL statement >>> is first prepared, and then executed (each of which cause a log >>> entry). It's not critical or anything, but it would be nice if this >>> could be fixed at some point. >>> >>> -harryh >>> >>> On Oct 13, 10:28 am, Derek Chen-Becker <dchenbec...@gmail.com> wrote: >>> > I'm not sure how that could be getting logged twice, especially since >>> it's >>> > the exact same ResultSet being returned. When I tested this on my local >>> app >>> > (against both PG and MySQL) I didn't get this behavior, but I'll try >>> pulling >>> > from master and testing again just in case something changed. >>> > >>> > Derek >>> > >>> > On Tue, Oct 13, 2009 at 6:56 AM, Jeppe Nejsum Madsen <je...@ingolfs.dk >>> >wrote: >>> > >>> > >>> > >>> > > Hi, >>> > >>> > > Just wanted to update to the new db logging by adding the following >>> to >>> > > boot: >>> > >>> > > DB.addLogFunc { >>> > > case (query:DBLog, time) => { >>> > > LogBoot.loggerByName("query").info(">>> All queries took " + >>> time + >>> > > "ms: ") >>> > > query.statementEntries.foreach({ case DBLogEntry(stmt, >>> duration) => >>> > > LogBoot.loggerByName("query").info(" "+stmt + " took " + duration >>> + >>> > > "ms")}) >>> > > LogBoot.loggerByName("query").info("<<< End queries") >>> > > } >>> > > } >>> > >>> > > But it seems all executed statements are logged twice. I have this >>> > > snippet: >>> > >>> > > def currentUser(xhtml: Group): NodeSeq = >>> > > Text(User.currentUser.dmap(S.?("Anonym"))(user => user.firstName + " >>> " + >>> > > user.lastName)) >>> > >>> > > This logs: >>> > >>> > > 14:46:09.068 [tp-1029120287-4] INFO query >>> - >>> > > >>> All queries took 5ms: >>> > > 14:46:09.068 [tp-1029120287-4] INFO query >>> - >>> > > Exec query "SELECT users.id, users.firstname, users.lastname, >>> > > users.email, users.locale, users.timezone, users.password_pw, >>> > > users.password_slt, users.account_id, users.superuser, >>> users.uniqueid, >>> > > users.validated FROM users WHERE id = 2 (scale -5)" : >>> > > org.postgresql.jdbc4.jdbc4result...@77f31432 took 4ms >>> > > 14:46:09.069 [tp-1029120287-4] INFO query >>> - >>> > > <<< End queries >>> > > 14:46:09.069 [tp-1029120287-4] INFO query >>> - >>> > > >>> All queries took 8ms: >>> > > 14:46:09.069 [tp-1029120287-4] INFO query >>> - >>> > > Exec query "SELECT users.id, users.firstname, users.lastname, >>> > > users.email, users.locale, users.timezone, users.password_pw, >>> > > users.password_slt, users.account_id, users.superuser, >>> users.uniqueid, >>> > > users.validated FROM users WHERE id = 2 (scale -5)" : >>> > > org.postgresql.jdbc4.jdbc4result...@77f31432 took 4ms >>> > > 14:46:09.069 [tp-1029120287-4] INFO query >>> > > - <<< End queries >>> > >>> > > Note the same resultset. The postgres logs also shows that only a >>> single >>> > > statement is executed.... >>> > >>> > > So, what did I miss? >>> > >>> > > /Jeppe >>> >>> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---