Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
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
I am not sure where I am suppose to look for the classpath? Where is it situated? Thank you very much
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.
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