SQLException java.sql.SQLException: [192.168.0.234:5050](GBA-02AD-0005)Failed to query in gnode

代码

 public List<WccWarningView> QueryWaring2(@Param("catName") String catName, @Param("address")String adr){
            List<WccWarningView> list =new ArrayList<>();
            List<WccWarningView> list2 =new ArrayList<>();
            Criteria cri = Cnd.cri();
            Criteria cri2 = Cnd.cri();
            //cri.where().andGT("chain_price",0);
            cri.where().and(Cnd.exp("chain_price", ">=",0));
            //cri2.where().andLT("chain_price",0);
            cri2.where().and(Cnd.exp("chain_price", "<",0));
            if (!StringUtils.isEmpty(catName)) {
                cri.where().and("cat_name","=",catName);
                cri2.where().and("cat_name","=",catName);
            }
            if (!StringUtils.isEmpty(adr)){
                cri.where().and("province_name","=",adr);
                cri2.where().and("province_name","=",adr);
            }
        /*cri.getGroupBy().groupBy("commodity_name");*/
            cri.getOrderBy().desc("chain_price");
            cri2.getOrderBy().asc("chain_price");
            list=dao.query(WccWarningView.class,cri);
            list2=dao.query(WccWarningView.class,cri2);
            list.addAll(list2);
            return list;
        }

日志

