Skip to Main Content

Java Database Connectivity (JDBC)

java.lang.NoClassDefFoundError: oracle/xdb/XMLType error

User_EOYHXNov 19 2022

Hi Team,
I am using ojdbc8-21.4.0.0.1.jar in my project.
There is a table in my lab which has a column with data type as 'OPERA_SRW_PARAMLIST' .
I tried to load this column using the below code-
---
String query = "select params as Parameter from reports";
pstmt = conn.prepareStatement(query);

    resultSet = pstmt.executeQuery();
    System.out.println("Before while loop!");

    while (resultSet.next()) {
      try {
        System.out.println("ooooooooooooooooooooooooooooooo");
        System.out.println(resultSet.getString("Parameter"));
      } catch (Exception e) {
        System.out.println("ex- " + e);
      }
---
Error/Exception is coming on the line - resultSet.getString("Parameter").

Error message is -
java.lang.NoClassDefFoundError: oracle/xdb/XMLType
at oracle.jdbc.driver.NamedTypeAccessor.getString(NamedTypeAccessor.java:376)
at oracle.jdbc.driver.GeneratedStatement.getString(GeneratedStatement.java:232)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:410)
at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:662)....etc

Sample of data of params column is as below-


DUMMY_DATA_TO_TEST([DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], )

Any suggestion or idea will be very much helpful to handle this type of data.
Thanks in advance.
Comments
Post Details
Added on Nov 19 2022
4 comments
1,778 views