My logback setup is apparently dropping some of the sql parameters. Has anyone seen this? It's possible the missing values are in fact null. Can I rely on this?


I'm using ch.qos.logback:logback-core:jar:0.9.18
spring-framwork 3.0.1
java 1.6

I have this in my logback.xml
<logger name="org.hibernate">
<level value="WARN" />
</logger>

<logger name="org.hibernate.type">
<level value="TRACE" />
</logger>
and this in my persistence.xml
<!-- Echo all executed SQL to stdout -->
<property name="hibernate.show_sql" value="true"/>
<!-- don't pretty-print, leave it on one line -->
<property name="hibernate.format_sql" value="false"/>

but as you can see below in my intelliJ console, I sometimes miss one of the parameters.
Hibernate: insert into cps.content_metadata (author, pointer_id, deleted, name, parent_id, publish_date, representation, source, version, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
17:16:52.108 [pool-3-thread-2] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - amirsys
>>>> Where did parameter [2] go???
17:16:52.108 [pool-3-thread-2] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [3] as [BIT] - false
17:16:52.108 [pool-3-thread-2] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [4] as [VARCHAR] - Legacy ID: 2055023653
>>>> Where did parameter [5] go???
17:16:52.108 [pool-3-thread-2] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [6] as [TIMESTAMP] - Thu Oct 27 17:16:52 MDT 2011
17:16:52.108 [pool-3-thread-2] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [7] as [VARCHAR] - annotated-working
17:16:52.108 [pool-3-thread-2] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [8] as [VARCHAR] - cms
17:16:52.109 [pool-3-thread-2] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [9] as [VARCHAR] - 1.1
Hibernate: select cmspointer0_.id as id1_, cmspointer0_.cms_id as cms2_1_, cmspointer0_.legacy_id as legacy3_1_, cmspointer0_.version as version1_ from cps.cms_pointer cmspointer0_ where cmspointer0_.legacy_id=? and cmspointer0_.version=?
17:16:52.109 [pool-3-thread-1] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - 2055023653
17:16:52.110 [pool-3-thread-1] TRACE o.h.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - 1.1