[
https://issues.apache.org/jira/browse/HDDS-14451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krishna Kumar Asawa reassigned HDDS-14451:
------------------------------------------
Assignee: Abhishek Pal (was: Krishna Kumar Asawa)
> Recon does not work with SQLite
> -------------------------------
>
> Key: HDDS-14451
> URL: https://issues.apache.org/jira/browse/HDDS-14451
> Project: Apache Ozone
> Issue Type: Bug
> Components: Ozone Recon
> Reporter: Attila Doroszlai
> Assignee: Abhishek Pal
> Priority: Critical
>
> HDDS-3411 switched Recon from SQLite to Derby, saying "retains the out of the
> box support for SQLite". {{ozone.recon.sql.db.driver}} and
> {{ozone.recon.sql.db.jdbc.url}} allows configuring SQLite. However, Recon
> does not work out of the box with SQLite due to some hard-coded logic..
> {code:title=https://github.com/apache/ozone/blob/65f0af09fa7c65fa00d7df06f232159f61edde98/hadoop-ozone/recon-codegen/src/main/java/org/apache/ozone/recon/codegen/JooqCodeGenerator.java#L87-L89}
> .withJdbc(new Jdbc()
> .withDriver(SqlDbUtils.DERBY_DRIVER_CLASS)
> .withUrl(JDBC_URL))
> {code}
> {code:title=https://github.com/apache/ozone/blob/65f0af09fa7c65fa00d7df06f232159f61edde98/hadoop-ozone/recon/src/main/java/org/apache/hadoop/ozone/recon/ReconControllerModule.java#L222-L223}
> sqlDbConfig.setJdbcUrl(
> "jdbc:derby:" + reconDbDir.getPath() + "/ozone_recon_derby.db");
> {code}
> There are also comments in various Recon classes related to Derby, suggesting
> they may not work properly with SQLite.
> Derby [retired|https://db.apache.org/derby/#Derby+Retired], so we should move
> off of it.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]