I have got same problem on Informix database and I am using 

<property name="hibernate.connection.url" 
value="jdbc:informix-sqli://url:informixserver=xxx;user=xxx;password=xxx;IFX_LOCK_MODE_WAIT=1;IFX_TRIMTRAILINGSPACES=1"/>

It is causing 

Caused by: java.lang.StringIndexOutOfBoundsException: String index out of 
range: 0
        at java.lang.String.charAt(String.java:695)
        at org.hibernate.type.CharacterType.get(CharacterType.java:29)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
        at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
        at 
org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2096)
        at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308)
        at org.hibernate.loader.Loader.getRow(Loader.java:1206)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
        at org.hibernate.loader.Loader.doQuery(Loader.java:701)
        at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at 
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

Can someone suggest how to getaway with this

Thanks



On Monday, 28 June 2010 19:38:03 UTC+1, Thomas Mueller wrote:
>
> Hi,
>
> According to my test case, H2 behaves like PostgreSQL and MySQL
> (trailing spaces are trimmed). I added a feature request
> "Compatibility for data type CHAR (Derby, HSQLDB).". See also
> http://code.google.com/p/h2database/issues/detail?id=212
>
> Regards,
> Thomas
>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/GeEgVCTZdxUJ.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to