Test other components that relying on S3-compatible storage

[xxchan]

• S3 source
• Java connector

Already mentioned in #8266.

For storage, I guess it generally works, and we just want to test maturity https://github.com/risingwavelabs/risingwave-test/issues/285.

But I guess other components are not tested yet, as it's not functional, e.g., #10994.

Note that now each component has it own logic of AWS config handling, and they are inconsistent. This might be the root of the problems.

[fuyufjh]

This is a reminder from the past. Can you please help with this once S3 source & sink completed? cc. @tabVersion @xiangjinwu

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