Hi maintainer of this port, The original distfile of this port is not available. $ make -C /usr/ports/java/sqlitejdbc fetch ===> sqlitejdbc-056_3 depends on file: /usr/local/sbin/pkg - found => sqlitejdbc-v056-src.tgz doesn't seem to exist in /data/distfiles. => Attempting to fetch http://files.zentus.com/sqlitejdbc/sqlitejdbc-v056-src.tgz fetch: http://files.zentus.com/sqlitejdbc/sqlitejdbc-v056-src.tgz: Operation timed out => Attempting to fetch http://distcache.FreeBSD.org/ports-distfiles/sqlitejdbc-v056-src.tgz sqlitejdbc-v056-src.tgz 156 kB 19 MBps 00s ===> Fetching all distfiles required by sqlitejdbc-056_3 for building The file is only available from the FreeBSD distcache. The original source times out. Can this be fixed? And is it worth keeping this port?
NB: I'm not directly interested in the port, but I'm going through the java ports for the openjdk21 default (bug #272855) and noticed this.
The project has been here https://github.com/xerial/sqlite-jdbc for ages now. Could of years ago I modified upstream for FreeBSD and other to be able to link the JNI code dynamically against libsqlite.so instead of using the archive. Moreover, the JAR can be fully stripped of the bundled native libs because it will happily the FreeBSD-compiled one from the loader's path. Let's wait for the maintainer... Commits: * https://github.com/xerial/sqlite-jdbc/commit/bb91612de41c4fec90a4736916c1a486b19855d5 * https://github.com/xerial/sqlite-jdbc/commit/45a05e09c7a56c4082a6dd9606b117361d1c7334
I'd recommend not to touch the port until this one is merged: https://github.com/xerial/sqlite-jdbc/pull/1387
(In reply to Michael Osipov from comment #3) Upstream pull request 1387 was closed 3 days ago without merging. This pull request was merged though: https://github.com/xerial/sqlite-jdbc/pull/1388. Is that enough to get this FreeBSD PR moving again?
(In reply to Ronald Klop from comment #4) Yes, my idea is to use the without-natives JAR and compile the libsqlitejdbc dynamically against libsqlite3 instead of the bundled one. Will pick it up next week. Do we need a maintainer reset?
(In reply to Michael Osipov from comment #5) Thanks for working on this. About the maintainer reset. I see last activity in the ports tree in January 2026. Not too long ago. https://cgit.freebsd.org/ports/log/?qt=grep&q=lapo@lapo.it&showmsg=1 I think by the policy it is needed to register a couple of "maintainer timeout"'s in commits before a reset.
Alright, let me work on a patch.
https://reviews.freebsd.org/D56649
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=dc08083010183602bcf04c64bddb58917aec7486 commit dc08083010183602bcf04c64bddb58917aec7486 Author: Michael Osipov <michaelo@FreeBSD.org> AuthorDate: 2026-04-26 19:13:32 +0000 Commit: Michael Osipov <michaelo@FreeBSD.org> CommitDate: 2026-04-28 17:15:30 +0000 [NEW PORT] databases/sqlite-jdbc: JDBC driver for SQLite PR: 293491 Reviewed by: ronald Differential Revision: https://reviews.freebsd.org/D56649 databases/Makefile | 1 + databases/sqlite-jdbc/Makefile (new) | 39 ++++++++++++++++++ databases/sqlite-jdbc/distinfo (new) | 5 +++ databases/sqlite-jdbc/files/patch-Makefile (new) | 11 +++++ .../sqlite-jdbc/files/patch-Makefile.common (new) | 47 ++++++++++++++++++++++ databases/sqlite-jdbc/pkg-descr (new) | 2 + databases/sqlite-jdbc/pkg-message (new) | 12 ++++++ 7 files changed, 117 insertions(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=c374ad91e69e63cd5b26a16d2b33b8f08944824a commit c374ad91e69e63cd5b26a16d2b33b8f08944824a Author: Michael Osipov <michaelo@FreeBSD.org> AuthorDate: 2026-04-28 17:55:57 +0000 Commit: Michael Osipov <michaelo@FreeBSD.org> CommitDate: 2026-04-28 17:55:57 +0000 java/sqlitejdbc: deprecate and expire Upstream source dead for quite some time and long replaced by sqlite-jdbc on GitHub. PR: 293491 java/sqlitejdbc/Makefile | 3 +++ 1 file changed, 3 insertions(+)
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=85394610f1bc83be7e9165d850e9f2a8a6ec3aae commit 85394610f1bc83be7e9165d850e9f2a8a6ec3aae Author: Ronald Klop <ronald@FreeBSD.org> AuthorDate: 2026-04-28 18:53:57 +0000 Commit: Ronald Klop <ronald@FreeBSD.org> CommitDate: 2026-04-28 18:53:57 +0000 java/sqlitejdbc: little cleanup - bump portrevision so new packages with the deprecation annotation and expiration date are build - be a bit more pedantic about the 3 months expiration date so we are sure the next quarterly branch contains this package - mark as conflicting with the new port, they install the same .so library file PR: 293491 Approved-by: maintainer timeout (Lapo Luchini) java/sqlitejdbc/Makefile | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-)
(In reply to commit-hook from comment #11) Thank you for the cleanup, quite reasonable.
(In reply to Michael Osipov from comment #12) Well, and thank you for doing the work in bringing this driver up-to-date. 🏆
(In reply to Ronald Klop from comment #13) I have a good connection to the upstream maintainer and have already upstreamed two of our downstream hunks.