We have defined a field as RAW(1) in Oracle. Need to store 0x00 to 0xff into it. Using:


<property name="inboundElementSeperator" type="char" >
<column name="INBOUND_ELEMENT_SEPERATOR" length="1" sql-type="raw"/>
</property>


We get an exception from Oracle: ORA-01465: invalid hex number

No field information provided. Specifying sql-type="raw(1)", or type="binary" does not fix it. We can change the field in Oracle or change the hibernate definition or both as long as we can store a single byte and be able to retrieve it into a java char.

Thanks for any suggestions.

Did you try "byte" or maybe write a custom UserType class that will allow you to convert the data by yourself. See http://forum.hibernate.org/viewtopic.ph ... 47#2334047

Thanks for the response. I should have mentioned that we tried byte and it did not solve the issue. Custom types seem like an overkill. We ended up using NUMBER instead and added getters that convert the number to char.