NutzCN Logo
问答 oracle 数据字段类型为collection查询出错问题
发布于 2352天前 作者 qq_f9ff1315 1439 次浏览 复制 上一个帖子 下一个帖子
标签: nutzwk

我使用nutzwk,查询oracle数据库中某字段,类型为collection,出错,错误如下:

java.lang.IllegalAccessError: java/net/PlainSocketImpl
	at org.nutz.lang.reflect.fast.java.net.PlainSocketImpl$FM$getTimeout$368a4b19ca881db4e724deb4a21096f2.invoke(PlainSocketImpl.java)
	at org.nutz.lang.eject.EjectByGetter.eject(EjectByGetter.java:33)
	at org.nutz.json.entity.JsonEntityField.getValue(JsonEntityField.java:173)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:278)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.map2Json(JsonRenderImpl.java:252)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:149)
	at org.nutz.json.impl.JsonRenderImpl.coll2Json(JsonRenderImpl.java:440)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:153)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.map2Json(JsonRenderImpl.java:252)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:149)
	at org.nutz.json.Json.toJson(Json.java:239)
	at org.nutz.mvc.Mvcs.write(Mvcs.java:292)
	at org.nutz.mvc.view.UTF8JsonView.render(UTF8JsonView.java:68)
	at org.nutz.mvc.impl.processor.ViewProcessor.process(ViewProcessor.java:66)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:30)
	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 cn.wizzer.app.web.commons.processor.XssSqlFilterProcessor.process(XssSqlFilterProcessor.java:35)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at cn.wizzer.app.web.commons.processor.NutShiroProcessor.process(NutShiroProcessor.java:52)
	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 cn.wizzer.app.web.commons.processor.GlobalsSettingProcessor.process(GlobalsSettingProcessor.java:36)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at cn.wizzer.app.web.commons.processor.LogTimeProcessor.process(LogTimeProcessor.java:21)
	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:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at cn.wizzer.app.web.commons.filter.RouteFilter.doFilter(RouteFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	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:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1533)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1489)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
[WARN ] 2017-10-19 13:42:16,315 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) - Error@/platform/sys/edit/loadObjs_sdo :
java.lang.IllegalAccessError: tried to access class java.net.PlainSocketImpl from class org.nutz.lang.reflect.fast.java.net.PlainSocketImpl$FM$getTimeout$368a4b19ca881db4e724deb4a21096f2
	at org.nutz.lang.reflect.fast.java.net.PlainSocketImpl$FM$getTimeout$368a4b19ca881db4e724deb4a21096f2.invoke(PlainSocketImpl.java)
	at org.nutz.lang.eject.EjectByGetter.eject(EjectByGetter.java:33)
	at org.nutz.json.entity.JsonEntityField.getValue(JsonEntityField.java:173)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:278)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.pojo2Json(JsonRenderImpl.java:343)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:161)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.map2Json(JsonRenderImpl.java:252)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:149)
	at org.nutz.json.impl.JsonRenderImpl.coll2Json(JsonRenderImpl.java:440)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:153)
	at org.nutz.json.impl.JsonRenderImpl.appendPair(JsonRenderImpl.java:199)
	at org.nutz.json.impl.JsonRenderImpl.writeItem(JsonRenderImpl.java:350)
	at org.nutz.json.impl.JsonRenderImpl.map2Json(JsonRenderImpl.java:252)
	at org.nutz.json.impl.JsonRenderImpl.render(JsonRenderImpl.java:149)
	at org.nutz.json.Json.toJson(Json.java:239)
	at org.nutz.mvc.Mvcs.write(Mvcs.java:292)
	at org.nutz.mvc.view.UTF8JsonView.render(UTF8JsonView.java:68)
	at org.nutz.mvc.impl.processor.ViewProcessor.process(ViewProcessor.java:66)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:33)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:30)
	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 cn.wizzer.app.web.commons.processor.XssSqlFilterProcessor.process(XssSqlFilterProcessor.java:35)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at cn.wizzer.app.web.commons.processor.NutShiroProcessor.process(NutShiroProcessor.java:52)
	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 cn.wizzer.app.web.commons.processor.GlobalsSettingProcessor.process(GlobalsSettingProcessor.java:36)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at cn.wizzer.app.web.commons.processor.LogTimeProcessor.process(LogTimeProcessor.java:21)
	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:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at cn.wizzer.app.web.commons.filter.RouteFilter.doFilter(RouteFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	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:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1533)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1489)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
13 回复

入口方法的内容贴一下看看

入口方法:

@At
       @Ok("json")
       @RequiresAuthentication
   	public Object loadObjs_sdo(@Param("length") int length, @Param("start") int start, @Param("draw") int draw, @Param("::order") List<DataTableOrder> order, @Param("::columns") List<DataTableColumn> columns) {
    	   
    	   return editService.getobjData(length, start, draw,order,columns);
      	/* List<Map> results= editService.loadObjs_sdo();   	   
      	return Result.success("成功", results);   */ 
   	}

实现类

public Object getobjData(int length,int start,int draw,List order,List columns) {
String sql = "select t.objname,t.objtypename,t.shape.SDO_ORDINATES as shape,t.shape.SDO_POINT.X as x, t.shape.SDO_POINT.Y as y from objs t";
String s = sql;
if (order != null && order.size() > 0) {
for (DataTableOrder o : order) {
DataTableColumn col = columns.get(o.getColumn());
s += " order by t." + Sqls.escapeSqlFieldValue(col.getData()).toString() + " " + o.getDir();
}
}

return data(length, start, draw, Sqls.create(sql), Sqls.create(s));

}

用 "插入代码" 按钮重新贴一下

public Object getobjData(int length,int start,int draw,List<DataTableOrder> order,List<DataTableColumn> columns) {
	String sql = "select t.objname,t.objtypename,t.shape.SDO_ORDINATES as shape,t.shape.SDO_POINT.X as x, t.shape.SDO_POINT.Y as y from objs t";
    String s = sql;
    if (order != null && order.size() > 0) {
        for (DataTableOrder o : order) {
            DataTableColumn col = columns.get(o.getColumn());
            s += " order by t." + Sqls.escapeSqlFieldValue(col.getData()).toString() + " " + o.getDir();
        }
    }
    
    return data(length, start, draw, Sqls.create(sql), Sqls.create(s));
	
}

  @At
       @Ok("json")
       @RequiresAuthentication
   	public Object loadObjs_sdo(@Param("length") int length, @Param("start") int start, @Param("draw") int draw, @Param("::order") List<DataTableOrder> order, @Param("::columns") List<DataTableColumn> columns) {
    	   
    	   return editService.getobjData(length, start, draw,order,columns);
      	/* List<Map> results= editService.loadObjs_sdo();   	   
      	return Result.success("成功", results);   */ 
   	}

用的是什么回调???

data方法贴来看看

我觉得是把oracle的原生对象给搞出来了, 结果toJson的时候报错了

data方法是nutzwk带的datatable查询方法

把data的返回值, toString打印看看什么内容

你得自己写个data方法

添加回复
请先登陆
回到顶部