Problem with nullable enum fields + Hibernate 3

[Praful Thakare]

Hi,

I am using following combinations for my application

1) Hibernate 3
2) MySQL 5.0.15-standard

And I am facing a problem when i select row (using findObjects) from table that has enum field and value of that field is null.

I understand that enum field should be not-null in database,but if its nullable why hiberate throws following error ? Is this a bug in Hibernate 3.0 ? Ideally it should check for not null before calling CharAt(0) method,but it seems it dose not.

 
 java.lang.StringIndexOutOfBoundsException: String index out of range: 0
10:55:04,913 INFO  [STDOUT]     at java.lang.String.charAt(String.java:558)
10:55:04,916 INFO  [STDOUT]     at org.hibernate.type.CharacterType.get(CharacterType.java:28)
10:55:04,916 INFO  [STDOUT]     at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:77)
10:55:04,917 INFO  [STDOUT]     at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:68)
10:55:04,917 INFO  [STDOUT]     at org.hibernate.type.AbstractType.hydrate(AbstractType.java:80)
10:55:04,917 INFO  [STDOUT]     at org.hibernate.persister.entity.BasicEntityPersister.hydrate(BasicEntityPersister.java:1690)
10:55:04,917 INFO  [STDOUT]     at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:991)
10:55:04,924 INFO  [STDOUT]     at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:942)
10:55:04,924 INFO  [STDOUT]     at org.hibernate.loader.Loader.getRow(Loader.java:855)
10:55:04,925 INFO  [STDOUT]     at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:305)
10:55:04,925 INFO  [STDOUT]     at org.hibernate.loader.Loader.doQuery(Loader.java:412)
 

Cheers
-Praful

[Praful Thakare]

Is there any one else under this sun getting same error ?

-Praful
[ November 10, 2005: Message edited by: Praful Thakare ]

[John Mikhail]

I'm curious...there is no enum support in hibernate. Did you write your own custom UserType that you're mapping to? If so, if you can include that code it might shed some more light on the subject.

John