E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\bin\catalina.bat run
[2017-09-01 09:44:33,826] Artifact wcc:war exploded: Waiting for server connection to start artifact deployment...
Using CATALINA_BASE:   "C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc"
Using CATALINA_HOME:   "E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14"
Using CATALINA_TMPDIR: "E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\temp"
Using JRE_HOME:        "D:\Software_Develops\JDK"
Using CLASSPATH:       "E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\bin\bootstrap.jar;E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\bin\tomcat-juli.jar"
Connected to the target VM, address: '127.0.0.1:57862', transport: 'socket'
01-Sep-2017 09:44:34.848 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.14
01-Sep-2017 09:44:34.853 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Apr 13 2017 12:55:45 UTC
01-Sep-2017 09:44:34.854 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.14.0
01-Sep-2017 09:44:34.854 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows 10
01-Sep-2017 09:44:34.854 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
01-Sep-2017 09:44:34.854 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
01-Sep-2017 09:44:34.854 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             D:\Software_Develops\JDK\jre
01-Sep-2017 09:44:34.854 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_121-b13
01-Sep-2017 09:44:34.855 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
01-Sep-2017 09:44:34.856 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc
01-Sep-2017 09:44:34.856 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14
01-Sep-2017 09:44:34.856 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF-8
01-Sep-2017 09:44:34.857 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc\conf\logging.properties
01-Sep-2017 09:44:34.857 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
01-Sep-2017 09:44:34.857 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:57862,suspend=y,server=n
01-Sep-2017 09:44:34.857 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF-8
01-Sep-2017 09:44:34.857 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote=
01-Sep-2017 09:44:34.857 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1099
01-Sep-2017 09:44:34.858 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false
01-Sep-2017 09:44:34.858 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.authenticate=false
01-Sep-2017 09:44:34.858 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1
01-Sep-2017 09:44:34.858 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
01-Sep-2017 09:44:34.858 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
01-Sep-2017 09:44:34.858 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc
01-Sep-2017 09:44:34.858 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14
01-Sep-2017 09:44:34.858 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\temp
01-Sep-2017 09:44:34.863 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library 1.2.12 using APR version 1.5.2.
01-Sep-2017 09:44:34.863 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
01-Sep-2017 09:44:34.864 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
01-Sep-2017 09:44:35.836 信息 [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized (OpenSSL 1.0.2k  26 Jan 2017)
01-Sep-2017 09:44:35.971 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
01-Sep-2017 09:44:35.992 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
01-Sep-2017 09:44:35.995 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
01-Sep-2017 09:44:35.997 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
01-Sep-2017 09:44:35.997 信息 [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1517 ms
01-Sep-2017 09:44:36.031 信息 [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
01-Sep-2017 09:44:36.031 信息 [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.14
01-Sep-2017 09:44:36.041 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
01-Sep-2017 09:44:36.059 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
01-Sep-2017 09:44:36.062 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in 64 ms
Connected to server
[2017-09-01 09:44:36,463] Artifact wcc:war exploded: Artifact is being deployed, please wait...
01-Sep-2017 09:44:37.804 信息 [RMI TCP Connection(5)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
2017-09-01 09:44:38,183 org.nutz.mvc.NutFilter._init(NutFilter.java:85) INFO  - NutFilter[nutz] starting ...
2017-09-01 09:44:38,204 org.nutz.resource.Scans.printLocations(Scans.java:527) DEBUG - Locations count=4 time use 5ms
2017-09-01 09:44:38,211 org.nutz.resource.Scans.printLocations(Scans.java:527) DEBUG - Locations count=14 time use 7ms
2017-09-01 09:44:38,233 org.nutz.mvc.config.AbstractNutConfig.createLoading(AbstractNutConfig.java:59) DEBUG - Loading by class org.nutz.mvc.impl.NutLoading
2017-09-01 09:44:38,237 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:55) INFO  - Nutz Version : 1.r.63-SNAPSHOT 
2017-09-01 09:44:38,237 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:56) INFO  - Nutz.Mvc[nutz] is initializing ...
2017-09-01 09:44:38,237 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:60) DEBUG - Web Container Information:
2017-09-01 09:44:38,238 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:61) DEBUG -  - Default Charset : UTF-8
2017-09-01 09:44:38,238 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:62) DEBUG -  - Current . path  : E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\bin\.
2017-09-01 09:44:38,239 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:63) DEBUG -  - Java Version    : 1.8.0_121
2017-09-01 09:44:38,239 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:64) DEBUG -  - File separator  : \
2017-09-01 09:44:38,239 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:65) DEBUG -  - Timezone        : Asia/Shanghai
2017-09-01 09:44:38,240 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:66) DEBUG -  - OS              : Windows 10 amd64
2017-09-01 09:44:38,240 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:67) DEBUG -  - ServerInfo      : Apache Tomcat/8.5.14
2017-09-01 09:44:38,240 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:68) DEBUG -  - Servlet API     : 3.1
2017-09-01 09:44:38,241 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:73) DEBUG -  - ContextPath     : /wcc
2017-09-01 09:44:38,242 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:74) DEBUG -  - context.tempdir : C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc\work\Catalina\localhost\wcc
2017-09-01 09:44:38,242 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:75) DEBUG -  - MainModule      : net.nutz.wcc.MainModule
2017-09-01 09:44:38,244 org.nutz.mvc.impl.NutLoading.createContext(NutLoading.java:235) DEBUG - >> app.root = E:/Work/InstelliJIDEAR_WorkSpaceNo.1/wcc/target/wcc
2017-09-01 09:44:38,302 org.nutz.castor.Castors.reload(Castors.java:115) DEBUG - Using 95 castor for Castors
2017-09-01 09:44:38,303 org.nutz.mvc.impl.NutLoading.createIoc(NutLoading.java:376) DEBUG - @IocBy(type=org.nutz.mvc.ioc.provider.ComboIocProvider, args=["*js", "ioc/", "*anno", "net.nutz.wcc", "*tx", "*async"],init=[])
2017-09-01 09:44:38,346 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 1 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
2017-09-01 09:44:38,346 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:49) DEBUG - loading [dao.js]
2017-09-01 09:44:38,349 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:57) DEBUG - Loaded 3 bean define from path=[ioc/] --> [conf, dao, dataSource]
2017-09-01 09:44:38,365 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 16 resource by src( net/nutz/wcc/ ) , regex( ^.+[.]class$ )
2017-09-01 09:44:38,484 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:76) DEBUG - Found @IocBean : class net.nutz.wcc.controller.WarningAction
2017-09-01 09:44:38,494 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:76) DEBUG - Found @IocBean : class net.nutz.wcc.server.WarningServer
2017-09-01 09:44:38,500 org.nutz.ioc.loader.annotation.AnnotationIocLoader.<init>(AnnotationIocLoader.java:52) INFO  - Found 2 classes in 1 base-packages!
beans = ["warningAction", "warningServer"]
2017-09-01 09:44:38,513 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:40) DEBUG - Loaded 5 bean define from reader --
[txREPEATABLE_READ, txSERIALIZABLE, txNONE, txREAD_UNCOMMITTED, txREAD_COMMITTED]
2017-09-01 09:44:38,539 org.nutz.ioc.aop.SimpleAopMaker.<init>(SimpleAopMaker.java:79) DEBUG - Load AopConfigure for anno=org.nutz.aop.interceptor.async.Async by type=org.nutz.aop.interceptor.async.AsyncAopIocLoader
2017-09-01 09:44:38,543 org.nutz.ioc.impl.NutIoc.<init>(NutIoc.java:98) INFO  - NutIoc init begin ...
2017-09-01 09:44:38,546 org.nutz.ioc.impl.NutIoc.<init>(NutIoc.java:115) INFO  - ... NutIoc init complete
2017-09-01 09:44:38,549 org.nutz.mvc.impl.NutLoading.evalUrlMapping(NutLoading.java:159) INFO  - Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
2017-09-01 09:44:38,552 org.nutz.mvc.impl.NutLoading.createViewMakers(NutLoading.java:366) DEBUG - @Views(DefaultViewMaker.class)
2017-09-01 09:44:38,556 org.nutz.mvc.impl.NutLoading.createChainMaker(NutLoading.java:263) DEBUG - @ChainBy(org.nutz.mvc.impl.NutActionChainMaker)
2017-09-01 09:44:38,563 org.nutz.mvc.impl.Loadings.scanModules(Loadings.java:154) DEBUG - module class location 'file:/E:/Work/InstelliJIDEAR_WorkSpaceNo.1/wcc/target/wcc/WEB-INF/classes/'
2017-09-01 09:44:38,564 org.nutz.mvc.impl.Loadings.scanModuleInPackage(Loadings.java:184) DEBUG -  > scan 'net.nutz.wcc'
2017-09-01 09:44:38,568 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 16 resource by src( net/nutz/wcc/ ) , regex( ^.+[.]class$ )
2017-09-01 09:44:38,570 org.nutz.mvc.impl.Loadings.checkModule(Loadings.java:199) DEBUG -    >> add 'net.nutz.wcc.controller.WarningAction'
2017-09-01 09:44:38,593 org.nutz.mvc.impl.NutActionChainMaker.getProcessorByName(NutActionChainMaker.java:72) INFO  - Optional processor class not found, disabled : org.nutz.integration.shiro.NutShiroProcessor
2017-09-01 09:44:38,615 org.nutz.mvc.impl.NutActionChainMaker.getProcessorByName(NutActionChainMaker.java:72) INFO  - Optional processor class not found, disabled : org.nutz.plugins.validation.ValidationProcessor
2017-09-01 09:44:38,641 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/warning/query/detailed'   >> (WarningAction.java:58).QueryDetailed : List       | @Ok(json ) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2017-09-01 09:44:38,642 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/warning/query/navigation' >> (WarningAction.java:39).QueryNavigation : List       | @Ok(json ) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2017-09-01 09:44:38,643 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/warning/query'            >> (WarningAction.java:87).QueryWaring2  : List       | @Ok(json ) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2017-09-01 09:44:38,643 org.nutz.mvc.impl.NutLoading.evalUrlMapping(NutLoading.java:217) INFO  - Found 3 module methods
2017-09-01 09:44:38,644 org.nutz.mvc.impl.NutLoading.evalLocalization(NutLoading.java:303) DEBUG - Localization: org.nutz.mvc.impl.NutMessageLoader('msg/')  dft<zh-CN>
2017-09-01 09:44:38,650 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 1 resource by src( msg/ ) , regex( ^.+[.]properties$ )
2017-09-01 09:44:38,650 org.nutz.mvc.impl.NutMessageLoader.load(NutMessageLoader.java:27) DEBUG - Load Messages in 1 resource : [[File[E:\Work\InstelliJIDEAR_WorkSpaceNo.1\wcc\target\wcc\WEB-INF\classes\msg\user.properties]]]
2017-09-01 09:44:38,652 org.nutz.mvc.impl.NutMessageLoader.load(NutMessageLoader.java:95) DEBUG - Message Loaded, size = 1
2017-09-01 09:44:38,652 org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:271) INFO  - Setup application...
2017-09-01 09:44:38,655 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dao'<interface org.nutz.dao.Dao>
2017-09-01 09:44:38,656 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get '$aop_async'<interface org.nutz.ioc.aop.config.AopConfigration>
2017-09-01 09:44:38,657 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=$aop_async
2017-09-01 09:44:38,659 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject($aop_async) in AsyncAopIocLoader@244516405
2017-09-01 09:44:38,660 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'$aop_async'<interface org.nutz.ioc.aop.config.AopConfigration>
2017-09-01 09:44:38,661 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object '$aop_async' to [app] 
2017-09-01 09:44:38,667 org.nutz.ioc.aop.SimpleAopMaker.<init>(SimpleAopMaker.java:79) DEBUG - Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
2017-09-01 09:44:38,668 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=dao
2017-09-01 09:44:38,668 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dao
2017-09-01 09:44:38,672 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dao) in JsonLoader(paths=[ioc/])
2017-09-01 09:44:38,672 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'dao'<interface org.nutz.dao.Dao>
2017-09-01 09:44:38,672 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'dao' to [app] 
2017-09-01 09:44:38,673 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dataSource'<>
2017-09-01 09:44:38,674 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=dataSource
2017-09-01 09:44:38,674 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dataSource
2017-09-01 09:44:38,689 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
2017-09-01 09:44:38,689 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'dataSource'<>
2017-09-01 09:44:38,690 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'dataSource' to [app] 
2017-09-01 09:44:38,731 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class com.alibaba.druid.pool.DruidDataSource without AOP
2017-09-01 09:44:38,732 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'conf'<>
2017-09-01 09:44:38,732 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=conf
2017-09-01 09:44:38,732 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=conf
2017-09-01 09:44:38,774 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(conf) in JsonLoader(paths=[ioc/])
2017-09-01 09:44:38,775 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'conf'<>
2017-09-01 09:44:38,776 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'conf' to [app] 
2017-09-01 09:44:38,778 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.ioc.impl.PropertiesProxy without AOP
2017-09-01 09:44:38,844 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 1 resource by src( custom/ ) , regex( ^.+[.]properties$ )
2017-09-01 09:44:38,845 org.nutz.ioc.impl.PropertiesProxy.setPaths(PropertiesProxy.java:113) DEBUG - load properties from File[E:\Work\InstelliJIDEAR_WorkSpaceNo.1\wcc\target\wcc\WEB-INF\classes\custom\db.properties]
2017-09-01 09:44:39,268 com.alibaba.druid.pool.DruidDataSource.validationQueryCheck(DruidDataSource.java:994) ERROR - testWhileIdle is true, validationQuery not set
2017-09-01 09:44:39,276 com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:854) INFO  - {dataSource-1} inited
2017-09-01 09:44:39,289 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.dao.impl.NutDao without AOP
2017-09-01 09:44:39,291 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dataSource'<>
2017-09-01 09:44:39,579 org.nutz.dao.jdbc.Jdbcs.<clinit>(Jdbcs.java:90) DEBUG - Jdbcs init complete
2017-09-01 09:44:39,579 org.nutz.dao.jdbc.Jdbcs.getExpert(Jdbcs.java:103) INFO  - Get Connection from DataSource for JdbcExpert, if you lock at here, check your database server and configure
2017-09-01 09:44:39,823 org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:188) DEBUG - select expert : org.nutz.dao.impl.jdbc.gbase.GBaseJdbcExpert
2017-09-01 09:44:39,829 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:199) DEBUG - JDBC Driver --> gbase-jdbc-8.2.01 ( $Date: 2006/11/09 10:30:41 $, $Revision: 1.1 $ )
2017-09-01 09:44:39,829 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:200) DEBUG - JDBC Name   --> GBase JDBC Driver
2017-09-01 09:44:39,830 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:202) DEBUG - JDBC URL    --> jdbc:gbase://203.207.224.106:5258/fgw_keshihua1
2017-09-01 09:44:39,830 org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:221) DEBUG - Database info --> OTHER:[GBase - 8.6.2.10-R3.78567]
2017-09-01 09:44:39,833 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:141) INFO  - Nutz.Mvc[nutz] is up in 1590ms
2017-09-01 09:44:39,834 org.nutz.mvc.NutFilter._init(NutFilter.java:117) INFO  - exclusionsPrefix  = ^(/rs/|/druid/)
[2017-09-01 09:44:39,857] Artifact wcc:war exploded: Artifact is deployed successfully
[2017-09-01 09:44:39,858] Artifact wcc:war exploded: Deploy took 3,396 milliseconds
2017-09-01 09:44:45,621 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/warning/query/navigation : WarningAction.QueryNavigation(WarningAction.java:39)
2017-09-01 09:44:45,624 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'warningAction'<class net.nutz.wcc.controller.WarningAction>
2017-09-01 09:44:45,625 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=warningAction
2017-09-01 09:44:45,625 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(warningAction) in AnnotationIocLoader(packages=[net.nutz.wcc])
2017-09-01 09:44:45,626 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'warningAction'<class net.nutz.wcc.controller.WarningAction>
2017-09-01 09:44:45,626 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'warningAction' to [app] 
2017-09-01 09:44:45,628 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class net.nutz.wcc.controller.WarningAction without AOP
2017-09-01 09:44:45,651 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dao'<interface org.nutz.dao.Dao>
2017-09-01 09:44:45,652 org.nutz.ioc.val.ReferTypeValue.get(ReferTypeValue.java:64) DEBUG - name=warnSer not found, search for type=net.nutz.wcc.server.WarningServer
2017-09-01 09:44:45,652 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=conf
2017-09-01 09:44:45,652 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(conf) in JsonLoader(paths=[ioc/])
2017-09-01 09:44:45,652 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dao
2017-09-01 09:44:45,653 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dao) in JsonLoader(paths=[ioc/])
2017-09-01 09:44:45,653 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dataSource
2017-09-01 09:44:45,654 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
2017-09-01 09:44:45,654 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(warningAction) in AnnotationIocLoader(packages=[net.nutz.wcc])
2017-09-01 09:44:45,654 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(warningServer) in AnnotationIocLoader(packages=[net.nutz.wcc])
2017-09-01 09:44:45,654 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'warningServer'<class net.nutz.wcc.server.WarningServer>
2017-09-01 09:44:45,655 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=warningServer
2017-09-01 09:44:45,655 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(warningServer) in AnnotationIocLoader(packages=[net.nutz.wcc])
2017-09-01 09:44:45,655 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'warningServer'<class net.nutz.wcc.server.WarningServer>
2017-09-01 09:44:45,655 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'warningServer' to [app] 
2017-09-01 09:44:45,655 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class net.nutz.wcc.server.WarningServer without AOP
2017-09-01 09:44:45,731 org.nutz.service.EntityService.<init>(EntityService.java:41) DEBUG - Get TypeParams for self : net.nutz.wcc.bean.WccCatdata
2017-09-01 09:44:45,732 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dao'<>
2017-09-01 09:44:45,823 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - Select DISTINCT(cat_name) FROM fct_jg_wcc_catdata where chain_price <> 0
01-Sep-2017 09:44:46.049 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\webapps\manager
01-Sep-2017 09:44:46.092 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\webapps\manager has finished in 41 ms
2017-09-01 09:44:46,149 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/warning/query : WarningAction.QueryWaring2(WarningAction.java:87)
2017-09-01 09:44:46,149 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'warningAction'<class net.nutz.wcc.controller.WarningAction>
2017-09-01 09:44:46,207 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM wcc_warning  WHERE chain_price >= ? ORDER BY chain_price DESC  
    | 1 |
    |---|
    | 0 |
  For example:> "SELECT * FROM wcc_warning  WHERE chain_price >= 0 ORDER BY chain_price DESC  "
