MyBatis 외부 DTD: accessExternalDTD 속성으로 설정된 제한으로 인해 'https' 액세스가 허용되지 않으므로 외부 DTD 'mybatis-3-config.dtd' 읽기를 실패했습니다.

Question

package com.my.customer.dao;import java.io.IOException;import java.io.InputStream;import java.util.HashMap;import java.util.Map;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import com.my.customer.dto.CustomerDTO;import com.my.exception.AddException;import com.my.exception.FindException;import com.my.exception.ModifyException;public class CustomerDAOImpl implements CustomerDAO { // Mybatis에서 db와 연결하고 sql문을 실행 할 SqlSessionFactory 인터페이스 선언 private SqlSessionFactory sqlSessionFactory; public CustomerDAOImpl() { // Mybatis 설정파일 로드 String resource = "com/my/sql/mybatis-config.xml"; InputStream inputStream; try { // 리소스 경로에 파일 읽어들이는 클래스(Resources) inputStream = Resources.getResourceAsStream(resource); // sqlSessionFactory를 멤버변수로 만듦 sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); } catch (IOException e) { e.printStackTrace(); } // try-catch } // constructor // 회원가입 메서드 @Override public void create(CustomerDTO customerDTO) throws AddException { // db와 상호작용하기 위한 객체 생성 SqlSession session = null; try { // session객체로 sql문 수행 session = sqlSessionFactory.openSession(); session.insert("com.my.customer.CustomerMapper.create", customerDTO); session.commit(); } catch (Exception e) { session.rollback(); e.printStackTrace(); throw new AddException(e.getMessage()); } finally { if(session != null) { session.close(); } // if } // try-catch-finally } // insert // 회원조회 메서드 @Override public CustomerDTO selectById(String id) throws FindException { SqlSession session = null; try { session = sqlSessionFactory.openSession(); CustomerDTO customer = (CustomerDTO)session.selectOne("com.my.customer.CustomerMapper.selectById", id); if( customer != null ) { return customer; } else { throw new FindException("고객없음"); } // if-else } catch (Exception e) { e.printStackTrace(); throw new FindException(e.getMessage()); } finally { if(session != null) { session.close(); } // if } // try-catch-finally } // selectById// ======================== db와 연결 테스트 ============================ public static void main(String[] args) { CustomerDAOImpl customerDAOImpl = new CustomerDAOImpl(); // ================ create 메서드 테스트 ========================= CustomerDTO dto = new CustomerDTO(); dto.setId("test99"); dto.setPwd("test99"); dto.setNickname("test99"); dto.setName("test99"); dto.setBirthday("1993-05-04"); dto.setPhone("01011112222"); dto.setEmail("dd@naver.com");// dto.setStatus(1); try { customerDAOImpl.create(dto); System.out.println("회원가입 완료 ^ㅡ^b"); } catch (AddException e) { e.printStackTrace(); } // ================================================================== // ================= selectById 메서드 테서트 =======================//// String id = "test01";////// try {// CustomerDTO dto = customerDAOImpl.selectById(id);// // 출력// System.out.println("id : " + dto.getId());// System.out.println("nickname : " + dto.getName());// } catch(Exception e) {// e.printStackTrace();// System.out.println(" 해당 회원이 없습니다 ");// } } // main(test) @Override public CustomerDTO selectByNickname(String nickname) throws FindException{ SqlSession session = null; try { session = sqlSessionFactory.openSession(); CustomerDTO customer = session.selectOne("com.my.customer.CustomerMapper.selectByNickname", nickname); if(customer != null) { return customer; }else { throw new FindException("고객이 없습니다"); } } catch (Exception e) { e.printStackTrace(); throw new FindException(e.getMessage()); } finally { if(session != null) { session.close(); } } } @Override public void updateNickname(String id, String nickname) throws ModifyException{ SqlSession session = null; Map map = new HashMap<>(); try{ session = sqlSessionFactory.openSession(); map.put("id", id); map.put("nickname", nickname); session.update("com.my.customer.CustomerMapper.updateNickname", map); session.commit(); }catch(Exception e) { session.rollback(); throw new ModifyException(e.getMessage()); }finally { if(session!=null) { session.close(); } } } @Override public void updateCustomerAll(String id, CustomerDTO customer) throws ModifyException{ SqlSession session = null; Map map = new HashMap<>(); try{ session = sqlSessionFactory.openSession(); map.put("id", id); map.put("customer", customer); session.update("com.my.customer.CustomerMapper.updateCustomerAll", map); session.commit(); }catch(Exception e) { session.rollback(); throw new ModifyException(e.getMessage()); }finally { if(session!=null) { session.close(); } } } } // end class 여기서 myBatis 테스트를 위해서 main()을 실행 시키면 Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:### Error building SqlSession.### Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 50; 외부 DTD: accessExternalDTD 속성으로 설정된 제한으로 인해 'https' 액세스가 허용되지 않으므로 외부 DTD 'mybatis-3-config.dtd' 읽기를 실패했습니다.at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:82)at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:66)at com.my.customer.dao.CustomerDAOImpl.(CustomerDAOImpl.java:35)at com.my.customer.dao.CustomerDAOImpl.main(CustomerDAOImpl.java:104)Caused by: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 50; 외부 DTD: accessExternalDTD 속성으로 설정된 제한으로 인해 'https' 액세스가 허용되지 않으므로 외부 DTD 'mybatis-3-config.dtd' 읽기를 실패했습니다.at org.apache.ibatis.parsing.XPathParser.createDocument(XPathParser.java:263)at org.apache.ibatis.parsing.XPathParser.(XPathParser.java:127)at org.apache.ibatis.builder.xml.XMLConfigBuilder.(XMLConfigBuilder.java:82)at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:79)... 3 moreCaused by: org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 50; 외부 DTD: accessExternalDTD 속성으로 설정된 제한으로 인해 'https' 액세스가 허용되지 않으므로 외부 DTD 'mybatis-3-config.dtd' 읽기를 실패했습니다.at java.xml/com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:204)at java.xml/com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:178)at java.xml/com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:400)at java.xml/com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)at java.xml/com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1465)at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$DTDDriver.dispatch(XMLDocumentScannerImpl.java:1148)at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$DTDDriver.next(XMLDocumentScannerImpl.java:1040)at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:943)at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:605)at java.xml/com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:542)at java.xml/com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:889)at java.xml/com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:825)at java.xml/com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)at java.xml/com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:247)at java.xml/com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:342)at org.apache.ibatis.parsing.XPathParser.createDocument(XPathParser.java:261)... 6 more 이런 오류가 발생하는데 뭐가 문제일까요 ㅠㅠ... eclipse.ini에서 -Djavax.xml.accessExternalSchema=all랑 -Djavax.xml.accessExternalDTD=all 옵션도 줘봤는데 계속 동일한 오류가 발생합니다..

antop · Answer

https://dalili.tistory.com/225Mapper XML 에 dtd를 인터넷 주소로 썻더라도 내부 jar 파일에 있는 dtd 파일을 참조하게 됩니다.뭔가 라이브러리 설정이 꼬인 것 같습니다.

MyBatis 외부 DTD: accessExternalDTD 속성으로 설정된 제한으로 인해 'https' 액세스가 허용되지 않으므로 외부 DTD 'mybatis-3-config.dtd' 읽기를 실패했습니다.

1개의 답변

Q&A 목록