求大神帮忙,SSM连接oracle,sql查询爆错误,跪求~~
期猫 2018-02-08 09:41:50 <select id="checkUsername" resultType="int" parameterType="string">
SELECT count(1)
FROM MMALL_USER
WHERE USERNAME = #{username}
</select>
oracle数据库中表名和列名都已大写,测试时出现以下错误,求大神帮忙解决
严重: Servlet.service() for servlet [dispatcher] in context with path [/com.mmall] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
### The error may exist in file [E:\IDEA\workspace\target\mmall\WEB-INF\classes\mappers\UserMapper.xml]
### The error may involve com.mmall.dao.UserMapper.checkUsername-Inline
### The error occurred while setting parameters
### SQL: SELECT count(1) FROM MMALL_USER WHERE USERNAME = ?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
] with root cause
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在