Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi.
I am trying to use Hibernates SybaseDialect for Sybase. My query is a simple select query which takes a parameter of int. On Execution i get an error "Implicit conversion from datatype 'VARCHAR' to 'SMALLINT' is not allowed. Use the CONVERT function to run this query."
The same query works fine with MS Sql Server.
DO i need to explicitly use the CONVERT function just for Sybase in my HQL.???
I am using Hibernate3.0 and net.sf.hibernate.SybaseDialect.
Any help in this would be highly appreciable.

Thanks
Binny

Can anyone pls help me out in this

Most likely the parameter to your query is incorrect. What is the datatype of the column in database for which you are passing int parameter.

Hi the data type is a VARCHAR. As i mentioned it works fine with the MS SQL database.

if the datatype is varchar use setString instead of setInt. Also post the mapping file also.

Yes i am doing a setString only in my Query.

i am posting the mapping file.

**********************************************************
?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.mypackage.ClassStatus">
<meta attribute="class-code"> static final long serialVersionUID = -2498036496345162848L;</meta>
<id name="id" type="long">
<generator class="increment"/>
</id>
<property name="testNum" type="java.lang.String"/>
<property name="testTypeCd" type="java.lang.String"/>
</class>
<query name="ClassStatusQuery">
<![CDATA[
select
new ClassStatus(
tab1.testNum,
tab1.testTypeCd

)
from Table1 as tab1
where tab1.tCol = ?
]]>
</query>
</hibernate-mapping>

**********************************************************
Here tCol is VARCHAR(50);
Am doing a query.setString(0,parameter);

still insufficient info. post java code , pojo code and also database structre of table