jdbc error while opening sqlite3 file

[mistergibson]

openjdk version "24" 2025-03-18
OpenJDK Runtime Environment GraalVM CE 24+36.1 (build 24+36-jvmci-b01)
OpenJDK 64-Bit Server VM GraalVM CE 24+36.1 (build 24+36-jvmci-b01, mixed mode, sharing)

Mounting or creating a database ...
WARNING: A restricted method in java.lang.System has been called
WARNING: java.lang.System::loadLibrary has been called by org.sqlite.NativeDB in an unnamed module (file:/opt/jruby-gems/shared/gems/jdbc-sqlite3-3.6.14.2.056-java/lib/sqlitejdbc-3.6.14.2.056.jar)
WARNING: Use --enable-native-access=ALL-UNNAMED to avoid a warning for callers in this module
WARNING: Restricted methods will be blocked in a future release unless native access is enabled

Exception: Unable to format a read-only database
initialize at /opt/jruby-gems/shared/gems/gxg-framework-0.0.64/lib/gxg/gxg_database.rb:5458
new at org/jruby/RubyClass.java:1036
connect at /opt/jruby-gems/shared/gems/gxg-framework-0.0.64/lib/gxg/gxg_database.rb:403
db_pool_setup at ./setup.rb:229
each at org/jruby/RubyArray.java:2088
db_pool_setup at ./setup.rb:210
at ./setup.rb:252

Ubuntu Linux 22.04

More details here: jeremyevans/sequel#2342

[gotson]

if you are talking about the warning, the message explains how to get rid of it.

[mistergibson]

no. I'm filing a report because it all USED TO WORK and I have not altered my code. Now, a fully initialized db is around 1.45MB the way I have it configured. Your current code writes out 3072 bytes and fails. I am unable to format the db and my code now fails 100% of the time. I'm currently using version 3.6.14.2.056. Can you suggest perhaps an older version that is solid?

[gotson]

no. I'm filing a report because it all USED TO WORK and I have not altered my code. Now, a fully initialized db is around 1.45MB the way I have it configured. Your current code writes out 3072 bytes and fails. I am unable to format the db and my code now fails 100% of the time. I'm currently using version 3.6.14.2.056. Can you suggest perhaps an older version that is solid?

Please be civilized.

The problem is not clear, how you use the library is not clear. Seems like you are using Ruby, which uses sqlite-jdbc. The exception comes from Ruby, so you should check with the Ruby library in the first place probably.

The warning coming from sqlite-jdbc about restricted methods is just a warning, and is explained in #1289

[mistergibson]

Sorry --> Didn't mean to be offensive. That ruby exception thrown is only thrown under very specific circumstances. if it cannot even open the file read only it throws that error --> suggesting the issue is at a deeper layer than JRuby