SELECT count (1)
The FROM MMALL_USER
WHERE the USERNAME=# {USERNAME}

The oracle database table and column names are capitalized, the following errors in the test, the great god help solve
Serious: Servlet service () for the Servlet/dispatcher in context with the path//com. Mmall threw the exception [Request processing failed; nested exception is org. Springframework. JDBC. BadSqlGrammarException:
# # # Error querying the database. Cause: Java, SQL, SQLSyntaxErrorException: ORA - 00942: table or view there is no

# # # The error may exist in The file [E: \ IDEA \ workspace \ target \ mmall \ WEB - INF \ classes \ mappers \ UserMapper XML]
# # # The error may involve com. Mmall. Dao. UserMapper. CheckUsername - The Inline
# # # The error occurred while setting The parameters
# # # SQL: SELECT count (1) the FROM MMALL_USER WHERE USERNAME=?
# # # Cause: Java. SQL. SQLSyntaxErrorException: ORA - 00942: table or view there is no

; Bad SQL grammar []; Nested exception is Java. SQL. SQLSyntaxErrorException: ORA - 00942: table or view there is no
] with root cause
Java. SQL. SQLSyntaxErrorException: ORA - 00942: table or view does not exist

CodePudding user response:

Error is clear MMALL_USER table does not exist,
You confirm the program to connect users have MMALL_USER below this table, estimation is connected the wrong user, user don't have the table below,

CodePudding user response:

Connect the wrong user, not the table or view