Hi,

When i try to search for a data in oracle db whose length is greater than the column width, i get the below execption.

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute query
DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: 1; nested exception is com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001

It works fine if i pass data <= column width.

Hibernate3.0
Spring1.2.7
DB2

Any of you faced this problem? please let me know how you fixed it?

Thanks in advance.

looks like this doesnt have to do anything with hibernate .
wondering What make you think that !!

Hello Friend:

All you have to do is check the word´s length before you do transaction.

If your are working with application based on web, you can constraints it simply when yo define your html tag line <input type="text" size="9" maxsize="10">.

If you want constraints it well, you can add the attribute "length" in the column tag in your hibernate mapping files, like follow:

<property name="word" type="string">
<column name="word_columnname" lenght="10">
</property>

I think if you write carefully , it will work fine.

Regards. Neketsu Shonen

No the length attribute doesnt do any validation checks !! . helps you in ddl generation .

Implementing this interface might help you

I know that restricting the user from entering more than the desired length or checking before executing the query would solve the issue. But i am just wondering why hibernate should validate on the column width when i am just quering the database. Ideally this should happen only when its inserted or updated.