Hibernate Statistics in ColdFusion

TweetBacks

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

• #1 by Marc Esher on 8/8/10 - 6:49 PM

  

  Dan,
  Thinking out loud here: I see a getQueries() method. I wonder if you could create a new CF debugging template that would let you output the queries that hibernate runs, alongside the query output you get in the normal debugging template.

• #2 by Dan Vega on 8/8/10 - 6:57 PM

  

  The getQueries() doesn't return the actual SQL. I ran this example just as a test.
  
  <cfset people = entityLoad("Person")>
  <cfdump var="#people#">
  
  It returned an array with the 1st element being
  
  from Person

• #3 by todd sharp on 8/8/10 - 8:17 PM

  

  Awesome find Dan! Can you put up an example of what's in there? I agree with Marc - some stuff might be real handy to throw in the debug output. Also - you might want to throw in a check for isDebugMode before you enable the stats - that way you have a fail safe in case you accidentally forget to disable it before pushing to production.

• #4 by Marc esher on 8/8/10 - 9:45 PM

  

  Do you fine lads know if the actual SQL is exposed by any means? Clearly it shows up in the console output. If we could get at it, I'd love to see it in the debug output, which would make it much easier to copy and paste into tools, especially with the aid of nathan's excellent "query copy" firefox extension

• #5 by Raymond Camden on 8/9/10 - 7:51 AM

  

  Not that it adds much, but here is the entry I did on this as well: http://www.coldfusionjedi.com/index.cfm/2009/12/1/...

• #6 by todd sharp on 8/9/10 - 8:10 AM

  

  Actually - that adds a ton. I deduct all of Vega's points and award them to Ray.

• #7 by Raymond Camden on 8/9/10 - 8:13 AM

  

  We get points? Can I turn them into beer?

• #8 by todd sharp on 8/9/10 - 8:59 AM

  

  No. You can exchange them for 'Prestige'.

• #9 by John Whish on 8/10/10 - 3:39 AM

  

  This isn't quite what you're after but might be useful, which was part of my Scotch on the Rocks 2010 presentation (although I did rush this bit as I ran out of time!).
  
  I tend to use hql over the EntityLoad method which means that I can get the generated SQL. Instead of calling the ORMExecuteQuery, I call my own method which includes some debugging stuff which I adapted from a post on the hibernate forums to work with CF.
  
  For example:
  
  function ExecuteHQL( required string hql, struct params=StructNew(), boolean unique=false )
  {
     // debug flag is set here for simple demo
     var debug = CGI.SERVER_NAME == "localhost";
     if ( debug )
     {
        var factory = CreateObject( "java", "org.hibernate.hql.ast.ASTQueryTranslatorFactory" );
        var query = factory.createQueryTranslator( hql, hql, Javacast( "null", "" ), ORMGetSessionFactory() );
        query.compile( Javacast( "null", "" ), false );
        
        // add the created SQL to the struct
        arguments.sql = query.getSQLString();
        
        // normally this would use cflog, cftrace or a logging object like logbox
        WriteOutput( SerializeJSON( arguments ) );
        // for demo purposes dump it out
        WriteDump( arguments );
     }
     return ORMExecuteQuery( hql, params, unique );
  }
  
  result = ExecuteHQL( "from Artist where upper( lastname ) like :prefix", {prefix='D%'}, false );
  
  Maybe I should get around to blogging this...