Forum Stats

  • 3,874,342 Users
  • 2,266,727 Discussions
  • 7,911,827 Comments

Discussions

How to get the data from PARAMS column using JDBC java

User_EOYHX
User_EOYHX Posts: 4 Employee

I have a table named- Reports . It has a column name - PARAMS. After executing DESCRIBE REPORTS ,It's datatype shows as OPERA_SRW_PARAMLIST which is a user defined datatype.

I have a result set which has data from query- "SELECT PARAMS FROM REPORTS";

I tried to get that column data in my java code but i am getting NULL for that column.


The data present in the PARAMS column looks like this-

DUMMY_DATA_TO_TEST([DUMMY], [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], )

I tried below code to retrieve data as a string but not successful.

while (resultSet.next()) {
    
    System.out.println(resultSet.getString("PARAMS"));
}


Please suggest me any good way to retrieve that column data in my java code. Thanks in advance.

Tagged:

Answers