Skip to content

Conversation

@yinxiaolog
Copy link
Contributor

Purpose of the pull request

If SQL specifies a user-defined parameter of the TIME type, set it to the java.sql.Time type when setting the PreparedStatement parameter.

SQL使用自定义参数为TIME类型,设置PreparedStatement执行参数时,会设置为java.sql.Time,原来是String类型。

Brief change log

change set PreparedStatement to org.apache.dolphinscheduler.plugin.task.api.utils.ParameterUtils .

修改ParameterUtils.setInParameter方法设置DataType类型为TIME,设置为java.sql.Time。

Verify this pull request

@ruanwenjun ruanwenjun changed the title [Fix-16046][api] Fix PreparedStatement parameter type [Fix-16046][SqlTask] Fix PreparedStatement parameter type May 22, 2024
@ruanwenjun ruanwenjun changed the title [Fix-16046][SqlTask] Fix PreparedStatement parameter type [Fix-16046][SqlTask] Fix Sql task use time type is incorrect May 22, 2024
@ruanwenjun ruanwenjun added the bug Something isn't working label May 22, 2024
@codecov-commenter
Copy link

codecov-commenter commented May 22, 2024

Codecov Report

Attention: Patch coverage is 0% with 1 lines in your changes are missing coverage. Please review.

Project coverage is 40.61%. Comparing base (581a7ed) to head (c7d94cf).

Current head c7d94cf differs from pull request most recent head d7be00c

Please upload reports for the commit d7be00c to get more accurate results.

Files Patch % Lines
...cheduler/plugin/task/api/utils/ParameterUtils.java 0.00% 1 Missing ⚠️
Additional details and impacted files
@@             Coverage Diff              @@
##                dev   #16050      +/-   ##
============================================
- Coverage     40.61%   40.61%   -0.01%     
+ Complexity     5221     5220       -1     
============================================
  Files          1380     1380              
  Lines         46069    46069              
  Branches       4917     4917              
============================================
- Hits          18712    18709       -3     
- Misses        25432    25435       +3     
  Partials       1925     1925              

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

Copy link
Member

@ruanwenjun ruanwenjun left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

Copy link
Member

@SbloodyS SbloodyS left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

+1

@SbloodyS
Copy link
Member

Please link this pr to your issue. @yinxiaolog

Copy link
Contributor

@rickchengx rickchengx left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@sonarqubecloud
Copy link

Please retry analysis of this Pull-Request directly on SonarCloud

@rickchengx rickchengx merged commit baa252a into apache:dev May 24, 2024
wangxj3 added a commit that referenced this pull request May 25, 2024
…ASF release (#16042)

* add version of 3.2.2

* Fix rpc channel leak due to concurrent operation (#16021)

* Fix rpc channel leak due to concurrent operation

* Throw channel create failed exception

---------

Co-authored-by: Rick Cheng <[email protected]>

* Fix WorkerTaskExecutorThreadPool#isOverload is incorrect (#16027)

* cp: Reduce the size of tarball to continue ASF release (#15004) (#15540)

* Reduce the size of tarball to continue ASF release

for more detail you can see https://lists.apache.org/thread/rmp7fghlj0n7h9y2v3p8gkw9f9qbo6qt
# Conflicts:
#	tools/dependencies/known-dependencies.txt

* Increase block-until-connected in ZookeeperRegistryTestCase (#16041)

* [Fix][CI] fix the ci error of Values.datasource.profile (#16031)

Co-authored-by: Eric Gao <[email protected]>

* Correction of Typos in the Chinese Document Appendix for Task Parameters (#16033)

Co-authored-by: Rick Cheng <[email protected]>

* [DSIP-39][parameter] Improvement startup parameters/global parameters/project parameters data type (#15967)

* [Improvement][parameter] New data types and type filtering

* [Improvement][parameter] Improvement startup parameters/global parameters data type

* fix api interfaces compatible

* add project parameter data type default value

* [Improvement][parameter] New data types and type filtering

* [Improvement][parameter] Improvement startup parameters/global parameters data type

* fix api interfaces compatible

* add project parameter data type default value

* improvement project code

* remove useless imports

* remove method onClearSearchTaskType

* add parameter doc

* optimisation logic

* code conflict resolution

* code conflict resolution

* [Improvement][Monitor] Show master && worker Busy Or Normal Status and Show Commands table list (#15978)

* update

* test

* add monitor enhance ui

* update

* update

* update doc

* fix spotless

* update

* update

* Update dolphinscheduler-api/src/main/java/org/apache/dolphinscheduler/api/controller/DataAnalysisController.java

Co-authored-by: Wenjun Ruan <[email protected]>

* Update dolphinscheduler-api/src/main/java/org/apache/dolphinscheduler/api/controller/DataAnalysisController.java

Co-authored-by: Wenjun Ruan <[email protected]>

* Update dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/mapper/ErrorCommandMapper.java

Co-authored-by: Wenjun Ruan <[email protected]>

* Update dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ErrorCommandMapper.xml

Co-authored-by: Wenjun Ruan <[email protected]>

* Update dolphinscheduler-dao/src/main/java/org/apache/dolphinscheduler/dao/mapper/CommandMapper.java

Co-authored-by: Wenjun Ruan <[email protected]>

* Update dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ErrorCommandMapper.xml

Co-authored-by: Wenjun Ruan <[email protected]>

* update

* fix spotless

* update

---------

Co-authored-by: Wenjun Ruan <[email protected]>

* [Improvement][Monitor] Add UT for montor (#15998)

* formatting Code

* add pom

* Fix NettyRemotingClient might throw IllegalMonitorStateException (#16038)

* Removed unused StateEventHandleFailure (#16052)

* Remove OmitStackTraceInFastThrow in start.sh (#16054)

* Update Chart.yaml Rollback APPversion

* modify log msg (#16062)

Co-authored-by: xiangzihao <[email protected]>

* [DS-16046][fix] Set PreparedStatement parameter type (#16050)

Fix the PreparedStatement parameter is TIME, set it to java.sql.Time

Co-authored-by: Aaron Wang <[email protected]>
Co-authored-by: Rick Cheng <[email protected]>

* Update pom.xml

* [DSIP-42] Add dolphinscheduler-aws-authentication module  (#16043)

---------

Co-authored-by: wangxj <wangxj31>
Co-authored-by: Wenjun Ruan <[email protected]>
Co-authored-by: Rick Cheng <[email protected]>
Co-authored-by: Eric Gao <[email protected]>
Co-authored-by: TianXinCoord <[email protected]>
Co-authored-by: 小可耐 <[email protected]>
Co-authored-by: sleo <[email protected]>
Co-authored-by: xiangzihao <[email protected]>
Co-authored-by: yinxiaolog <[email protected]>
Co-authored-by: Aaron Wang <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

3.2.2 backend bug Something isn't working first time contributor First-time contributor

Projects

None yet

Development

Successfully merging this pull request may close these issues.

6 participants