I am running symmetricds as a war file runing in tomcat connected to Apache web server. I am using mysql database and haveset initial.load.create.first=true. Everything works fine except that Foreign key integrity fails with initial insertion of data at the client side. I copied this from the user guide and inserted into the mysql database to disable foreign keys before load and enable them after the load:
But code fails to compile. I am getting this error in the logs.
08-Jun-2018 20:44:55.806 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 6115 ms
[remote-000] - ExtensionService - Found 1 extension points from the database that will be registered
[remote-000] - SimpleClassCompiler - Compiling class 'MyReloadListener'
[remote-000] - SimpleClassCompiler - Compilation of 'MyReloadListener' failed
[remote-000] - SimpleClassCompiler - MyReloadListener at line 1, column 27: package org.jumpmind.db.sql does not exist
[remote-000] - SimpleClassCompiler - MyReloadListener at line 2, column 30: package org.jumpmind.symmetric does not exist
[remote-000] - SimpleClassCompiler - MyReloadListener at line 3, column 34: package org.jumpmind.symmetric.ext does not exist
[remote-000] - SimpleClassCompiler - MyReloadListener at line 4, column 35: package org.jumpmind.symmetric.load does not exist
[remote-000] - SimpleClassCompiler - MyReloadListener at line 5, column 36: package org.jumpmind.symmetric.model does not exist
[remote-000] - SimpleClassCompiler - MyReloadListener at line 7, column 46: cannot find symbol
symbol: class IReloadListener
[remote-000] - SimpleClassCompiler - MyReloadListener at line 7, column 63: cannot find symbol
symbol: class ISymmetricEngineAware
[remote-000] - SimpleClassCompiler - MyReloadListener at line 9, column 5: cannot find symbol
symbol: class ISymmetricEngine
location: class SimpleClassCompiler1
[remote-000] - SimpleClassCompiler - MyReloadListener at line 12, column 36: cannot find symbol
symbol: class ISymmetricEngine
location: class SimpleClassCompiler1
[remote-000] - SimpleClassCompiler - MyReloadListener at line 17, column 30: cannot find symbol
symbol: class ISqlTransaction
location: class SimpleClassCompiler1
[remote-000] - SimpleClassCompiler - MyReloadListener at line 17, column 59: cannot find symbol
symbol: class Node
location: class SimpleClassCompiler1
[remote-000] - SimpleClassCompiler - MyReloadListener at line 22, column 29: cannot find symbol
symbol: class ISqlTransaction
location: class SimpleClassCompiler1
[remote-000] - SimpleClassCompiler - MyReloadListener at line 22, column 58: cannot find symbol
symbol: class Node
location: class SimpleClassCompiler1
[remote-000] - SimpleClassCompiler - MyReloadListener at line 11, column 5: method does not override or implement a method from a supertype
[remote-000] - SimpleClassCompiler - MyReloadListener at line 16, column 5: method does not override or implement a method from a supertype
[remote-000] - SimpleClassCompiler - MyReloadListener at line 21, column 5: method does not override or implement a method from a supertype
[remote-000] - ExtensionService - Error while compiling Java extension disable ref integrity
org.jumpmind.util.SimpleClassCompilerException
at org.jumpmind.util.SimpleClassCompiler.getCompiledClass(SimpleClassCompiler.java:117)
at org.jumpmind.symmetric.service.impl.ExtensionService.registerExtension(ExtensionService.java:109)
at org.jumpmind.symmetric.service.impl.ExtensionService.refresh(ExtensionService.java:100)
at org.jumpmind.symmetric.service.impl.ClientExtensionService.refresh(ClientExtensionService.java:46)
at org.jumpmind.symmetric.ClientSymmetricEngine.init(ClientSymmetricEngine.java:228)
at org.jumpmind.symmetric.web.ServerSymmetricEngine.init(ServerSymmetricEngine.java:66)
at org.jumpmind.symmetric.ClientSymmetricEngine.<init>(ClientSymmetricEngine.java:151)
at org.jumpmind.symmetric.web.ServerSymmetricEngine.<init>(ServerSymmetricEngine.java:51)
at org.jumpmind.symmetric.web.SymmetricEngineHolder.create(SymmetricEngineHolder.java:247)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:527)
[remote-000] - ClientExtensionService - Found 7 extension points from spring that will be registered
[remote-000] - AbstractSymmetricEngine - Initializing SymmetricDS database
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There are parameters which allow you to run SQL before and after your initial load which may be simpler for your configuration here. See:
initial.load.before.sql
and
initial.load.after.sql
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am running symmetricds as a war file runing in tomcat connected to Apache web server. I am using mysql database and haveset initial.load.create.first=true. Everything works fine except that Foreign key integrity fails with initial insertion of data at the client side. I copied this from the user guide and inserted into the mysql database to disable foreign keys before load and enable them after the load:
But code fails to compile. I am getting this error in the logs.
08-Jun-2018 20:44:55.806 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 6115 ms [remote-000] - ExtensionService - Found 1 extension points from the database that will be registered [remote-000] - SimpleClassCompiler - Compiling class 'MyReloadListener' [remote-000] - SimpleClassCompiler - Compilation of 'MyReloadListener' failed [remote-000] - SimpleClassCompiler - MyReloadListener at line 1, column 27: package org.jumpmind.db.sql does not exist [remote-000] - SimpleClassCompiler - MyReloadListener at line 2, column 30: package org.jumpmind.symmetric does not exist [remote-000] - SimpleClassCompiler - MyReloadListener at line 3, column 34: package org.jumpmind.symmetric.ext does not exist [remote-000] - SimpleClassCompiler - MyReloadListener at line 4, column 35: package org.jumpmind.symmetric.load does not exist [remote-000] - SimpleClassCompiler - MyReloadListener at line 5, column 36: package org.jumpmind.symmetric.model does not exist [remote-000] - SimpleClassCompiler - MyReloadListener at line 7, column 46: cannot find symbol symbol: class IReloadListener [remote-000] - SimpleClassCompiler - MyReloadListener at line 7, column 63: cannot find symbol symbol: class ISymmetricEngineAware [remote-000] - SimpleClassCompiler - MyReloadListener at line 9, column 5: cannot find symbol symbol: class ISymmetricEngine location: class SimpleClassCompiler1 [remote-000] - SimpleClassCompiler - MyReloadListener at line 12, column 36: cannot find symbol symbol: class ISymmetricEngine location: class SimpleClassCompiler1 [remote-000] - SimpleClassCompiler - MyReloadListener at line 17, column 30: cannot find symbol symbol: class ISqlTransaction location: class SimpleClassCompiler1 [remote-000] - SimpleClassCompiler - MyReloadListener at line 17, column 59: cannot find symbol symbol: class Node location: class SimpleClassCompiler1 [remote-000] - SimpleClassCompiler - MyReloadListener at line 22, column 29: cannot find symbol symbol: class ISqlTransaction location: class SimpleClassCompiler1 [remote-000] - SimpleClassCompiler - MyReloadListener at line 22, column 58: cannot find symbol symbol: class Node location: class SimpleClassCompiler1 [remote-000] - SimpleClassCompiler - MyReloadListener at line 11, column 5: method does not override or implement a method from a supertype [remote-000] - SimpleClassCompiler - MyReloadListener at line 16, column 5: method does not override or implement a method from a supertype [remote-000] - SimpleClassCompiler - MyReloadListener at line 21, column 5: method does not override or implement a method from a supertype [remote-000] - ExtensionService - Error while compiling Java extension disable ref integrity org.jumpmind.util.SimpleClassCompilerException at org.jumpmind.util.SimpleClassCompiler.getCompiledClass(SimpleClassCompiler.java:117) at org.jumpmind.symmetric.service.impl.ExtensionService.registerExtension(ExtensionService.java:109) at org.jumpmind.symmetric.service.impl.ExtensionService.refresh(ExtensionService.java:100) at org.jumpmind.symmetric.service.impl.ClientExtensionService.refresh(ClientExtensionService.java:46) at org.jumpmind.symmetric.ClientSymmetricEngine.init(ClientSymmetricEngine.java:228) at org.jumpmind.symmetric.web.ServerSymmetricEngine.init(ServerSymmetricEngine.java:66) at org.jumpmind.symmetric.ClientSymmetricEngine.<init>(ClientSymmetricEngine.java:151) at org.jumpmind.symmetric.web.ServerSymmetricEngine.<init>(ServerSymmetricEngine.java:51) at org.jumpmind.symmetric.web.SymmetricEngineHolder.create(SymmetricEngineHolder.java:247) at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:527) [remote-000] - ClientExtensionService - Found 7 extension points from spring that will be registered [remote-000] - AbstractSymmetricEngine - Initializing SymmetricDS database
There are parameters which allow you to run SQL before and after your initial load which may be simpler for your configuration here. See:
initial.load.before.sql
and
initial.load.after.sql