1. How to show hibernate sql parameter values, instead of ?,? coderanch.com |
2. Named parameters in SQL is not working forum.hibernate.orgHello, I have a sql-query in hbm file as Code: select count(REQUESTID) AS TOTALREQUESTS , TO_CHAR(ENTRYDATE, :DFPARAM1) AS ENTRY_DATE FROM REQUEST_TABLE WHERE ENTRYDATE BETWEEN TO_DATE(:FROM_DATE, 'DD.MM.YYYY') AND TO_DATE(:END_DATE, 'DD.MM.YYYY') ... |
3. Logging SQL parameter values for perfo analysis ? forum.hibernate.orgHibernate version:2.1.6 In addition to show_sql, could there be (is there?) a setting that would, instead of question marks, log the actual values of the SQL query parameters ? Values can, sure, be debug-logged explicitly in code, but a globally configurable Hibernate-level switch would come in very handy when locating performance bottlenecks and analyzing their SQL... You would have to pay ... |
4. unresolved parameter values when show_sql = true forum.hibernate.org |
5. SQL error "Missing IN or OUT parameter at index" forum.hibernate.orgHi all ! We have, from time to time, a strange sql error in a production environnement : Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 1 In this code : Code: public Book findBook(String code) throws PWRBusinessException { try { ... |
6. Log the parameter substitutions in the SQL statement forum.hibernate.orgHi! At a minimum I need to handle all exceptions that are caused by sending SQL to the database to log the SQL and all parameters bound to the SQL. Now, by configuring log4j appropriately it will log the SQL and bound parameters but will log a lot of other junk as well. I am interested in extracting just the SQL ... |
7. how can i log more info about sql parameter's name and value forum.hibernate.org |
8. I've looked and looked - hibernate to print sql parameters? forum.hibernate.org |
9. Print/log parameter values for ? in HQL/SQL statements forum.hibernate.org |
10. passing in parameters to sql functions forum.hibernate.orghi. i'm having a problem trying to pass in parameters to sql functions. see below: StringBuffer sb = new StringBuffer("SELECT lastName from myDB where dateAdded <= TO_TIMESTAMP_TZ(:dateAdded, 'DY MON DD HH24:MI:SS TZD YYYY')"); Query myquery = sessionFactory.getCurrentSession().createQuery(sb.toString()); myquery.setDate("dateAdded", dateAdded); after checking the logs, i'll get org.hibernate.exception.SQLGrammarException: could not execute query. But, if i remove the TO_TIMESTAMP_TZ function and just do "dateAdded ... |
11. Viewing sql with parameters forum.hibernate.org |
12. Show SQL With Parameters forum.hibernate.orgIn your log4j configuration file set the following org.hibernate.type=DEBUG Be aware that in the logs, this will not show the value for your parameters in the query itself. Rather, there'll be additional log statements following the query log of the nature "Binding xxx to yyyy". My understanding is that there isn't any setting to log the value of the parameters in ... |
13. Collect executed SQL statement with parameters forum.hibernate.orgHi, Does anyone know if there is a hook/extension point in Hibernate that would allow me to record all executed SQL with parameters in a convenient way? I know of the usual show sql options. I followed instructions in this blog post http://www.javalobby.org/java/forums/t44119.html but it logs parameter values in separate log entries. What I need is everything in the same log ... |