初始化数据报错sql语句问题

一月 26, 2018 8:54:47 上午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:nutzbook' did not find a matching property.
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/8.0.36
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Jun 9 2016 13:55:50 UTC
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         8.0.36.0
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Windows 7
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            6.1
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          amd64
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             C:\Program Files\Java\jre1.8.0_151
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.8.0_151-b12
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         D:\soft
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=D:\soft
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dwtp.deploy=D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\wtpwebapps
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=D:\soft\endorsed
一月 26, 2018 8:54:47 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dfile.encoding=UTF-8
一月 26, 2018 8:54:47 上午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_151\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre1.8.0_151/bin/server;C:/Program Files/Java/jre1.8.0_151/bin;C:/Program Files/Java/jre1.8.0_151/lib/amd64;C:\ProgramData\Oracle\Java\javapath;E:\orcl\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\java\jdk1.8.0_151\bin;C:\java\jdk1.8.0_151\jre\bin;C:\Program Files\TortoiseSVN\bin;D:\soft\apache-maven-3.5.2-bin\apache-maven-3.5.2\bin;C:\Users\Administrator\Downloads\mysql-5.7.20-winx64\mysql-5.7.20-winx64\bin;D:\software\tortoiseGit\bin;C:\Users\Administrator\Desktop;;.
一月 26, 2018 8:54:48 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-nio-8080"]
一月 26, 2018 8:54:48 上午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
信息: Using a shared selector for servlet write/read
一月 26, 2018 8:54:48 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-nio-8009"]
一月 26, 2018 8:54:48 上午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
信息: Using a shared selector for servlet write/read
一月 26, 2018 8:54:48 上午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 768 ms
一月 26, 2018 8:54:48 上午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
一月 26, 2018 8:54:48 上午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/8.0.36
一月 26, 2018 8:54:51 上午 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 scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
一月 26, 2018 8:54:53 上午 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 scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
一月 26, 2018 8:54:53 上午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Shiro environment
2018-01-26 08:54:53,686 org.apache.shiro.web.env.EnvironmentLoader.initEnvironment(EnvironmentLoader.java:128) INFO  - Starting Shiro environment initialization.
2018-01-26 08:54:53,696 org.apache.shiro.web.env.IniWebEnvironment.init(IniWebEnvironment.java:76) DEBUG - Checking any specified config locations.
2018-01-26 08:54:53,696 org.apache.shiro.web.env.IniWebEnvironment.init(IniWebEnvironment.java:81) DEBUG - No INI instance or config locations specified.  Trying default config locations.
2018-01-26 08:54:53,700 org.apache.shiro.io.ResourceUtils.loadFromClassPath(ResourceUtils.java:159) DEBUG - Opening resource from class path [shiro.ini]
2018-01-26 08:54:53,705 org.apache.shiro.config.Ini.load(Ini.java:351) DEBUG - Parsing [main]
2018-01-26 08:54:53,706 org.apache.shiro.config.Ini.load(Ini.java:351) DEBUG - Parsing [urls]
2018-01-26 08:54:53,709 org.apache.shiro.web.env.IniWebEnvironment.getDefaultIni(IniWebEnvironment.java:136) DEBUG - Discovered non-empty INI configuration at location 'classpath:shiro.ini'.  Using for configuration.
2018-01-26 08:54:53,712 org.apache.shiro.config.IniFactorySupport.createInstance(IniFactorySupport.java:122) DEBUG - Creating instance from Ini [sections=urls]
2018-01-26 08:54:53,938 org.apache.shiro.config.IniFactorySupport.createInstance(IniFactorySupport.java:122) DEBUG - Creating instance from Ini [sections=urls]
2018-01-26 08:54:53,941 org.apache.shiro.web.filter.mgt.DefaultFilterChainManager.createChain(DefaultFilterChainManager.java:127) DEBUG - Creating chain [/*] from String definition [anon]
2018-01-26 08:54:53,941 org.apache.shiro.web.filter.mgt.DefaultFilterChainManager.applyChainConfig(DefaultFilterChainManager.java:278) DEBUG - Attempting to apply path [/*] to filter [anon] with config [null]
2018-01-26 08:54:53,942 org.apache.shiro.web.env.EnvironmentLoader.initEnvironment(EnvironmentLoader.java:136) DEBUG - Published WebEnvironment as ServletContext attribute with name [org.apache.shiro.web.env.EnvironmentLoader.ENVIRONMENT_ATTRIBUTE_KEY]
2018-01-26 08:54:53,942 org.apache.shiro.web.env.EnvironmentLoader.initEnvironment(EnvironmentLoader.java:141) INFO  - Shiro environment initialized in 254 ms.
2018-01-26 08:54:53,969 org.nutz.mvc.NutFilter._init(NutFilter.java:85) INFO  - NutFilter[nutz] starting ...
2018-01-26 08:54:53,998 org.nutz.resource.Scans.printLocations(Scans.java:521) DEBUG - Locations count=10 time use 21ms
2018-01-26 08:54:54,010 org.nutz.resource.Scans.printLocations(Scans.java:521) DEBUG - Locations count=30 time use 11ms
2018-01-26 08:54:54,089 org.nutz.castor.Castors.reload(Castors.java:115) DEBUG - Using 95 castor for Castors
2018-01-26 08:54:54,117 org.nutz.mvc.config.AbstractNutConfig.createLoading(AbstractNutConfig.java:59) DEBUG - Loading by class org.nutz.mvc.impl.NutLoading
2018-01-26 08:54:54,120 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:55) INFO  - Nutz Version : 1.r.62 
2018-01-26 08:54:54,120 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:56) INFO  - Nutz.Mvc[nutz] is initializing ...
2018-01-26 08:54:54,121 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:60) DEBUG - Web Container Information:
2018-01-26 08:54:54,121 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:61) DEBUG -  - Default Charset : UTF-8
2018-01-26 08:54:54,122 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:62) DEBUG -  - Current . path  : C:\Users\Administrator\Desktop\.
2018-01-26 08:54:54,144 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:63) DEBUG -  - Java Version    : 1.8.0_151
2018-01-26 08:54:54,145 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:64) DEBUG -  - File separator  : \
2018-01-26 08:54:54,145 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:65) DEBUG -  - Timezone        : Asia/Shanghai
2018-01-26 08:54:54,153 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:66) DEBUG -  - OS              : Windows 7 amd64
2018-01-26 08:54:54,153 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:67) DEBUG -  - ServerInfo      : Apache Tomcat/8.0.36
2018-01-26 08:54:54,154 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:68) DEBUG -  - Servlet API     : 3.1
2018-01-26 08:54:54,154 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:73) DEBUG -  - ContextPath     : /nutzbook
2018-01-26 08:54:54,154 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:74) DEBUG -  - context.tempdir : D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\work\Catalina\localhost\nutzbook
2018-01-26 08:54:54,154 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:75) DEBUG -  - MainModule      : net.wendal.nutzbook.MainModule
2018-01-26 08:54:54,156 org.nutz.mvc.impl.NutLoading.createContext(NutLoading.java:235) DEBUG - >> app.root = D:/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp2/wtpwebapps/nutzbook
2018-01-26 08:54:54,163 org.nutz.mvc.impl.NutLoading.createIoc(NutLoading.java:376) DEBUG - @IocBy(type=org.nutz.mvc.ioc.provider.ComboIocProvider, args=["*js", "ioc/", "*anno", "net.wendal.nutzbook", "*tx"],init=[])
2018-01-26 08:54:54,234 org.nutz.resource.Scans.scan(Scans.java:274) DEBUG - Found 1 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
2018-01-26 08:54:54,235 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:49) DEBUG - loading [dao.js]
2018-01-26 08:54:54,240 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:57) DEBUG - Loaded 3 bean define from path=[ioc/] --> [conf, dao, dataSource]
2018-01-26 08:54:54,369 org.nutz.resource.Scans.scan(Scans.java:274) DEBUG - Found 9 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
2018-01-26 08:54:54,384 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:76) DEBUG - Found @IocBean : class net.wendal.nutzbook.module.UserModule
2018-01-26 08:54:54,393 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:76) DEBUG - Found @IocBean : class net.wendal.nutzbook.quartz.NutQuartzJobFactory
2018-01-26 08:54:54,416 org.nutz.ioc.loader.annotation.AnnotationIocLoader.<init>(AnnotationIocLoader.java:52) INFO  - Found 2 classes in 1 base-packages!
beans = ["nutQuartzJobFactory", "userModule"]
2018-01-26 08:54:54,432 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:40) DEBUG - Loaded 5 bean define from reader --
[txREPEATABLE_READ, txSERIALIZABLE, txNONE, txREAD_UNCOMMITTED, txREAD_COMMITTED]
2018-01-26 08:54:54,435 org.nutz.ioc.impl.NutIoc.<init>(NutIoc.java:98) INFO  - NutIoc init begin ...
2018-01-26 08:54:54,437 org.nutz.ioc.impl.NutIoc.<init>(NutIoc.java:115) INFO  - ... NutIoc init complete
2018-01-26 08:54:54,439 org.nutz.mvc.impl.NutLoading.evalUrlMapping(NutLoading.java:159) INFO  - Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
2018-01-26 08:54:54,442 org.nutz.mvc.impl.NutLoading.createViewMakers(NutLoading.java:366) DEBUG - @Views(DefaultViewMaker.class)
2018-01-26 08:54:54,459 org.nutz.resource.Scans.scan(Scans.java:274) DEBUG - Found 1 resource by src( mvc/nutzbook-mvc-chain.js ) , regex( ^(.+[.])(js|json)$ )
2018-01-26 08:54:54,471 org.nutz.mvc.impl.chainconfig.JsonActionChainMakerConfiguretion.<init>(JsonActionChainMakerConfiguretion.java:37) DEBUG - ActionChain Config:
{
   "default": {
      "ps": ["net.wendal.nutzbook.mvc.LogTimeProcessor", "org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor", "org.nutz.mvc.impl.processor.EncodingProcessor", "org.nutz.mvc.impl.processor.ModuleProcessor", "!org.nutz.integration.shiro.NutShiroProcessor", "org.nutz.mvc.impl.processor.ActionFiltersProcessor", "org.nutz.mvc.impl.processor.AdaptorProcessor", "org.nutz.mvc.impl.processor.MethodInvokeProcessor", "org.nutz.mvc.impl.processor.ViewProcessor"],
      "error": "org.nutz.mvc.impl.processor.FailProcessor"
   }
}
2018-01-26 08:54:54,522 org.nutz.mvc.impl.NutLoading.createChainMaker(NutLoading.java:263) DEBUG - @ChainBy(org.nutz.mvc.impl.NutActionChainMaker)
2018-01-26 08:54:54,529 org.nutz.mvc.impl.Loadings.scanModules(Loadings.java:154) DEBUG - module class location 'file:/D:/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp2/wtpwebapps/nutzbook/WEB-INF/classes/'
2018-01-26 08:54:54,529 org.nutz.mvc.impl.Loadings.scanModuleInPackage(Loadings.java:184) DEBUG -  > scan 'net.wendal.nutzbook'
2018-01-26 08:54:54,535 org.nutz.resource.Scans.scan(Scans.java:274) DEBUG - Found 9 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
2018-01-26 08:54:54,536 org.nutz.mvc.impl.Loadings.checkModule(Loadings.java:199) DEBUG -    >> add 'net.wendal.nutzbook.module.UserModule'
2018-01-26 08:54:54,614 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/'                    >> (UserModule.java:100).index           : void       | @Ok(jsp:jsp.user.list) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,805 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/add'                 >> (UserModule.java:55).add              : Object     | @Ok(json:{locked:'password|salt',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,806 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/count'               >> (UserModule.java:32).count            : int        | @Ok(json:{locked:'password|salt',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,809 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/update'              >> (UserModule.java:66).update           : Object     | @Ok(json:{locked:'password|salt',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,815 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/delete'              >> (UserModule.java:80).delete           : Object     | @Ok(json:{locked:'password|salt',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,894 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/query'               >> (UserModule.java:89).query            : Object     | @Ok(json:{locked:'password|salt',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,895 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/error'               >> (UserModule.java:137).error           : void       | @Ok(json:{locked:'password|salt',ignoreNull:true}) @Fail(jsp:jsp.500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,897 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/login'               >> (UserModule.java:38).login            : Object     | @Ok(json:{locked:'password|salt',ignoreNull:true}) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,898 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/user/logout'              >> (UserModule.java:50).logout           : void       | @Ok(>>:/ ) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
2018-01-26 08:54:54,898 org.nutz.mvc.impl.NutLoading.evalUrlMapping(NutLoading.java:217) INFO  - Found 9 module methods
2018-01-26 08:54:54,898 org.nutz.mvc.impl.NutLoading.evalLocalization(NutLoading.java:303) DEBUG - Localization: org.nutz.mvc.impl.NutMessageLoader('msg/')  dft<zh-CN>
2018-01-26 08:54:54,912 org.nutz.resource.Scans.scan(Scans.java:274) DEBUG - Found 1 resource by src( msg/ ) , regex( ^.+[.]properties$ )
2018-01-26 08:54:54,912 org.nutz.mvc.impl.NutMessageLoader.load(NutMessageLoader.java:27) DEBUG - Load Messages in 1 resource : [[File[D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\wtpwebapps\nutzbook\WEB-INF\classes\msg\zh-CN\user.properties]]]
2018-01-26 08:54:54,913 org.nutz.mvc.impl.NutMessageLoader.load(NutMessageLoader.java:95) DEBUG - Message Loaded, size = 2
2018-01-26 08:54:54,914 org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:271) INFO  - Setup application...
2018-01-26 08:54:54,921 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dao'<interface org.nutz.dao.Dao>
2018-01-26 08:54:54,927 org.nutz.ioc.aop.SimpleAopMaker.<init>(SimpleAopMaker.java:79) DEBUG - Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
2018-01-26 08:54:54,928 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=dao
2018-01-26 08:54:54,928 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dao
2018-01-26 08:54:54,931 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dao) in JsonLoader(paths=[ioc/])
2018-01-26 08:54:54,931 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'dao'<interface org.nutz.dao.Dao>
2018-01-26 08:54:54,984 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.dao.impl.NutDao without AOP
2018-01-26 08:54:54,985 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'dao' to [app] 
2018-01-26 08:54:54,986 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dataSource'<>
2018-01-26 08:54:54,987 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=dataSource
2018-01-26 08:54:54,987 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dataSource
2018-01-26 08:54:55,002 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
2018-01-26 08:54:55,002 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'dataSource'<>
2018-01-26 08:54:55,029 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class com.alibaba.druid.pool.DruidDataSource without AOP
2018-01-26 08:54:55,029 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'dataSource' to [app] 
2018-01-26 08:54:55,031 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'conf'<>
2018-01-26 08:54:55,032 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=conf
2018-01-26 08:54:55,032 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=conf
2018-01-26 08:54:55,051 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(conf) in JsonLoader(paths=[ioc/])
2018-01-26 08:54:55,051 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'conf'<>
2018-01-26 08:54:55,052 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.ioc.impl.PropertiesProxy without AOP
2018-01-26 08:54:55,052 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'conf' to [app] 
2018-01-26 08:54:55,127 org.nutz.resource.Scans.scan(Scans.java:274) DEBUG - Found 1 resource by src( custom/ ) , regex( ^.+[.]properties$ )
2018-01-26 08:54:55,127 org.nutz.ioc.impl.PropertiesProxy.setPaths(PropertiesProxy.java:113) DEBUG - load properties from File[D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\wtpwebapps\nutzbook\WEB-INF\classes\custom\db.properties]
2018-01-26 08:54:55,505 com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:715) INFO  - {dataSource-1} inited
2018-01-26 08:54:55,506 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dataSource'<>
2018-01-26 08:54:55,664 org.nutz.dao.jdbc.Jdbcs.<clinit>(Jdbcs.java:90) DEBUG - Jdbcs init complete
2018-01-26 08:54:55,664 org.nutz.dao.jdbc.Jdbcs.getExpert(Jdbcs.java:103) INFO  - Get Connection from DataSource for JdbcExpert, if you lock at here, check your database server and configure
2018-01-26 08:54:56,136 org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:188) DEBUG - select expert : org.nutz.dao.impl.jdbc.oracle.OracleJdbcExpert
2018-01-26 08:54:56,141 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:199) DEBUG - JDBC Driver --> 11.2.0.4.0
2018-01-26 08:54:56,142 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:200) DEBUG - JDBC Name   --> Oracle JDBC driver
2018-01-26 08:54:56,142 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:202) DEBUG - JDBC URL    --> jdbc:oracle:thin:@127.0.0.1:1521/NUTZBOOK
2018-01-26 08:54:56,144 org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:221) DEBUG - Database info --> ORACLE:[Oracle - Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options]
2018-01-26 08:54:56,149 org.nutz.resource.Scans.scan(Scans.java:274) DEBUG - Found 9 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
2018-01-26 08:54:56,240 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT COUNT(*) FROM t_user 
2018-01-26 08:54:56,248 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'scheduler'<interface org.quartz.Scheduler>
2018-01-26 08:54:56,248 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=scheduler
2018-01-26 08:54:56,249 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:125) ERROR - Error happend during start serivce!
org.nutz.ioc.IocException: IocBean[scheduler] For object [scheduler] - type:[interface org.quartz.Scheduler]
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:218)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:239)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:146)
	at net.wendal.nutzbook.MainSetup.init(MainSetup.java:32)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:274)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:121)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:91)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:69)
	at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4689)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5329)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.nutz.ioc.ObjectLoadException: Object 'scheduler' without define!
	at org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:166)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:180)
	... 20 more
2018-01-26 08:54:56,252 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:127) ERROR - try to depose ioc
2018-01-26 08:54:56,255 org.nutz.ioc.impl.NutIoc.depose(NutIoc.java:255) INFO  - org.nutz.ioc.impl.NutIoc@586637397 is closing. startup date [18-01-26 08:54:54.435]
2018-01-26 08:54:56,256 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'conf' ...
2018-01-26 08:54:56,256 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'dao' ...
2018-01-26 08:54:56,256 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:113) DEBUG - Depose object 'dataSource' ...
2018-01-26 08:54:56,262 com.alibaba.druid.pool.DruidDataSource.close(DruidDataSource.java:1444) INFO  - {dataSource-1} closed
2018-01-26 08:54:56,262 org.nutz.ioc.impl.NutIoc.depose(NutIoc.java:262) INFO  - org.nutz.ioc.impl.NutIoc@586637397 is deposed. startup date [18-01-26 08:54:54.435]
一月 26, 2018 8:54:56 上午 org.apache.catalina.core.StandardContext filterStart
严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.ioc.IocException: IocBean[scheduler] For object [scheduler] - type:[interface org.quartz.Scheduler]
	at org.nutz.mvc.LoadingException$FC$9a86caf9ff5d3b587784fcdf555a4a7d.invoke(LoadingException.java)
	at org.nutz.lang.born.AbstractConstructorBorning.call(AbstractConstructorBorning.java:25)
	at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:19)
	at org.nutz.lang.born.BornContext.doBorn(BornContext.java:60)
	at org.nutz.lang.Mirror.born(Mirror.java:990)
	at org.nutz.lang.Lang.wrapThrow(Lang.java:200)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:135)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:91)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:69)
	at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4689)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5329)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.nutz.ioc.IocException: IocBean[scheduler] For object [scheduler] - type:[interface org.quartz.Scheduler]
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:218)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:239)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:146)
	at net.wendal.nutzbook.MainSetup.init(MainSetup.java:32)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:274)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:121)
	... 15 more
Caused by: org.nutz.ioc.ObjectLoadException: Object 'scheduler' without define!
	at org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:166)
	at org.nutz.ioc.impl.NutIoc.get(NutIoc.java:180)
	... 20 more

一月 26, 2018 8:54:56 上午 org.apache.catalina.core.StandardContext startInternal
严重: One or more Filters failed to start. Full details will be found in the appropriate container log file
一月 26, 2018 8:54:56 上午 org.apache.catalina.core.StandardContext startInternal
严重: Context [/nutzbook] startup failed due to previous errors
一月 26, 2018 8:54:56 上午 org.apache.catalina.core.ApplicationContext log
信息: Cleaning up Shiro Environment
一月 26, 2018 8:54:56 上午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
警告: The web application [nutzbook] registered the JDBC driver [com.alibaba.druid.proxy.DruidDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
一月 26, 2018 8:54:56 上午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
警告: The web application [nutzbook] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
一月 26, 2018 8:54:56 上午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
警告: The web application [nutzbook] appears to have started a thread named [Druid-ConnectionPool-Create-261452782] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 sun.misc.Unsafe.park(Native Method)
 java.util.concurrent.locks.LockSupport.park(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown Source)
 com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1977)
一月 26, 2018 8:54:56 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-nio-8080"]
一月 26, 2018 8:54:56 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-nio-8009"]
一月 26, 2018 8:54:56 上午 org.apache.catalina.startup.Catalina start
信息: Server startup in 8088 ms

qq_796a181a 1楼•2289天前

@wendal

wendal

2楼•2289天前

是不是看错章节了，看上去你取的quartz的scheduler对象，那是定时任务才涉及到的

qq_796a181a 3楼•2289天前

没有，按着步骤来的，毕竟才第十步，代码都是复制粘贴过来的，改了dao.js，数据库能链接
@wendal

wendal

4楼•2289天前

贴MainSetup的代码及所在的出处

qq_796a181a 5楼•2289天前

删除表格跑第一遍是上面的代码，跑第二遍
18-01-26 09:23:07.511 DEBUG [localhost-startStop-1] INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES(?,?,?,?,?)
| 1 | 2 | 3 | 4 | 5 |
|-------|--------|------|---------------------|---------------------|
| admin | 123456 | NULL | 2018-01-26 09:23:07 | 2018-01-26 09:23:07 |
For example:> "INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES('admin','123456','NULL','2018-01-26 09:23:07','2018-01-26 09:23:07') "

这个就出来了但是错误仍然存在

qq_796a181a 6楼•2289天前

package net.wendal.nutzbook;

import java.util.Date;

import net.wendal.nutzbook.bean.User;

import org.nutz.dao.Dao;
import org.nutz.dao.util.Daos;
import org.nutz.ioc.Ioc;
import org.nutz.mvc.NutConfig;
import org.nutz.mvc.Setup;

public class MainSetup implements Setup {

// 注意是init方法,不是destroy方法
public void init(NutConfig nc) {
Ioc ioc = nc.getIoc();
Dao dao = ioc.get(Dao.class);
// 如果提示没有createTablesInPackage方法,请确认用了最新版的nutz,且老版本的nutz已经删除干净
Daos.createTablesInPackage(dao, "net.wendal.nutzbook", false);

    // 初始化默认根用户
    if (dao.count(User.class) == 0) {
        User user = new User();
        user.setName("admin");
        user.setPassword("123456");
        user.setCreateTime(new Date());
        user.setUpdateTime(new Date());
        dao.insert(user);
    }
}

public void destroy(NutConfig nc) {
     // webapp销毁之前执行的逻辑
     // 这个时候依然可以从nc取出ioc, 然后取出需要的ioc 对象进行操作
}

}
@wendal

qq_796a181a 7楼•2289天前

第二遍跑的结果

一月 26, 2018 9:26:08 上午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:demo' did not find a matching property.
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/8.0.36
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Jun 9 2016 13:55:50 UTC
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         8.0.36.0
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Windows 7
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            6.1
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          amd64
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             C:\Program Files\Java\jre1.8.0_151
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.8.0_151-b12
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         D:\soft
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=D:\soft
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dwtp.deploy=D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\wtpwebapps
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=D:\soft\endorsed
一月 26, 2018 9:26:08 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dfile.encoding=UTF-8
一月 26, 2018 9:26:08 上午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_151\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre1.8.0_151/bin/server;C:/Program Files/Java/jre1.8.0_151/bin;C:/Program Files/Java/jre1.8.0_151/lib/amd64;C:\ProgramData\Oracle\Java\javapath;E:\orcl\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\java\jdk1.8.0_151\bin;C:\java\jdk1.8.0_151\jre\bin;C:\Program Files\TortoiseSVN\bin;D:\soft\apache-maven-3.5.2-bin\apache-maven-3.5.2\bin;C:\Users\Administrator\Downloads\mysql-5.7.20-winx64\mysql-5.7.20-winx64\bin;D:\software\tortoiseGit\bin;C:\Users\Administrator\Desktop;;.
一月 26, 2018 9:26:09 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-nio-8080"]
一月 26, 2018 9:26:09 上午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
信息: Using a shared selector for servlet write/read
一月 26, 2018 9:26:09 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-nio-8009"]
一月 26, 2018 9:26:09 上午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
信息: Using a shared selector for servlet write/read
一月 26, 2018 9:26:09 上午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 821 ms
一月 26, 2018 9:26:09 上午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
一月 26, 2018 9:26:09 上午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/8.0.36
一月 26, 2018 9:26:11 上午 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 scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
一月 26, 2018 9:26:13 上午 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 scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
18-01-26 09:26:13.835 WARN [localhost-startStop-1] NONE Annotation-Class found!! Check your ioc configure!! packages=[net.wendal.nutzbook]
18-01-26 09:26:13.897 WARN [localhost-startStop-1] None module classes found!!!
18-01-26 09:26:13.897 WARN [localhost-startStop-1] None @At found in any modules class!!
18-01-26 09:26:13.617 INFO [localhost-startStop-1] Select SystemLog as Nutz.Log implement
18-01-26 09:26:13.626 INFO [localhost-startStop-1] NutFilter[nutz] starting ...
18-01-26 09:26:13.657 DEBUG [localhost-startStop-1] Locations count=9 time use 19ms
18-01-26 09:26:13.661 DEBUG [localhost-startStop-1] Locations count=14 time use 3ms
18-01-26 09:26:13.717 DEBUG [localhost-startStop-1] Using 95 castor for Castors
18-01-26 09:26:13.730 DEBUG [localhost-startStop-1] Loading by class org.nutz.mvc.impl.NutLoading
18-01-26 09:26:13.734 INFO [localhost-startStop-1] Nutz Version : 1.r.62 
18-01-26 09:26:13.734 INFO [localhost-startStop-1] Nutz.Mvc[nutz] is initializing ...
18-01-26 09:26:13.734 DEBUG [localhost-startStop-1] Web Container Information:
18-01-26 09:26:13.735 DEBUG [localhost-startStop-1]  - Default Charset : UTF-8
18-01-26 09:26:13.736 DEBUG [localhost-startStop-1]  - Current . path  : C:\Users\Administrator\Desktop\.
18-01-26 09:26:13.736 DEBUG [localhost-startStop-1]  - Java Version    : 1.8.0_151
18-01-26 09:26:13.736 DEBUG [localhost-startStop-1]  - File separator  : \
18-01-26 09:26:13.738 DEBUG [localhost-startStop-1]  - Timezone        : Asia/Shanghai
18-01-26 09:26:13.738 DEBUG [localhost-startStop-1]  - OS              : Windows 7 amd64
18-01-26 09:26:13.738 DEBUG [localhost-startStop-1]  - ServerInfo      : Apache Tomcat/8.0.36
18-01-26 09:26:13.739 DEBUG [localhost-startStop-1]  - Servlet API     : 3.1
18-01-26 09:26:13.739 DEBUG [localhost-startStop-1]  - ContextPath     : /demo
18-01-26 09:26:13.740 DEBUG [localhost-startStop-1]  - context.tempdir : D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp2\work\Catalina\localhost\demo
18-01-26 09:26:13.740 DEBUG [localhost-startStop-1]  - MainModule      : net.wendal.nutzbook.MainModule
18-01-26 09:26:13.741 DEBUG [localhost-startStop-1] >> app.root = D:/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp2/wtpwebapps/demo
18-01-26 09:26:13.744 DEBUG [localhost-startStop-1] @IocBy(type=org.nutz.mvc.ioc.provider.ComboIocProvider, args=["*js", "ioc/", "*anno", "net.wendal.nutzbook", "*tx", "*async"],init=[])
18-01-26 09:26:13.810 DEBUG [localhost-startStop-1] Found 1 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
18-01-26 09:26:13.810 DEBUG [localhost-startStop-1] loading [dao.js]
18-01-26 09:26:13.819 DEBUG [localhost-startStop-1] Loaded 2 bean define from path=[ioc/] --> [dataSource, dao]
18-01-26 09:26:13.832 DEBUG [localhost-startStop-1] Found 3 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
18-01-26 09:26:13.840 DEBUG [localhost-startStop-1] Loaded 5 bean define from reader --
[txREPEATABLE_READ, txSERIALIZABLE, txNONE, txREAD_UNCOMMITTED, txREAD_COMMITTED]
18-01-26 09:26:13.857 DEBUG [localhost-startStop-1] Load AopConfigure for anno=org.nutz.aop.interceptor.async.Async by type=org.nutz.aop.interceptor.async.AsyncAopIocLoader
18-01-26 09:26:13.861 INFO [localhost-startStop-1] NutIoc init begin ...
18-01-26 09:26:13.866 INFO [localhost-startStop-1] ... NutIoc init complete
18-01-26 09:26:13.869 INFO [localhost-startStop-1] Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
18-01-26 09:26:13.872 DEBUG [localhost-startStop-1] @Views(DefaultViewMaker.class)
18-01-26 09:26:13.884 DEBUG [localhost-startStop-1] @ChainBy(org.nutz.mvc.impl.NutActionChainMaker)
18-01-26 09:26:13.890 DEBUG [localhost-startStop-1] module class location 'file:/D:/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp2/wtpwebapps/demo/WEB-INF/classes/'
18-01-26 09:26:13.890 DEBUG [localhost-startStop-1]  > scan 'net.wendal.nutzbook'
18-01-26 09:26:13.896 DEBUG [localhost-startStop-1] Found 3 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
18-01-26 09:26:13.897 DEBUG [localhost-startStop-1] @Localization not define
18-01-26 09:26:13.898 INFO [localhost-startStop-1] Setup application...
18-01-26 09:26:13.901 DEBUG [localhost-startStop-1] Get 'dao'<interface org.nutz.dao.Dao>
18-01-26 09:26:13.901 DEBUG [localhost-startStop-1] Get '$aop_async'<interface org.nutz.ioc.aop.config.AopConfigration>
18-01-26 09:26:13.903 DEBUG [localhost-startStop-1] 	 >> Load definition name=$aop_async
18-01-26 09:26:13.915 DEBUG [localhost-startStop-1] Found IocObject($aop_async) in AsyncAopIocLoader@30550103
18-01-26 09:26:13.916 DEBUG [localhost-startStop-1] 	 >> Make...'$aop_async'<interface org.nutz.ioc.aop.config.AopConfigration>
18-01-26 09:26:13.917 DEBUG [localhost-startStop-1] Save object '$aop_async' to [app] 
18-01-26 09:26:13.923 DEBUG [localhost-startStop-1] Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
18-01-26 09:26:13.925 DEBUG [localhost-startStop-1] 	 >> Load definition name=dao
18-01-26 09:26:13.925 DEBUG [localhost-startStop-1] Loading define for name=dao
18-01-26 09:26:13.928 DEBUG [localhost-startStop-1] Found IocObject(dao) in JsonLoader(paths=[ioc/])
18-01-26 09:26:13.928 DEBUG [localhost-startStop-1] 	 >> Make...'dao'<interface org.nutz.dao.Dao>
18-01-26 09:26:13.940 DEBUG [localhost-startStop-1] Load class org.nutz.dao.impl.NutDao without AOP
18-01-26 09:26:13.941 DEBUG [localhost-startStop-1] Save object 'dao' to [app] 
18-01-26 09:26:13.941 DEBUG [localhost-startStop-1] Get 'dataSource'<>
18-01-26 09:26:13.941 DEBUG [localhost-startStop-1] 	 >> Load definition name=dataSource
18-01-26 09:26:13.942 DEBUG [localhost-startStop-1] Loading define for name=dataSource
18-01-26 09:26:13.956 DEBUG [localhost-startStop-1] Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
18-01-26 09:26:13.956 DEBUG [localhost-startStop-1] 	 >> Make...'dataSource'<>
18-01-26 09:26:13.971 DEBUG [localhost-startStop-1] Load class com.alibaba.druid.pool.DruidDataSource without AOP
18-01-26 09:26:13.971 DEBUG [localhost-startStop-1] Save object 'dataSource' to [app] 
18-01-26 09:26:14.363 DEBUG [localhost-startStop-1] Get 'dataSource'<>
一月 26, 2018 9:26:14 上午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} inited
18-01-26 09:26:14.531 DEBUG [localhost-startStop-1] Jdbcs init complete
18-01-26 09:26:14.531 INFO [localhost-startStop-1] Get Connection from DataSource for JdbcExpert, if you lock at here, check your database server and configure
18-01-26 09:26:14.825 DEBUG [localhost-startStop-1] select expert : org.nutz.dao.impl.jdbc.oracle.OracleJdbcExpert
18-01-26 09:26:14.830 DEBUG [localhost-startStop-1] JDBC Driver --> 11.2.0.4.0
18-01-26 09:26:14.830 DEBUG [localhost-startStop-1] JDBC Name   --> Oracle JDBC driver
18-01-26 09:26:14.830 DEBUG [localhost-startStop-1] JDBC URL    --> jdbc:oracle:thin:@127.0.0.1:1521/NUTZBOOK
18-01-26 09:26:14.830 DEBUG [localhost-startStop-1] Database info --> ORACLE:[Oracle - Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options]
18-01-26 09:26:14.836 DEBUG [localhost-startStop-1] Found 3 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
18-01-26 09:26:14.917 DEBUG [localhost-startStop-1] SELECT COUNT(*) FROM t_user 
18-01-26 09:26:14.931 DEBUG [localhost-startStop-1] INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES(?,?,?,?,?) 
    |     1 |      2 |    3 |                   4 |                   5 |
    |-------|--------|------|---------------------|---------------------|
    | admin | 123456 | NULL | 2018-01-26 09:26:14 | 2018-01-26 09:26:14 |
  For example:> "INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES('admin','123456','NULL','2018-01-26 09:26:14','2018-01-26 09:26:14') "
18-01-26 09:26:14.980 DEBUG [localhost-startStop-1] SQLException
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: 无法将 NULL 插入 ("SYSTEM"."T_USER"."ID")

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:308)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:104)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:88)
	at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:74)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:72)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:55)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:148)
	at net.wendal.nutzbook.MainSetup.init(MainSetup.java:29)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:274)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:121)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:91)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:69)
	at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4689)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5329)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
18-01-26 09:26:14.985 ERROR [localhost-startStop-1] Error happend during start serivce!
org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES('admin','123456','NULL','2018-01-26 09:26:14','2018-01-26 09:26:14') '
PreparedStatement: 
'INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES(?,?,?,?,?) '
CaseMessage=ORA-01400: 无法将 NULL 插入 ("SYSTEM"."T_USER"."ID")

	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:104)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:88)
	at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:74)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:72)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:55)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:148)
	at net.wendal.nutzbook.MainSetup.init(MainSetup.java:29)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:274)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:121)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:91)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:69)
	at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4689)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5329)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: 无法将 NULL 插入 ("SYSTEM"."T_USER"."ID")

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:308)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
	... 32 more
18-01-26 09:26:14.989 ERROR [localhost-startStop-1] try to depose ioc
18-01-26 09:26:14.990 INFO [localhost-startStop-1] org.nutz.ioc.impl.NutIoc@327577824 is closing. startup date [18-01-26 09:26:13.864]
18-01-26 09:26:14.990 DEBUG [localhost-startStop-1] Depose object 'dao' ...
18-01-26 09:26:14.990 DEBUG [localhost-startStop-1] Depose object '$aop_async' ...
18-01-26 09:26:14.990 DEBUG [localhost-startStop-1] Depose object 'dataSource' ...
一月 26, 2018 9:26:14 上午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} closed
一月 26, 2018 9:26:15 上午 org.apache.catalina.core.StandardContext filterStart
严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES('admin','123456','NULL','2018-01-26 09:26:14','2018-01-26 09:26:14') '
PreparedStatement: 
'INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES(?,?,?,?,?) '
CaseMessage=ORA-01400: 无法将 NULL 插入 ("SYSTEM"."T_USER"."ID")

	at org.nutz.mvc.LoadingException$FC$9a86caf9ff5d3b587784fcdf555a4a7d.invoke(LoadingException.java)
	at org.nutz.lang.born.AbstractConstructorBorning.call(AbstractConstructorBorning.java:25)
	at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:19)
	at org.nutz.lang.born.BornContext.doBorn(BornContext.java:60)
	at org.nutz.lang.Mirror.born(Mirror.java:990)
	at org.nutz.lang.Lang.wrapThrow(Lang.java:200)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:135)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:91)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:69)
	at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:279)
	at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:260)
	at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:105)
	at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4689)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5329)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES('admin','123456','NULL','2018-01-26 09:26:14','2018-01-26 09:26:14') '
PreparedStatement: 
'INSERT INTO t_user(name,passwd,salt,ct,ut) VALUES(?,?,?,?,?) '
CaseMessage=ORA-01400: 无法将 NULL 插入 ("SYSTEM"."T_USER"."ID")

	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:104)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:88)
	at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:74)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:72)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:55)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:148)
	at net.wendal.nutzbook.MainSetup.init(MainSetup.java:29)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:274)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:121)
	... 15 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: 无法将 NULL 插入 ("SYSTEM"."T_USER"."ID")

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:308)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
	... 32 more

一月 26, 2018 9:26:15 上午 org.apache.catalina.core.StandardContext startInternal
严重: One or more Filters failed to start. Full details will be found in the appropriate container log file
一月 26, 2018 9:26:15 上午 org.apache.catalina.core.StandardContext startInternal
严重: Context [/demo] startup failed due to previous errors
一月 26, 2018 9:26:15 上午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
警告: The web application [demo] registered the JDBC driver [com.alibaba.druid.proxy.DruidDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
一月 26, 2018 9:26:15 上午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
警告: The web application [demo] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
一月 26, 2018 9:26:15 上午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
警告: The web application [demo] appears to have started a thread named [Druid-ConnectionPool-Create-1429503723] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 sun.misc.Unsafe.park(Native Method)
 java.util.concurrent.locks.LockSupport.park(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireQueued(Unknown Source)
 java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown Source)
 com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1977)
18-01-26 09:26:14.999 INFO [localhost-startStop-1] org.nutz.ioc.impl.NutIoc@327577824 is deposed. startup date [18-01-26 09:26:13.864]
一月 26, 2018 9:26:15 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-nio-8080"]
一月 26, 2018 9:26:15 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-nio-8009"]
一月 26, 2018 9:26:15 上午 org.apache.catalina.startup.Catalina start
信息: Server startup in 5745 ms

wendal

8楼•2289天前

提示的MainSetup的32行，执行的代码类似于ioc.get(Scheduler.class),跟你贴的代码并不相符，是不是有多个项目

qq_796a181a 9楼•2289天前

只有一个项目在TOMCAT运行，重新建了server运行还是同样错误
下面是dao.js

var ioc = {
        dataSource : {
            type : "com.alibaba.druid.pool.DruidDataSource",
            events : {
                create : "init",
                depose : 'close'
            },
            fields : {
                url : "jdbc:oracle:thin:@127.0.0.1:1521/NUTZBOOK",
                username : "system",
                password : "894",
//                testWhileIdle : true, // 非常重要,预防mysql的8小时timeout问题
                validationQuery : "select 1 from dual" , 
                // Oracle的话需要改成 select 1 from dual
                maxActive : 100
            }
        },
        dao : {
            type : "org.nutz.dao.impl.NutDao",
            args : [{refer:"dataSource"}]
        }
};

qq_796a181a 10楼•2289天前

@wendal

wendal

11楼•2289天前

同一个错误指的是oracle的报错吗？

qq_796a181a 12楼•2289天前

是的，结果在7楼
@wendal

qq_796a181a 13楼•2289天前

已经解决了谢谢大神关注，改成了User类上面的@TAable改成了（“tf_user”）
@wendal 万分感谢

wendal

14楼•2289天前

把表删掉, 然后重启, 贴日志

wendal

15楼•2289天前

哦, ok

qq_796a181a 16楼•2289天前

@wendal
30分钟项目跑起来--第一个模块类UserModule这里粘贴后控制台不报错，网页带了下面链接是404
http://127.0.0.1:8080/nutzbook/user/count

wendal

17楼•2289天前

18-01-26 09:26:13.739 DEBUG [localhost-startStop-1]  - ContextPath     : /demo

qq_796a181a 18楼•2289天前

这是控制台代码@wendal

一月 26, 2018 10:03:54 上午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:demo' did not find a matching property.
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/8.0.36
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Jun 9 2016 13:55:50 UTC
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         8.0.36.0
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Windows 7
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            6.1
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          amd64
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             C:\Program Files\Java\jre1.8.0_151
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.8.0_151-b12
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         D:\soft
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=D:\soft
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dwtp.deploy=D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=D:\soft\endorsed
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dfile.encoding=UTF-8
一月 26, 2018 10:03:54 上午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_151\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre1.8.0_151/bin/server;C:/Program Files/Java/jre1.8.0_151/bin;C:/Program Files/Java/jre1.8.0_151/lib/amd64;C:\ProgramData\Oracle\Java\javapath;E:\orcl\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\java\jdk1.8.0_151\bin;C:\java\jdk1.8.0_151\jre\bin;C:\Program Files\TortoiseSVN\bin;D:\soft\apache-maven-3.5.2-bin\apache-maven-3.5.2\bin;C:\Users\Administrator\Downloads\mysql-5.7.20-winx64\mysql-5.7.20-winx64\bin;D:\software\tortoiseGit\bin;C:\Users\Administrator\Desktop;;.
一月 26, 2018 10:03:54 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-nio-8080"]
一月 26, 2018 10:03:54 上午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
信息: Using a shared selector for servlet write/read
一月 26, 2018 10:03:54 上午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-nio-8009"]
一月 26, 2018 10:03:54 上午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
信息: Using a shared selector for servlet write/read
一月 26, 2018 10:03:54 上午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 894 ms
一月 26, 2018 10:03:54 上午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
一月 26, 2018 10:03:54 上午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/8.0.36
一月 26, 2018 10:03:56 上午 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 scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
一月 26, 2018 10:03:58 上午 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 scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
18-01-26 10:03:59.018 INFO [localhost-startStop-1] Select SystemLog as Nutz.Log implement
18-01-26 10:03:59.027 INFO [localhost-startStop-1] NutFilter[nutz] starting ...
18-01-26 10:03:59.058 DEBUG [localhost-startStop-1] Locations count=9 time use 18ms
18-01-26 10:03:59.062 DEBUG [localhost-startStop-1] Locations count=14 time use 4ms
18-01-26 10:03:59.124 DEBUG [localhost-startStop-1] Using 95 castor for Castors
18-01-26 10:03:59.149 DEBUG [localhost-startStop-1] Loading by class org.nutz.mvc.impl.NutLoading
18-01-26 10:03:59.153 INFO [localhost-startStop-1] Nutz Version : 1.r.62 
18-01-26 10:03:59.153 INFO [localhost-startStop-1] Nutz.Mvc[nutz] is initializing ...
18-01-26 10:03:59.154 DEBUG [localhost-startStop-1] Web Container Information:
18-01-26 10:03:59.155 DEBUG [localhost-startStop-1]  - Default Charset : UTF-8
18-01-26 10:03:59.155 DEBUG [localhost-startStop-1]  - Current . path  : C:\Users\Administrator\Desktop\.
18-01-26 10:03:59.155 DEBUG [localhost-startStop-1]  - Java Version    : 1.8.0_151
18-01-26 10:03:59.156 DEBUG [localhost-startStop-1]  - File separator  : \
18-01-26 10:03:59.156 DEBUG [localhost-startStop-1]  - Timezone        : Asia/Shanghai
18-01-26 10:03:59.156 DEBUG [localhost-startStop-1]  - OS              : Windows 7 amd64
18-01-26 10:03:59.156 DEBUG [localhost-startStop-1]  - ServerInfo      : Apache Tomcat/8.0.36
18-01-26 10:03:59.157 DEBUG [localhost-startStop-1]  - Servlet API     : 3.1
18-01-26 10:03:59.157 DEBUG [localhost-startStop-1]  - ContextPath     : /demo
18-01-26 10:03:59.157 DEBUG [localhost-startStop-1]  - context.tempdir : D:\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\work\Catalina\localhost\demo
18-01-26 10:03:59.157 DEBUG [localhost-startStop-1]  - MainModule      : net.wendal.nutzbook.MainModule
18-01-26 10:03:59.161 DEBUG [localhost-startStop-1] >> app.root = D:/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/demo
18-01-26 10:03:59.164 DEBUG [localhost-startStop-1] @IocBy(type=org.nutz.mvc.ioc.provider.ComboIocProvider, args=["*js", "ioc/", "*anno", "net.wendal.nutzbook", "*tx", "*async"],init=[])
18-01-26 10:03:59.228 DEBUG [localhost-startStop-1] Found 1 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
18-01-26 10:03:59.228 DEBUG [localhost-startStop-1] loading [dao.js]
18-01-26 10:03:59.236 DEBUG [localhost-startStop-1] Loaded 2 bean define from path=[ioc/] --> [dataSource, dao]
18-01-26 10:03:59.245 DEBUG [localhost-startStop-1] Found 4 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
18-01-26 10:03:59.253 DEBUG [localhost-startStop-1] Found @IocBean : class net.wendal.nutzbook.module.UserModule
18-01-26 10:03:59.259 INFO [localhost-startStop-1] Found 1 classes in 1 base-packages!
beans = ["userModule"]
18-01-26 10:03:59.262 DEBUG [localhost-startStop-1] Loaded 5 bean define from reader --
[txREPEATABLE_READ, txSERIALIZABLE, txNONE, txREAD_UNCOMMITTED, txREAD_COMMITTED]
18-01-26 10:03:59.278 DEBUG [localhost-startStop-1] Load AopConfigure for anno=org.nutz.aop.interceptor.async.Async by type=org.nutz.aop.interceptor.async.AsyncAopIocLoader
18-01-26 10:03:59.281 INFO [localhost-startStop-1] NutIoc init begin ...
18-01-26 10:03:59.284 INFO [localhost-startStop-1] ... NutIoc init complete
18-01-26 10:03:59.286 INFO [localhost-startStop-1] Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
18-01-26 10:03:59.288 DEBUG [localhost-startStop-1] @Views(DefaultViewMaker.class)
18-01-26 10:03:59.298 DEBUG [localhost-startStop-1] @ChainBy(org.nutz.mvc.impl.NutActionChainMaker)
18-01-26 10:03:59.304 DEBUG [localhost-startStop-1] module class location 'file:/D:/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/demo/WEB-INF/classes/'
18-01-26 10:03:59.304 DEBUG [localhost-startStop-1]  > scan 'net.wendal.nutzbook'
18-01-26 10:03:59.324 DEBUG [localhost-startStop-1] Found 4 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
18-01-26 10:03:59.325 DEBUG [localhost-startStop-1]    >> add 'net.wendal.nutzbook.module.UserModule'
18-01-26 10:03:59.351 INFO [localhost-startStop-1] Optional processor class not found, disabled : org.nutz.integration.shiro.NutShiroProcessor
18-01-26 10:03:59.365 INFO [localhost-startStop-1] Optional processor class not found, disabled : org.nutz.plugins.validation.ValidationProcessor
18-01-26 10:03:59.384 DEBUG [localhost-startStop-1]    '/user/count'               >> (UserModule.java:23).count            : int        | @Ok(json ) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
18-01-26 10:03:59.385 INFO [localhost-startStop-1] Found 1 module methods
18-01-26 10:03:59.386 DEBUG [localhost-startStop-1] @Localization not define
18-01-26 10:03:59.387 INFO [localhost-startStop-1] Setup application...
18-01-26 10:03:59.392 DEBUG [localhost-startStop-1] Get 'dao'<interface org.nutz.dao.Dao>
18-01-26 10:03:59.393 DEBUG [localhost-startStop-1] Get '$aop_async'<interface org.nutz.ioc.aop.config.AopConfigration>
18-01-26 10:03:59.394 DEBUG [localhost-startStop-1] 	 >> Load definition name=$aop_async
18-01-26 10:03:59.396 DEBUG [localhost-startStop-1] Found IocObject($aop_async) in AsyncAopIocLoader@1505571410
18-01-26 10:03:59.396 DEBUG [localhost-startStop-1] 	 >> Make...'$aop_async'<interface org.nutz.ioc.aop.config.AopConfigration>
18-01-26 10:03:59.398 DEBUG [localhost-startStop-1] Save object '$aop_async' to [app] 
18-01-26 10:03:59.401 DEBUG [localhost-startStop-1] Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
18-01-26 10:03:59.402 DEBUG [localhost-startStop-1] 	 >> Load definition name=dao
18-01-26 10:03:59.402 DEBUG [localhost-startStop-1] Loading define for name=dao
18-01-26 10:03:59.407 DEBUG [localhost-startStop-1] Found IocObject(dao) in JsonLoader(paths=[ioc/])
18-01-26 10:03:59.407 DEBUG [localhost-startStop-1] 	 >> Make...'dao'<interface org.nutz.dao.Dao>
18-01-26 10:03:59.431 DEBUG [localhost-startStop-1] Load class org.nutz.dao.impl.NutDao without AOP
18-01-26 10:03:59.431 DEBUG [localhost-startStop-1] Save object 'dao' to [app] 
18-01-26 10:03:59.432 DEBUG [localhost-startStop-1] Get 'dataSource'<>
18-01-26 10:03:59.432 DEBUG [localhost-startStop-1] 	 >> Load definition name=dataSource
18-01-26 10:03:59.432 DEBUG [localhost-startStop-1] Loading define for name=dataSource
18-01-26 10:03:59.449 DEBUG [localhost-startStop-1] Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
18-01-26 10:03:59.449 DEBUG [localhost-startStop-1] 	 >> Make...'dataSource'<>
18-01-26 10:03:59.470 DEBUG [localhost-startStop-1] Load class com.alibaba.druid.pool.DruidDataSource without AOP
18-01-26 10:03:59.470 DEBUG [localhost-startStop-1] Save object 'dataSource' to [app] 
18-01-26 10:03:59.851 DEBUG [localhost-startStop-1] Get 'dataSource'<>
一月 26, 2018 10:03:59 上午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} inited
18-01-26 10:04:00.057 DEBUG [localhost-startStop-1] Jdbcs init complete
18-01-26 10:04:00.057 INFO [localhost-startStop-1] Get Connection from DataSource for JdbcExpert, if you lock at here, check your database server and configure
18-01-26 10:04:00.299 DEBUG [localhost-startStop-1] select expert : org.nutz.dao.impl.jdbc.oracle.OracleJdbcExpert
18-01-26 10:04:00.305 DEBUG [localhost-startStop-1] JDBC Driver --> 11.2.0.4.0
18-01-26 10:04:00.305 DEBUG [localhost-startStop-1] JDBC Name   --> Oracle JDBC driver
18-01-26 10:04:00.305 DEBUG [localhost-startStop-1] JDBC URL    --> jdbc:oracle:thin:@127.0.0.1:1521/NUTZBOOK
18-01-26 10:04:00.305 DEBUG [localhost-startStop-1] Database info --> ORACLE:[Oracle - Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options]
18-01-26 10:04:00.311 DEBUG [localhost-startStop-1] Found 4 resource by src( net/wendal/nutzbook/ ) , regex( ^.+[.]class$ )
18-01-26 10:04:00.403 DEBUG [localhost-startStop-1] SELECT COUNT(*) FROM tf_user 
18-01-26 10:04:00.409 INFO [localhost-startStop-1] Nutz.Mvc[nutz] is up in 1249ms
一月 26, 2018 10:04:00 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-nio-8080"]
一月 26, 2018 10:04:00 上午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-nio-8009"]
一月 26, 2018 10:04:00 上午 org.apache.catalina.startup.Catalina start
信息: Server startup in 5816 ms

wendal

19楼•2289天前

你的项目名是 demo , 默认的context path就是 /demo 的, 所以你得访问 http://127.0.0.1:8080/demo/user/count 才会有结果,这是eclipse/tomcat的约定

qq_796a181a 20楼•2289天前

@wendal

谢谢

请先登陆