[Oracle ]java.lang.ClassNotFoundException: oracle.xdb.XMLType

!markdown

# Oracle (오라클)

### 1. Error - 에러

```error 

Caused by: java.lang.ClassNotFoundException: oracle.xdb.XMLType

```

### 2. Problem - 문제

Maven Repository에 언제부턴가 필요한 구성요소를 더 세분화하고 의존성을 끊어서 배포한거 같다.

아닐 수도 있다 ㅎㅎ

### 3. Solved - 해결

이곳에서 `xdb6.jar`를 다운받아서 추가합니다.

[http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html](http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html)

### 참고

- Why is database-transfer to Oracle 12c failing on WebSphere Portal 8.5?: [https://developer.ibm.com/answers/questions/208041/why-is-database-transfer-to-oracle-failing-on-webs.html](https://developer.ibm.com/answers/questions/208041/why-is-database-transfer-to-oracle-failing-on-webs.html)

- java.lang.NoClassDefFoundError: oracle/xdb/XMLType error for tests run with Ready Api maven plugin: [https://community.smartbear.com/t5/SoapUI-Pro/java-lang-NoClassDefFoundError-oracle-xdb-XMLType-error-for/td-p/117360](https://community.smartbear.com/t5/SoapUI-Pro/java-lang-NoClassDefFoundError-oracle-xdb-XMLType-error-for/td-p/117360)

- Java: Returning XMLType Data from StoredProcedure, Usage of ojdbc6.jar xdb6.jar xmlparserv2.jar for Java to PLSQL interaction: [https://stackoverflow.com/questions/25208239/java-returning-xmltype-data-from-storedprocedure-usage-of-ojdbc6-jar-xdb6-jar](https://stackoverflow.com/questions/25208239/java-returning-xmltype-data-from-storedprocedure-usage-of-ojdbc6-jar-xdb6-jar)

- Oracle Database 11.2.0.4 JDBC Driver & UCP Downloads: [http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html](http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html)