View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005833 | SymmetricDS | Bug | public | 2023-05-16 14:29 | 2023-09-13 17:25 |
| Reporter | sebaies | Assigned To | |||
| Priority | high | ||||
| Status | closed | Resolution | open | ||
| Product Version | 3.14.7 | ||||
| Summary | 0005833: SqlException when set load.only=true | ||||
| Description | Hi, 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(JdbcDatabasePlatformFactory.java:287) at org.jumpmind.db.platform.JdbcDatabasePlatformFactory.create(JdbcDatabasePlatformFactory.java:238) at org.jumpmind.symmetric.ClientSymmetricEngine.createDatabasePlatform(ClientSymmetricEngine.java:367) at org.jumpmind.symmetric.ClientSymmetricEngine.createTargetDialect(ClientSymmetricEngine.java:299) at org.jumpmind.symmetric.AbstractSymmetricEngine.init(AbstractSymmetricEngine.java:293) at org.jumpmind.symmetric.ClientSymmetricEngine.init(ClientSymmetricEngine.java:196) at org.jumpmind.symmetric.web.ServerSymmetricEngine.init(ServerSymmetricEngine.java:80) at org.jumpmind.symmetric.ClientSymmetricEngine.<init>(ClientSymmetricEngine.java:147) at org.jumpmind.symmetric.web.ServerSymmetricEngine.<init>(ServerSymmetricEngine.java:59) at org.jumpmind.symmetric.web.SymmetricEngineHolder.create(SymmetricEngineHolder.java:347) at org.jumpmind.symmetric.web.SymmetricEngineStarter.run(SymmetricEngineStarter.java:38) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:830) Caused by: java.lang.NullPointerException at org.jumpmind.db.platform.JdbcDatabasePlatformFactory.determineDatabaseNameVersionSubprotocol(JdbcDatabasePlatformFactory.java:271) ... 13 more " I have tried both on a SQLServer and PostgreSQL db but the result is the same Thanks | ||||
| Tags | No tags attached. | ||||
|
|
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. https://www.symmetricds.org/doc/3.14/html/user-guide.html#_setup_load_only_node 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" |
|
|
ok thanks, i'll try as soon as possible |