请问@Prev里怎么调用存储过程获得主键id谢谢。

我写成这样提示错误

	@Id(auto=false)
	@Prev(@SQL(" call nextid('tablename') "))
    private int ID;

存储过程类似这样

ALTER PROCEDURE [dbo].[nextid]
  @tablename varchar(50)
AS
begin
 declare @id int
 select @id=isnull(ID,0)＋1 from othertable where Name=@tablename
  select @id
  return @id
END

感谢回复。

瞎折腾(qq_b8d02b2c) 1楼•2997天前

错误日志如下：

严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.dao.DaoException: !Nutz SQL Error: 'call nextid('tablename')'
PreparedStatement: 
'call nextid('tablename')'
CaseMessage='wx_menu' 附近有语法错误。
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:17)
	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:169)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:134)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
	at net.lfsoft.cms.mvc.LfcmsNutFilter.init(LfcmsNutFilter.java:17)
	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:4841)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'call nextid('tablename')'

wendal

2楼•2997天前

报错信息没贴全

wendal

3楼•2997天前

那存储过程就一句select,那直接写select语句啦

瞎折腾(qq_b8d02b2c) 4楼•2997天前

@wendal 感谢回复

九月 01, 2016 12:50:56 下午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:lfcms' did not find a matching property.
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/7.0.65
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Oct 9 2015 08:36:58 UTC
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         7.0.65.0
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Mac OS X
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            10.9.5
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          x86_64
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             /Library/Java/JavaVirtualMachines/jdk1.7.0_80.jdk/Contents/Home/jre
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.7.0_80-b15
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         /Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         /Users/crackerciwei/apache-tomcat-7.0.65
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=/Users/crackerciwei/apache-tomcat-7.0.65
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dwtp.deploy=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=/Users/crackerciwei/apache-tomcat-7.0.65/endorsed
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dfile.encoding=UTF-8
九月 01, 2016 12:50:56 下午 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: /Users/crackerciwei/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.
九月 01, 2016 12:50:56 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-bio-8080"]
九月 01, 2016 12:50:56 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-bio-8009"]
九月 01, 2016 12:50:56 下午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 818 ms
九月 01, 2016 12:50:56 下午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
九月 01, 2016 12:50:56 下午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.65
九月 01, 2016 12:50:57 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/core is already defined
九月 01, 2016 12:50:57 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
九月 01, 2016 12:50:57 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
九月 01, 2016 12:50:57 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
九月 01, 2016 12:50:57 下午 org.apache.catalina.startup.TldConfig execute
信息: 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.
九月 01, 2016 12:50:57 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Shiro environment
log4j: 2016-09-01 12:50:57,894 [localhost-startStop-1] INFO  org.apache.shiro.web.env.EnvironmentLoader - Starting Shiro environment initialization.
log4j: 2016-09-01 12:50:57,901 [localhost-startStop-1] DEBUG org.apache.shiro.web.env.IniWebEnvironment - Checking any specified config locations.
log4j: 2016-09-01 12:50:57,902 [localhost-startStop-1] DEBUG org.apache.shiro.web.env.IniWebEnvironment - No INI instance or config locations specified.  Trying default config locations.
log4j: 2016-09-01 12:50:57,904 [localhost-startStop-1] DEBUG org.apache.shiro.io.ResourceUtils - Opening resource from class path [shiro.ini]
log4j: 2016-09-01 12:50:57,909 [localhost-startStop-1] DEBUG org.apache.shiro.config.Ini - Parsing [main]
log4j: 2016-09-01 12:50:57,909 [localhost-startStop-1] DEBUG org.apache.shiro.config.Ini - Parsing [urls]
log4j: 2016-09-01 12:50:57,910 [localhost-startStop-1] DEBUG org.apache.shiro.web.env.IniWebEnvironment - Discovered non-empty INI configuration at location 'classpath:shiro.ini'.  Using for configuration.
log4j: 2016-09-01 12:50:57,913 [localhost-startStop-1] DEBUG org.apache.shiro.config.IniFactorySupport - Creating instance from Ini [sections=urls]
log4j: 2016-09-01 12:50:57,949 [localhost-startStop-1] DEBUG org.apache.shiro.config.IniFactorySupport - Creating instance from Ini [sections=urls]
log4j: 2016-09-01 12:50:57,952 [localhost-startStop-1] DEBUG org.apache.shiro.web.filter.mgt.DefaultFilterChainManager - Creating chain [/rs/*] from String definition [anon]
log4j: 2016-09-01 12:50:57,952 [localhost-startStop-1] DEBUG org.apache.shiro.web.filter.mgt.DefaultFilterChainManager - Attempting to apply path [/rs/*] to filter [anon] with config [null]
log4j: 2016-09-01 12:50:57,953 [localhost-startStop-1] DEBUG org.apache.shiro.web.env.EnvironmentLoader - Published WebEnvironment as ServletContext attribute with name [org.apache.shiro.web.env.EnvironmentLoader.ENVIRONMENT_ATTRIBUTE_KEY]
log4j: 2016-09-01 12:50:57,953 [localhost-startStop-1] INFO  org.apache.shiro.web.env.EnvironmentLoader - Shiro environment initialized in 58 ms.
log4j: 2016-09-01 12:50:57,966 [localhost-startStop-1] INFO  net.crackerciwei.cms.mvc.LfcmsNutFilter - NutFilter[nutz] starting ...
log4j: 2016-09-01 12:50:58,085 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Locations for Scans:
[FileSystemResourceLocation [root=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/classes], JarResourceLocation [jarPath=/Users/crackerciwei/apache-tomcat-7.0.65/bin/tomcat-juli.jar], JarResourceLocation [jarPath=/Library/Java/JavaVirtualMachines/jdk1.7.0_80.jdk/Contents/Home/lib/tools.jar], FileSystemResourceLocation [root=/Users/crackerciwei/EclipseMars/Eclipse.app/Contents/MacOS], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutz-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/apache-tomcat-7.0.65/bin/bootstrap.jar]]
log4j: 2016-09-01 12:50:58,327 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Locations for Scans:
[FileSystemResourceLocation [root=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/classes], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/commons-lang3-3.4.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/quartz-2.2.2.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/commons-beanutils-1.9.2.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/simplecaptcha-1.2.2.jar], FileSystemResourceLocation [root=/Users/crackerciwei/EclipseMars/Eclipse.app/Contents/MacOS], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/commons-logging-1.2.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/taglibs-standard-impl-1.2.5.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/taglibs-standard-compat-1.2.5.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/mysql-connector-java-5.1.37.jar], JarResourceLocation [jarPath=/Library/Java/JavaVirtualMachines/jdk1.7.0_80.jdk/Contents/Home/lib/tools.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/druid-1.0.16.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/taglibs-standard-spec-1.2.5.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/slf4j-api-1.7.7.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/javax.servlet.jsp.jstl-api-1.2.1.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/emoji-java-3.1.3.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutz-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutz-integration-shiro-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/apache-tomcat-7.0.65/bin/tomcat-juli.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/c3p0-0.9.1.1.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/quartz-jobs-2.2.2.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutz-integration-quartz-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/log4j-1.2.16.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutzwx-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/apache-tomcat-7.0.65/bin/bootstrap.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/sqljdbc4.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/slf4j-log4j12-1.7.7.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/taglibs-standard-jstlel-1.2.5.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/shiro-all-1.2.4.jar]]
log4j: 2016-09-01 12:50:58,329 [localhost-startStop-1] DEBUG org.nutz.mvc.config.AbstractNutConfig - MainModule: <net.crackerciwei.cms.MainModule>
log4j: 2016-09-01 12:50:58,346 [localhost-startStop-1] DEBUG org.nutz.mvc.config.AbstractNutConfig - Loading by class org.nutz.mvc.impl.NutLoading
log4j: 2016-09-01 12:50:58,348 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Nutz Version : 1.r.57 
log4j: 2016-09-01 12:50:58,348 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Nutz.Mvc[nutz] is initializing ...
log4j: 2016-09-01 12:50:58,348 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - Web Container Information:
log4j: 2016-09-01 12:50:58,367 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Default Charset : UTF-8
log4j: 2016-09-01 12:50:58,368 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Current . path  : /Users/crackerciwei/EclipseMars/Eclipse.app/Contents/MacOS/.
log4j: 2016-09-01 12:50:58,368 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Java Version    : 1.7.0_80
log4j: 2016-09-01 12:50:58,368 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - File separator  : /
log4j: 2016-09-01 12:50:58,368 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Timezone        : Asia/Shanghai
log4j: 2016-09-01 12:50:58,368 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - OS              : Mac OS X x86_64
log4j: 2016-09-01 12:50:58,368 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - ServerInfo      : Apache Tomcat/7.0.65
log4j: 2016-09-01 12:50:58,369 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Servlet API     : 3.0
log4j: 2016-09-01 12:50:58,369 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - ContextPath     : /lfcms
log4j: 2016-09-01 12:50:58,369 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - context.tempdir : /Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/work/Catalina/localhost/lfcms
log4j: 2016-09-01 12:50:58,369 [localhost-startStop-1] DEBUG org.nutz.mvc.config.AbstractNutConfig - MainModule: <net.crackerciwei.cms.MainModule>
log4j: 2016-09-01 12:50:58,369 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - >> app.root = /Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms
log4j: 2016-09-01 12:50:58,418 [localhost-startStop-1] DEBUG org.nutz.castor.Castors - Using 94 castor for Castors
log4j: 2016-09-01 12:50:58,419 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - @IocBy(type=org.nutz.mvc.ioc.provider.ComboIocProvider, args=["*js", "ioc/", "*anno", "net.crackerciwei.cms", "*tx", "*org.nutz.integration.quartz.QuartzIocLoader"],init=[])
log4j: 2016-09-01 12:50:58,438 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 1 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
log4j: 2016-09-01 12:50:58,438 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.json.JsonLoader - loading ioc js config from [dao.js]
log4j: 2016-09-01 12:50:58,442 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.json.JsonLoader - Loaded 3 bean define from path=[ioc/] --> [dataSource, dao, conf]
log4j: 2016-09-01 12:50:58,456 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 30 resource by src( net/crackerciwei/cms/ ) , regex( ^.+[.]class$ )
log4j: 2016-09-01 12:50:58,498 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.CaptchaModule
log4j: 2016-09-01 12:50:58,502 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.IndexModule
log4j: 2016-09-01 12:50:58,505 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.MemberModule
log4j: 2016-09-01 12:50:58,506 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.NewsClassModule
log4j: 2016-09-01 12:50:58,507 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.NewsModule
log4j: 2016-09-01 12:50:58,511 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.RoleModule
log4j: 2016-09-01 12:50:58,512 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.TemplateModule
log4j: 2016-09-01 12:50:58,515 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.UserModule
log4j: 2016-09-01 12:50:58,518 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.WeixinModule
log4j: 2016-09-01 12:50:58,519 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.quartz.job.UpdateCacheJob
log4j: 2016-09-01 12:50:58,520 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.service.NewsClassService
log4j: 2016-09-01 12:50:58,523 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.service.NewsService
log4j: 2016-09-01 12:50:58,524 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.service.UserService
log4j: 2016-09-01 12:50:58,524 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.util.WxHandler
log4j: 2016-09-01 12:50:58,531 [localhost-startStop-1] INFO  org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found 14 classes in 1 base-packages!
beans = ["newsService", "indexModule", "userService", "memberModule", "newsClassService", "userModule", "weixinModule", "captchaModule", "templateModule", "updateCacheJob", "roleModule", "newsModule", "wxHandler", "newsClassModule"]
log4j: 2016-09-01 12:50:58,532 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.json.JsonLoader - Loaded 5 bean define from reader --
[txREPEATABLE_READ, txREAD_COMMITTED, txNONE, txSERIALIZABLE, txREAD_UNCOMMITTED]
log4j: 2016-09-01 12:50:58,535 [localhost-startStop-1] INFO  org.nutz.ioc.impl.NutIoc - NutIoc init begin ...
log4j: 2016-09-01 12:50:58,537 [localhost-startStop-1] INFO  org.nutz.ioc.impl.NutIoc - ... NutIoc init complete
log4j: 2016-09-01 12:50:58,537 [localhost-startStop-1] DEBUG org.nutz.mvc.config.AbstractNutConfig - MainModule: <net.crackerciwei.cms.MainModule>
log4j: 2016-09-01 12:50:58,539 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
log4j: 2016-09-01 12:50:58,540 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - @Views(DefaultViewMaker.class)
log4j: 2016-09-01 12:50:58,545 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 1 resource by src( mvc/nutzbook-mvc-chain.js ) , regex( ^(.+[.])(js|json)$ )
log4j: 2016-09-01 12:50:58,550 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.chainconfig.JsonActionChainMakerConfiguretion - ActionChain Config:
{
   "default" :{
      "ps" :["net.crackerciwei.cms.mvc.LogTimeProcessor", "org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor", "org.nutz.mvc.impl.processor.EncodingProcessor", "org.nutz.mvc.impl.processor.ModuleProcessor", "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"
   }
}
log4j: 2016-09-01 12:50:58,550 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - @ChainBy(org.nutz.mvc.impl.NutActionChainMaker)
log4j: 2016-09-01 12:50:58,553 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings - module class location 'file:/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/classes/'
log4j: 2016-09-01 12:50:58,553 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -  > scan 'net.crackerciwei.cms'
log4j: 2016-09-01 12:50:58,559 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 30 resource by src( net/crackerciwei/cms/ ) , regex( ^.+[.]class$ )
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.CaptchaModule'
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.IndexModule'
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.MemberModule'
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.NewsClassModule'
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.NewsModule'
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.RoleModule'
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.TemplateModule'
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.UserModule'
log4j: 2016-09-01 12:50:58,561 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.WeixinModule'
log4j: 2016-09-01 12:50:58,580 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/add'                 >> NewsModule.add(...)            : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,590 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/type'                >> NewsModule.type(...)           : Map        | @Ok(jsp:jsp.front.${obj.template}.type) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,590 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/list'                >> NewsModule.list(...)           : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,591 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/delete'              >> NewsModule.delete(...)         : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,592 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/check'               >> NewsModule.check(...)          : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,595 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/query'               >> NewsModule.query(...)          : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,596 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/modify'              >> NewsModule.modify(...)         : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,597 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/manage'              >> NewsModule.manage(...)         : void       | @Ok(jsp:jsp.user.news) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,599 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/img/?'               >> NewsModule.img(...)            : Object     | @Ok(raw:jpg) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,601 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/detail/?'            >> NewsModule.detail(...)         : Map        | @Ok(jsp:jsp.front.${obj.template}.detail) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,602 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/add'               >> MemberModule.add(...)          : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,603 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/list'              >> MemberModule.list(...)         : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,603 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/delete'            >> MemberModule.delete(...)       : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,604 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/modify'            >> MemberModule.modify(...)       : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,605 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/manage'            >> MemberModule.manage(...)       : void       | @Ok(jsp:jsp.user.member) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,608 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/index'                    >> IndexModule.index(...)         : Map        | @Ok(jsp:jsp.front.${obj.template}.index) @Fail(jsp:jsp.500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,608 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/commonjs'                 >> IndexModule.commonjs(...)      : Object     | @Ok(raw:js) @Fail(jsp:jsp.500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,610 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/add'            >> NewsClassModule.add(...)       : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,610 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/list'           >> NewsClassModule.list(...)      : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,611 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/delete'         >> NewsClassModule.delete(...)    : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,612 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/modify'         >> NewsClassModule.modify(...)    : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,612 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/manage'         >> NewsClassModule.manage(...)    : void       | @Ok(jsp:jsp.user.newsclass) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,613 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/role/list'                >> RoleModule.list(...)           : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,614 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/role/manage'              >> RoleModule.manage(...)         : void       | @Ok(jsp:jsp.user.role) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,615 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/weixin/api', '/weixin/api/?' >> WeixinModule.msgIn(...)        : View       | @Ok(json:full) @Fail(http:200) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,616 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/weixin/test', '/weixin/test/?' >> WeixinModule.test(...)         : String     | @Ok(json:full) @Fail(http:200) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,624 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/add'                 >> UserModule.add(...)            : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,625 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/count'               >> UserModule.count(...)          : int        | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,625 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/list'                >> UserModule.list(...)           : Map        | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,626 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/'                    >> UserModule.index(...)          : void       | @Ok(jsp:jsp.user.index) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,627 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/delete'              >> UserModule.delete(...)         : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,628 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/query'               >> UserModule.query(...)          : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,628 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/loginPage'           >> UserModule.loginPage(...)      : void       | @Ok(jsp:jsp.user.login) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,630 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/login'               >> UserModule.login(...)          : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,631 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/logout'              >> UserModule.logout(...)         : void       | @Ok(>>:/ ) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,632 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/modify'              >> UserModule.modify(...)         : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,632 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/manage'              >> UserModule.manage(...)         : void       | @Ok(jsp:jsp.user.user) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,634 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/add'             >> TemplateModule.add(...)        : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,634 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/list'            >> TemplateModule.list(...)       : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,635 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/delete'          >> TemplateModule.delete(...)     : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,636 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/modify'          >> TemplateModule.modify(...)     : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,636 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/manage'          >> TemplateModule.manage(...)     : void       | @Ok(jsp:jsp.user.template) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,637 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/captcha/next'             >> CaptchaModule.next(...)        : BufferedImage | @Ok(raw:png) @Fail(jsp:jsp.500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 12:50:58,637 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Found 43 module methods
log4j: 2016-09-01 12:50:58,637 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - Localization: org.nutz.mvc.impl.NutMessageLoader('msg/')  dft<zh-CN>
log4j: 2016-09-01 12:50:58,638 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 1 resource by src( msg/ ) , regex( ^.+[.]properties$ )
log4j: 2016-09-01 12:50:58,639 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutMessageLoader - Load Messages in 1 resource : [[NutResource[zh-CN/user.properties]]]
log4j: 2016-09-01 12:50:58,639 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutMessageLoader - Message Loaded, size = 2
log4j: 2016-09-01 12:50:58,640 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Setup application...
log4j: 2016-09-01 12:50:58,640 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dao'<interface org.nutz.dao.Dao>
log4j: 2016-09-01 12:50:58,641 [localhost-startStop-1] DEBUG org.nutz.ioc.aop.SimpleAopMaker - Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
log4j: 2016-09-01 12:50:58,641 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=dao
log4j: 2016-09-01 12:50:58,642 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.map.MapLoader - Loading define for name=dao
log4j: 2016-09-01 12:50:58,645 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(dao) in JsonLoader(paths=[ioc/])
log4j: 2016-09-01 12:50:58,645 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'dao'<interface org.nutz.dao.Dao>
log4j: 2016-09-01 12:50:58,651 [localhost-startStop-1] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class org.nutz.dao.impl.NutDao without AOP
log4j: 2016-09-01 12:50:58,652 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'dao' to [app] 
log4j: 2016-09-01 12:50:58,653 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dataSource'<>
log4j: 2016-09-01 12:50:58,653 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=dataSource
log4j: 2016-09-01 12:50:58,653 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.map.MapLoader - Loading define for name=dataSource
log4j: 2016-09-01 12:50:58,658 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
log4j: 2016-09-01 12:50:58,658 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'dataSource'<>
log4j: 2016-09-01 12:50:58,669 [localhost-startStop-1] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class com.alibaba.druid.pool.DruidDataSource without AOP
log4j: 2016-09-01 12:50:58,669 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'dataSource' to [app] 
log4j: 2016-09-01 12:50:58,682 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 12:50:58,683 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=conf
log4j: 2016-09-01 12:50:58,683 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.map.MapLoader - Loading define for name=conf
log4j: 2016-09-01 12:50:58,683 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(conf) in JsonLoader(paths=[ioc/])
log4j: 2016-09-01 12:50:58,683 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'conf'<>
log4j: 2016-09-01 12:50:58,683 [localhost-startStop-1] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class org.nutz.ioc.impl.PropertiesProxy without AOP
log4j: 2016-09-01 12:50:58,683 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'conf' to [app] 
log4j: 2016-09-01 12:50:58,685 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 3 resource by src( custom/ ) , regex( ^.+[.]properties$ )
log4j: 2016-09-01 12:50:58,688 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 12:50:58,688 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 12:50:58,689 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 12:50:58,689 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 12:50:58,734 [localhost-startStop-1] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
log4j: 2016-09-01 12:50:58,735 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dataSource'<>
log4j: 2016-09-01 12:50:58,741 [localhost-startStop-1] DEBUG org.nutz.dao.impl.NutDao - NutDao[_selfId=0] init ...
log4j: 2016-09-01 12:50:58,755 [localhost-startStop-1] INFO  org.nutz.filepool.NutFilePool - Init file-pool by: /Users/crackerciwei/.nutz/tmp/dao/ [200000]
log4j: 2016-09-01 12:50:58,755 [localhost-startStop-1] DEBUG org.nutz.filepool.NutFilePool - file-pool.home: '/Users/crackerciwei/.nutz/tmp/dao'
log4j: 2016-09-01 12:50:58,758 [localhost-startStop-1] INFO  org.nutz.filepool.NutFilePool - file-pool.cursor: 3
log4j: 2016-09-01 12:50:58,764 [localhost-startStop-1] DEBUG org.nutz.dao.jdbc.Jdbcs - Jdbcs init complete
log4j: 2016-09-01 12:50:58,764 [localhost-startStop-1] INFO  org.nutz.dao.jdbc.Jdbcs - Get Connection from DataSource for JdbcExpert, if I lock at here, check your database server and configure
log4j: 2016-09-01 12:50:59,104 [localhost-startStop-1] DEBUG org.nutz.dao.impl.DaoSupport - JDBC Driver --> 3.0.1119.0
log4j: 2016-09-01 12:50:59,104 [localhost-startStop-1] DEBUG org.nutz.dao.impl.DaoSupport - JDBC Name   --> Microsoft SQL Server JDBC Driver 3.0
log4j: 2016-09-01 12:50:59,105 [localhost-startStop-1] DEBUG org.nutz.dao.impl.DaoSupport - JDBC URL    --> jdbc:sqlserver://192.168.1.250:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=cms;applicationName=Microsoft SQL Server JDBC Driver;
log4j: 2016-09-01 12:50:59,105 [localhost-startStop-1] DEBUG org.nutz.dao.impl.DaoSupport - Database info --> SQLSERVER:[Microsoft SQL Server - 10.00.1600]
log4j: 2016-09-01 12:50:59,166 [localhost-startStop-1] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT COUNT(*) FROM v_tUser 
log4j: 2016-09-01 12:50:59,193 [localhost-startStop-1] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - call pnextid('tablename')
log4j: 2016-09-01 12:50:59,221 [localhost-startStop-1] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - SQLException
com.microsoft.sqlserver.jdbc.SQLServerException: 'tablename' 附近有语法错误。
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:127)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
	at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
	at net.crackerciwei.cms.MainSetup.init(MainSetup.java:31)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
	at net.crackerciwei.cms.mvc.LfcmsNutFilter.init(LfcmsNutFilter.java:17)
	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:4841)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
log4j: 2016-09-01 12:50:59,240 [localhost-startStop-1] ERROR org.nutz.mvc.impl.NutLoading - Error happend during start serivce!
org.nutz.dao.DaoException: !Nutz SQL Error: 'call pnextid('tablename')'
PreparedStatement: 
'call pnextid('tablename')'
CaseMessage='tablename' 附近有语法错误。
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:96)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
	at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
	at net.crackerciwei.cms.MainSetup.init(MainSetup.java:31)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
	at net.crackerciwei.cms.mvc.LfcmsNutFilter.init(LfcmsNutFilter.java:17)
	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:4841)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 'tablename' 附近有语法错误。
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:127)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	... 27 more
log4j: 2016-09-01 12:50:59,241 [localhost-startStop-1] ERROR org.nutz.mvc.impl.NutLoading - try to depose ioc
log4j: 2016-09-01 12:50:59,244 [localhost-startStop-1] INFO  org.nutz.ioc.impl.NutIoc - org.nutz.ioc.impl.NutIoc@1939930861 is closing. startup date [16-09-01 12:50:58.535]
log4j: 2016-09-01 12:50:59,244 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Depose object 'dataSource' ...
log4j: 2016-09-01 12:50:59,246 [localhost-startStop-1] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closed
log4j: 2016-09-01 12:50:59,246 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Depose object 'dao' ...
log4j: 2016-09-01 12:50:59,246 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Depose object 'conf' ...
log4j: 2016-09-01 12:50:59,246 [localhost-startStop-1] INFO  org.nutz.ioc.impl.NutIoc - org.nutz.ioc.impl.NutIoc@1939930861 is deposed. startup date [16-09-01 12:50:58.535]
九月 01, 2016 12:50:59 下午 org.apache.catalina.core.StandardContext filterStart
严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.dao.DaoException: !Nutz SQL Error: 'call pnextid('tablename')'
PreparedStatement: 
'call pnextid('tablename')'
CaseMessage='tablename' 附近有语法错误。
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:17)
	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:169)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:134)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
	at net.crackerciwei.cms.mvc.LfcmsNutFilter.init(LfcmsNutFilter.java:17)
	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:4841)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'call pnextid('tablename')'
PreparedStatement: 
'call pnextid('tablename')'
CaseMessage='tablename' 附近有语法错误。
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:96)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
	at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
	at net.crackerciwei.cms.MainSetup.init(MainSetup.java:31)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
	... 16 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 'tablename' 附近有语法错误。
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:127)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	... 27 more

九月 01, 2016 12:50:59 下午 org.apache.catalina.core.StandardContext startInternal
严重: One or more Filters failed to start. Full details will be found in the appropriate container log file
九月 01, 2016 12:50:59 下午 org.apache.catalina.core.StandardContext startInternal
严重: Context [/lfcms] startup failed due to previous errors
九月 01, 2016 12:50:59 下午 org.apache.catalina.core.ApplicationContext log
信息: Cleaning up Shiro Environment
九月 01, 2016 12:50:59 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/lfcms] 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.
九月 01, 2016 12:50:59 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/lfcms] registered the JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
九月 01, 2016 12:50:59 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8080"]
九月 01, 2016 12:50:59 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
九月 01, 2016 12:50:59 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 2803 ms

瞎折腾(qq_b8d02b2c) 5楼•2997天前

@wendal 存储过程挺复杂的，还做了其他事儿，我只是把最关键的部分摘出来了

wendal

6楼•2997天前

试试这样写:

@Prev(@SQL("call nextid(@table)"))

瞎折腾(qq_b8d02b2c) 7楼•2997天前

@wendal 还是不行。

九月 01, 2016 1:14:54 下午 org.apache.tomcat.util.digester.SetPropertiesRule begin
警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:lfcms' did not find a matching property.
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server version:        Apache Tomcat/7.0.65
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server built:          Oct 9 2015 08:36:58 UTC
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Server number:         7.0.65.0
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Name:               Mac OS X
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: OS Version:            10.9.5
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Architecture:          x86_64
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Java Home:             /Library/Java/JavaVirtualMachines/jdk1.7.0_80.jdk/Contents/Home/jre
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Version:           1.7.0_80-b15
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: JVM Vendor:            Oracle Corporation
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_BASE:         /Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: CATALINA_HOME:         /Users/crackerciwei/apache-tomcat-7.0.65
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.base=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dcatalina.home=/Users/crackerciwei/apache-tomcat-7.0.65
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dwtp.deploy=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Djava.endorsed.dirs=/Users/crackerciwei/apache-tomcat-7.0.65/endorsed
九月 01, 2016 1:14:54 下午 org.apache.catalina.startup.VersionLoggerListener log
信息: Command line argument: -Dfile.encoding=UTF-8
九月 01, 2016 1:14: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: /Users/crackerciwei/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.
九月 01, 2016 1:14:55 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["http-bio-8080"]
九月 01, 2016 1:14:55 下午 org.apache.coyote.AbstractProtocol init
信息: Initializing ProtocolHandler ["ajp-bio-8009"]
九月 01, 2016 1:14:55 下午 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 650 ms
九月 01, 2016 1:14:55 下午 org.apache.catalina.core.StandardService startInternal
信息: Starting service Catalina
九月 01, 2016 1:14:55 下午 org.apache.catalina.core.StandardEngine startInternal
信息: Starting Servlet Engine: Apache Tomcat/7.0.65
九月 01, 2016 1:14:56 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/core is already defined
九月 01, 2016 1:14:56 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
九月 01, 2016 1:14:56 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
九月 01, 2016 1:14:56 下午 org.apache.catalina.startup.TaglibUriRule body
信息: TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
九月 01, 2016 1:14:56 下午 org.apache.catalina.startup.TldConfig execute
信息: 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.
九月 01, 2016 1:14:56 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Shiro environment
log4j: 2016-09-01 13:14:56,500 [localhost-startStop-1] INFO  org.apache.shiro.web.env.EnvironmentLoader - Starting Shiro environment initialization.
log4j: 2016-09-01 13:14:56,511 [localhost-startStop-1] DEBUG org.apache.shiro.web.env.IniWebEnvironment - Checking any specified config locations.
log4j: 2016-09-01 13:14:56,511 [localhost-startStop-1] DEBUG org.apache.shiro.web.env.IniWebEnvironment - No INI instance or config locations specified.  Trying default config locations.
log4j: 2016-09-01 13:14:56,515 [localhost-startStop-1] DEBUG org.apache.shiro.io.ResourceUtils - Opening resource from class path [shiro.ini]
log4j: 2016-09-01 13:14:56,519 [localhost-startStop-1] DEBUG org.apache.shiro.config.Ini - Parsing [main]
log4j: 2016-09-01 13:14:56,519 [localhost-startStop-1] DEBUG org.apache.shiro.config.Ini - Parsing [urls]
log4j: 2016-09-01 13:14:56,521 [localhost-startStop-1] DEBUG org.apache.shiro.web.env.IniWebEnvironment - Discovered non-empty INI configuration at location 'classpath:shiro.ini'.  Using for configuration.
log4j: 2016-09-01 13:14:56,524 [localhost-startStop-1] DEBUG org.apache.shiro.config.IniFactorySupport - Creating instance from Ini [sections=urls]
log4j: 2016-09-01 13:14:56,562 [localhost-startStop-1] DEBUG org.apache.shiro.config.IniFactorySupport - Creating instance from Ini [sections=urls]
log4j: 2016-09-01 13:14:56,564 [localhost-startStop-1] DEBUG org.apache.shiro.web.filter.mgt.DefaultFilterChainManager - Creating chain [/rs/*] from String definition [anon]
log4j: 2016-09-01 13:14:56,564 [localhost-startStop-1] DEBUG org.apache.shiro.web.filter.mgt.DefaultFilterChainManager - Attempting to apply path [/rs/*] to filter [anon] with config [null]
log4j: 2016-09-01 13:14:56,565 [localhost-startStop-1] DEBUG org.apache.shiro.web.env.EnvironmentLoader - Published WebEnvironment as ServletContext attribute with name [org.apache.shiro.web.env.EnvironmentLoader.ENVIRONMENT_ATTRIBUTE_KEY]
log4j: 2016-09-01 13:14:56,565 [localhost-startStop-1] INFO  org.apache.shiro.web.env.EnvironmentLoader - Shiro environment initialized in 65 ms.
log4j: 2016-09-01 13:14:56,586 [localhost-startStop-1] INFO  net.crackerciwei.cms.mvc.LfcmsNutFilter - NutFilter[nutz] starting ...
log4j: 2016-09-01 13:14:56,692 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Locations for Scans:
[FileSystemResourceLocation [root=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/classes], JarResourceLocation [jarPath=/Users/crackerciwei/apache-tomcat-7.0.65/bin/tomcat-juli.jar], JarResourceLocation [jarPath=/Library/Java/JavaVirtualMachines/jdk1.7.0_80.jdk/Contents/Home/lib/tools.jar], FileSystemResourceLocation [root=/Users/crackerciwei/EclipseMars/Eclipse.app/Contents/MacOS], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutz-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/apache-tomcat-7.0.65/bin/bootstrap.jar]]
log4j: 2016-09-01 13:14:56,931 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Locations for Scans:
[FileSystemResourceLocation [root=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/classes], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/commons-lang3-3.4.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/quartz-2.2.2.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/commons-beanutils-1.9.2.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/simplecaptcha-1.2.2.jar], FileSystemResourceLocation [root=/Users/crackerciwei/EclipseMars/Eclipse.app/Contents/MacOS], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/commons-logging-1.2.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/taglibs-standard-impl-1.2.5.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/taglibs-standard-compat-1.2.5.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/mysql-connector-java-5.1.37.jar], JarResourceLocation [jarPath=/Library/Java/JavaVirtualMachines/jdk1.7.0_80.jdk/Contents/Home/lib/tools.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/druid-1.0.16.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/taglibs-standard-spec-1.2.5.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/slf4j-api-1.7.7.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/javax.servlet.jsp.jstl-api-1.2.1.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/emoji-java-3.1.3.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutz-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutz-integration-shiro-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/apache-tomcat-7.0.65/bin/tomcat-juli.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/c3p0-0.9.1.1.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/quartz-jobs-2.2.2.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutz-integration-quartz-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/log4j-1.2.16.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/nutzwx-1.r.57.jar], JarResourceLocation [jarPath=/Users/crackerciwei/apache-tomcat-7.0.65/bin/bootstrap.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/sqljdbc4.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/slf4j-log4j12-1.7.7.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/taglibs-standard-jstlel-1.2.5.jar], JarResourceLocation [jarPath=/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/lib/shiro-all-1.2.4.jar]]
log4j: 2016-09-01 13:14:56,942 [localhost-startStop-1] DEBUG org.nutz.mvc.config.AbstractNutConfig - MainModule: <net.crackerciwei.cms.MainModule>
log4j: 2016-09-01 13:14:56,961 [localhost-startStop-1] DEBUG org.nutz.mvc.config.AbstractNutConfig - Loading by class org.nutz.mvc.impl.NutLoading
log4j: 2016-09-01 13:14:56,962 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Nutz Version : 1.r.57 
log4j: 2016-09-01 13:14:56,962 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Nutz.Mvc[nutz] is initializing ...
log4j: 2016-09-01 13:14:56,962 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - Web Container Information:
log4j: 2016-09-01 13:14:56,986 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Default Charset : UTF-8
log4j: 2016-09-01 13:14:56,986 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Current . path  : /Users/crackerciwei/EclipseMars/Eclipse.app/Contents/MacOS/.
log4j: 2016-09-01 13:14:56,987 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Java Version    : 1.7.0_80
log4j: 2016-09-01 13:14:56,987 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - File separator  : /
log4j: 2016-09-01 13:14:56,987 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Timezone        : Asia/Shanghai
log4j: 2016-09-01 13:14:56,987 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - OS              : Mac OS X x86_64
log4j: 2016-09-01 13:14:56,987 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - ServerInfo      : Apache Tomcat/7.0.65
log4j: 2016-09-01 13:14:56,987 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - Servlet API     : 3.0
log4j: 2016-09-01 13:14:56,987 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - ContextPath     : /lfcms
log4j: 2016-09-01 13:14:56,987 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading -  - context.tempdir : /Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/work/Catalina/localhost/lfcms
log4j: 2016-09-01 13:14:56,988 [localhost-startStop-1] DEBUG org.nutz.mvc.config.AbstractNutConfig - MainModule: <net.crackerciwei.cms.MainModule>
log4j: 2016-09-01 13:14:56,988 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - >> app.root = /Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms
log4j: 2016-09-01 13:14:57,035 [localhost-startStop-1] DEBUG org.nutz.castor.Castors - Using 94 castor for Castors
log4j: 2016-09-01 13:14:57,037 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - @IocBy(type=org.nutz.mvc.ioc.provider.ComboIocProvider, args=["*js", "ioc/", "*anno", "net.crackerciwei.cms", "*tx", "*org.nutz.integration.quartz.QuartzIocLoader"],init=[])
log4j: 2016-09-01 13:14:57,057 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 1 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
log4j: 2016-09-01 13:14:57,058 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.json.JsonLoader - loading ioc js config from [dao.js]
log4j: 2016-09-01 13:14:57,063 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.json.JsonLoader - Loaded 3 bean define from path=[ioc/] --> [dataSource, dao, conf]
log4j: 2016-09-01 13:14:57,084 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 30 resource by src( net/crackerciwei/cms/ ) , regex( ^.+[.]class$ )
log4j: 2016-09-01 13:14:57,136 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.CaptchaModule
log4j: 2016-09-01 13:14:57,139 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.IndexModule
log4j: 2016-09-01 13:14:57,144 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.MemberModule
log4j: 2016-09-01 13:14:57,145 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.NewsClassModule
log4j: 2016-09-01 13:14:57,147 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.NewsModule
log4j: 2016-09-01 13:14:57,152 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.RoleModule
log4j: 2016-09-01 13:14:57,153 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.TemplateModule
log4j: 2016-09-01 13:14:57,157 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.UserModule
log4j: 2016-09-01 13:14:57,160 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.module.WeixinModule
log4j: 2016-09-01 13:14:57,161 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.quartz.job.UpdateCacheJob
log4j: 2016-09-01 13:14:57,163 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.service.NewsClassService
log4j: 2016-09-01 13:14:57,166 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.service.NewsService
log4j: 2016-09-01 13:14:57,166 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.service.UserService
log4j: 2016-09-01 13:14:57,167 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found @IocBean : class net.crackerciwei.cms.util.WxHandler
log4j: 2016-09-01 13:14:57,175 [localhost-startStop-1] INFO  org.nutz.ioc.loader.annotation.AnnotationIocLoader - Found 14 classes in 1 base-packages!
beans = ["newsService", "indexModule", "userService", "memberModule", "newsClassService", "userModule", "weixinModule", "captchaModule", "templateModule", "updateCacheJob", "roleModule", "newsModule", "wxHandler", "newsClassModule"]
log4j: 2016-09-01 13:14:57,177 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.json.JsonLoader - Loaded 5 bean define from reader --
[txREPEATABLE_READ, txREAD_COMMITTED, txNONE, txSERIALIZABLE, txREAD_UNCOMMITTED]
log4j: 2016-09-01 13:14:57,181 [localhost-startStop-1] INFO  org.nutz.ioc.impl.NutIoc - NutIoc init begin ...
log4j: 2016-09-01 13:14:57,183 [localhost-startStop-1] INFO  org.nutz.ioc.impl.NutIoc - ... NutIoc init complete
log4j: 2016-09-01 13:14:57,183 [localhost-startStop-1] DEBUG org.nutz.mvc.config.AbstractNutConfig - MainModule: <net.crackerciwei.cms.MainModule>
log4j: 2016-09-01 13:14:57,185 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
log4j: 2016-09-01 13:14:57,186 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - @Views(DefaultViewMaker.class)
log4j: 2016-09-01 13:14:57,191 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 1 resource by src( mvc/nutzbook-mvc-chain.js ) , regex( ^(.+[.])(js|json)$ )
log4j: 2016-09-01 13:14:57,197 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.chainconfig.JsonActionChainMakerConfiguretion - ActionChain Config:
{
   "default" :{
      "ps" :["net.crackerciwei.cms.mvc.LogTimeProcessor", "org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor", "org.nutz.mvc.impl.processor.EncodingProcessor", "org.nutz.mvc.impl.processor.ModuleProcessor", "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"
   }
}
log4j: 2016-09-01 13:14:57,197 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - @ChainBy(org.nutz.mvc.impl.NutActionChainMaker)
log4j: 2016-09-01 13:14:57,200 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings - module class location 'file:/Users/crackerciwei/workspace2015/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/lfcms/WEB-INF/classes/'
log4j: 2016-09-01 13:14:57,200 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -  > scan 'net.crackerciwei.cms'
log4j: 2016-09-01 13:14:57,207 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 30 resource by src( net/crackerciwei/cms/ ) , regex( ^.+[.]class$ )
log4j: 2016-09-01 13:14:57,209 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.CaptchaModule'
log4j: 2016-09-01 13:14:57,209 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.IndexModule'
log4j: 2016-09-01 13:14:57,209 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.MemberModule'
log4j: 2016-09-01 13:14:57,209 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.NewsClassModule'
log4j: 2016-09-01 13:14:57,209 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.NewsModule'
log4j: 2016-09-01 13:14:57,210 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.RoleModule'
log4j: 2016-09-01 13:14:57,210 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.TemplateModule'
log4j: 2016-09-01 13:14:57,210 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.UserModule'
log4j: 2016-09-01 13:14:57,210 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.Loadings -    >> add 'net.crackerciwei.cms.module.WeixinModule'
log4j: 2016-09-01 13:14:57,243 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/add'                 >> UserModule.add(...)            : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,244 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/count'               >> UserModule.count(...)          : int        | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,245 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/list'                >> UserModule.list(...)           : Map        | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,251 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/'                    >> UserModule.index(...)          : void       | @Ok(jsp:jsp.user.index) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,252 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/delete'              >> UserModule.delete(...)         : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,256 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/query'               >> UserModule.query(...)          : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,258 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/modify'              >> UserModule.modify(...)         : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,260 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/login'               >> UserModule.login(...)          : Object     | @Ok(json:{locked:'Password',ignoreNull:true}) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,261 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/logout'              >> UserModule.logout(...)         : void       | @Ok(>>:/ ) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,261 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/loginPage'           >> UserModule.loginPage(...)      : void       | @Ok(jsp:jsp.user.login) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,262 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/user/manage'              >> UserModule.manage(...)         : void       | @Ok(jsp:jsp.user.user) @Fail(http:500) | by 1 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,263 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/add'               >> MemberModule.add(...)          : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,264 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/list'              >> MemberModule.list(...)         : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,264 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/delete'            >> MemberModule.delete(...)       : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,265 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/modify'            >> MemberModule.modify(...)       : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,268 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/member/manage'            >> MemberModule.manage(...)       : void       | @Ok(jsp:jsp.user.member) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,282 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/index'                    >> IndexModule.index(...)         : Map        | @Ok(jsp:jsp.front.${obj.template}.index) @Fail(jsp:jsp.500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,284 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/commonjs'                 >> IndexModule.commonjs(...)      : Object     | @Ok(raw:js) @Fail(jsp:jsp.500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,285 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/captcha/next'             >> CaptchaModule.next(...)        : BufferedImage | @Ok(raw:png) @Fail(jsp:jsp.500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,286 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/add'             >> TemplateModule.add(...)        : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,287 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/list'            >> TemplateModule.list(...)       : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,287 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/delete'          >> TemplateModule.delete(...)     : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,288 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/modify'          >> TemplateModule.modify(...)     : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,289 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/template/manage'          >> TemplateModule.manage(...)     : void       | @Ok(jsp:jsp.user.template) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,292 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/weixin/api', '/weixin/api/?' >> WeixinModule.msgIn(...)        : View       | @Ok(json:full) @Fail(http:200) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,293 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/weixin/test', '/weixin/test/?' >> WeixinModule.test(...)         : String     | @Ok(json:full) @Fail(http:200) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,295 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/add'            >> NewsClassModule.add(...)       : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,296 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/list'           >> NewsClassModule.list(...)      : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,296 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/delete'         >> NewsClassModule.delete(...)    : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,297 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/modify'         >> NewsClassModule.modify(...)    : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,298 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/newsclass/manage'         >> NewsClassModule.manage(...)    : void       | @Ok(jsp:jsp.user.newsclass) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,299 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/role/list'                >> RoleModule.list(...)           : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,300 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/role/manage'              >> RoleModule.manage(...)         : void       | @Ok(jsp:jsp.user.role) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,301 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/add'                 >> NewsModule.add(...)            : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,301 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/type'                >> NewsModule.type(...)           : Map        | @Ok(jsp:jsp.front.${obj.template}.type) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,302 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/list'                >> NewsModule.list(...)           : Map        | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,303 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/delete'              >> NewsModule.delete(...)         : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,304 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/check'               >> NewsModule.check(...)          : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,305 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/query'               >> NewsModule.query(...)          : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,306 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/modify'              >> NewsModule.modify(...)         : Object     | @Ok(json:full) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,307 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/manage'              >> NewsModule.manage(...)         : void       | @Ok(jsp:jsp.user.news) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,308 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/img/?'               >> NewsModule.img(...)            : Object     | @Ok(raw:jpg) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,310 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.UrlMappingImpl -    '/news/detail/?'            >> NewsModule.detail(...)         : Map        | @Ok(jsp:jsp.front.${obj.template}.detail) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
log4j: 2016-09-01 13:14:57,310 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Found 43 module methods
log4j: 2016-09-01 13:14:57,310 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutLoading - Localization: org.nutz.mvc.impl.NutMessageLoader('msg/')  dft<zh-CN>
log4j: 2016-09-01 13:14:57,316 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 1 resource by src( msg/ ) , regex( ^.+[.]properties$ )
log4j: 2016-09-01 13:14:57,316 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutMessageLoader - Load Messages in 1 resource : [[NutResource[zh-CN/user.properties]]]
log4j: 2016-09-01 13:14:57,358 [localhost-startStop-1] DEBUG org.nutz.mvc.impl.NutMessageLoader - Message Loaded, size = 2
log4j: 2016-09-01 13:14:57,358 [localhost-startStop-1] INFO  org.nutz.mvc.impl.NutLoading - Setup application...
log4j: 2016-09-01 13:14:57,359 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dao'<interface org.nutz.dao.Dao>
log4j: 2016-09-01 13:14:57,361 [localhost-startStop-1] DEBUG org.nutz.ioc.aop.SimpleAopMaker - Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
log4j: 2016-09-01 13:14:57,361 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=dao
log4j: 2016-09-01 13:14:57,362 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.map.MapLoader - Loading define for name=dao
log4j: 2016-09-01 13:14:57,365 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(dao) in JsonLoader(paths=[ioc/])
log4j: 2016-09-01 13:14:57,366 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'dao'<interface org.nutz.dao.Dao>
log4j: 2016-09-01 13:14:57,373 [localhost-startStop-1] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class org.nutz.dao.impl.NutDao without AOP
log4j: 2016-09-01 13:14:57,374 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'dao' to [app] 
log4j: 2016-09-01 13:14:57,375 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dataSource'<>
log4j: 2016-09-01 13:14:57,375 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=dataSource
log4j: 2016-09-01 13:14:57,375 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.map.MapLoader - Loading define for name=dataSource
log4j: 2016-09-01 13:14:57,382 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
log4j: 2016-09-01 13:14:57,382 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'dataSource'<>
log4j: 2016-09-01 13:14:57,397 [localhost-startStop-1] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class com.alibaba.druid.pool.DruidDataSource without AOP
log4j: 2016-09-01 13:14:57,397 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'dataSource' to [app] 
log4j: 2016-09-01 13:14:57,412 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 13:14:57,412 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=conf
log4j: 2016-09-01 13:14:57,412 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.map.MapLoader - Loading define for name=conf
log4j: 2016-09-01 13:14:57,412 [localhost-startStop-1] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(conf) in JsonLoader(paths=[ioc/])
log4j: 2016-09-01 13:14:57,412 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'conf'<>
log4j: 2016-09-01 13:14:57,413 [localhost-startStop-1] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class org.nutz.ioc.impl.PropertiesProxy without AOP
log4j: 2016-09-01 13:14:57,413 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'conf' to [app] 
log4j: 2016-09-01 13:14:57,415 [localhost-startStop-1] DEBUG org.nutz.resource.Scans - Found 3 resource by src( custom/ ) , regex( ^.+[.]properties$ )
log4j: 2016-09-01 13:14:57,419 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 13:14:57,419 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 13:14:57,419 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 13:14:57,419 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<>
log4j: 2016-09-01 13:14:57,451 [localhost-startStop-1] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
log4j: 2016-09-01 13:14:57,451 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dataSource'<>
log4j: 2016-09-01 13:14:57,456 [localhost-startStop-1] DEBUG org.nutz.dao.impl.NutDao - NutDao[_selfId=0] init ...
log4j: 2016-09-01 13:14:57,469 [localhost-startStop-1] INFO  org.nutz.filepool.NutFilePool - Init file-pool by: /Users/crackerciwei/.nutz/tmp/dao/ [200000]
log4j: 2016-09-01 13:14:57,470 [localhost-startStop-1] DEBUG org.nutz.filepool.NutFilePool - file-pool.home: '/Users/crackerciwei/.nutz/tmp/dao'
log4j: 2016-09-01 13:14:57,472 [localhost-startStop-1] INFO  org.nutz.filepool.NutFilePool - file-pool.cursor: 3
log4j: 2016-09-01 13:14:57,478 [localhost-startStop-1] DEBUG org.nutz.dao.jdbc.Jdbcs - Jdbcs init complete
log4j: 2016-09-01 13:14:57,478 [localhost-startStop-1] INFO  org.nutz.dao.jdbc.Jdbcs - Get Connection from DataSource for JdbcExpert, if I lock at here, check your database server and configure
log4j: 2016-09-01 13:14:57,812 [localhost-startStop-1] DEBUG org.nutz.dao.impl.DaoSupport - JDBC Driver --> 3.0.1119.0
log4j: 2016-09-01 13:14:57,812 [localhost-startStop-1] DEBUG org.nutz.dao.impl.DaoSupport - JDBC Name   --> Microsoft SQL Server JDBC Driver 3.0
log4j: 2016-09-01 13:14:57,812 [localhost-startStop-1] DEBUG org.nutz.dao.impl.DaoSupport - JDBC URL    --> jdbc:sqlserver://192.168.1.250:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=cms;applicationName=Microsoft SQL Server JDBC Driver;
log4j: 2016-09-01 13:14:57,812 [localhost-startStop-1] DEBUG org.nutz.dao.impl.DaoSupport - Database info --> SQLSERVER:[Microsoft SQL Server - 10.00.1600]
log4j: 2016-09-01 13:14:57,862 [localhost-startStop-1] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT COUNT(*) FROM v_tUser 
log4j: 2016-09-01 13:14:57,876 [localhost-startStop-1] ERROR org.nutz.mvc.impl.NutLoading - Error happend during start serivce!
java.lang.NullPointerException
	at org.nutz.dao.impl.entity.macro.SqlFieldMacro.setOperatingObject(SqlFieldMacro.java:55)
	at org.nutz.dao.impl.EntityOperator.addInsert(EntityOperator.java:164)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:145)
	at net.crackerciwei.cms.MainSetup.init(MainSetup.java:31)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
	at net.crackerciwei.cms.mvc.LfcmsNutFilter.init(LfcmsNutFilter.java:17)
	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:4841)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
log4j: 2016-09-01 13:14:57,877 [localhost-startStop-1] ERROR org.nutz.mvc.impl.NutLoading - try to depose ioc
log4j: 2016-09-01 13:14:57,879 [localhost-startStop-1] INFO  org.nutz.ioc.impl.NutIoc - org.nutz.ioc.impl.NutIoc@306941945 is closing. startup date [16-09-01 13:14:57.181]
log4j: 2016-09-01 13:14:57,879 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Depose object 'dataSource' ...
log4j: 2016-09-01 13:14:57,881 [localhost-startStop-1] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closed
log4j: 2016-09-01 13:14:57,881 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Depose object 'dao' ...
log4j: 2016-09-01 13:14:57,881 [localhost-startStop-1] DEBUG org.nutz.ioc.impl.ScopeContext - Depose object 'conf' ...
log4j: 2016-09-01 13:14:57,881 [localhost-startStop-1] INFO  org.nutz.ioc.impl.NutIoc - org.nutz.ioc.impl.NutIoc@306941945 is deposed. startup date [16-09-01 13:14:57.181]
九月 01, 2016 1:14:57 下午 org.apache.catalina.core.StandardContext filterStart
严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: java.lang.NullPointerException
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:17)
	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:169)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:134)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
	at net.crackerciwei.cms.mvc.LfcmsNutFilter.init(LfcmsNutFilter.java:17)
	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:4841)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
	at org.nutz.dao.impl.entity.macro.SqlFieldMacro.setOperatingObject(SqlFieldMacro.java:55)
	at org.nutz.dao.impl.EntityOperator.addInsert(EntityOperator.java:164)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:145)
	at net.crackerciwei.cms.MainSetup.init(MainSetup.java:31)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
	... 16 more

九月 01, 2016 1:14:57 下午 org.apache.catalina.core.StandardContext startInternal
严重: One or more Filters failed to start. Full details will be found in the appropriate container log file
九月 01, 2016 1:14:57 下午 org.apache.catalina.core.StandardContext startInternal
严重: Context [/lfcms] startup failed due to previous errors
九月 01, 2016 1:14:57 下午 org.apache.catalina.core.ApplicationContext log
信息: Cleaning up Shiro Environment
九月 01, 2016 1:14:57 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/lfcms] 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.
九月 01, 2016 1:14:57 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/lfcms] registered the JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
九月 01, 2016 1:14:57 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8080"]
九月 01, 2016 1:14:57 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
九月 01, 2016 1:14:57 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 2853 ms

wendal

8楼•2997天前

稍等,我提交个修改,然后你用快照版试试吧

瞎折腾(qq_b8d02b2c) 9楼•2997天前

@wendal 谢谢啦

wendal

10楼•2997天前

或者换个方式, 把入参去掉,看看能不能行

瞎折腾(qq_b8d02b2c) 11楼•2997天前

@wendal
写成

@Prev(@SQL("call nextid()"))

日志是这样的

九月 01, 2016 1:33:23 下午 org.apache.catalina.core.StandardContext filterStart
严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.dao.DaoException: !Nutz SQL Error: 'call nextid()'
PreparedStatement: 
'call nextid()'
CaseMessage=')' 附近有语法错误。
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:17)
	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:169)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:134)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
	at net.crackerciwei.cms.mvc.LfcmsNutFilter.init(LfcmsNutFilter.java:17)
	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:4841)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'call nextid()'
PreparedStatement: 
'call nextid()'
CaseMessage=')' 附近有语法错误。
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:96)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
	at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
	at net.crackerciwei.cms.MainSetup.init(MainSetup.java:31)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
	... 16 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: ')' 附近有语法错误。
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:127)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	... 27 more

九月 01, 2016 1:33:23 下午 org.apache.catalina.core.StandardContext startInternal
严重: One or more Filters failed to start. Full details will be found in the appropriate container log file
九月 01, 2016 1:33:23 下午 org.apache.catalina.core.StandardContext startInternal
严重: Context [/lfcms] startup failed due to previous errors
九月 01, 2016 1:33:23 下午 org.apache.catalina.core.ApplicationContext log
信息: Cleaning up Shiro Environment
九月 01, 2016 1:33:23 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/lfcms] 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.
九月 01, 2016 1:33:23 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/lfcms] registered the JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
九月 01, 2016 1:33:23 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8080"]
九月 01, 2016 1:33:23 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
九月 01, 2016 1:33:23 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 2622 ms

wendal

12楼•2997天前

奇怪,为啥报语法错误呢

瞎折腾(qq_b8d02b2c) 13楼•2997天前

@wendal
我先把存储过程参数去掉了，然后写成

@Prev(@SQL("call nextid()"))

日志是这样的

九月 01, 2016 1:33:23 下午 org.apache.catalina.core.StandardContext filterStart
严重: Exception starting filter nutz
org.nutz.mvc.LoadingException: org.nutz.dao.DaoException: !Nutz SQL Error: 'call nextid()'
PreparedStatement: 
'call nextid()'
CaseMessage=')' 附近有语法错误。
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at org.nutz.lang.born.ConstructorBorning.born(ConstructorBorning.java:17)
	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:169)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:134)
	at org.nutz.mvc.ActionHandler.<init>(ActionHandler.java:19)
	at org.nutz.mvc.NutFilter._init(NutFilter.java:87)
	at org.nutz.mvc.NutFilter.init(NutFilter.java:65)
	at net.crackerciwei.cms.mvc.LfcmsNutFilter.init(LfcmsNutFilter.java:17)
	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:4841)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5535)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1574)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1564)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.nutz.dao.DaoException: !Nutz SQL Error: 'call nextid()'
PreparedStatement: 
'call nextid()'
CaseMessage=')' 附近有语法错误。
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:96)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
	at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
	at net.crackerciwei.cms.MainSetup.init(MainSetup.java:31)
	at org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:276)
	at org.nutz.mvc.impl.NutLoading.load(NutLoading.java:120)
	... 16 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: ')' 附近有语法错误。
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:127)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	... 27 more

九月 01, 2016 1:33:23 下午 org.apache.catalina.core.StandardContext startInternal
严重: One or more Filters failed to start. Full details will be found in the appropriate container log file
九月 01, 2016 1:33:23 下午 org.apache.catalina.core.StandardContext startInternal
严重: Context [/lfcms] startup failed due to previous errors
九月 01, 2016 1:33:23 下午 org.apache.catalina.core.ApplicationContext log
信息: Cleaning up Shiro Environment
九月 01, 2016 1:33:23 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/lfcms] 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.
九月 01, 2016 1:33:23 下午 org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
严重: The web application [/lfcms] registered the JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
九月 01, 2016 1:33:23 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["http-bio-8080"]
九月 01, 2016 1:33:23 下午 org.apache.coyote.AbstractProtocol start
信息: Starting ProtocolHandler ["ajp-bio-8009"]
九月 01, 2016 1:33:23 下午 org.apache.catalina.startup.Catalina start
信息: Server startup in 2622 ms

wendal

14楼•2997天前

... 是这样吧

@Prev(@SQL("{call nextid()}"))

瞎折腾(qq_b8d02b2c) 15楼•2997天前

@wendal T_T 是的，这么写才行

瞎折腾(qq_b8d02b2c) 16楼•2997天前

@wendal 可是这样没办法传参数啊

wendal

17楼•2997天前

试试传参.

@Prev(@SQL("{call nextid('tablename')} "))

瞎折腾(qq_b8d02b2c) 18楼•2997天前

@wendal

log4j: 2016-09-01 16:02:29,439 [http-bio-8080-exec-7] DEBUG org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [GET] path=/weixin/test : WeixinModule.test(WeixinModule.java:41)
log4j: 2016-09-01 16:02:29,439 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.NutIoc - Get 'weixinModule'<class net.lfsoft.cms.module.WeixinModule>
log4j: 2016-09-01 16:02:29,439 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=weixinModule
log4j: 2016-09-01 16:02:29,439 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(weixinModule) in AnnotationIocLoader(packages=[net.lfsoft.cms])
log4j: 2016-09-01 16:02:29,439 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'weixinModule'<class net.lfsoft.cms.module.WeixinModule>
log4j: 2016-09-01 16:02:29,440 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class net.lfsoft.cms.module.WeixinModule without AOP
log4j: 2016-09-01 16:02:29,440 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'weixinModule' to [app] 
log4j: 2016-09-01 16:02:29,442 [http-bio-8080-exec-7] WARN  org.nutz.weixin.util.Wxs - nutzwx DevMode=true now
log4j: 2016-09-01 16:02:29,443 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.NutIoc - Get 'wxHandler'<class net.lfsoft.cms.util.WxHandler>
log4j: 2016-09-01 16:02:29,443 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=wxHandler
log4j: 2016-09-01 16:02:29,443 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(wxHandler) in AnnotationIocLoader(packages=[net.lfsoft.cms])
log4j: 2016-09-01 16:02:29,443 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'wxHandler'<class net.lfsoft.cms.util.WxHandler>
log4j: 2016-09-01 16:02:29,444 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class net.lfsoft.cms.util.WxHandler without AOP
log4j: 2016-09-01 16:02:29,444 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'wxHandler' to [app] 
log4j: 2016-09-01 16:02:29,444 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dao'<interface org.nutz.dao.Dao>
log4j: 2016-09-01 16:02:29,444 [http-bio-8080-exec-7] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<class org.nutz.ioc.impl.PropertiesProxy>
log4j: 2016-09-01 16:02:29,468 [http-bio-8080-exec-7] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - {call nextid('wx_menu')}
log4j: 2016-09-01 16:02:29,536 [http-bio-8080-exec-7] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - SQLException
com.microsoft.sqlserver.jdbc.SQLServerException: 过程 nextid 没有参数，但却为该过程提供了参数。
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:127)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
	at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
	at net.lfsoft.cms.module.WeixinModule.test(WeixinModule.java:43)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at net.lfsoft.cms.mvc.LogTimeProcessor.process(LogTimeProcessor.java:18)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at net.lfsoft.cms.mvc.LfcmsNutFilter.doFilter(LfcmsNutFilter.java:32)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
log4j: 2016-09-01 16:02:29,572 [http-bio-8080-exec-7] DEBUG net.lfsoft.cms.mvc.LogTimeProcessor - [ GET]URI=/lfcms/weixin/test 133ms
log4j: 2016-09-01 16:02:29,572 [http-bio-8080-exec-7] WARN  org.nutz.mvc.impl.processor.FailProcessor - Error@/weixin/test :
org.nutz.dao.DaoException: !Nutz SQL Error: '{call nextid('wx_menu')}'
PreparedStatement: 
'{call nextid('wx_menu')}'
CaseMessage=过程 nextid 没有参数，但却为该过程提供了参数。
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:96)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
	at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
	at net.lfsoft.cms.module.WeixinModule.test(WeixinModule.java:43)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at net.lfsoft.cms.mvc.LogTimeProcessor.process(LogTimeProcessor.java:18)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at net.lfsoft.cms.mvc.LfcmsNutFilter.doFilter(LfcmsNutFilter.java:32)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 过程 nextid 没有参数，但却为该过程提供了参数。
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:322)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:127)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	... 60 more

瞎折腾(qq_b8d02b2c) 19楼•2997天前

@wendal 不好意思上面那个错了，这个日志才是

log4j: 2016-09-01 16:03:46,560 [http-bio-8080-exec-5] DEBUG org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [GET] path=/weixin/test : WeixinModule.test(WeixinModule.java:41)
log4j: 2016-09-01 16:03:46,560 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.NutIoc - Get 'weixinModule'<class net.lfsoft.cms.module.WeixinModule>
log4j: 2016-09-01 16:03:46,560 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=weixinModule
log4j: 2016-09-01 16:03:46,560 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(weixinModule) in AnnotationIocLoader(packages=[net.lfsoft.cms])
log4j: 2016-09-01 16:03:46,560 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'weixinModule'<class net.lfsoft.cms.module.WeixinModule>
log4j: 2016-09-01 16:03:46,561 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class net.lfsoft.cms.module.WeixinModule without AOP
log4j: 2016-09-01 16:03:46,561 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'weixinModule' to [app] 
log4j: 2016-09-01 16:03:46,563 [http-bio-8080-exec-5] WARN  org.nutz.weixin.util.Wxs - nutzwx DevMode=true now
log4j: 2016-09-01 16:03:46,564 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.NutIoc - Get 'wxHandler'<class net.lfsoft.cms.util.WxHandler>
log4j: 2016-09-01 16:03:46,564 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=wxHandler
log4j: 2016-09-01 16:03:46,564 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(wxHandler) in AnnotationIocLoader(packages=[net.lfsoft.cms])
log4j: 2016-09-01 16:03:46,564 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'wxHandler'<class net.lfsoft.cms.util.WxHandler>
log4j: 2016-09-01 16:03:46,564 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class net.lfsoft.cms.util.WxHandler without AOP
log4j: 2016-09-01 16:03:46,564 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'wxHandler' to [app] 
log4j: 2016-09-01 16:03:46,565 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dao'<interface org.nutz.dao.Dao>
log4j: 2016-09-01 16:03:46,565 [http-bio-8080-exec-5] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<class org.nutz.ioc.impl.PropertiesProxy>
log4j: 2016-09-01 16:03:46,591 [http-bio-8080-exec-5] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - {call pnextid('wx_menu')}
log4j: 2016-09-01 16:03:46,630 [http-bio-8080-exec-5] DEBUG net.lfsoft.cms.mvc.LogTimeProcessor - [ GET]URI=/lfcms/weixin/test 70ms
log4j: 2016-09-01 16:03:46,631 [http-bio-8080-exec-5] WARN  org.nutz.mvc.impl.processor.FailProcessor - Error@/weixin/test :
org.nutz.dao.DaoException: java.lang.NullPointerException
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:49)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:257)
	at org.nutz.dao.impl.DaoSupport$DaoExec.run(DaoSupport.java:324)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:294)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:158)
	at net.lfsoft.cms.module.WeixinModule.test(WeixinModule.java:43)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at net.lfsoft.cms.mvc.LogTimeProcessor.process(LogTimeProcessor.java:18)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at net.lfsoft.cms.mvc.LfcmsNutFilter.doFilter(LfcmsNutFilter.java:32)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
	at org.nutz.dao.impl.entity.macro.SqlFieldMacro.onAfter(SqlFieldMacro.java:61)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:132)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	at org.nutz.dao.impl.DaoSupport$DaoExec.invoke(DaoSupport.java:334)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:38)
	... 58 more

wendal

20楼•2997天前

你写的是这个? 带@table参数的?

@Prev(@SQL("{call nextid(@table)}"))

这个得更新到快照版才不会抛NPE, https://oss.sonatype.org/content/repositories/snapshots/org/nutz/nutz/

我是想你试试,直接传表名

@Prev(@SQL("{call nextid(\"abcdefg\")}"))

瞎折腾(qq_b8d02b2c) 21楼•2997天前

@wendal 更新了快照版：@Prev(@SQL("{call nextid(@table)}"))的日志是：

log4j: 2016-09-01 16:12:25,336 [http-bio-8080-exec-6] DEBUG org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [GET] path=/weixin/test : WeixinModule.test(WeixinModule.java:41)
log4j: 2016-09-01 16:12:25,336 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - Get 'weixinModule'<class net.lfsoft.cms.module.WeixinModule>
log4j: 2016-09-01 16:12:25,336 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=weixinModule
log4j: 2016-09-01 16:12:25,336 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(weixinModule) in AnnotationIocLoader(packages=[net.lfsoft.cms])
log4j: 2016-09-01 16:12:25,337 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'weixinModule'<class net.lfsoft.cms.module.WeixinModule>
log4j: 2016-09-01 16:12:25,337 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class net.lfsoft.cms.module.WeixinModule without AOP
log4j: 2016-09-01 16:12:25,337 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'weixinModule' to [app] 
log4j: 2016-09-01 16:12:25,339 [http-bio-8080-exec-6] WARN  org.nutz.weixin.util.Wxs - nutzwx DevMode=true now
log4j: 2016-09-01 16:12:25,340 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - Get 'wxHandler'<class net.lfsoft.cms.util.WxHandler>
log4j: 2016-09-01 16:12:25,340 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=wxHandler
log4j: 2016-09-01 16:12:25,340 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(wxHandler) in AnnotationIocLoader(packages=[net.lfsoft.cms])
log4j: 2016-09-01 16:12:25,340 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'wxHandler'<class net.lfsoft.cms.util.WxHandler>
log4j: 2016-09-01 16:12:25,340 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class net.lfsoft.cms.util.WxHandler without AOP
log4j: 2016-09-01 16:12:25,340 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'wxHandler' to [app] 
log4j: 2016-09-01 16:12:25,341 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dao'<interface org.nutz.dao.Dao>
log4j: 2016-09-01 16:12:25,341 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<class org.nutz.ioc.impl.PropertiesProxy>
log4j: 2016-09-01 16:12:25,368 [http-bio-8080-exec-6] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - {call pnextid(?)}
    |       1 |
    |---------|
    | wx_menu |
  For example:> "{call pnextid('wx_menu')}"
log4j: 2016-09-01 16:12:25,368 [http-bio-8080-exec-6] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - {call pnextid(?)}
log4j: 2016-09-01 16:12:25,415 [http-bio-8080-exec-6] DEBUG net.lfsoft.cms.mvc.LogTimeProcessor - [ GET]URI=/lfcms/weixin/test 79ms
log4j: 2016-09-01 16:12:25,416 [http-bio-8080-exec-6] WARN  org.nutz.mvc.impl.processor.FailProcessor - Error@/weixin/test :
org.nutz.dao.DaoException: java.lang.NullPointerException
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:104)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:77)
	at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:63)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:61)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:267)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:275)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:159)
	at net.lfsoft.cms.module.WeixinModule.test(WeixinModule.java:43)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at net.lfsoft.cms.mvc.LogTimeProcessor.process(LogTimeProcessor.java:18)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at net.lfsoft.cms.mvc.LfcmsNutFilter.doFilter(LfcmsNutFilter.java:32)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
	at org.nutz.dao.impl.entity.macro.SqlFieldMacro.onAfter(SqlFieldMacro.java:55)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:132)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	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:147)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:93)
	... 60 more

瞎折腾(qq_b8d02b2c) 22楼•2997天前

@wendal 直接传表名的日志是：

log4j: 2016-09-01 16:15:12,363 [http-bio-8080-exec-6] DEBUG org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [GET] path=/weixin/test : WeixinModule.test(WeixinModule.java:41)
log4j: 2016-09-01 16:15:12,363 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - Get 'weixinModule'<class net.lfsoft.cms.module.WeixinModule>
log4j: 2016-09-01 16:15:12,363 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=weixinModule
log4j: 2016-09-01 16:15:12,363 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(weixinModule) in AnnotationIocLoader(packages=[net.lfsoft.cms])
log4j: 2016-09-01 16:15:12,363 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'weixinModule'<class net.lfsoft.cms.module.WeixinModule>
log4j: 2016-09-01 16:15:12,364 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class net.lfsoft.cms.module.WeixinModule without AOP
log4j: 2016-09-01 16:15:12,364 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'weixinModule' to [app] 
log4j: 2016-09-01 16:15:12,366 [http-bio-8080-exec-6] WARN  org.nutz.weixin.util.Wxs - nutzwx DevMode=true now
log4j: 2016-09-01 16:15:12,367 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - Get 'wxHandler'<class net.lfsoft.cms.util.WxHandler>
log4j: 2016-09-01 16:15:12,367 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Load definition name=wxHandler
log4j: 2016-09-01 16:15:12,367 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.loader.combo.ComboIocLoader - Found IocObject(wxHandler) in AnnotationIocLoader(packages=[net.lfsoft.cms])
log4j: 2016-09-01 16:15:12,367 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - 	 >> Make...'wxHandler'<class net.lfsoft.cms.util.WxHandler>
log4j: 2016-09-01 16:15:12,367 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.aop.impl.DefaultMirrorFactory - Load class net.lfsoft.cms.util.WxHandler without AOP
log4j: 2016-09-01 16:15:12,367 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.ScopeContext - Save object 'wxHandler' to [app] 
log4j: 2016-09-01 16:15:12,367 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - Get 'dao'<interface org.nutz.dao.Dao>
log4j: 2016-09-01 16:15:12,367 [http-bio-8080-exec-6] DEBUG org.nutz.ioc.impl.NutIoc - Get 'conf'<class org.nutz.ioc.impl.PropertiesProxy>
log4j: 2016-09-01 16:15:12,388 [http-bio-8080-exec-6] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - {call pnextid("wx_menu")}
log4j: 2016-09-01 16:15:12,388 [http-bio-8080-exec-6] DEBUG org.nutz.dao.impl.sql.run.NutDaoExecutor - {call pnextid("wx_menu")}
log4j: 2016-09-01 16:15:12,432 [http-bio-8080-exec-6] DEBUG net.lfsoft.cms.mvc.LogTimeProcessor - [ GET]URI=/lfcms/weixin/test 69ms
log4j: 2016-09-01 16:15:12,433 [http-bio-8080-exec-6] WARN  org.nutz.mvc.impl.processor.FailProcessor - Error@/weixin/test :
org.nutz.dao.DaoException: java.lang.NullPointerException
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:104)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:77)
	at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:63)
	at org.nutz.trans.Trans.exec(Trans.java:174)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:61)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:267)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:275)
	at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
	at org.nutz.dao.impl.NutDao.insert(NutDao.java:159)
	at net.lfsoft.cms.module.WeixinModule.test(WeixinModule.java:43)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at net.lfsoft.cms.mvc.LogTimeProcessor.process(LogTimeProcessor.java:18)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
	at net.lfsoft.cms.mvc.LfcmsNutFilter.doFilter(LfcmsNutFilter.java:32)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
	at org.nutz.dao.impl.entity.macro.SqlFieldMacro.onAfter(SqlFieldMacro.java:55)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runExec(NutDaoExecutor.java:132)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	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:147)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:93)
	... 60 more

wendal

23楼•2997天前

奇怪, 为啥用不传参数的就正常呢? 我本地试试

瞎折腾(qq_b8d02b2c) 24楼•2997天前

@wendal
一个奇怪的问题，存储过程写完在sqlserver里调用没有问题。
但是存储过程里有更新另一张表的语句，@Prev(@SQL("{call nextid()}"))就会报错。

wendal

25楼•2997天前

我提交了个修改,你试试吧

瞎折腾(qq_b8d02b2c) 26楼•2997天前

@wendal 谢谢，是在https://oss.sonatype.org/content/repositories/snapshots/org/nutz/nutz/这里等收录嘛？

瞎折腾(qq_b8d02b2c) 27楼•2997天前

@wendal 这网站一直没更新……我还是先写成手动执行存储过程吧。谢谢啦

wendal

28楼•2997天前

@qq_b8d02b2c 额，构建失败了？顺便把你写的调用存储代码贴一下呗，看看我写漏了啥

来自炫酷的 NutzCN

瞎折腾(qq_b8d02b2c) 29楼•2997天前

@wendal

		dao().run(new ConnCallback() {
            public void invoke(Connection conn) throws Exception {
				CallableStatement cstmt = conn.prepareCall("{?=call pnextid('wx_menu')}");
				cstmt.registerOutParameter(1, Types.NUMERIC);
				cstmt.execute();
				int id = cstmt.getInt(1);
				menu.setID(id);
				dao().insert(menu);
            }
        });

wendal

30楼•2997天前

好吧... 出参

请先登陆