The problem is not the jdbc-driver for Tersus, but the combination of several mysql jdbc-drivers for the different tomcat application. As in Tersus the other application hasn't also the feature for placing the driver in their "container"/runtime-environment.
For Tersus, as mentioned in http://www.tersus.com/#Id=5580 the newer drivers give some problems. because I didn't give an example, here a short example:
with jdbc-driver mysql-connector-java-5.1.17-bin.jar gives as error:
Missing column in database query resultDetails:Missing Columns: langdescQuery result columns: lang, description at tersus.plugins.database.QueryPlugin.getElementPositions(QueryPlugin.java:254) at tersus.plugins.database.QueryPlugin.getResults(QueryPlugin.java:104) at tersus.plugins.database.QueryPlugin.outputResults(QueryPlugin.java:128) at tersus.plugins.database.DatabaseQuery.start(DatabaseQuery.java:112) at tersus.runtime.FlowHandler.doStart(FlowHandler.java:118) at tersus.runtime.Plugin.doStart(Plugin.java:32) at tersus.runtime.SubFlowHandler.invoke(SubFlowHandler.java:85) at tersus.runtime.CompositeFlowHandler.run(CompositeFlowHandler.java:152) at tersus.runtime.CompositeFlowHandler.start(CompositeFlowHandler.java:85) at tersus.runtime.FlowHandler.doStart(FlowHandler.java:118) at tersus.runtime.CompositeFlowHandler.doStart(CompositeFlowHandler.java:295) at tersus.runtime.RuntimeContext.runProcess(RuntimeContext.java:1221) at tersus.webapp.Engine.callService(Engine.java:1286) at tersus.webapp.Engine.handleJavascriptRequest(Engine.java:1135) at tersus.webapp.Engine.handleRequest(Engine.java:201) at tersus.webapp.Engine.doPost(Engine.java:162) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at tersus.webapp.Engine.service(Engine.java:1504) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at tersus.webapp.ServiceFilter.doFilter(ServiceFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source)ERROR 2012-10-23 12:04:13,398 [http-8080-Processor21] Error while executing process (type=/Service)Error Location:Variable Pane/viewbrief/Letters Table Display and Management/viewbrief/Table Row/briefid/<On Click>/Formulier/Pane/BriefPane/Init/getLetter/fndLanguageComp/Database Query
But it should be nice, if the driver could be installed under Tersus-runtime ;)
Jan Pieter
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