I'm getting an error when trying to login using SQL Server as the database...

Exception occurred checking user login : java.sql.SQLException: 'UCASE' is not a recognized function name.

This error is an indication of an incorrect setting in the file ApplicationSettings.properties, located in [tomcat]/webapps/asset-bank/WEB-INF/classes. The setting sql-generator-class must read as follows:

sql-generator-class=com.bright.assetbank.database.SQLServerGenerator

You need to restart Tomcat to pick up this change.


Was this article helpful?

Yes No

Thanks for your feedback!