[ 
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]

Reply via email to