1 Reply Latest reply on Apr 17, 2014 3:20 PM by wdfink

    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)