Hi ,In the develop Environment,the tersus studio conncet to the external database,my database use mysql ,mysql version is 5.6.10,
1、In the Navigator view, create a file called "Configuration.xml" with the following content:
<!--
Configuration file template for Tersus embedded server.
See the deployment documentation at http://www.tersus.com/#Id=242 for more details.
-->
<Application name="Shopping" rootSystem="Shopping/Shopping" authenticationMethod="None">
<Parameter
name="init_db"
value="false"/>
name="check_db"
name="use_sql_quoted_identifiers"
<Resource name="jdbc/Main"
driverClassName="com.mysql.jdbc.Driver"
maxActive="20" maxIdle="10" maxWait="10000"
type="javax.sql.DataSource"
username="root"
password="mysql"
url="jdbc:mysql://localhost:3306/Shopping"
validationQuery="select now()"/>
</Application>
2、copy the database driver of mysql mysql-connector-java-3.1.14-bin.jar to \tersus-server-2.1.31.4\WEB-INF\db-lib
3、then click the studio launch the application button,the application conn't stat and load,to see the terser.log ,it tips :
INFO 2015-11-28 16:45:22,310 [Worker-10] Initializing WebContext #1
INFO 2015-11-28 16:45:22,311 [Worker-10] WebContext #1 initialized in 1 ms.
ERROR 2015-11-28 16:45:22,316 [Worker-10] Request ID:20151128-16:45:22:310 [Worker-10]
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:54)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at tersus.runtime.SQLUtils.connectToDataSource(SQLUtils.java:147)
... 18 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1714)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1559)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
... 21 more
ERROR 2015-11-28 16:45:22,317 [Worker-10] Startup failed
ERROR 2015-11-28 16:45:22,318 [Worker-10] Startup failed
INFO 2015-11-28 16:45:22,320 [Worker-10] Initializing WebContext #2
INFO 2015-11-28 16:45:22,320 [Worker-10] WebContext #2 initialized in 0 ms.
ERROR 2015-11-28 16:45:22,323 [Worker-10] 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