Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

create-sym-tables CREATE ALIAS IF NOT EXISTS SYM_BASE64_ENCODE for "org.jumpmind.symmetric.db.EmbeddedDbFunctions.encodeBase64"; [90086-164]

Help
Justin
2014-07-10
2014-07-15
  • Justin
    Justin
    2014-07-10

    Hello,

    I get the below stacktrace using versions 3.5.19 and the 3.6.1whenever I run the create-sym-tables I get the following stack trace:

    CREATE ALIAS IF NOT EXISTS SYM_BASE64_ENCODE for "org.jumpmind.symmetric.db.EmbeddedDbFunctions.encodeBase64"; [90086-175]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
    at org.h2.message.DbException.get(DbException.java:161)
    at org.h2.util.Utils.loadUserClass(Utils.java:659)
    at org.h2.engine.FunctionAlias.loadClass(FunctionAlias.java:146)
    at org.h2.engine.FunctionAlias.load(FunctionAlias.java:122)
    at org.h2.engine.FunctionAlias.init(FunctionAlias.java:107)
    at org.h2.engine.FunctionAlias.newInstance(FunctionAlias.java:78)
    at org.h2.command.ddl.CreateFunctionAlias.update(CreateFunctionAlias.java:49)
    at org.h2.command.CommandContainer.update(CommandContainer.java:79)
    at org.h2.command.Command.executeUpdate(Command.java:253)
    at org.h2.server.TcpServerThread.process(TcpServerThread.java:340)
    at org.h2.server.TcpServerThread.run(TcpServerThread.java:156)
    at java.lang.Thread.run(Thread.java:695)
    Caused by: java.lang.ClassNotFoundException: org.jumpmind.symmetric.db.EmbeddedDbFunctions
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:392)
    at runjettyrun.ProjectClassLoader.loadClass(ProjectClassLoader.java:89)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:171)
    at org.h2.util.Utils.loadUserClass(Utils.java:654)
    ... 10 more

    I've add symmetric-core-3.5.19.jar, symmetric-server-3.5.19.jar and symmetric-client-3.5.19.jar to the classpath by dropping them into the symmetric-3.5.19/lib folder, but this doesn't seem to help. I started using 3.5.19 because I was not able to locate these jar files for version 3.6.1.

    I get a very similar stack trace when running create-sym-tables in 3.6.1 as well. Any help or suggestions would be greatly appreciated.

    Thank you,

    Justin

     
  • Justin
    Justin
    2014-07-14

    Anyone else have this problem or can point me in the right direction?

     
  • Chris Henson
    Chris Henson
    2014-07-14

    You are running H2 as a standalone database engine? If so, you need to include symmetric-client-x.x.x.jar in the classpath.

     
  • Justin
    Justin
    2014-07-15

    Hi Chris,

    Thank you for the additional information. This database starts dynamically with the application (embedded). Where would the symmetric-client JAR need to be available on the classpath in this scenario?

    Thank you,

    Justin

     
  • Chris Henson
    Chris Henson
    2014-07-15

    yep