• Recent
    • Tags
    • Popular
    • Register
    • Login
    1. Home
    2. ywwtx
    3. Posts

    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
    Y
    • Profile
    • Following 0
    • Followers 0
    • Topics 2
    • Posts 4
    • Best 0
    • Controversial 0
    • Groups 0

    Posts made by ywwtx

    • Derby to mysql erro

      2010-2-22 15:53:21 org.apache.catalina.core.ApplicationContext log
      ??: Initializing Spring root WebApplicationContext
      2010-2-22 15:53:23 org.apache.catalina.core.StandardContext listenerStart
      ??: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
      com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select ds.id, ds.name, ds.dataSourceType, ds.enabled, vrt.updateSeconds, mbs.updateSeconds, mbs.commPortId, mbs.baudRate, mbs.flowControlIn, mbs.flowControlOut, mbs.dataBits, mbs.stopBits, mbs.parity, mbs.encoding, mbs.echo, mbi.updateSeconds, mbi.transportType, mbi.host, mbi.port from dataSources ds left join dataSourceVrt vrt on vrt.dataSourceId = ds.id left join dataSourceMbs mbs on mbs.dataSourceId = ds.id left join dataSourceMbi mbi on mbi.dataSourceId = ds.id]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist
      at com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:87)
      at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:135)
      at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:248)
      at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:85)
      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.deployDescriptor(HostConfig.java:630)
      at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)
      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: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select ds.id, ds.name, ds.dataSourceType, ds.enabled, vrt.updateSeconds, mbs.updateSeconds, mbs.commPortId, mbs.baudRate, mbs.flowControlIn, mbs.flowControlOut, mbs.dataBits, mbs.stopBits, mbs.parity, mbs.encoding, mbs.echo, mbi.updateSeconds, mbi.transportType, mbi.host, mbi.port from dataSources ds left join dataSourceVrt vrt on vrt.dataSourceId = ds.id left join dataSourceMbs mbs on mbs.dataSourceId = ds.id left join dataSourceMbi mbi on mbi.dataSourceId = ds.id]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist
      at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.translate(SQLExceptionSubclassTranslator.java:78)
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:237)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:457)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465)
      at com.serotonin.db.DaoUtils.query(DaoUtils.java:167)
      at com.serotonin.mango.db.upgrade.Upgrade0_7_0.upgrade(Upgrade0_7_0.java:68)
      at com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:82)
      ... 27 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
      at com.mysql.jdbc.Util.getInstance(Util.java:381)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
      at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)
      at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:210)
      at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:442)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
      ... 32 more
      2010-2-22 15:53:23 org.apache.catalina.core.ApplicationContext log
      ??: Closing Spring root WebApplicationContext
      2010-2-22 15:53:24 org.apache.catalina.core.ApplicationContext log
      ??: ContextListener: contextInitialized()
      2010-2-22 15:53:24 org.apache.catalina.core.ApplicationContext log
      ??: SessionListener: contextInitialized()

      posted in User help
      Y
      ywwtx
    • RE: Derby to mysql erro

      2010-2-22 15:53:21 org.apache.catalina.core.ApplicationContext log
      ??: Initializing Spring root WebApplicationContext
      2010-2-22 15:53:23 org.apache.catalina.core.StandardContext listenerStart
      ??: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
      com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select ds.id, ds.name, ds.dataSourceType, ds.enabled, vrt.updateSeconds, mbs.updateSeconds, mbs.commPortId, mbs.baudRate, mbs.flowControlIn, mbs.flowControlOut, mbs.dataBits, mbs.stopBits, mbs.parity, mbs.encoding, mbs.echo, mbi.updateSeconds, mbi.transportType, mbi.host, mbi.port from dataSources ds left join dataSourceVrt vrt on vrt.dataSourceId = ds.id left join dataSourceMbs mbs on mbs.dataSourceId = ds.id left join dataSourceMbi mbi on mbi.dataSourceId = ds.id]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist
      at com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:87)
      at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:135)
      at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:248)
      at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:85)
      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.deployDescriptor(HostConfig.java:630)
      at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)
      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: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select ds.id, ds.name, ds.dataSourceType, ds.enabled, vrt.updateSeconds, mbs.updateSeconds, mbs.commPortId, mbs.baudRate, mbs.flowControlIn, mbs.flowControlOut, mbs.dataBits, mbs.stopBits, mbs.parity, mbs.encoding, mbs.echo, mbi.updateSeconds, mbi.transportType, mbi.host, mbi.port from dataSources ds left join dataSourceVrt vrt on vrt.dataSourceId = ds.id left join dataSourceMbs mbs on mbs.dataSourceId = ds.id left join dataSourceMbi mbi on mbi.dataSourceId = ds.id]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist
      at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.translate(SQLExceptionSubclassTranslator.java:78)
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:237)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:457)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465)
      at com.serotonin.db.DaoUtils.query(DaoUtils.java:167)
      at com.serotonin.mango.db.upgrade.Upgrade0_7_0.upgrade(Upgrade0_7_0.java:68)
      at com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:82)
      ... 27 more
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
      at com.mysql.jdbc.Util.getInstance(Util.java:381)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
      at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)
      at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:210)
      at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:442)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
      ... 32 more
      2010-2-22 15:53:23 org.apache.catalina.core.ApplicationContext log
      ??: Closing Spring root WebApplicationContext
      2010-2-22 15:53:24 org.apache.catalina.core.ApplicationContext log
      ??: ContextListener: contextInitialized()
      2010-2-22 15:53:24 org.apache.catalina.core.ApplicationContext log
      ??: SessionListener: contextInitialized()

      posted in User help
      Y
      ywwtx
    • Derby to mysql

      INFO 2010-02-10 09:41:21,203 (org.springframework.web.context.ContextLoader.ini
      tWebApplicationContext:209) - Root WebApplicationContext: initialization complet
      ed in 344 ms
      INFO 2010-02-10 09:41:21,203 (com.serotonin.mango.MangoContextListener.contextI
      nitialized:73) - Mango context starting
      INFO 2010-02-10 09:41:21,453 (com.serotonin.mango.db.BasePooledAccess.initializ
      eImpl:54) - Initializing pooled connection manager
      WARN 2010-02-10 09:41:21,796 (com.serotonin.mango.db.upgrade.DBUpgrade.checkUpg
      rade:81) - Upgrading instance from 0.7.0 to 0.8.0
      INFO 2010-02-10 09:41:21,812 (org.springframework.beans.factory.xml.XmlBeanDefi
      nitionReader.loadBeanDefinitions:323) - Loading XML bean definitions from class
      path resource [org/springframework/jdbc/support/sql-error-codes.xml]
      INFO 2010-02-10 09:41:21,859 (org.springframework.jdbc.support.SQLErrorCodesFac
      tory.<init>:128) - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL
      , MySQL, Oracle, PostgreSQL, Sybase]
      2010-2-10 9:41:21 org.apache.catalina.core.StandardContext start
      ??: Error listenerStart
      2010-2-10 9:41:21 org.apache.catalina.core.StandardContext start
      ??: Context [/mango-1.8.0] startup failed due to previous errors
      INFO 2010-02-10 09:41:21,859 (com.serotonin.mango.MangoContextListener.contextD
      estroyed:101) - Mango context terminating
      INFO 2010-02-10 09:41:21,859 (com.serotonin.mango.db.BasePooledAccess.terminate
      :123) - Stopping database
      INFO 2010-02-10 09:41:21,859 (com.serotonin.mango.MangoContextListener.contextD
      estroyed:121) - Mango context terminated
      INFO 2010-02-10 09:41:21,859 (org.springframework.context.support.AbstractAppli
      cationContext.doClose:816) - Closing org.springframework.web.context.support.Xml
      WebApplicationContext@19e15c: display name [Root WebApplicationContext]; startup
      date [Wed Feb 10 09:41:20 CST 2010]; root of context hierarchy
      INFO 2010-02-10 09:41:21,859 (org.springframework.beans.factory.support.Default
      SingletonBeanRegistry.destroySingletons:392) - Destroying singletons in org.spri
      ngframework.beans.factory.support.DefaultListableBeanFactory@193c0cf: defining b
      eans [CompoundEventsDwr,CustomViewDwr,DataPointDetailsDwr,DataPointEditDwr,DataS
      ourceEditDwr,DataSourceListDwr,EmportDwr,EventHandlersDwr,EventsDwr,MailingLists
      Dwr,MiscDwr,PointHierarchyDwr,PointLinksDwr,PublisherEditDwr,PublisherListDwr,Re
      portsDwr,ScheduledEventsDwr,SystemSettingsDwr,UsersDwr,ViewDwr,WatchListDwr,loca
      leResolver,messageSource]; root of factory hierarchy
      2010-2-10 9:41:22 org.apache.coyote.http11.Http11Protocol start
      ??: Starting Coyote HTTP/1.1 on http-8080
      2010-2-10 9:41:22 org.apache.jk.common.ChannelSocket init
      ??: JK: ajp13 listening on /0.0.0.0:8009
      2010-2-10 9:41:22 org.apache.jk.server.JkMain start
      ??: Jk running ID=0 time=0/31 config=null
      2010-2-10 9:41:22 org.apache.catalina.startup.Catalina start
      ??: Server startup in 2142 ms

      posted in User help
      Y
      ywwtx
    • RE: Derby to mysql

      INFO 2010-02-10 09:41:21,203 (org.springframework.web.context.ContextLoader.ini
      tWebApplicationContext:209) - Root WebApplicationContext: initialization complet
      ed in 344 ms
      INFO 2010-02-10 09:41:21,203 (com.serotonin.mango.MangoContextListener.contextI
      nitialized:73) - Mango context starting
      INFO 2010-02-10 09:41:21,453 (com.serotonin.mango.db.BasePooledAccess.initializ
      eImpl:54) - Initializing pooled connection manager
      WARN 2010-02-10 09:41:21,796 (com.serotonin.mango.db.upgrade.DBUpgrade.checkUpg
      rade:81) - Upgrading instance from 0.7.0 to 0.8.0
      INFO 2010-02-10 09:41:21,812 (org.springframework.beans.factory.xml.XmlBeanDefi
      nitionReader.loadBeanDefinitions:323) - Loading XML bean definitions from class
      path resource [org/springframework/jdbc/support/sql-error-codes.xml]
      INFO 2010-02-10 09:41:21,859 (org.springframework.jdbc.support.SQLErrorCodesFac
      tory.<init>:128) - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL
      , MySQL, Oracle, PostgreSQL, Sybase]
      2010-2-10 9:41:21 org.apache.catalina.core.StandardContext start
      ??: Error listenerStart
      2010-2-10 9:41:21 org.apache.catalina.core.StandardContext start
      ??: Context [/mango-1.8.0] startup failed due to previous errors
      INFO 2010-02-10 09:41:21,859 (com.serotonin.mango.MangoContextListener.contextD
      estroyed:101) - Mango context terminating
      INFO 2010-02-10 09:41:21,859 (com.serotonin.mango.db.BasePooledAccess.terminate
      :123) - Stopping database
      INFO 2010-02-10 09:41:21,859 (com.serotonin.mango.MangoContextListener.contextD
      estroyed:121) - Mango context terminated
      INFO 2010-02-10 09:41:21,859 (org.springframework.context.support.AbstractAppli
      cationContext.doClose:816) - Closing org.springframework.web.context.support.Xml
      WebApplicationContext@19e15c: display name [Root WebApplicationContext]; startup
      date [Wed Feb 10 09:41:20 CST 2010]; root of context hierarchy
      INFO 2010-02-10 09:41:21,859 (org.springframework.beans.factory.support.Default
      SingletonBeanRegistry.destroySingletons:392) - Destroying singletons in org.spri
      ngframework.beans.factory.support.DefaultListableBeanFactory@193c0cf: defining b
      eans [CompoundEventsDwr,CustomViewDwr,DataPointDetailsDwr,DataPointEditDwr,DataS
      ourceEditDwr,DataSourceListDwr,EmportDwr,EventHandlersDwr,EventsDwr,MailingLists
      Dwr,MiscDwr,PointHierarchyDwr,PointLinksDwr,PublisherEditDwr,PublisherListDwr,Re
      portsDwr,ScheduledEventsDwr,SystemSettingsDwr,UsersDwr,ViewDwr,WatchListDwr,loca
      leResolver,messageSource]; root of factory hierarchy
      2010-2-10 9:41:22 org.apache.coyote.http11.Http11Protocol start
      ??: Starting Coyote HTTP/1.1 on http-8080
      2010-2-10 9:41:22 org.apache.jk.common.ChannelSocket init
      ??: JK: ajp13 listening on /0.0.0.0:8009
      2010-2-10 9:41:22 org.apache.jk.server.JkMain start
      ??: Jk running ID=0 time=0/31 config=null
      2010-2-10 9:41:22 org.apache.catalina.startup.Catalina start
      ??: Server startup in 2142 ms

      posted in User help
      Y
      ywwtx