Database using: SQLserver 2005
Hibernate Version: 3.2.5

Problem Description:

We have a USER table with following columns
1) UserId char(8)
2) UserFName varchar(30)
3)USerLName varchar(30)

List result = hibernateSession.createSQLQuery(" from USER where UserId = 'abcd' ").list();

Above query is working fine and I getting the result.

List result = hibernateSession.createSQLQuery("select UserId from USER ").list();

this is returning only the first character of all the UserIds from the table.

Any fix for this issue?

Thanks,
Jithesh

Can you show us the annotations used for the mapping of that class and field?

This is the mapping I am using in .hbm file

<property name="userId" type="string" column="UserId" />

Maybe this is an issue with hibernate mapping somehow the char[8] to a byte[8] and then messing up the translation to unicode?

You can either test by changing the db to varchar(8) or trying to map to a char[] (change the java type).

Let us know what you find :-)

Hi,

Thanks for your reply.

I know it will work perfectly if I change char data type to varchar datatype.

But i cannot do that, we are using char data type in lot of tables.

I tested char[] too but no luck.

If I execute the query like a normal sql it will work perfectly.

I am using the following code.

Connection connection = session.connection();
PreparedStatement preparedStatement = connection.prepareStatement("Select UserId from USER");
ResultSet resultSet = preparedStatement.executeQuery();

Thanks,
Jithesh