<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: 表或视图不存在
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: 表或视图不存在
你确认下 程序连接的用户下面是否有MMALL_USER 这个表吧。估计是连接错用户了,连接的用户下面没有这个表。