My hibernate application is running fine within JBoss...the only problem is that I do not see the sql outout even though I have show_sql=true in my hibernate.properties file

Where should I see the output...in the jboss log or someplace else?

Hibernate version:2.1

hibernate.properties:
hibernate.dialect.net.sf.hibernate.dialect.Oracle9Dialect
hibernate.connection.drive_class oracle.jdbc.driver.OracleDriver
hibernate.connection.datasource=java:/OracleDS
hibernate.show_sql=true

Not sure about it but it seems the sql debug output produced by Hibernate is not using the log4j utility but is 'simply' printed using System.out.println() statements...

Don't know how JBoss handles these outputs but you should probably have a look at either your console or another log file.

log4j category is net.sf.hibernate.SQL