Ok, I'm a little bit further, I added in the configuration file the following (in bold):
<Resource name="jdbc/Main" driverClassName="com.mysql.jdbc.Driver" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="10" maxWait="10000" type="javax.sql.DataSource" username="root" password="xxx" url="jdbc:mysql://localhost/Administratie" validationQuery="select now()"/>
No I get the following error:
java.lang.RuntimeException: Failed to create connection to DataSource jdbc/Main at tersus.runtime.SQLUtils.connectToDataSource(SQLUtils.java:128) at tersus.runtime.SQLUtils.tableExists(SQLUtils.java:33) at tersus.runtime.RuntimeContext.cacheUpdateTableExits(RuntimeContext.java:323) at tersus.runtime.RuntimeContext.clearPermissionCacheIfNeeded(RuntimeContext.java:306) at tersus.runtime.ContextPool.getContext(ContextPool.java:368) at tersus.webapp.ContextPool.getContext(ContextPool.java:415) at tersus.runtime.ContextPool.shutdown(ContextPool.java:622) at tersus.webapp.ContextPool.contextDestroyed(ContextPool.java:391) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3805) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4357) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4246) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1176) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:542) at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) 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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) 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:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870) 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:685) at java.lang.Thread.run(libgcj.so.8)Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Error during query: Unexpected Exception: java.io.CharConversionException message given: null
Any ideas?
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