mybatis foreach , selectkey 사용 질문 드립니다

Question

안녕하십니까 선배님들 최근에 마이바티스 내에서 사용가능한 샐랙키 결과값을 if문 , if문 내에 insert용으로 사용하려고 공부중에아무리 찾아봐도 틀린점이 없어보이지만 에러가 발생하고있습니다 기술이 부족하여 어디가 잘못된건지 모르겠습니다 도와주세요 ㅠㅠ-- 마이바티스를 오랜만에 사용해서 그런데 쿼리문 조건들 자체가 문제가 있는건가요 ??select USER_IDX,STATUS,PHONE_NUMBER from TB_PHS_USER WHERE PHONE_NUMBER = #{multi.PHONE_NUMBER}INSERT INTO SC_TRAN ( TR_NUM, TR_PHONE, TR_CALLBACK ,TR_MSG, TR_ID, TR_SENDDATE, TR_SENDSTAT, TR_MSGTYPE )SELECT SC_SEQUENCE.NEXTVAL,A.* FROM (SELECT #{multi.PHONE_NUMBER} AS TR_PHONE,#{multi.TR_CALLBACK} AS TR_CALLBACK ,#{multi.TR_MSG} as TR_MSG ,#{multi.TR_ID} as TR_ID ,SYSDATE,#{multi.TR_SENDSTAT} as TR_SENDSTAT ,#{multi.TR_MSGTYPE} as TR_MSGTYPEFROM DUAL)AINSERT INTO TB_PHS_PUSH_MESSAGES ( PUSH_IDX, USER_IDX, MESSAGE, SENDER, READ, STATUS, CREATE_DATE, CREATE_TIME, WORKER )SELECT SEQ_PHS_PUSH_MESSAGES.NEXTVAL,A.* FROM (SELECT #{USERIDX} AS USER_IDX,#{multi.MESSAGE} AS MESSAGE,#{multi.SENDER} AS SENDER,#{multi.READ} AS READ,#{multi.STATUS} AS STATUS,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24miss'),#{multi.WORKER} AS WORKERFROM DUAL)A해당 쿼리 실행시에 ORA-00907: 누락된 우괄호 에러가 발생합니다 if문 내에 있는것들은 따로 실행시킬때 이상이 없고selectkey를 새로 추가 했는데 도저히 어느 부분이 잘못된건지 ........... 모르겠습니다 ㅠㅠ괄호가 누락되었다고 하는데 괄호 관련해서는 확실히 확인했습니다 쿼리문 자체가 문제가 있는건지 제가잘못 선언한 부분이 있는건지 ...에러 코드 입니다 .....bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00907: 누락된 우괄호] with root causejava.sql.SQLSyntaxErrorException: ORA-00907: 누락된 우괄호at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)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:324)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:83)at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:68)at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processBefore(SelectKeyGenerator.java:47)at org.apache.ibatis.executor.statement.BaseStatementHandler.generateKeys(BaseStatementHandler.java:141)at org.apache.ibatis.executor.statement.BaseStatementHandler.(BaseStatementHandler.java:63)at org.apache.ibatis.executor.statement.PreparedStatementHandler.(PreparedStatementHandler.java:40)at org.apache.ibatis.executor.statement.RoutingStatementHandler.(RoutingStatementHandler.java:46)at org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:558)at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)at com.sun.proxy.$Proxy166.insert(Unknown Source)at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)at ko.co.kr.Message_DAO.multi_message_insert(Message_DAO.java:62)at ko.co.kr.Message_Service.multi_message_insert(Message_Service.java:57)at ko.co.kr.Ftr_Controller.multi_message_insert(Ftr_Controller.java:739)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Unknown Source)

Bluebell · Answer

말고 이런식으로 해보세요

mybatis foreach , selectkey 사용 질문 드립니다

1개의 답변

Q&A 목록