Create Maven module shardingsphere-jdbc-core-jakarta using Jakarta EE 9 API

[linghengqian]

Feature Request

For English only, other languages will not be accepted.

Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot make decision by current information, we will close it.

Please answer these questions before submitting your issue. Thanks!

Is your feature request related to a problem?

• Refer to Transition from Java EE to Jakarta EE #26041 and Migrate from Jakarta EE 8 to Jakarta EE 9 #27976 (review) .

Describe the feature you would like.

• Since Migrate from Jakarta EE 8 to Jakarta EE 9 #27976 is controversial at the current milestone, I propose another transition option for migrating to Jakarta EE. That is, create Maven module shardingsphere-jdbc-core-jakarta using Jakarta EE 9 API through Eclipse Transformer. Refer to https://github.com/eclipse/transformer .
• This involves the following steps.
  • Migrate from Java EE 8 to Jakarta EE 8. This will only change the GAV information of the corresponding dependencies to align the behavior of Spring Boot 2.2-2.7.
  • Create a Jakarta EE 9 variant of ShardingSphere JDBC Core. The series of processing of ShardingSphere at DistSQL is ignored for the time being, because DistSQL only involves ShardingSphere Proxy.
  • Migrate nativeTest targeted by shardingsphere-test-native to the new Maven module. To be honest, I believe that all GraalVM Native Image application scenarios on the Web are located under Jakarta EE.

[linghengqian]

• I'm working on this issue.
• Variants involving the following dependencies:
  • shardingsphere-jdbc-core-jakarta corresponds to shardingsphere-jdbc-core

[linghengqian]

• Due to the merge of Removes use of JAXB API via jackson-dataformat-xml #29384, this issue only needs to deal with the XA distributed transaction module. Retarget this issue later.

[linghengqian]

• This issue is no longer relevant as there are only 4 Optional modules that actually need to consider the jakarta variant. But we may need to consider additional abstractions to unify javax and jakarta.
  • org.apache.shardingsphere:shardingsphere-transaction-xa-core
  • org.apache.shardingsphere:shardingsphere-transaction-xa-spi
  • org.apache.shardingsphere:shardingsphere-transaction-xa-atomikos
  • org.apache.shardingsphere:shardingsphere-transaction-xa-narayana