2017-09-01 09:44:46,629 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
java.sql.SQLException: [192.168.0.234:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near '?) LIMIT 0 ; commit' at line 1
SQL: CREATE TABLE `gctmpdb`._tmp_3925911744_643067_t22521_4_1503404897_s AS SELECT /*192.168.0.234_643067_9_2017-09-01_09:44:22*/ /*+ TID('1136633') */ `wcc_warning`.`province_name` AS `c15`, `wcc_warning`.`cat_name` AS `c16`, `wcc_warning`.`picture` AS `c17`, `wcc_warning`.`
	at com.gbase.jdbc.SQLError.createSQLException(SQLError.java:946)
	at com.gbase.jdbc.GbaseIO.checkErrorPacket(GbaseIO.java:2870)
	at com.gbase.jdbc.GbaseIO.sendCommand(GbaseIO.java:1573)
	at com.gbase.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
	at com.gbase.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
	at com.gbase.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2830)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2827)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:182)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:228)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.NutDao.query(NutDao.java:483)
	at org.nutz.dao.impl.NutDao.query(NutDao.java:488)
	at net.nutz.wcc.controller.WarningAction.QueryWaring2(WarningAction.java:106)
	at net.nutz.wcc.controller.WarningAction$FM$QueryWaring2$8101c8b5c0af664cebe32906dd0e2c2a.invoke(WarningAction.java)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
	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.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:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
2017-09-01 09:44:46,687 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN  - Error@/warning/query :
org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM wcc_warning  WHERE chain_price >= 0 ORDER BY chain_price DESC  '
PreparedStatement: 
'SELECT * FROM wcc_warning  WHERE chain_price >= ? ORDER BY chain_price DESC  '
CaseMessage=[192.168.0.234:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near '?) LIMIT 0 ; commit' at line 1
SQL: CREATE TABLE `gctmpdb`._tmp_3925911744_643067_t22521_4_1503404897_s AS SELECT /*192.168.0.234_643067_9_2017-09-01_09:44:22*/ /*+ TID('1136633') */ `wcc_warning`.`province_name` AS `c15`, `wcc_warning`.`cat_name` AS `c16`, `wcc_warning`.`picture` AS `c17`, `wcc_warning`.`
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.NutDao.query(NutDao.java:483)
	at org.nutz.dao.impl.NutDao.query(NutDao.java:488)
	at net.nutz.wcc.controller.WarningAction.QueryWaring2(WarningAction.java:106)
	at net.nutz.wcc.controller.WarningAction$FM$QueryWaring2$8101c8b5c0af664cebe32906dd0e2c2a.invoke(WarningAction.java)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
	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.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:202)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: [192.168.0.234:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near '?) LIMIT 0 ; commit' at line 1
SQL: CREATE TABLE `gctmpdb`._tmp_3925911744_643067_t22521_4_1503404897_s AS SELECT /*192.168.0.234_643067_9_2017-09-01_09:44:22*/ /*+ TID('1136633') */ `wcc_warning`.`province_name` AS `c15`, `wcc_warning`.`cat_name` AS `c16`, `wcc_warning`.`picture` AS `c17`, `wcc_warning`.`
	at com.gbase.jdbc.SQLError.createSQLException(SQLError.java:946)
	at com.gbase.jdbc.GbaseIO.checkErrorPacket(GbaseIO.java:2870)
	at com.gbase.jdbc.GbaseIO.sendCommand(GbaseIO.java:1573)
	at com.gbase.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
	at com.gbase.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
	at com.gbase.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2830)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2827)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:182)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:228)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:272)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
	... 51 more

 public List<WccWarningView> QueryWaring2(@Param("catName") String catName, @Param("address")String adr){
            List<WccWarningView> list =new ArrayList<>();
            List<WccWarningView> list2 =new ArrayList<>();
            Criteria cri = Cnd.cri();
            Criteria cri2 = Cnd.cri();
            //cri.where().andGT("chain_price",0);
            cri.where().and(Cnd.exp("chain_price", ">=",0));
            //cri2.where().andLT("chain_price",0);
            cri2.where().and(Cnd.exp("chain_price", "<",0));
            if (!StringUtils.isEmpty(catName)) {
                cri.where().and("cat_name","=",catName);
                cri2.where().and("cat_name","=",catName);
            }
            if (!StringUtils.isEmpty(adr)){
                cri.where().and("province_name","=",adr);
                cri2.where().and("province_name","=",adr);
            }
        /*cri.getGroupBy().groupBy("commodity_name");*/
            cri.getOrderBy().desc("chain_price");
            cri2.getOrderBy().asc("chain_price");
            list=dao.query(WccWarningView.class,cri);
            list2=dao.query(WccWarningView.class,cri2);
            list.addAll(list2);
            return list;
        }

wendal

1楼•2638天前

不支持分页？

qq_4945a577 2楼•2638天前

分页指什么？

qq_4945a577 3楼•2638天前

这个方法里没有用到分页查询

qq_4945a577 4楼•2638天前

把代码减少到下面这样跑起来还是相同的异常，只要注释掉cri.where().and(Cnd.exp("chain_price", ">=",0));就不报错

 public List<WccWarningView> QueryWaring2(@Param("catName") String catName, @Param("address")String adr){
            List<WccWarningView> list =new ArrayList<>();
            Criteria cri = Cnd.cri();
            cri.where().and(Cnd.exp("chain_price", ">=",0));
            cri.getOrderBy().desc("chain_price");
            list=dao.query(WccWarningView.class,cri);
            return list;
        }

wendal

5楼•2638天前

话说,上一个帖子都还没结呢, 先去把上一个帖子的问题说清楚些

https://nutz.cn/yvr/t/uum7husit6g7fq31ev15gc6e41

wendal

6楼•2638天前

这是中间件生成的SQL??

DETAIL: You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near '?) LIMIT 0 ; commit' at line 1
SQL: CREATE TABLE `gctmpdb`._tmp_3925911744_643067_t22521_4_1503404897_s AS SELECT /*192.168.0.234_643067_9_2017-09-01_09:44:22*/ /*+ TID('1136633') */ `wcc_warning`.`province_name` AS `c15`, `wcc_warning`.`cat_name` AS `c16`, `wcc_warning`.`picture` AS `c17`, `wcc_warning`.`

按这个提示看, 生成的SQL是

CREATE TABLE `gctmpdb`._tmp_3925911744_643067_t22521_4_1503404897_s AS SELECT /*192.168.0.234_643067_9_2017-09-01_09:44:22*/ /*+ TID('1136633') */ `wcc_warning`.`province_name` AS `c15`, `wcc_warning`.`cat_name` AS `c16`, `wcc_warning`.`picture` AS `c17`, `wcc_warning`.`?) LIMIT 0 ; commit

qq_4945a577 7楼•2638天前

我把sql放到数据库去运行，结果是：

[SQL]CREATE TABLE `gctmpdb`._tmp_3925911744_643067_t22521_4_1503404897_s AS SELECT
	/*192.168.0.234_643067_9_2017-09-01_09:44:22*/
	/*+ TID('1136633') */
	`wcc_warning`.`province_name` AS `c15`,
	`wcc_warning`.`cat_name` AS `c16`,
	`wcc_warning`.`picture` AS `c17`,
	`wcc_warning`.`?) LIMIT 0 ; commit

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near '`?) LIMIT 0 ; commit' at line 6

