Andrew's ramblings

ColdFusion 9 ORM logging to a file gotcha with log4j

Tags: Coldfusion, ColdFusion 9

I wanted to write up a quick post on this because I think a lot of people might not know this, and at the moment I haven't looked into a solution to this.

If you haven't read this post http://www.rupeshk.org/blog/index.php/2009/07/coldfusion-orm-how-to-log-sql/, that explains how to enable the logging then I suggest you read it for further information.

I would also like to point out that I am not even sure this behaviour is the same on other platforms, but on windows the log file is not created where you think it might be created.

If you read the notes in Rupesh's blog on this, he states that it will be created in the logs directory. However he doesn't reference the logs directory here and if you try to use ../logs/hibernatesql.log, I was getting errors in the ColdFusion logs stating it couldn't create the log file. However if you leave it the way Rupesh has the location which is ../hibernatesql.log it was creating the log file, however I was not able to see it in any of the ColdFusion file structures.

Which was a bit odd, till I noticed it on my desktop one day.

It appears that for some reason it is actually stored in that location, now why this is happening I am not sure. But I have a sneaking suspicion it is because I may have installed ColdFusion from this location at some point over the last 12 months or so.

Anyway I thought this was worth noting because if you go looking for it, there is a high chance you might not find it where you think it might be.

Tweet