• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Derby->MySQL: ERROR 42X05: Table/View 'SYSTEMSETTINGS' does not exist.

    User help
    2
    5
    4.8k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      cora
      last edited by

      INFO: Initializing Spring root WebApplicationContext
      08.07.2011 16:19:51 org.apache.catalina.core.StandardContext listenerStart
      SCHWERWIEGEND: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
      com.serotonin.ShouldNeverHappenException: java.sql.SQLSyntaxErrorException: Table/View 'SYSTEMSETTINGS' does not exist.
      at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:125)
      at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:255)
      at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:94)
      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
      at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
      at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      at org.apache.catalina.core.StandardService.start(StandardService.java:516)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
      Caused by: java.sql.SQLSyntaxErrorException: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
      at com.serotonin.mango.db.DBConvert.copyTable(DBConvert.java:109)
      at com.serotonin.mango.db.DBConvert.execute(DBConvert.java:58)
      at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:122)
      ... 26 more
      Caused by: java.sql.SQLException: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      ... 37 more
      Caused by: ERROR 42X05: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
      at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
      at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
      ... 31 more
      08.07.2011 16:19:51 org.apache.catalina.core.ApplicationContext log
      INFO: Closing Spring root WebApplicationContext

      Any help is welcome! ^^

      1 Reply Last reply Reply Quote 0
      • A
        apl
        last edited by

        Hi,

        which mango version | OS type, version, tomcat version?

        What do you did exactly? new emty derby db to mysql? ...

        Arne

        1 Reply Last reply Reply Quote 0
        • C
          cora
          last edited by

          tomcat 6.0.20
          Mango 1.12.4
          Windows XP (2002)
          I am trying to swich from a new empty derby to Mysql

          1 Reply Last reply Reply Quote 0
          • A
            apl
            last edited by

            Use mango 1.12.3 ther are nop sources for versions > 1.12.3, or ask serotonin directly.

            Arne

            1 Reply Last reply Reply Quote 0
            • First post
              Last post