wendal

8楼•2638天前

这是谁生成的sql？nutz没生成这样的sql呢

qq_4945a577 9楼•2638天前

按新手入门搭起来的，根本没有别的框架的半点影子

qq_4945a577 10楼•2638天前

在Oracle和MySQL上都没事，就是到了生产环境换了个数据库报这个错

wendal

11楼•2638天前

在数据库里跑这句看看

SELECT * FROM wcc_warning  WHERE chain_price >= 0 ORDER BY chain_price DESC

qq_4945a577 12楼•2638天前

这句没问题，查询成功

wendal

13楼•2638天前

将

 cri.where().and(Cnd.exp("chain_price", ">=",0))

改成

 cri.where().and(new Static("chain_price >=0"));

看看会怎样

qq_4945a577 14楼•2638天前

这样能成功

wendal

15楼•2638天前

难道这数据库不支持PreparedStatement参数的？查查手册及问一下厂商吧

qq_4945a577 16楼•2638天前

嗯，过去问问

qq_4945a577 17楼•2638天前

Sql sql=Sqls.creates(select * from $table where where A=@a )
sql.vars().set("table","t_abc");
sql.params().set("a","123")

qq_4945a577 18楼•2638天前

他们说支持给了我一个模板

wendal

19楼•2638天前

那你试一下??

