vayzhang opened a new issue #3436:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3436
### MyCase:
1. use sql task node, sql type is query;
2. (db is oracle )config a sql, such as select *from table_t;
table_t has two columns, one's name is comment, type is
VARCHAR2(50),
another is last_updated_time , timestamp;
3. excute the job.
### version: 1.3.1
### Exception:
java.lang.IllegalArgumentException: No serializer found for class
java.io.ByteArrayInputStream and no properties discovered to create
BeanSerializer (to avoid exception, disable
SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain:
oracle.sql.TIMESTAMP["stream"])
at
com.fasterxml.jackson.databind.ObjectMapper.valueToTree(ObjectMapper.java:2802)
at
org.apache.dolphinscheduler.common.utils.JSONUtils.toJsonNode(JSONUtils.java:67)
at
org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.resultProcess(SqlTask.java:265)
at
org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:232)
at
org.apache.dolphinscheduler.server.worker.task.sql.SqlTask.handle(SqlTask.java:138)
at
org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:129)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
### My Solution:
modifiy the declare ObjectMapper in the Class "JSONUtils" as following:
`new ObjectMapper().configure(FAIL_ON_EMPTY_BEANS, false)
`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
