빼빼
20
2020-09-15 18:12:12
2
129

마이바티스 update 오류 봐주세요..



	<update id="CorpInfo_Update" parameterType="corporationDto">  	
  		UPDATE MEMBER AS M JOIN CORPORATOIN AS C ON M.MEMBER_ID = C.MEMBER_ID
  		SET M.MEMBER_PW = #{member_pw}, 
  		M.MEMBER_NAME = #{member_name},
  		M.MEMBER_POSTCODE = #{member_postcode, jdbcType=VARCHAR}, 
  		M.MEMBER_ADDR = #{member_addr, jdbcType=VARCHAR},
  		M.MEMBER_PHONE = #{member_phone}, 
  		M.MEMBER_EMAIL = #{member_email},
  		C.CORP_CEO_NAME = #{corp_ceo_name}, 
  		C.CORP_BOARD_NAME = #{corp_board_name}
  		WHERE M.MEMBER_ID = #{member_id}
  	</update>
  	### SQL: UPDATE MEMBER AS M JOIN CORPORATOIN AS C ON M.MEMBER_ID = C.MEMBER_ID     SET M.MEMBER_PW = ?,      M.MEMBER_NAME = ?,     M.MEMBER_POSTCODE = ?,      M.MEMBER_ADDR = ?,     M.MEMBER_PHONE = ?,      M.MEMBER_EMAIL = ?,     C.CORP_CEO_NAME = ?,      C.CORP_BOARD_NAME = ?     WHERE M.MEMBER_ID = ?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword

이런 오류가 납니다. set 키워드는 넣었는데도 왜 자꾸 오류가 날까요




0
  • 답변 2

  • 제타건담
    6k
    2020-09-15 22:39:25

    그 문법을 oracle에서 직접 사용했을때 문제가 없었나요..? 검색해보니 oracle은 update join 문법이 없어보여서..

  • 빼빼
    20
    2020-09-18 01:40:58

    네 동시 insert가 안된다고 합니다 ㅎㅎ

  • 로그인을 하시면 답변 을 등록할 수 있습니다.