1
0
-1

I'm trying to populate a selectBox with a table in the default database used by joget.

I tried to connect the other way, but the driver isn't found.

***HERE THE LOG OF THE STARTING SERVER

******************************************************************************************** 

13-Mar-2017 16:20:13.223 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Server version: Apache Tomcat/8.0.20
13-Mar-2017 16:20:13.223 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Server built: Feb 15 2015 18:10:42 UTC
13-Mar-2017 16:20:13.223 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Server number: 8.0.20.0
13-Mar-2017 16:20:13.223 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log OS Name: Windows 7
13-Mar-2017 16:20:13.223 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log OS Version: 6.1
13-Mar-2017 16:20:13.238 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Architecture: x86
13-Mar-2017 16:20:13.238 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Java Home: C:\Joget-v5-Enterprise\jre1.7.0_76
13-Mar-2017 16:20:13.238 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log JVM Version: 1.7.0_76-b13
13-Mar-2017 16:20:13.238 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log JVM Vendor: Oracle Corporation
13-Mar-2017 16:20:13.238 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log CATALINA_BASE: C:\Joget-v5-Enterprise\apache-tomcat-8.0.20
13-Mar-2017 16:20:13.238 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log CATALINA_HOME: C:\Joget-v5-Enterprise\apache-tomcat-8.0.20
13-Mar-2017 16:20:13.316 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -XX:MaxPermSize=128m
13-Mar-2017 16:20:13.316 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -Xmx512M
13-Mar-2017 16:20:13.332 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -Dwflow.home=./wflow/
13-Mar-2017 16:20:13.347 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -javaagent:./wflow/aspectjweaver-1.8.5.jar
13-Mar-2017 16:20:13.363 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -Djava.util.logging.config.file=.\apache-tomca
t-8.0.20\conf\logging.properties
13-Mar-2017 16:20:13.394 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.Cl
assLoaderLogManager
13-Mar-2017 16:20:13.425 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -Djava.endorsed.dirs=.\apache-tomcat-8.0.20\en
dorsed
13-Mar-2017 16:20:13.457 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -Dcatalina.base=.\apache-tomcat-8.0.20
13-Mar-2017 16:20:13.472 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -Dcatalina.home=.\apache-tomcat-8.0.20
13-Mar-2017 16:20:13.488 INFO [main] org.apache.catalina.startup.VersionLoggerLi
stener.log Command line argument: -Djava.io.tmpdir=.\apache-tomcat-8.0.20\temp
13-Mar-2017 16:20:13.503 INFO [main] org.apache.catalina.core.AprLifecycleListen
er.lifecycleEvent The APR based Apache Tomcat Native library which allows optima
l performance in production environments was not found on the java.library.path:
C:\Joget-v5-Enterprise\jre1.7.0_76\bin;C:\Windows\Sun\Java\bin;C:\Windows\syste
m32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Window
s\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\110\Too
ls\Binn\;c:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;c:\Program
Files\Microsoft SQL Server\110\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Se
rver\110\Tools\Binn\ManagementStudio\;c:\Program Files (x86)\Microsoft SQL Serve
r\110\DTS\Binn\;.
13-Mar-2017 16:20:14.783 INFO [main] org.apache.coyote.AbstractProtocol.init Ini
tializing ProtocolHandler ["http-nio-8080"]
13-Mar-2017 16:20:14.985 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.
getSharedSelector Using a shared selector for servlet write/read
13-Mar-2017 16:20:15.017 INFO [main] org.apache.coyote.AbstractProtocol.init Ini
tializing ProtocolHandler ["ajp-nio-8009"]
13-Mar-2017 16:20:15.032 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.
getSharedSelector Using a shared selector for servlet write/read
13-Mar-2017 16:20:15.048 INFO [main] org.apache.catalina.startup.Catalina.load I
nitialization processed in 4288 ms
13-Mar-2017 16:20:15.453 INFO [main] org.apache.catalina.core.StandardService.st
artInternal DÚmarrage du service Catalina
13-Mar-2017 16:20:15.469 INFO [main] org.apache.catalina.core.StandardEngine.sta
rtInternal Starting Servlet Engine: Apache Tomcat/8.0.20
13-Mar-2017 16:20:15.843 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployWAR DÚploiement de l'archive C:\Joget-v5-Enterprise\apache-to
mcat-8.0.20\webapps\jw.war de l'application web
[WebappClassLoader@c7e8b9] warning javax.* types are not being woven because the
weaver option '-Xset:weaveJavaxPackages=true' has not been specified
INFO 13 mars 2017 16:21:09 org.joget.commons.util.SetupManager - Using base di
rectory: ./wflow/
INFO 13 mars 2017 16:21:13 org.joget.commons.util.DynamicDataSource - datasour
ceName=workflow, url=jdbc:sqlserver://localhost\SQLEXPRESS:1433;SelectMethod=cur
sor;DatabaseName=jwdb, user=jwdb
INFO 13 mars 2017 16:21:22 org.joget.commons.util.SetupManager - Initializing
setup cache
INFO 13 mars 2017 16:21:23 org.joget.plugin.base.PluginManager - PluginManager
initialized
INFO 13 mars 2017 16:21:34 org.joget.plugin.base.PluginManager - Bundle org.jo
get.jdbc_datalist_action started
INFO 13 mars 2017 16:21:34 org.joget.plugin.base.PluginManager - Bundle org.jo
get.tutorial.jdbc_load_binder started
INFO 13 mars 2017 16:21:34 org.joget.plugin.base.PluginManager - Bundle org.jo
get.tutorial.jdbc_options_binder started
INFO 13 mars 2017 16:21:34 org.joget.plugin.base.PluginManager - Bundle org.jo
get.tutorial.jdbc_store_binder started
INFO 13 mars 2017 16:21:34 org.joget.plugin.base.PluginManager - Bundle org.jo
get.sample.theme-pack started
INFO 13 mars 2017 16:21:36 org.joget.workflow.model.service.WorkflowManagerImpl
- Datasource bound to jwdb
SharkEngineManager -> Shark engine is being initialized ...
Unknown JDBC Driver Vendor for : null using default (Standard) instead
Shark -> shark engine initialization is finished, it lasted 6 [s]
Shark -> SharkExampleJSP ready and waiting ...
INFO 13 mars 2017 16:21:54 org.displaytag.filter.ResponseOverrideFilter - Filt
er initialized. Response buffering is enabled
13-Mar-2017 16:21:54.982 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployWAR Deployment of web application archive C:\Joget-v5-Enterpr
ise\apache-tomcat-8.0.20\webapps\jw.war has finished in 99á139 ms
13-Mar-2017 16:21:55.044 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployWAR DÚploiement de l'archive C:\Joget-v5-Enterprise\apache-to
mcat-8.0.20\webapps\jwdesigner.war de l'application web
13-Mar-2017 16:21:59.069 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployWAR Deployment of web application archive C:\Joget-v5-Enterpr
ise\apache-tomcat-8.0.20\webapps\jwdesigner.war has finished in 4á025 ms
13-Mar-2017 16:21:59.100 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory DÚploiement du rÚpertoire C:\Joget-v5-Enterprise\ap
ache-tomcat-8.0.20\webapps\docs de l'application web
13-Mar-2017 16:21:59.600 INFO [localhost-startStop-1] org.apache.jasper.servlet.
TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs.
Enable debug logging for this logger for a complete list of JARs that were scan
ned but no TLDs were found in them. Skipping unneeded JARs during scanning can i
mprove startup time and JSP compilation time.
13-Mar-2017 16:21:59.662 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory Deployment of web application directory C:\Joget-v5
-Enterprise\apache-tomcat-8.0.20\webapps\docs has finished in 562 ms
13-Mar-2017 16:21:59.693 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory DÚploiement du rÚpertoire C:\Joget-v5-Enterprise\ap
ache-tomcat-8.0.20\webapps\examples de l'application web
13-Mar-2017 16:22:02.345 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory Deployment of web application directory C:\Joget-v5
-Enterprise\apache-tomcat-8.0.20\webapps\examples has finished in 2á652 ms
13-Mar-2017 16:22:02.376 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory DÚploiement du rÚpertoire C:\Joget-v5-Enterprise\ap
ache-tomcat-8.0.20\webapps\host-manager de l'application web
13-Mar-2017 16:22:02.844 INFO [localhost-startStop-1] org.apache.jasper.servlet.
TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs.
Enable debug logging for this logger for a complete list of JARs that were scan
ned but no TLDs were found in them. Skipping unneeded JARs during scanning can i
mprove startup time and JSP compilation time.
13-Mar-2017 16:22:02.907 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory Deployment of web application directory C:\Joget-v5
-Enterprise\apache-tomcat-8.0.20\webapps\host-manager has finished in 531 ms
13-Mar-2017 16:22:02.938 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory DÚploiement du rÚpertoire C:\Joget-v5-Enterprise\ap
ache-tomcat-8.0.20\webapps\manager de l'application web
13-Mar-2017 16:22:03.593 INFO [localhost-startStop-1] org.apache.jasper.servlet.
TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs.
Enable debug logging for this logger for a complete list of JARs that were scan
ned but no TLDs were found in them. Skipping unneeded JARs during scanning can i
mprove startup time and JSP compilation time.
13-Mar-2017 16:22:03.640 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory Deployment of web application directory C:\Joget-v5
-Enterprise\apache-tomcat-8.0.20\webapps\manager has finished in 702 ms
13-Mar-2017 16:22:03.671 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory DÚploiement du rÚpertoire C:\Joget-v5-Enterprise\ap
ache-tomcat-8.0.20\webapps\ROOT de l'application web
13-Mar-2017 16:22:04.139 INFO [localhost-startStop-1] org.apache.jasper.servlet.
TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs.
Enable debug logging for this logger for a complete list of JARs that were scan
ned but no TLDs were found in them. Skipping unneeded JARs during scanning can i
mprove startup time and JSP compilation time.
13-Mar-2017 16:22:04.186 INFO [localhost-startStop-1] org.apache.catalina.startu
p.HostConfig.deployDirectory Deployment of web application directory C:\Joget-v5
-Enterprise\apache-tomcat-8.0.20\webapps\ROOT has finished in 515 ms
13-Mar-2017 16:22:04.217 INFO [main] org.apache.coyote.AbstractProtocol.start St
arting ProtocolHandler ["http-nio-8080"]
13-Mar-2017 16:22:04.264 INFO [main] org.apache.coyote.AbstractProtocol.start St
arting ProtocolHandler ["ajp-nio-8009"]
13-Mar-2017 16:22:04.280 INFO [main] org.apache.catalina.startup.Catalina.start
Server startup in 109214 ms

******************************************************************************************** 

***END*** 

 

Thank you for your help,

Jonatan Nadeau

 

I tried two weeks ago to connect with this jdbc driver, and joget  was able to find it. I really don't know how I can resolve this problem.

 

Here's a proof

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, since you are trying to use the Microsoft SQL Server JDBC driver, you should try to verify that the SQL Server JDBC driver is in the classpath e.g. WEB-INF/lib/ or tomcat/lib

      1. Jonatan nadeau

        I am not sure where I am suppose to look for the classpath? Where is it situated? Thank you very much

      2. Jonatan nadeau

        I have download this: https://www.microsoft.com/en-us/download/confirmation.aspx?id=11774 Then I extract the thing and after I put the jre8\sqljdbc42.executableJarFile In the tomcat_appache/lib. It still doesn't work. I put a picture what it wrote when it come to the jdbc driver. Thank you very much.

      CommentAdd your comment...