qq_4945a577 20楼•2638天前

我这没用到sql对象啊

wendal

21楼•2638天前

//SELECT * FROM wcc_warning  WHERE chain_price >= 0 ORDER BY chain_price DESC
Sql sql=Sqls.create("SELECT * FROM wcc_warning  WHERE chain_price >= @chain_price  ORDER BY chain_price DESC")
sql.params().set("chain_price", 0);
dao.execute(sql);

看看会不会抛错

qq_4945a577 22楼•2638天前

没有报错，成功了

wendal

23楼•2638天前

日志贴一下看看

qq_4945a577 24楼•2638天前

E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\bin\catalina.bat run
[2017-09-01 12:46:30,528] Artifact wcc:war exploded: Waiting for server connection to start artifact deployment...
Using CATALINA_BASE:   "C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc"
Using CATALINA_HOME:   "E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14"
Using CATALINA_TMPDIR: "E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\temp"
Using JRE_HOME:        "D:\Software_Develops\JDK"
Using CLASSPATH:       "E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\bin\bootstrap.jar;E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\bin\tomcat-juli.jar"
Connected to the target VM, address: '127.0.0.1:57862', transport: 'socket'
01-Sep-2017 12:46:31.501 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.14
01-Sep-2017 12:46:31.504 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Apr 13 2017 12:55:45 UTC
01-Sep-2017 12:46:31.505 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.14.0
01-Sep-2017 12:46:31.505 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows 10
01-Sep-2017 12:46:31.505 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
01-Sep-2017 12:46:31.505 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
01-Sep-2017 12:46:31.506 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             D:\Software_Develops\JDK\jre
01-Sep-2017 12:46:31.506 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_121-b13
01-Sep-2017 12:46:31.506 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
01-Sep-2017 12:46:31.506 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc
01-Sep-2017 12:46:31.506 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14
01-Sep-2017 12:46:31.506 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF-8
01-Sep-2017 12:46:31.506 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc\conf\logging.properties
01-Sep-2017 12:46:31.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
01-Sep-2017 12:46:31.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:57862,suspend=y,server=n
01-Sep-2017 12:46:31.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF-8
01-Sep-2017 12:46:31.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote=
01-Sep-2017 12:46:31.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1099
01-Sep-2017 12:46:31.507 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false
01-Sep-2017 12:46:31.510 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.authenticate=false
01-Sep-2017 12:46:31.510 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1
01-Sep-2017 12:46:31.510 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
01-Sep-2017 12:46:31.510 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
01-Sep-2017 12:46:31.510 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc
01-Sep-2017 12:46:31.510 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14
01-Sep-2017 12:46:31.511 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\temp
01-Sep-2017 12:46:31.511 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library 1.2.12 using APR version 1.5.2.
01-Sep-2017 12:46:31.511 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
01-Sep-2017 12:46:31.511 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
01-Sep-2017 12:46:32.512 信息 [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized (OpenSSL 1.0.2k  26 Jan 2017)
01-Sep-2017 12:46:32.642 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
01-Sep-2017 12:46:32.675 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
01-Sep-2017 12:46:32.677 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
01-Sep-2017 12:46:32.679 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
01-Sep-2017 12:46:32.681 信息 [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1558 ms
01-Sep-2017 12:46:32.718 信息 [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
01-Sep-2017 12:46:32.718 信息 [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.14
01-Sep-2017 12:46:32.732 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
01-Sep-2017 12:46:32.743 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
01-Sep-2017 12:46:32.749 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in 67 ms
Connected to server
[2017-09-01 12:46:33,192] Artifact wcc:war exploded: Artifact is being deployed, please wait...
01-Sep-2017 12:46:34.557 信息 [RMI TCP Connection(3)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
2017-09-01 12:46:34,885 org.nutz.mvc.NutFilter._init(NutFilter.java:85) INFO  - NutFilter[nutz] starting ...
2017-09-01 12:46:34,912 org.nutz.resource.Scans.printLocations(Scans.java:527) DEBUG - Locations count=4 time use 7ms
2017-09-01 12:46:34,924 org.nutz.resource.Scans.printLocations(Scans.java:527) DEBUG - Locations count=14 time use 11ms
2017-09-01 12:46:34,943 org.nutz.mvc.config.AbstractNutConfig.createLoading(AbstractNutConfig.java:59) DEBUG - Loading by class org.nutz.mvc.impl.NutLoading
2017-09-01 12:46:34,945 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:55) INFO  - Nutz Version : 1.r.63-SNAPSHOT 
2017-09-01 12:46:34,946 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:56) INFO  - Nutz.Mvc[nutz] is initializing ...
2017-09-01 12:46:34,946 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:60) DEBUG - Web Container Information:
2017-09-01 12:46:34,947 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:61) DEBUG -  - Default Charset : UTF-8
2017-09-01 12:46:34,947 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:62) DEBUG -  - Current . path  : E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\bin\.
2017-09-01 12:46:34,948 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:63) DEBUG -  - Java Version    : 1.8.0_121
2017-09-01 12:46:34,948 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:64) DEBUG -  - File separator  : \
2017-09-01 12:46:34,948 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:65) DEBUG -  - Timezone        : Asia/Shanghai
2017-09-01 12:46:34,948 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:66) DEBUG -  - OS              : Windows 10 amd64
2017-09-01 12:46:34,948 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:67) DEBUG -  - ServerInfo      : Apache Tomcat/8.5.14
2017-09-01 12:46:34,949 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:68) DEBUG -  - Servlet API     : 3.1
2017-09-01 12:46:34,949 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:73) DEBUG -  - ContextPath     : /wcc
2017-09-01 12:46:34,950 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:74) DEBUG -  - context.tempdir : C:\Users\lenovo\.IntelliJIdea2017.2\system\tomcat\Unnamed_wcc\work\Catalina\localhost\wcc
2017-09-01 12:46:34,950 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:75) DEBUG -  - MainModule      : net.nutz.wcc.MainModule
2017-09-01 12:46:34,951 org.nutz.mvc.impl.NutLoading.createContext(NutLoading.java:235) DEBUG - >> app.root = E:/Work/InstelliJIDEAR_WorkSpaceNo.1/wcc/target/wcc
2017-09-01 12:46:35,009 org.nutz.castor.Castors.reload(Castors.java:115) DEBUG - Using 95 castor for Castors
2017-09-01 12:46:35,009 org.nutz.mvc.impl.NutLoading.createIoc(NutLoading.java:376) DEBUG - @IocBy(type=org.nutz.mvc.ioc.provider.ComboIocProvider, args=["*js", "ioc/", "*anno", "net.nutz.wcc", "*tx", "*async"],init=[])
2017-09-01 12:46:35,054 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 1 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
2017-09-01 12:46:35,054 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:49) DEBUG - loading [dao.js]
2017-09-01 12:46:35,057 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:57) DEBUG - Loaded 3 bean define from path=[ioc/] --> [conf, dao, dataSource]
2017-09-01 12:46:35,075 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 16 resource by src( net/nutz/wcc/ ) , regex( ^.+[.]class$ )
2017-09-01 12:46:35,198 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:76) DEBUG - Found @IocBean : class net.nutz.wcc.controller.WarningAction
2017-09-01 12:46:35,217 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:76) DEBUG - Found @IocBean : class net.nutz.wcc.server.WarningServer
2017-09-01 12:46:35,224 org.nutz.ioc.loader.annotation.AnnotationIocLoader.<init>(AnnotationIocLoader.java:52) INFO  - Found 2 classes in 1 base-packages!
beans = ["warningAction", "warningServer"]
2017-09-01 12:46:35,233 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:40) DEBUG - Loaded 5 bean define from reader --
[txREPEATABLE_READ, txSERIALIZABLE, txNONE, txREAD_UNCOMMITTED, txREAD_COMMITTED]
2017-09-01 12:46:35,256 org.nutz.ioc.aop.SimpleAopMaker.<init>(SimpleAopMaker.java:79) DEBUG - Load AopConfigure for anno=org.nutz.aop.interceptor.async.Async by type=org.nutz.aop.interceptor.async.AsyncAopIocLoader
2017-09-01 12:46:35,260 org.nutz.ioc.impl.NutIoc.<init>(NutIoc.java:98) INFO  - NutIoc init begin ...
2017-09-01 12:46:35,263 org.nutz.ioc.impl.NutIoc.<init>(NutIoc.java:115) INFO  - ... NutIoc init complete
2017-09-01 12:46:35,266 org.nutz.mvc.impl.NutLoading.evalUrlMapping(NutLoading.java:159) INFO  - Build URL mapping by org.nutz.mvc.impl.UrlMappingImpl ...
2017-09-01 12:46:35,269 org.nutz.mvc.impl.NutLoading.createViewMakers(NutLoading.java:366) DEBUG - @Views(DefaultViewMaker.class)
2017-09-01 12:46:35,274 org.nutz.mvc.impl.NutLoading.createChainMaker(NutLoading.java:263) DEBUG - @ChainBy(org.nutz.mvc.impl.NutActionChainMaker)
2017-09-01 12:46:35,281 org.nutz.mvc.impl.Loadings.scanModules(Loadings.java:154) DEBUG - module class location 'file:/E:/Work/InstelliJIDEAR_WorkSpaceNo.1/wcc/target/wcc/WEB-INF/classes/'
2017-09-01 12:46:35,281 org.nutz.mvc.impl.Loadings.scanModuleInPackage(Loadings.java:184) DEBUG -  > scan 'net.nutz.wcc'
2017-09-01 12:46:35,285 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 16 resource by src( net/nutz/wcc/ ) , regex( ^.+[.]class$ )
2017-09-01 12:46:35,288 org.nutz.mvc.impl.Loadings.checkModule(Loadings.java:199) DEBUG -    >> add 'net.nutz.wcc.controller.WarningAction'
2017-09-01 12:46:35,311 org.nutz.mvc.impl.NutActionChainMaker.getProcessorByName(NutActionChainMaker.java:72) INFO  - Optional processor class not found, disabled : org.nutz.integration.shiro.NutShiroProcessor
2017-09-01 12:46:35,331 org.nutz.mvc.impl.NutActionChainMaker.getProcessorByName(NutActionChainMaker.java:72) INFO  - Optional processor class not found, disabled : org.nutz.plugins.validation.ValidationProcessor
2017-09-01 12:46:35,355 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/warning/query'            >> (WarningAction.java:114).QueryWaring3 : List       | @Ok(json ) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2017-09-01 12:46:35,356 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/warning/query/detailed'   >> (WarningAction.java:59).QueryDetailed : List       | @Ok(json ) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2017-09-01 12:46:35,357 org.nutz.mvc.impl.UrlMappingImpl.print(UrlMappingImpl.java:146) DEBUG -    '/warning/query/navigation' >> (WarningAction.java:40).QueryNavigation : List       | @Ok(json ) @Fail(http:500) | by 0 Filters | (I:UTF-8/O:UTF-8)
2017-09-01 12:46:35,357 org.nutz.mvc.impl.NutLoading.evalUrlMapping(NutLoading.java:217) INFO  - Found 3 module methods
2017-09-01 12:46:35,357 org.nutz.mvc.impl.NutLoading.evalLocalization(NutLoading.java:303) DEBUG - Localization: org.nutz.mvc.impl.NutMessageLoader('msg/')  dft<zh-CN>
2017-09-01 12:46:35,362 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 1 resource by src( msg/ ) , regex( ^.+[.]properties$ )
2017-09-01 12:46:35,363 org.nutz.mvc.impl.NutMessageLoader.load(NutMessageLoader.java:27) DEBUG - Load Messages in 1 resource : [[File[E:\Work\InstelliJIDEAR_WorkSpaceNo.1\wcc\target\wcc\WEB-INF\classes\msg\user.properties]]]
2017-09-01 12:46:35,364 org.nutz.mvc.impl.NutMessageLoader.load(NutMessageLoader.java:95) DEBUG - Message Loaded, size = 1
2017-09-01 12:46:35,365 org.nutz.mvc.impl.NutLoading.evalSetup(NutLoading.java:271) INFO  - Setup application...
2017-09-01 12:46:35,368 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dao'<interface org.nutz.dao.Dao>
2017-09-01 12:46:35,369 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get '$aop_async'<interface org.nutz.ioc.aop.config.AopConfigration>
2017-09-01 12:46:35,369 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=$aop_async
2017-09-01 12:46:35,372 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject($aop_async) in AsyncAopIocLoader@580993643
2017-09-01 12:46:35,372 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'$aop_async'<interface org.nutz.ioc.aop.config.AopConfigration>
2017-09-01 12:46:35,373 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object '$aop_async' to [app] 
2017-09-01 12:46:35,379 org.nutz.ioc.aop.SimpleAopMaker.<init>(SimpleAopMaker.java:79) DEBUG - Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
2017-09-01 12:46:35,380 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=dao
2017-09-01 12:46:35,380 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dao
2017-09-01 12:46:35,383 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dao) in JsonLoader(paths=[ioc/])
2017-09-01 12:46:35,383 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'dao'<interface org.nutz.dao.Dao>
2017-09-01 12:46:35,383 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'dao' to [app] 
2017-09-01 12:46:35,384 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dataSource'<>
2017-09-01 12:46:35,385 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=dataSource
2017-09-01 12:46:35,386 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dataSource
2017-09-01 12:46:35,400 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
2017-09-01 12:46:35,401 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'dataSource'<>
2017-09-01 12:46:35,401 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'dataSource' to [app] 
2017-09-01 12:46:35,421 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class com.alibaba.druid.pool.DruidDataSource without AOP
2017-09-01 12:46:35,421 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'conf'<>
2017-09-01 12:46:35,422 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=conf
2017-09-01 12:46:35,422 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=conf
2017-09-01 12:46:35,442 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(conf) in JsonLoader(paths=[ioc/])
2017-09-01 12:46:35,443 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'conf'<>
2017-09-01 12:46:35,443 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'conf' to [app] 
2017-09-01 12:46:35,444 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.ioc.impl.PropertiesProxy without AOP
2017-09-01 12:46:35,515 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 1 resource by src( custom/ ) , regex( ^.+[.]properties$ )
2017-09-01 12:46:35,516 org.nutz.ioc.impl.PropertiesProxy.setPaths(PropertiesProxy.java:113) DEBUG - load properties from File[E:\Work\InstelliJIDEAR_WorkSpaceNo.1\wcc\target\wcc\WEB-INF\classes\custom\db.properties]
2017-09-01 12:46:35,920 com.alibaba.druid.pool.DruidDataSource.validationQueryCheck(DruidDataSource.java:994) ERROR - testWhileIdle is true, validationQuery not set
2017-09-01 12:46:35,932 com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:854) INFO  - {dataSource-1} inited
2017-09-01 12:46:35,946 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.dao.impl.NutDao without AOP
2017-09-01 12:46:35,948 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dataSource'<>
2017-09-01 12:46:36,244 org.nutz.dao.jdbc.Jdbcs.<clinit>(Jdbcs.java:90) DEBUG - Jdbcs init complete
2017-09-01 12:46:36,244 org.nutz.dao.jdbc.Jdbcs.getExpert(Jdbcs.java:103) INFO  - Get Connection from DataSource for JdbcExpert, if you lock at here, check your database server and configure
2017-09-01 12:46:36,447 org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:188) DEBUG - select expert : org.nutz.dao.impl.jdbc.gbase.GBaseJdbcExpert
2017-09-01 12:46:36,454 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:199) DEBUG - JDBC Driver --> gbase-jdbc-8.2.01 ( $Date: 2006/11/09 10:30:41 $, $Revision: 1.1 $ )
2017-09-01 12:46:36,454 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:200) DEBUG - JDBC Name   --> GBase JDBC Driver
2017-09-01 12:46:36,455 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:202) DEBUG - JDBC URL    --> jdbc:gbase://203.207.224.106:5258/fgw_keshihua1
2017-09-01 12:46:36,455 org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:221) DEBUG - Database info --> OTHER:[GBase - 8.6.2.10-R3.78567]
2017-09-01 12:46:36,459 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:141) INFO  - Nutz.Mvc[nutz] is up in 1507ms
2017-09-01 12:46:36,459 org.nutz.mvc.NutFilter._init(NutFilter.java:117) INFO  - exclusionsPrefix  = ^(/rs/|/druid/)
[2017-09-01 12:46:36,491] Artifact wcc:war exploded: Artifact is deployed successfully
[2017-09-01 12:46:36,491] Artifact wcc:war exploded: Deploy took 3,299 milliseconds
2017-09-01 12:46:42,288 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/warning/query/navigation : WarningAction.QueryNavigation(WarningAction.java:40)
2017-09-01 12:46:42,290 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'warningAction'<class net.nutz.wcc.controller.WarningAction>
2017-09-01 12:46:42,290 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=warningAction
2017-09-01 12:46:42,290 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(warningAction) in AnnotationIocLoader(packages=[net.nutz.wcc])
2017-09-01 12:46:42,290 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'warningAction'<class net.nutz.wcc.controller.WarningAction>
2017-09-01 12:46:42,291 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'warningAction' to [app] 
2017-09-01 12:46:42,291 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class net.nutz.wcc.controller.WarningAction without AOP
2017-09-01 12:46:42,301 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dao'<interface org.nutz.dao.Dao>
2017-09-01 12:46:42,302 org.nutz.ioc.val.ReferTypeValue.get(ReferTypeValue.java:64) DEBUG - name=warnSer not found, search for type=net.nutz.wcc.server.WarningServer
2017-09-01 12:46:42,302 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=conf
2017-09-01 12:46:42,302 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(conf) in JsonLoader(paths=[ioc/])
2017-09-01 12:46:42,303 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dao
2017-09-01 12:46:42,303 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dao) in JsonLoader(paths=[ioc/])
2017-09-01 12:46:42,303 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dataSource
2017-09-01 12:46:42,306 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
2017-09-01 12:46:42,306 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(warningAction) in AnnotationIocLoader(packages=[net.nutz.wcc])
2017-09-01 12:46:42,306 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(warningServer) in AnnotationIocLoader(packages=[net.nutz.wcc])
2017-09-01 12:46:42,307 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'warningServer'<class net.nutz.wcc.server.WarningServer>
2017-09-01 12:46:42,307 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=warningServer
2017-09-01 12:46:42,307 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(warningServer) in AnnotationIocLoader(packages=[net.nutz.wcc])
2017-09-01 12:46:42,307 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'warningServer'<class net.nutz.wcc.server.WarningServer>
2017-09-01 12:46:42,307 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'warningServer' to [app] 
2017-09-01 12:46:42,307 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class net.nutz.wcc.server.WarningServer without AOP
2017-09-01 12:46:42,376 org.nutz.service.EntityService.<init>(EntityService.java:41) DEBUG - Get TypeParams for self : net.nutz.wcc.bean.WccCatdata
2017-09-01 12:46:42,376 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dao'<>
2017-09-01 12:46:42,469 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - Select DISTINCT(cat_name) FROM fct_jg_wcc_catdata where chain_price <> 0
01-Sep-2017 12:46:42.740 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\webapps\manager
2017-09-01 12:46:42,799 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/warning/query : WarningAction.QueryWaring3(WarningAction.java:114)
2017-09-01 12:46:42,800 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'warningAction'<class net.nutz.wcc.controller.WarningAction>
2017-09-01 12:46:49,421 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM wcc_warning  WHERE chain_price >= ?  ORDER BY chain_price DESC
    | 1 |
    |---|
    | 0 |
  For example:> "SELECT * FROM wcc_warning  WHERE chain_price >= 0  ORDER BY chain_price DESC"
01-Sep-2017 12:46:49.429 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory E:\Work\InstelliJIDEAR_TomcatNo.2\apache-tomcat-8.5.14\webapps\manager has finished in 6,687 ms
2017-09-01 12:47:27,207 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/warning/query : WarningAction.QueryWaring3(WarningAction.java:114)
2017-09-01 12:47:27,207 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'warningAction'<class net.nutz.wcc.controller.WarningAction>
2017-09-01 12:47:39,733 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM wcc_warning  WHERE chain_price >= ?  ORDER BY chain_price DESC
    | 1 |
    |---|
    | 0 |
  For example:> "SELECT * FROM wcc_warning  WHERE chain_price >= 0  ORDER BY chain_price DESC"

wendal

25楼•2638天前

太神奇了...

gbase有可下载安装的版本吗?? 或者提供一个可用的测试jdbc url?

qq_4945a577 26楼•2638天前

没有地方可以下载，而且这边是厂家安在局域网的外网访问不了

qq_4945a577 27楼•2638天前

是不是因为sql参数的部分（@canshu）的语法不一样导致的，听厂家说存储过程的语法啥的都有一点不一样

zozoh

28楼•2637天前

语法手册有吗？

来自美丽的 NutzCN

请先登陆