PostgreSQL, Sybase]
2018-04-12 14:18:55 [org.springframework.jdbc.support.sqlerrorcodesfactory]-[debug] Looking up default SQLErrorCodes For DataSource [{
Createtime: "2018-04-12 14:18:43",
Activecount:1,
poolingcount:0,
Createcount:1,
destroycount:0,
closecount:0,
Connectcount:1,
connections:[
]
}]
2018-04-12 14:18:55 [Org.springframework.jdbc.support.sqlerrorcodesfactory]-[debug] Database product name cached for DataSource [[email protected]]: name is ' MySQL '
2018-04-12 14:18:55 [Org.springframework.jdbc.support.sqlerrorcodesfactory]-[debug] SQL error codes for ' MySQL ' found
2018-04-12 14:18:55 [Org.springframework.jdbc.support.sqlerrorcodesqlexceptiontranslator]-[debug] Translating SQLException with SQL State ' 42000 ', error code ' 1064 ', message [you have a error in your SQL syntax; check the manual th At corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A on a.user_id=u.id
WHERE u.user_type= ' at line 1]; SQL is [] for task [
# # # Error querying database. Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
# # # The error may exist in file [D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp3\wtpwebapps\ Easyleadmin\web-inf\classes\com\yxl\manager\dao\mapper\useradminmapper.xml]
# # # The error may involve com.yxl.manager.dao.useradmindao.selectcountentity-inline
# # # The error occurred while setting parameters
# # # Sql:select COUNT (*) user_info u left joins admin_info a on a.user_id=u.id WHERE u.user_type=?
# # # Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
]
2018-04-12 14:18:55 [Org.mybatis.spring.sqlsessionutils]-[debug] Transaction synchronization deregistering sqlsession [[email protected]]
2018-04-12 14:18:55 [Org.mybatis.spring.sqlsessionutils]-[debug] Transaction synchronization closing SqlSession [[ Email protected]]
2018-04-12 14:18:55 [org.springframework.jdbc.datasource.datasourceutils]-[debug] Returning jdbc Connection to DataSource
2018-04-12 14:18:55 [org.springframework.jdbc.datasource.datasourcetransactionmanager]-[debug] Should Roll Back Transaction but Cannot-no transaction available
2018-04-12 14:18:55 [org.springframework.web.servlet.mvc.method.annotation.exceptionhandlerexceptionresolver]-[ DEBUG] Resolving exception from handler [public Org.springframework.web.servlet.ModelAndView Com.yxl.manager.controller.UserAdminController.teacherList (Javax.servlet.http.HttpServletRequest, Javax.servlet.http.httpservletresponse,com.yxl.manager.common.pager,com.yxl.manager.common.selectbean)]: Org.springframework.jdbc.BadSqlGrammarException:
# # # Error querying database. Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
# # # The error may exist in file [D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp3\wtpwebapps\ Easyleadmin\web-inf\classes\com\yxl\manager\dao\mapper\useradminmapper.xml]
# # # The error may involve com.yxl.manager.dao.useradmindao.selectcountentity-inline
# # # The error occurred while setting parameters
# # # Sql:select COUNT (*) user_info u left joins admin_info a on a.user_id=u.id WHERE u.user_type=?
# # # Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
; Bad SQL Grammar []; Nested exception is Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
2018-04-12 14:18:55 [Org.springframework.web.servlet.mvc.annotation.responsestatusexceptionresolver]-[debug] Resolving exception from Handler [public Org.springframework.web.servlet.ModelAndView Com.yxl.manager.controller.UserAdminController.teacherList (Javax.servlet.http.HttpServletRequest, Javax.servlet.http.httpservletresponse,com.yxl.manager.common.pager,com.yxl.manager.common.selectbean)]: Org.springframework.jdbc.BadSqlGrammarException:
# # # Error querying database. Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
# # # The error may exist in file [D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp3\wtpwebapps\ Easyleadmin\web-inf\classes\com\yxl\manager\dao\mapper\useradminmapper.xml]
# # # The error may involve com.yxl.manager.dao.useradmindao.selectcountentity-inline
# # # The error occurred while setting parameters
# # # Sql:select COUNT (*) user_info u left joins admin_info a on a.user_id=u.id WHERE u.user_type=?
# # # Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
; Bad SQL Grammar []; Nested exception is Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
2018-04-12 14:18:55 [Org.springframework.web.servlet.mvc.support.defaulthandlerexceptionresolver]-[debug] Resolving exception from Handler [public Org.springframework.web.servlet.ModelAndView Com.yxl.manager.controller.UserAdminController.teacherList (Javax.servlet.http.HttpServletRequest, Javax.servlet.http.httpservletresponse,com.yxl.manager.common.pager,com.yxl.manager.common.selectbean)]: Org.springframework.jdbc.BadSqlGrammarException:
# # # Error querying database. Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
# # # The error may exist in file [D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp3\wtpwebapps\ Easyleadmin\web-inf\classes\com\yxl\manager\dao\mapper\useradminmapper.xml]
# # # The error may involve com.yxl.manager.dao.useradmindao.selectcountentity-inline
# # # The error occurred while setting parameters
# # # Sql:select COUNT (*) user_info u left joins admin_info a on a.user_id=u.id WHERE u.user_type=?
# # # Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
; Bad SQL Grammar []; Nested exception is Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
2018-04-12 14:18:55 [Org.springframework.web.servlet.dispatcherservlet]-[debug] Could not complete request
Org.springframework.jdbc.BadSqlGrammarException:
# # # Error querying database. Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
WHERE u.user_type= ' at line 1
# # # The error may exist in file [D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp3\wtpwebapps\ Easyleadmin\web-inf\classes\com\yxl\manager\dao\mapper\useradminmapper.xml]
# # # The error may involve com.yxl.manager.dao.useradmindao.selectcountentity-inline
# # # The error occurred while setting parameters
# # # Sql:select COUNT (*) user_info u left joins admin_info a on a.user_id=u.id WHERE u.user_type=?
# # # Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' u left JOIN admin_info A On A.user_id=u.id
Wrong more than once I was using SSM, this is a database language error, check the database language near next
Translating SQLException with SQL State ' 42000 ', error code ' 1064 ' errors