EXECUTE: have a hibernate console config, hibernate 3.5 (haven't tried others)
EXECUTE: do a query in HQL editor
ASSERT: entities are shown in query results
EXECUTE: select hibernate dynamic sql preview view
ASSERT: it will show the corresponding sql

CURRENT FAIL: says session factory is not open even though one is for the queries

EXECUTE: expand the sesson factory node in console config and see it build

ASSERT: no errors and now dynamic sql preview should work

CURRENT FAIL: session factory is built but getting this in error log:

org.hibernate.console.ext.HibernateException: Factory was not closed before attempt to build a new Factory
at org.jboss.tools.hibernate3_5.HibernateExtension3_5$1.execute(HibernateExtension3_5.java:135)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:63)
at org.jboss.tools.hibernate3_5.HibernateExtension3_5.execute(HibernateExtension3_5.java:240)
at org.jboss.tools.hibernate3_5.HibernateExtension3_5.buildSessionFactory(HibernateExtension3_5.java:132)
at org.hibernate.console.ConsoleConfiguration.buildSessionFactory(ConsoleConfiguration.java:273)
at org.hibernate.eclipse.console.workbench.LazySessionFactoryAdapter.getChildren(LazySessionFactoryAdapter.java:43)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.getChildren(BasicWorkbenchAdapter.java:100)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:106)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:235)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

and the sql preview is still not working.