View Issue Details

IDProjectCategoryView StatusLast Update
0005833SymmetricDSBugpublic2023-09-13 17:25
Reportersebaies Assigned To 
Status closedResolutionopen 
Product Version3.14.7 
Summary0005833: SqlException when set load.only=true
if i set load.only=true option in engine configuration file and i start the server i get this error, if i remove the "load.only=true" everything works correctly (but clearly the whole sql sym_ structure is created).

SymmetricEngineHolder - Failed to initialize engine org.jumpmind.db.sql.SqlException: Error while reading the database metadata: null
        at org.jumpmind.db.platform.JdbcDatabasePlatformFactory.determineDatabaseNameVersionSubprotocol(
        at org.jumpmind.db.platform.JdbcDatabasePlatformFactory.create(
        at org.jumpmind.symmetric.ClientSymmetricEngine.createDatabasePlatform(
        at org.jumpmind.symmetric.ClientSymmetricEngine.createTargetDialect(
        at org.jumpmind.symmetric.AbstractSymmetricEngine.init(
        at org.jumpmind.symmetric.ClientSymmetricEngine.init(
        at org.jumpmind.symmetric.web.ServerSymmetricEngine.init(
        at org.jumpmind.symmetric.ClientSymmetricEngine.<init>(
        at org.jumpmind.symmetric.web.ServerSymmetricEngine.<init>(
        at org.jumpmind.symmetric.web.SymmetricEngineHolder.create(
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(
        at java.base/java.util.concurrent.ThreadPoolExecutor$
        at java.base/
Caused by: java.lang.NullPointerException
        at org.jumpmind.db.platform.JdbcDatabasePlatformFactory.determineDatabaseNameVersionSubprotocol(
        ... 13 more

I have tried both on a SQLServer and PostgreSQL db but the result is the same

TagsNo tags attached.



2023-05-16 16:52

developer   ~0002325

The docs say you need the db.* properties to connect to a runtime database, like H2. Then you set the target.db.* properties to connect to your load-only database.

We could add a warning message when someone just sets load.only=true without setting target.db.* properties to make it clearer. Something like "With load.only=true, please configure your load-only database with the target.db.url, target.db.driver, target.db.user, and target.db.password properties"


2023-05-23 08:14

reporter   ~0002329

ok thanks, i'll try as soon as possible

Issue History

Date Modified Username Field Change
2023-05-16 14:29 sebaies New Issue
2023-05-16 16:52 elong Note Added: 0002325
2023-05-23 08:14 sebaies Note Added: 0002329
2023-05-23 12:44 elong Status new => feedback
2023-09-13 17:25 emiller Status feedback => closed