求大神帮忙,SSM连接oracle，sql查询爆错误，跪求~~

[期猫]

<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: 表或视图不存在

[liu志坚]

报错很明确 就是MMALL_USER 表不存在了。 你确认下 程序连接的用户下面是否有MMALL_USER 这个表吧。估计是连接错用户了，连接的用户下面没有这个表。

[学海无涯-回头是岸]

连接错了用户吧，查不到那张表或视图