This is my first post and I want to thanks Hibernate Team for a greate tool.
I'm learning now but I will try to contribute as much as I can, for the moment
I have a question to ask:

I´m dealing with legacy database and I have all columns defined as CHAR SQL datatype.
Reading this Forum I found that the best solution to the issue is defining a Custom Type, but I also have to support multiple Databases like Oracle and SQL Server.
Oracle has special dealing with CHAR types and I need to use OracleTypes.FIXED_CHAR for setting prepared statement properly, as I read from the wiki: http://www.hibernate.org/Documentation/ ... 2AndOracle
On SQL Server I can directly use Types.CHAR and PreparedStatement.setString
I need to find a way of doing this using the same Custom User Type.

Can I do this extending Oracle Dialect?

Any ideas will be appreciated.
Thank you in advance,

Daniel
Hibernate version: 3.0.5

I need help with this same exact problem. I've been trying to use that OracleCHAR but with no avail

I have my hbm file as follows


I have some other similar UDTs on some attributes and primary keys, but only the ones on primary keys are ever called and used successfully.

user oracle varchar2 type except char
varchar2 work like sql char type and mappint to string work fine

Thank you for your answer.
I can´t use varchar2 because as I said this is legacy database already in production with other software I can't modify table definitions.

From now I resolved asking for the dialect at User Type method.

I did this:



it´s not very elegant but it works.

Daniel

I can't use varchar2 either, I am stuck with a legacy database. I am still having a problem using a FIXED_CHAR type in the where clause of a select statement. It doesn't get padded(doesn't use the UDT type) when it is used in a where clause and always returns false so my queries return zero entries.