ANYBODY - CF9 ORM SQL Logging in CF Builder 2 console window via log4j?

@lainteract2007, when you say you don't see it logged to the console, where are you looking? How is CF starting? Since you mention using IIS, I'll assume CF is starting as a service. If so, then the log that CF writes to (instead of really writing to the "console") is the \runtime\logs\*-out.log, or \logs\-out*.log.

So first, do you see the data logged there? Second, if you don't, it could be that your tweaking of the log4j.properties (to point it elsewhere) went amiss. Have you tried searching your entire hard drive (or the or directories at least) to see if perhaps they are being written somewhere you're not looking?

Finally, note that while CF can indeed log ORM activity, it does it in an extremely verbose manner. You may find you can far more usefully "spy on" ORM processing using any of a few other options. I discuss them in a blog entry:

http://www.carehart.org/blog/client/index.cfm/2009/11/14/spy_on_orm

Let us know if any of this helps, or not. Also, if it does, please be sure to mark the question "answered" in the web forum (link offered at the bottom of the email if you're reading it that way). Thanks.

/charlie arehart

charlie@carehart.org

Providing fast, remote, on-demand troubleshooting services for CF (and CFBuilder)

More at http://www.carehart.org/consulting

Thank you ... but the console still does not show the logging  information from Hibernate ORM ... I stopped and started the CF 9 server  (restarted) from within ColdFusion Builder 2. I am running CF 9 under  JRUN4 ... could that be a reason?

Don't forget, you have to start CF9 server from within CB to see the log4j output.