We purchased Tersus。 mySql connection to tersus
I go to the "root" of the application en create a Configuration.xml whith the following:
<Application name="ceshi" rootSystem="ceshi/ceshi" authenticationMethod="none">
<DataSource name="jdbc/Main"
driverClassName="com.mysql.jdbc.Driver"
username="root"
password="123"
url="jdbc:mysql://keweixing-PC/shiyan?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull"
validationQuery="select now()" />
</Application>
but Error after running:
INFO 2015-07-12 15:14:27,320 [Worker-2] Initializing WebContext #1
INFO 2015-07-12 15:14:27,320 [Worker-2] WebContext #1 initialized in 0 ms.
ERROR 2015-07-12 15:14:27,342 [Worker-2] Request ID:20150712-15:14:27:319 [Worker-2]
java.lang.RuntimeException: Failed to create connection to DataSource jdbc/Main
at tersus.runtime.SQLUtils.connectToDataSource(SQLUtils.java:169)
at tersus.runtime.SQLUtils.tableExists(SQLUtils.java:55)
at tersus.runtime.RuntimeContext.cacheUpdateTableExits(RuntimeContext.java:472)
at tersus.runtime.RuntimeContext.permissionCacheExists(RuntimeContext.java:462)
at tersus.runtime.RuntimeContext.clearPermissionCacheIfNeeded(RuntimeContext.java:449)
at tersus.runtime.ContextPool.getContext(ContextPool.java:505)
at tersus.webapp.ContextPool.getContext(ContextPool.java:738)
at tersus.runtime.ContextPool.startUp(ContextPool.java:276)
at tersus.webapp.ContextPool.initAndStartup(ContextPool.java:233)
at tersus.webapp.ContextPool.contextInitialized(ContextPool.java:221)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at tersus.appserver.ApplicationServer.start(ApplicationServer.java:466)
at tersus.appserver.ui.LaunchApplicationActionDelegate$1.run(LaunchApplicationActionDelegate.java:107)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (null, message from server: "Host 'keweixing-PC' is not allowed to connect to this MySQL server")
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at tersus.runtime.SQLUtils.connectToDataSource(SQLUtils.java:147)
... 18 more
Caused by: java.sql.SQLException: null, message from server: "Host 'keweixing-PC' is not allowed to connect to this MySQL server"
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1096)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 21 more
ERROR 2015-07-12 15:14:27,343 [Worker-2] Startup failed
INFO 2015-07-12 15:14:27,346 [Worker-2] Initializing WebContext #2
INFO 2015-07-12 15:14:27,346 [Worker-2] WebContext #2 initialized in 0 ms.
ERROR 2015-07-12 15:14:27,354 [Worker-2] Shutdown failed
at tersus.runtime.ContextPool.shutdown(ContextPool.java:885)
at tersus.webapp.ContextPool.contextDestroyed(ContextPool.java:711)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4980)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5626)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign