Does anyone know how to display the parameter values in a parameterized query?

Thank you in advance.

You mean in the logs?
AFAIK you can't

agree with grid

Thanks. but then how does one debug something like this?:

[4/23/10 10:59:01:460 EDT] 00000058 SystemOut O Hibernate: select portalreso0_.PRS_PORTAL_ID as PRS_PORT1_0_, portalreso0_.PRS_RESOURCE_ID as PRS_RESO2_0_, portalreso0_.PRS_RESOU_TYPE_CDE as PRS_RESO3_0_, portalreso0_.PRS_RESOURCE_DSC as PRS_RESO4_0_ from xxxxxxxx.dbxxxxxx portalreso0_ where portalreso0_.PRS_PORTAL_ID=? and portalreso0_.PRS_RESOURCE_ID=?
[4/23/10 10:59:01:463 EDT] 00000058 PersistentCol E net.sf.hibernate.collection.PersistentCollection initialize Failed to lazily initialize a collection
net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: com.medco.framework.securitymngr.bizcomponents.portalsettings.internal.PortalResourceId@667f5266, of class: com.medco.framework.securitymngr.bizcomponents.portalsettings.internal.PortalResourcesImpl

This is the last of thousands of selects .

seems like you deleted some records from db outside the hibernate session.

this might be my guess not exactly sure abt that

It is possible to log query parameters. Turn on debug logging for 'org.hibernate.type' as explained in http://docs.jboss.org/hibernate/stable/ ... on-logging

From the log messages shown in a previous post I think it might be a good idea to implement PortalResourceId.toString() as well.