Message Title

Dalal commented on

Thanks for the response.

For now since I am bound to Jboss 7.1.3 which in return uses Hibernate 4.1.6 version I am kind of stuck with it.

I found workaround by creating Hibernate userType which will make sure that PreparedStatement is binding string value always.

 
                                                                public class EnumToStringType extends EnumType 
{  
    
  @Override
  public int[] sqlTypes() 
  {    return new int[] { Types.VARCHAR };    }
  
  @Override
  public void nullSafeSet(PreparedStatement st, Object value, int index, SessionImplementor session)
      throws HibernateException, SQLException 
  {    
    if ( value == null ) 
    {   super.nullSafeSet(st, value, index, session);   }               
    else 
    {
      String enumString = ( (Enum<?>) value ).name();                  
      st.setObject( index, enumString, sqlTypes()[0] );        
    }    
  }
}
 
                                                            

Add Comment

This message was sent by Atlassian JIRA