hi ,
am using the following dialect "org.hibernate.dialect.SybaseDialect",
There is a field in the database which is of type smallint.When i execute a query it returns the following exception

eg ..input = 1
Implicit conversion from datatype 'VARCHAR' to 'SMALLINT' is not allowed. Use the CONVERT function to run this query.

However the same query with the same input works on an MSSQL database with the corresponding dialect.

Does this mean that to handle this situation i need to code seperatley for sybase using COVERT in my sql query???


Any help is highly appreciated.

Thanks
BT

If your DBMS doesn't handle varchar to smallint, then you'll have to handle it for it. You could define a UserType for it, but using Short.parseShort(String) is probably easier. Your dialect implicitly maps shorts to smallints, so using Short.parseShort(String) has the advantage that if the string would have caused the DB to throw an exception, you'll now get an exception earlier. Failfast code for free!