I developed j2ee application which was running well on jboss and sql2005 now i want it to run on jboss and sql2012 and i'm having the following error.

[hundu2]

@org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select type2 from query_cons where parameter_code='QQ' and query_code='CSER']; nested exception is java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][SQLServer]Invalid object name 'query_cons'. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:88) org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:294) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:348) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:352) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:356) org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:364) org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:369) com.systemspecs.Utility.JdbcDao.queryForObject(JdbcDao.java:779) com.systemspecs.servlets.InterceptingFilter.doBeforeProcessing(InterceptingFilter.java:138) com.systemspecs.servlets.InterceptingFilter.doFilter(InterceptingFilter.java:287) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)

[wdfink]

Could you provide a bit more information?

How the database is accessed?

There is a Spring class involved, maybe you need to set the SQL dialect for Spring