You have an error in your SQL syntax; 이슈

Question

안녕하세요You have an error in your SQL syntax; 오류가 있는데 , ; [ ] {}.. 기타 등등 오류가 나서 그 부분을 수정하면 된다는 것을 알고 있습니다. 있는데.. 찾기가 어렵네요. 제가 못보고 있는것 같아서 올리게 되었습니다.CheckMapper.GetShipmentCheckList 입니다.ReleaseMapper.GetReleaseList 입니다.2023-06-12 19:35:11,105 DEBUG [project.wms.board.check.mapper.CheckMapper.GetShipmentCheckList] &#61;&#61;> Preparing: SELECT r.releaseCode, p.productName, r.releaseGoodsCount, cs.contractorName, r.acceptDate, r.releaseDate, r.recipientName, r.shipmentCheckManager, r.shipmentCheckRegDate, r.shipmentCheckResult FROM release AS r INNER JOIN stock AS s ON r.stockCode &#61; s.stockCode INNER JOIN warehousing AS w ON s.warehousingCode &#61; w.warehousingCode INNER JOIN contractor_staff AS cs ON w.contractorId &#61; cs.contractorId INNER JOIN product AS p ON w.productCode &#61; p.productCode WHERE r.releaseAllow &#61; 'Y';2023-06-12 19:35:11,105 INFO [jdbc.audit] 1. PreparedStatement.new PreparedStatement returned2023-06-12 19:35:11,105 INFO [jdbc.audit] 1. Connection.prepareStatement(SELECTr.releaseCode,p.productName,r.releaseGoodsCount,cs.contractorName,r.acceptDate,r.releaseDate,r.recipientName,r.shipmentCheckManager,r.shipmentCheckRegDate,r.shipmentCheckResultFROMrelease AS rINNER JOINstock AS sONr.stockCode &#61; s.stockCodeINNER JOINwarehousing AS wONs.warehousingCode &#61; w.warehousingCodeINNER JOINcontractor_staff AS csONw.contractorId &#61; cs.contractorIdINNER JOINproduct AS pONw.productCode &#61; p.productCodeWHEREr.releaseAllow &#61; 'Y';) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy&#64;187e77af2023-06-12 19:35:11,105 DEBUG [project.wms.board.check.mapper.CheckMapper.GetShipmentCheckList] &#61;&#61;> Parameters:2023-06-12 19:35:11,105 INFO [jdbc.sqlonly] SELECTr.releaseCode,p.productName,r.releaseGoodsCount,cs.contractorName,r.acceptDate,r.releaseDate,r.recipientName,r.shipmentCheckManager,r.shipmentCheckRegDate,r.shipmentCheckResultFROMrelease AS rINNER JOINstock AS sONr.stockCode &#61; s.stockCodeINNER JOINwarehousing AS wONs.warehousingCode &#61; w.warehousingCodeINNER JOINcontractor_staff AS csONw.contractorId &#61; cs.contractorIdINNER JOINproduct AS pONw.productCode &#61; p.productCodeWHEREr.releaseAllow &#61; 'Y';2023-06-12 19:35:11,106 ERROR [jdbc.audit] 1. PreparedStatement.execute() SELECTr.releaseCode,p.productName,r.releaseGoodsCount,cs.contractorName,r.acceptDate,r.releaseDate,r.recipientName,r.shipmentCheckManager,r.shipmentCheckRegDate,r.shipmentCheckResultFROMrelease AS rINNER JOINstock AS sONr.stockCode &#61; s.stockCodeINNER JOINwarehousing AS wONs.warehousingCode &#61; w.warehousingCodeINNER JOINcontractor_staff AS csONw.contractorId &#61; cs.contractorIdINNER JOINproduct AS pONw.productCode &#61; p.productCodeWHEREr.releaseAllow &#61; 'Y';java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release AS rINNER JOINstock AS sONr.stockCode &#61; s.stockCodeINNE' at line 13at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)at net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy.execute(PreparedStatementSpy.java:443)at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.base/java.lang.reflect.Method.invoke(Method.java:568)at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)at jdk.proxy3/jdk.proxy3.$Proxy160.execute(Unknown Source)at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.base/java.lang.reflect.Method.invoke(Method.java:568)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)at jdk.proxy2/jdk.proxy2.$Proxy91.selectList(Unknown Source)at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)at jdk.proxy4/jdk.proxy4.$Proxy101.GetShipmentCheckList(Unknown Source)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.base/java.lang.reflect.Method.invoke(Method.java:568)at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)at

Dive_Drink_Develope · Answer

release 가 예약어 여서 그런것 같습니다.어퍼스트로피로 감싸서 해보세요..가급적이면 테이블명 변경을 추천드립니다.`release`

Clickin · Answer

Mybatis에서는 ; 빼셔야해요

You have an error in your SQL syntax; 이슈

2개의 답변

Q&A 목록