[Bug] [TASK SQL] The resultProcess function will have serialization errors when querying CLOB fields

[CloudSen]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

If I use Oracle or DM database in SQL-TASK, and then execute select statement that contains CLOB(both in Oracle and DM) or TEXT(in DM) field, it will have serialization errors.
After debugging, I found that this may be a BUG. All query results will be serialized, but not all jdbc-driver classes can be serialized.
This happend at:
org/apache/dolphinscheduler/plugin/task/sql/SqlTask.java:305

What you expected to happen

All data types should be queryable.

How to reproduce

1. create process
2. drag SQL-TASK component
3. choose ORACLE database
4. choose QUERY sql type
5. edit select statement to query CLOB fields
6. online and execute process

Anything else

No response

Version

3.1.x

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

[github-actions]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.