Oracle Clob data type and java.sql.ResultSet.getString() working?

Question

we need to update varchar2(4000) type to Clob to accommodate large data. Here data are being saved and retrieved using java.sql.ResultSet.getString() of JdbcTemplate with Oracle 19c.

If we have just updated data type from varchar2 to clob, it is working fine with existing code where we have used getString().

We are unable to find rationale why this is working or any enhancement at Oracle to have transformation seamlessly.

Acroyear · Accepted Answer · 2024-03-13 18:18:47Z

2

ResultSet.getString() works with multiple database data types, including VARCHAR2 and CLOB.

answered Mar 13, 2024 at 18:18

Acroyear

1,4614 gold badges25 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle Clob data type and java.sql.ResultSet.getString() working?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related