本地测试得时候没问题得，为什么上传到服务器上面得时候就会报这种错误呢
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar 错误
- 写回答
- 好问题 0 提建议
- 关注问题
分享- 邀请回答
-
6条回答 默认 最新
奋斗的小杨 2019-10-09 15:31关注把你的sql修改为 select from 库名.表名 试试 望采纳
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏举报 分享
- 2025-02-26 10:12手搓DesignPattern的博客 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [insert into user(id,real_name,age)values(?,?,?)]
- 2021-09-08 22:24qq_40853933的博客 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [update t_account set money=money-?where username=?]; nested exception is ...
- 2019-10-24 17:53涵岳散人的博客 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT s.STUDENT_NAME,f.FACULTY_NAME,m.MAJOR_NAME,c.CLASS_NAME,g.GRADE_CODE,l.* FROM leave_info l...
- Kazunorawa的博客 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select uid from user where username=SyusukeFuji]; nested exception is java.sql.SQLSyntaxErrorException: Unknown ...
- 2019-04-12 20:20博观而约取,厚积而薄发的博客 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ select * from tab_favorite where rid = ? and uid = ?]; nested exception is ...
- 2020-04-30 23:33qq_38337156的博客 最近搞springboot，第一次建项目难免出现看...org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM SPRING_SESSION WHERE EXPIRY_TIME < ?]; nested ex...
- 2018-08-22 09:51Love_banana_stars的博客 nested exception is org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL ...
- 2014-08-14 08:41守护_潇潇的博客 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM DEMO_ORDER WHERE 1=1and order_id = '1']; nested exception is com.mysql.jdbc.exceptions.
- amflytogether的博客 Exception in thread "... org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [update person set name=? where age=?]; nested exception is java.sql.SQLEx...
- 2016-05-13 18:20weixin_30345577的博客 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ INSERT INTO w_cabinet( ID,Name,Brand,Type,Spec,DeviceNum,Subsystem,BuildingName,Floor,RoomNo,Position,Heig...
- 胡八一、的博客 bad SQL grammar [SELECT JOB_INSTANCE_ID, JOB_NAME from BATCH_JOB_INSTANCE解决办法
- 2019-07-27 20:46
PreparedStatementCallback; bad SQL grammar [delete user where id=?]; nested exception is com.mysql.jbanboo998的博客 错误代码： PreparedStatementCallback; bad SQL grammar [delete user where id=?]; nested exception is ...org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [... - web_13233421436的博客 在使用Spring Boot连接MySQL数据库时，有时候会遇到“Bad SQL Grammar”错误，这种错误通常在执行SQL语句时发生。本文针对的是对于执行多条SQL语句的情况。MySQL连接配置中有一些常用的参数，这些参数可以在数据库...
- 2021-12-30 12:37君问归期魏有期的博客 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select* from artitle where keyWord like %]; nested exception is java.sql.SQLSyntaxErrorException: You have an error...
- 2021-09-07 11:10Wingsdream的博客 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [Delete from user where name= 正辉]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ...
- 2021-08-15 15:28艾仪的博客 目录关于MySQL当加入了Session...org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM SPRING_SESSION WHERE EXPIRY_TIME < ?]; nested exception is jav
- 咖煮的博客 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [Insert into user values(?,?,?,?,?,?,null,null)]; nested exception is ...
- 2024-07-18 19:20周先生FullStack的博客 spring-cloud-config与mysql结合使用的配置中心资料较少，但是spring-cloud-config原理较为简单，源码比较清晰，不妨直接看源码排查问题。
- 2024-09-25 17:53Zn-l的博客 出现问题：Request processing failed: org.springframework.jdbc.BadSqlGrammarException: StatementCallback;1、原sql语句：select `major_id` AS 'majorId' ,`major_name` AS 'majorName',tuition,`dept_id` as '...
- 没有解决我的问题, 去提问
问题事件
已采纳回答
12月22日