Attila Doroszlai created HDDS-14451:
---------------------------------------
Summary: 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: Krishna Kumar Asawa
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]
