[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Log: JBoss + MS Sql server 2005: 'nvl' is not a recognized b

Adding full log info: 2008-08-04 12:05:30,613 INFO [STDOUT] Caused by: org.hibernate.exception.GenericJDBCException: could not execute query 2008-08-04 12:05:30,613 INFO [STDOUT] at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) 2008-08-04 1

[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - JBoss + MS Sql server 2005: 'nvl' is not a recognized built-

Hi All, We have been trying to configure JBoss to use MS Sql server 2005 from our application. Technology we used in our application is hibernate. We are now able to access our application, but while loading some objects in one of screens, it is showing a error "Caused by: java.sql.SQLException