[Hibernate-issues] [Hibernate-JIRA] Created: (HB-577) hibernate.show_sql improvement

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-577


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-577
    Summary: hibernate.show_sql improvement
       Type: Improvement

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
   Versions:
             2.1.1

   Assignee: 
   Reporter: Leonid Shlyapnikov

    Created: Wed, 24 Dec 2003 10:30 AM
    Updated: Wed, 24 Dec 2003 10:30 AM
Environment: Linux version 2.4.21-144-smp4G (ro...@i3...) (gcc version 3.3.1 (SuSE Linux)) #1 SMP Fri Nov 14 00:07:01 UTC 2003;
jdk 1.4.2; jboss-3.2.2;

Description:
It would be more useful if hibernate logged its SQL queries in more details. I mean symbols '?' in the logged query. The real values would help to determine problems. BTW, TopLink logs SQL queries fully :)

A part of show_sql log:

18:42:14,506 INFO  [STDOUT] Hibernate: insert into RequestInfo (DurationMeasurementId, FromDate, Duration, EnterDate, ModificationDate, ProlongationOpportunity, RequestInfoDescription, RequestId, RequestInfoID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
bash: syntax error near unexpected token `('
shl@shl:~/javalib/hibernate-2.1/src> 18:42:14,506 INFO  [STDOUT] Hibernate: insert into Demand (Commission, PriceFrom, PriceTo, RequestInfoId) values (?, ?, ?, ?)
bash: syntax error near unexpected token `('
shl@shl:~/javalib/hibernate-2.1/src> 18:42:24,759 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 22P02
bash: 18:42:24,759: command not found
shl@shl:~/javalib/hibernate-2.1/src> 18:42:24,759 ERROR [JDBCExceptionReporter] ERROR: invalid input syntax for integer: "\254\355\000\005sr\000!ru.incom.solaris.common.UniqueKey8\344\2432{\016\316T\002\000\001L\000\003keyt\000\020Ljava/lang/Long;xpsr\000\016java.lang.Long;\213\344\220\314\217#\337\002\000\001J\000\005valuexr\000\020java.lang.Number\206\254\225\035\013\224\340\213\002\000\000xp\000\000\000\000\000\000\000\002"



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira