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

illi do-not-reply at jboss.com
Mon Aug 4 02:10:16 EDT 2008

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: 'nvl' is not a recognized built-in function name." what more need to be configured to make it use such functions.

--> following is the ds config we used.
       <type-mapping>MS SQLSERVER2005</type-mapping>

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4168353#4168353

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4168353

More information about the jboss-user mailing list