Hi,

Need some help.

We are using Datadirect driver (V 3.5 SP1) and Hibernate v3.1.3

While executing this query "select sequence_num.nextvalue from dual" using createSQLQuery API, we are getting an exception:
"org.hibernate.MappingException: No Dialect mapping for JDBC type: 3"

This is what we are using in hibernate.cfg.xml
<property name="hibernate.connection.datasource">jdbc/sam</property>
<property name="connection.pool_size">2</property>
<property name="dialect">org.hibernate.dialect.DataDirectOracle9Dialect</property>


Can someone pls. help us resolving this issue?

Thanks,
Sudhir

http://www.hibernate.org/hib_docs/v3/re ... l-dialects

has org.hibernate.dialect.Oracle9Dialect but not org.hibernate.dialect.DataDirectOracle9Dialect

We have investigated this and found that the new DataDirectOracle9Dialect, provided by Hibernate, does not include a mapping for the DECIMAL data type. The DataDirect Oracle driver describes some columns using this data type. The workaround is to add the following constructor to the DataDirectOracle9Dialect



We will work with Hibernate to get this included in a future update to Hibernate.

BTW, I believe the DataDirectOracle9Dialect is new in Hibernate 3.1.3

I have this error:
No Dialect mapping for JDBC type: -1

can you help me???

Try following and see if it works for you.


public class CustomSAPDBDialect extends SAPDBDialect {

public CustomSAPDBDialect() {
super();

registerColumnType( Types.DECIMAL,"number($p,$s)" );

registerHibernateType(Types.DECIMAL,
"big_decimal");
}
}