请问这个异常时什么毛病

org.nutz.dao.DaoException: host class=org.visual.reng.bean.InsGenner, props=insDetailed @Many(field="DETAILED_ID",key="GENNER_ID")) expect prop=DETAILED_ID found at target class=org.visual.reng.bean.InsDetailed

@Table("INS_GENNER")
public class InsGenner {

    @Id
    private int id;

    @Column("ARE_ID")
    private String areId;

    @Column("PLACE_ID")
    private String placeId;

    @Column("NAME")
    private String name;

    @Column("DETAILED_ID")
    private String detailedId;

    @Many(field = "DETAILED_ID", key="GENNER_ID")
    private List<InsDetailed> insDetailed;

@Table("INS_DETAILED")
public class InsDetailed {

    @Id
    private int id;

    @Column
    private String context;

    @Column
    private int state;

    @Column("fault_feedback")
    private String feedback;

    @Column("respond_time")
    private String rsptime;

    @Column("solutions_time")
    private String soltime;

    @Column("solutions_result")
    private String sol_result;

    @Column("genner_id")
    private String gennerId;

    @One(field = "genner_id", key = "id")
    private InsGenner insGenner;

    @Column("persion_id")
    private String persionId;

    @One(field = "persion_id", key = "id")
    private InsDepartment insDepartment;

wendal

1楼•2547天前

field和key都是java属性名，且大小写敏感

qq_4945a577 2楼•2547天前

还是报异常
org.nutz.dao.DaoException: host class=org.visual.ruifeng.bean.InsGenner, props=insDetailed @Many(field="detailed_id",key="genner_id")) expect prop=detailed_id found at target class=org.visual.ruifeng.bean.InsDetailed

    @Column("genner_id")
    private String gennerId;

    @One(field = "genner_id", key = "id")
    private InsGenner insGenner;

qq_4945a577 3楼•2547天前

@Many(field = "detailed_id", key="genner_id")
    private List<InsDetailed> insDetailed;

qq_4945a577 4楼•2547天前

小写的还是报呀

qq_4945a577 5楼•2547天前

@Many语法对吗

qq_4945a577 6楼•2547天前

list = dao.query(InsDepartment.class,cnd,pager);

org.nutz.dao.DaoException: host class=org.visual.reng.bean.InsGenner, props=insDetailed @Many(field="detailedId",key="gennerId")) expect prop=detailedId found at target class=org.visual.reng.bean.InsDetailed

	at org.nutz.dao.impl.entity.field.ManyLinkField.<init>(ManyLinkField.java:41)
	at org.nutz.dao.impl.entity.AnnotationEntityMaker.make(AnnotationEntityMaker.java:294)
	at org.nutz.dao.impl.EntityHolder.getEntity(EntityHolder.java:72)
	at org.nutz.dao.impl.entity.field.AbstractLinkField.getLinkedEntity(AbstractLinkField.java:72)
	at org.nutz.dao.impl.entity.field.OneLinkField.<init>(OneLinkField.java:45)
	at org.nutz.dao.impl.entity.AnnotationEntityMaker.make(AnnotationEntityMaker.java:290)
	at org.nutz.dao.impl.EntityHolder.getEntity(EntityHolder.java:72)
	at org.nutz.dao.impl.entity.field.AbstractLinkField.getLinkedEntity(AbstractLinkField.java:72)
	at org.nutz.dao.impl.entity.field.ManyLinkField.<init>(ManyLinkField.java:26)
	at org.nutz.dao.impl.entity.AnnotationEntityMaker.make(AnnotationEntityMaker.java:294)
	at org.nutz.dao.impl.EntityHolder.getEntity(EntityHolder.java:72)
	at org.nutz.dao.impl.NutDao.query(NutDao.java:477)
	at org.visual.reng.module.InspectionModule.queryDepartment(InspectionModule.java:39)
	at org.mytest.ty.test.NutzJunitTest.testQueryDepartment(NutzJunitTest.java:79)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:33)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:14)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)

package org.visual.reng.bean;

import org.nutz.dao.entity.annotation.*;

import java.util.List;

@Table("INS_GENNER")
public class InsGenner {

    @Id
    private int id;

    @Column("ARE_ID")
    private String areId;

    @Column("PLACE_ID")
    private String placeId;

    @Column("NAME")
    private String name;

    @Column("DETAILED_ID")
    private String detailedId;

    @Many(field = "detailedId", key="gennerId")
    private List<InsDetailed> insDetailed;

    public List<InsDetailed> getInsDetailed() {
        return insDetailed;
    }

    public void setInsDetailed(List<InsDetailed> insDetailed) {
        this.insDetailed = insDetailed;
    }

    public String getDetailedId() {
        return detailedId;
    }

    public void setDetailedId(String detailedId) {
        this.detailedId = detailedId;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getAreId() {
        return areId;
    }

    public void setAreId(String areId) {
        this.areId = areId;
    }

    public String getPlaceId() {
        return placeId;
    }

    public void setPlaceId(String placeId) {
        this.placeId = placeId;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

}

package org.visual.reng.bean;

import org.nutz.dao.entity.annotation.*;

@Table("INS_DETAILED")
public class InsDetailed {

    @Id
    private int id;

    @Column
    private String context;/*巡检内容*/

    @Column
    private int state;/*点检状态（'0'：异常，'1':正常）*/

    @Column("fault_feedback")
    private String feedback;/*故障(信息)反馈*/

    @Column("respond_time")
    private String rsptime;/*响应时间*/

    @Column("solutions_time")
    private String soltime;/*解决时间*/

    @Column("solutions_result")
    private String sol_result;/*处理结果*/

    @Column("genner_id")
    private String gennerId;

    @One(field = "gennerId", key = "id")
    private InsGenner insGenner;

    @Column("persion_id")
    private String persionId;

    @One(field = "persionId", key = "id")
    private InsDepartment insDepartment;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getPersionId() {
        return persionId;
    }

    public void setPersionId(String persionId) {
        this.persionId = persionId;
    }

    public InsDepartment getInsDepartment() {
        return insDepartment;
    }

    public void setInsDepartment(InsDepartment insDepartment) {
        this.insDepartment = insDepartment;
    }

    public String getGennerId() {
        return gennerId;
    }

    public void setGennerId(String gennerId) {
        this.gennerId = gennerId;
    }

    public InsGenner getInsGenner() {
        return insGenner;
    }

    public void setInsGenner(InsGenner insGenner) {
        this.insGenner = insGenner;
    }

    public String getContext() {
        return context;
    }

    public void setContext(String context) {
        this.context = context;
    }

    public int getState() {
        return state;
    }

    public void setState(int state) {
        this.state = state;
    }

    public String getFeedback() {
        return feedback;
    }

    public void setFeedback(String feedback) {
        this.feedback = feedback;
    }

    public String getRsptime() {
        return rsptime;
    }

    public void setRsptime(String rsptime) {
        this.rsptime = rsptime;
    }

    public String getSoltime() {
        return soltime;
    }

    public void setSoltime(String soltime) {
        this.soltime = soltime;
    }

    public String getSol_result() {
        return sol_result;
    }

    public void setSol_result(String sol_result) {
        this.sol_result = sol_result;
    }
}

qq_4945a577 7楼•2547天前

package org.visual.reng.bean;

import org.nutz.dao.entity.annotation.*;

import java.util.Date;
import java.util.List;

@Table("INS_DEPARYMENT")
public class InsDepartment {

    @Id
    private int id;

    @Column
    private String department;/*所属部门*/
    @Column
    private Date date;/*巡检日期*/
    @Column
    private String employee;/*巡检员名字*/

    @Many(field = "id", key="PERSION_ID")
    private List<InsDetailed> insDetailed;

    public int getId() {
        return id;
    }

    public List<InsDetailed> getInsDetailed() {
        return insDetailed;
    }

    public void setInsDetailed(List<InsDetailed> insDetailed) {
        this.insDetailed = insDetailed;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }

    public Date getDate() {
        return date;
    }

    public void setDate(Date date) {
        this.date = date;
    }

    public String getEmployee() {
        return employee;
    }

    public void setEmployee(String employee) {
        this.employee = employee;
    }
}

wendal

8楼•2547天前

是java属性名，不是数据库字段名

qq_4945a577 9楼•2547天前

org.nutz.dao.DaoException: host class=org.visual.ruifeng.bean.InsGenner, props=insDetailed @Many(field="detailedId",key="gennerId")) expect prop=detailedId found at target class=org.visual.ruifeng.bean.InsDetailed

package org.visual.reng.bean;

import org.nutz.dao.entity.annotation.*;

import java.util.List;

@Table("INS_GENNER")
public class InsGenner {

    @Id
    private int id;

    @Column("ARE_ID")
    private String areId;/*所属大区域id*/

    @Column("PLACE_ID")
    private String placeId;/*所属大区域具体地点id*/

    @Column("NAME")
    private String name;/*名称*/

    @Column("DETAILED_ID")
    private String detailedId;

    @Many(field = "detailedId", key="gennerId")
    private List<InsDetailed> insDetailed;

    public List<InsDetailed> getInsDetailed() {
        return insDetailed;
    }

    public void setInsDetailed(List<InsDetailed> insDetailed) {
        this.insDetailed = insDetailed;
    }

    public String getDetailedId() {
        return detailedId;
    }

    public void setDetailedId(String detailedId) {
        this.detailedId = detailedId;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getAreId() {
        return areId;
    }

    public void setAreId(String areId) {
        this.areId = areId;
    }

    public String getPlaceId() {
        return placeId;
    }

    public void setPlaceId(String placeId) {
        this.placeId = placeId;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

}

package org.visual.reng.bean;

import org.nutz.dao.entity.annotation.*;

@Table("INS_DETAILED")
public class InsDetailed {

    @Id
    private int id;

    @Column
    private String context;/*巡检内容*/

    @Column
    private int state;/*点检状态（'0'：异常，'1':正常）*/

    @Column("fault_feedback")
    private String feedback;/*故障(信息)反馈*/

    @Column("respond_time")
    private String rsptime;/*响应时间*/

    @Column("solutions_time")
    private String soltime;/*解决时间*/

    @Column("solutions_result")
    private String sol_result;/*处理结果*/

    @Column("genner_id")
    private String gennerId;

    @One(field = "gennerId", key = "detailedId")
    private InsGenner insGenner;

    @Column("persion_id")
    private String persionId;

    @One(field = "persionId", key = "id")
    private InsDepartment insDepartment;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getPersionId() {
        return persionId;
    }

    public void setPersionId(String persionId) {
        this.persionId = persionId;
    }

    public InsDepartment getInsDepartment() {
        return insDepartment;
    }

    public void setInsDepartment(InsDepartment insDepartment) {
        this.insDepartment = insDepartment;
    }

    public String getGennerId() {
        return gennerId;
    }

    public void setGennerId(String gennerId) {
        this.gennerId = gennerId;
    }

    public InsGenner getInsGenner() {
        return insGenner;
    }

    public void setInsGenner(InsGenner insGenner) {
        this.insGenner = insGenner;
    }

    public String getContext() {
        return context;
    }

    public void setContext(String context) {
        this.context = context;
    }

    public int getState() {
        return state;
    }

    public void setState(int state) {
        this.state = state;
    }

    public String getFeedback() {
        return feedback;
    }

    public void setFeedback(String feedback) {
        this.feedback = feedback;
    }

    public String getRsptime() {
        return rsptime;
    }

    public void setRsptime(String rsptime) {
        this.rsptime = rsptime;
    }

    public String getSoltime() {
        return soltime;
    }

    public void setSoltime(String soltime) {
        this.soltime = soltime;
    }

    public String getSol_result() {
        return sol_result;
    }

    public void setSol_result(String sol_result) {
        this.sol_result = sol_result;
    }
}

qq_4945a577 10楼•2547天前

还是报呀 !~~!

wendal

11楼•2547天前

@Many的key和field写反了

qq_4945a577 12楼•2547天前

2018-01-01 15:07:47,839 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
	at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:140)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
	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.plugins.cache.dao.DaoCacheInterceptor._exec(DaoCacheInterceptor.java:28)
	at org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:187)
	at org.nutz.plugins.cache.dao.DaoCacheInterceptor.filter(DaoCacheInterceptor.java:18)
	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.visual.ruifeng.module.InspectionModule.queryDepartment(InspectionModule.java:39)
	at org.mytest.ty.test.NutzJunitTest.testQueryDepartment(NutzJunitTest.java:79)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:33)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:14)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)

org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM INS_DEPARTMENT ) T WHERE ROWNUM <= 10) WHERE RN > 0 '
PreparedStatement: 
'SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM INS_DEPARTMENT ) T WHERE ROWNUM <= 10) WHERE RN > 0 '
CaseMessage=ORA-00942: 表或视图不存在


	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.plugins.cache.dao.DaoCacheInterceptor._exec(DaoCacheInterceptor.java:28)
	at org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:187)
	at org.nutz.plugins.cache.dao.DaoCacheInterceptor.filter(DaoCacheInterceptor.java:18)
	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.visual.ruifeng.module.InspectionModule.queryDepartment(InspectionModule.java:39)
	at org.mytest.ty.test.NutzJunitTest.testQueryDepartment(NutzJunitTest.java:79)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:33)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:14)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
	at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:140)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
	... 42 more

qq_4945a577 13楼•2547天前

把sql语句拿到数据库去世正常的语句可以查询出信息

wendal

14楼•2547天前

表名的大小写不对？

qq_4945a577 15楼•2547天前

数据库表明和代码@Table("") 都是大写，可还是报异常

qq_4945a577 16楼•2547天前

package org.visual.reng.bean;

import org.nutz.dao.entity.annotation.*;

import java.util.Date;
import java.util.List;

@Table("INS_DEPARTMENT")
public class InsDepartment {

    @Id
    private long id;

    @Column
    private String department;/*所属部门*/
    @Column
    private Date date;/*巡检日期*/
    @Column
    private String employee;/*巡检员名字*/

    @Many(field = "persionId", key="id")
    private List<InsDetailed> insDetailed;

    public long getId() {
        return id;
    }

    public List<InsDetailed> getInsDetailed() {
        return insDetailed;
    }

    public void setInsDetailed(List<InsDetailed> insDetailed) {
        this.insDetailed = insDetailed;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }

    public Date getDate() {
        return date;
    }

    public void setDate(Date date) {
        this.date = date;
    }

    public String getEmployee() {
        return employee;
    }

    public void setEmployee(String employee) {
        this.employee = employee;
    }
}

D:\Software_Develop\Java\jdk1.8.0_121\bin\java -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:D:\Software_Develop\IntelliJ IDEA 2017.3.2\lib\idea_rt.jar=58013:D:\Software_Develop\IntelliJ IDEA 2017.3.2\bin" -Dfile.encoding=UTF-8 -classpath "D:\Software_Develop\IntelliJ IDEA 2017.3.2\lib\idea_rt.jar;D:\Software_Develop\IntelliJ IDEA 2017.3.2\plugins\junit\lib\junit-rt.jar;D:\Software_Develop\IntelliJ IDEA 2017.3.2\plugins\junit\lib\junit5-rt.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\charsets.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\deploy.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\access-bridge-64.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\cldrdata.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\dnsns.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\jaccess.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\jfxrt.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\localedata.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\nashorn.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\sunec.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\sunjce_provider.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\sunmscapi.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\sunpkcs11.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\ext\zipfs.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\javaws.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\jce.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\jfr.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\jfxswt.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\jsse.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\management-agent.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\plugin.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\resources.jar;D:\Software_Develop\Java\jdk1.8.0_121\jre\lib\rt.jar;D:\WorkSpace\IntelliJIdear_Workspace_No.1\InspeManagement\target\test-classes;D:\WorkSpace\IntelliJIdear_Workspace_No.1\InspeManagement\target\classes;D:\Software_Develop\maven\Repository\org\nutz\nutz\1.r.63-SNAPSHOT\nutz-1.r.63-20171115.070034-161.jar;D:\Software_Develop\maven\Repository\org\apache\shiro\shiro-core\1.3.2\shiro-core-1.3.2.jar;D:\Software_Develop\maven\Repository\org\apache\shiro\shiro-web\1.3.2\shiro-web-1.3.2.jar;D:\Software_Develop\maven\Repository\org\apache\shiro\shiro-ehcache\1.3.2\shiro-ehcache-1.3.2.jar;D:\Software_Develop\maven\Repository\net\sf\ehcache\ehcache-core\2.5.3\ehcache-core-2.5.3.jar;D:\Software_Develop\maven\Repository\com\ibeetl\beetl\2.7.22\beetl-2.7.22.jar;D:\Software_Develop\maven\Repository\org\antlr\antlr4-runtime\4.2\antlr4-runtime-4.2.jar;D:\Software_Develop\maven\Repository\org\abego\treelayout\org.abego.treelayout.core\1.0.1\org.abego.treelayout.core-1.0.1.jar;D:\Software_Develop\maven\Repository\org\antlr\antlr4-annotations\4.2\antlr4-annotations-4.2.jar;D:\Software_Develop\maven\Repository\org\nutz\nutz-plugins-daocache\1.r.62\nutz-plugins-daocache-1.r.62.jar;D:\Software_Develop\maven\Repository\net\sf\ehcache\ehcache\2.10.4\ehcache-2.10.4.jar;D:\Software_Develop\maven\Repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\Software_Develop\maven\Repository\org\slf4j\slf4j-log4j12\1.7.25\slf4j-log4j12-1.7.25.jar;D:\Software_Develop\maven\Repository\commons-beanutils\commons-beanutils\1.9.3\commons-beanutils-1.9.3.jar;D:\Software_Develop\maven\Repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;D:\Software_Develop\maven\Repository\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;D:\Software_Develop\maven\Repository\jstl\jstl\1.2\jstl-1.2.jar;D:\Software_Develop\maven\Repository\org\apache\commons\commons-email\1.5\commons-email-1.5.jar;D:\Software_Develop\maven\Repository\com\sun\mail\javax.mail\1.5.6\javax.mail-1.5.6.jar;D:\Software_Develop\maven\Repository\javax\mail\mail\1.4\mail-1.4.jar;D:\Software_Develop\maven\Repository\javax\activation\activation\1.1\activation-1.1.jar;D:\Software_Develop\maven\Repository\cn\apiclub\tool\simplecaptcha\1.2.2\simplecaptcha-1.2.2.jar;D:\Software_Develop\maven\Repository\org\nutz\nutz-integration-quartz\1.r.62\nutz-integration-quartz-1.r.62.jar;D:\Software_Develop\maven\Repository\org\nutz\nutz-integration-shiro\1.r.62\nutz-integration-shiro-1.r.62.jar;D:\Software_Develop\maven\Repository\org\slf4j\jcl-over-slf4j\1.7.24\jcl-over-slf4j-1.7.24.jar;D:\Software_Develop\maven\Repository\org\nutz\nutz-plugins-apidoc\1.r.62\nutz-plugins-apidoc-1.r.62.jar;D:\Software_Develop\maven\Repository\redis\clients\jedis\2.8.1\jedis-2.8.1.jar;D:\Software_Develop\maven\Repository\org\apache\commons\commons-pool2\2.4.2\commons-pool2-2.4.2.jar;D:\Software_Develop\maven\Repository\org\nutz\nutz-integration-jedis\1.r.63-SNAPSHOT\nutz-integration-jedis-1.r.63-20171115.121909-125.jar;D:\Software_Develop\maven\Repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;D:\Software_Develop\maven\Repository\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;D:\Software_Develop\maven\Repository\org\apache\maven\plugins\maven-resources-plugin\2.4.3\maven-resources-plugin-2.4.3.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-plugin-api\2.0.6\maven-plugin-api-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-project\2.0.6\maven-project-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-profile\2.0.6\maven-profile-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-artifact-manager\2.0.6\maven-artifact-manager-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-plugin-registry\2.0.6\maven-plugin-registry-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-core\2.0.6\maven-core-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\wagon\wagon-file\1.0-beta-2\wagon-file-1.0-beta-2.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-plugin-parameter-documenter\2.0.6\maven-plugin-parameter-documenter-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\wagon\wagon-http-lightweight\1.0-beta-2\wagon-http-lightweight-1.0-beta-2.jar;D:\Software_Develop\maven\Repository\org\apache\maven\wagon\wagon-http-shared\1.0-beta-2\wagon-http-shared-1.0-beta-2.jar;D:\Software_Develop\maven\Repository\jtidy\jtidy\4aug2000r7-dev\jtidy-4aug2000r7-dev.jar;D:\Software_Develop\maven\Repository\xml-apis\xml-apis\1.0.b2\xml-apis-1.0.b2.jar;D:\Software_Develop\maven\Repository\org\apache\maven\reporting\maven-reporting-api\2.0.6\maven-reporting-api-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\doxia\doxia-sink-api\1.0-alpha-7\doxia-sink-api-1.0-alpha-7.jar;D:\Software_Develop\maven\Repository\org\apache\maven\wagon\wagon-provider-api\1.0-beta-2\wagon-provider-api-1.0-beta-2.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-repository-metadata\2.0.6\maven-repository-metadata-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-error-diagnostics\2.0.6\maven-error-diagnostics-2.0.6.jar;D:\Software_Develop\maven\Repository\commons-cli\commons-cli\1.0\commons-cli-1.0.jar;D:\Software_Develop\maven\Repository\org\apache\maven\wagon\wagon-ssh-external\1.0-beta-2\wagon-ssh-external-1.0-beta-2.jar;D:\Software_Develop\maven\Repository\org\apache\maven\wagon\wagon-ssh-common\1.0-beta-2\wagon-ssh-common-1.0-beta-2.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-plugin-descriptor\2.0.6\maven-plugin-descriptor-2.0.6.jar;D:\Software_Develop\maven\Repository\org\codehaus\plexus\plexus-interactivity-api\1.0-alpha-4\plexus-interactivity-api-1.0-alpha-4.jar;D:\Software_Develop\maven\Repository\org\apache\maven\wagon\wagon-ssh\1.0-beta-2\wagon-ssh-1.0-beta-2.jar;D:\Software_Develop\maven\Repository\com\jcraft\jsch\0.1.27\jsch-0.1.27.jar;D:\Software_Develop\maven\Repository\classworlds\classworlds\1.1\classworlds-1.1.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-artifact\2.0.6\maven-artifact-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-settings\2.0.6\maven-settings-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-model\2.0.6\maven-model-2.0.6.jar;D:\Software_Develop\maven\Repository\org\apache\maven\maven-monitor\2.0.6\maven-monitor-2.0.6.jar;D:\Software_Develop\maven\Repository\org\codehaus\plexus\plexus-container-default\1.0-alpha-9-stable-1\plexus-container-default-1.0-alpha-9-stable-1.jar;D:\Software_Develop\maven\Repository\org\codehaus\plexus\plexus-utils\2.0.5\plexus-utils-2.0.5.jar;D:\Software_Develop\maven\Repository\org\apache\maven\shared\maven-filtering\1.0-beta-4\maven-filtering-1.0-beta-4.jar;D:\Software_Develop\maven\Repository\org\sonatype\plexus\plexus-build-api\0.0.4\plexus-build-api-0.0.4.jar;D:\Software_Develop\maven\Repository\org\codehaus\plexus\plexus-interpolation\1.13\plexus-interpolation-1.13.jar;D:\Software_Develop\maven\Repository\org\oracle\ojdbc6\6\ojdbc6-6.jar;D:\Software_Develop\maven\Repository\org\quartz-scheduler\quartz\2.2.1\quartz-2.2.1.jar;D:\Software_Develop\maven\Repository\c3p0\c3p0\0.9.1.1\c3p0-0.9.1.1.jar;D:\Software_Develop\maven\Repository\org\quartz-scheduler\quartz-jobs\2.2.1\quartz-jobs-2.2.1.jar;D:\Software_Develop\maven\Repository\com\alibaba\druid\1.0.27\druid-1.0.27.jar;D:\Software_Develop\Java\jdk1.8.0_121\lib\jconsole.jar;D:\Software_Develop\Java\jdk1.8.0_121\lib\tools.jar;D:\Software_Develop\maven\Repository\org\nutz\nutz-plugins-mock\1.r.63-SNAPSHOT\nutz-plugins-mock-1.r.63-20171115.122045-125.jar;D:\Software_Develop\maven\Repository\junit\junit\4.12\junit-4.12.jar;D:\Software_Develop\maven\Repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\Software_Develop\maven\Repository\org\mockito\mockito-core\2.10.0\mockito-core-2.10.0.jar;D:\Software_Develop\maven\Repository\net\bytebuddy\byte-buddy\1.7.4\byte-buddy-1.7.4.jar;D:\Software_Develop\maven\Repository\net\bytebuddy\byte-buddy-agent\1.7.4\byte-buddy-agent-1.7.4.jar;D:\Software_Develop\maven\Repository\org\objenesis\objenesis\2.6\objenesis-2.6.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 org.mytest.ty.test.NutzJunitTest,testQueryDepartment
2018-01-01 16:10:31,446 org.nutz.resource.Scans.printLocations(Scans.java:527) DEBUG - Locations count=109 time use 85ms
2018-01-01 16:10:31,458 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 3 resource by src( ioc/ ) , regex( ^(.+[.])(js|json)$ )
2018-01-01 16:10:31,459 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:49) DEBUG - loading [dao.js]
2018-01-01 16:10:31,461 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:49) DEBUG - loading [ehcache.js]
2018-01-01 16:10:31,461 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:49) DEBUG - loading [mail.js]
2018-01-01 16:10:31,462 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:57) DEBUG - Loaded 8 bean define from path=[ioc/] --> [dao, cacheProvider, emailAuthenticator, htmlEmail, cacheExecutor, conf, dataSource, cacheManager]
2018-01-01 16:10:31,478 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 30 resource by src( org/visual/reng/ ) , regex( ^.+[.]class$ )
2018-01-01 16:10:31,496 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.module.AuthorityModule
2018-01-01 16:10:31,509 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.module.CaptchaModule
2018-01-01 16:10:31,512 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.module.DataModule
2018-01-01 16:10:31,512 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.module.InspectionModule
2018-01-01 16:10:31,513 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.module.SqlMappingModule
2018-01-01 16:10:31,513 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.module.UserModule
2018-01-01 16:10:31,518 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.module.UserProfileModule
2018-01-01 16:10:31,522 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.quartz.job.CleanNonActiveUserJob
2018-01-01 16:10:31,523 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.service.AuthorityServiceImpl
2018-01-01 16:10:31,525 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.service.EmailServiceImpl
2018-01-01 16:10:31,525 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.visual.reng.service.UserService
2018-01-01 16:10:31,532 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 2 resource by src( org/mytest/ ) , regex( ^.+[.]class$ )
2018-01-01 16:10:31,533 org.nutz.ioc.loader.annotation.AnnotationIocLoader.addClass(AnnotationIocLoader.java:80) DEBUG - Found @IocBean : class org.mytest.ty.test.NutzJunitTest
2018-01-01 16:10:31,564 org.nutz.castor.Castors.reload(Castors.java:115) DEBUG - Using 95 castor for Castors
2018-01-01 16:10:31,566 org.nutz.ioc.loader.annotation.AnnotationIocLoader.<init>(AnnotationIocLoader.java:56) INFO  - Found 12 classes in 2 base-packages!
beans = ["inspectionModule", "cleanNonActiveUserJob", "sqlMappingModule", "authorityService", "userProfileModule", "dataModule", "nutzJunitTest", "captchaModule", "authorityModule", "userModule", "emailService", "userService"]
2018-01-01 16:10:31,572 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:40) DEBUG - Loaded 5 bean define from reader --
[txREPEATABLE_READ, txSERIALIZABLE, txNONE, txREAD_UNCOMMITTED, txREAD_COMMITTED]
2018-01-01 16:10:31,572 org.nutz.ioc.loader.combo.ComboIocLoader.createIocLoader(ComboIocLoader.java:112) DEBUG - found jedis -- org.nutz.integration.jedis.JedisIocLoader
2018-01-01 16:10:31,575 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 1 resource by src( org/nutz/integration/jedis/jedis.js ) , regex( ^(.+[.])(js|json)$ )
2018-01-01 16:10:31,576 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:49) DEBUG - loading [org/nutz/integration/jedis/jedis.js]
2018-01-01 16:10:31,579 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:57) DEBUG - Loaded 9 bean define from path=[org/nutz/integration/jedis/jedis.js] --> [redisService, jedisCluster, jedisClusterNodes, jedisClusterWrapper, pubSubService, jedisPoolConfig, jedisPool, jedisAgent, redis]
2018-01-01 16:10:31,583 org.nutz.ioc.loader.combo.ComboIocLoader.createIocLoader(ComboIocLoader.java:112) DEBUG - found quartz -- org.nutz.integration.quartz.QuartzIocLoader
2018-01-01 16:10:31,586 org.nutz.ioc.loader.json.JsonLoader.<init>(JsonLoader.java:57) DEBUG - Loaded 0 bean define from path=[] --> []
2018-01-01 16:10:31,589 org.nutz.ioc.impl.NutIoc.<init>(NutIoc.java:98) INFO  - NutIoc init begin ...
2018-01-01 16:10:31,591 org.nutz.ioc.impl.NutIoc.<init>(NutIoc.java:121) INFO  - ... NutIoc init complete
2018-01-01 16:10:31,591 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'conf'<class org.nutz.ioc.impl.PropertiesProxy>
2018-01-01 16:10:31,592 org.nutz.ioc.aop.SimpleAopMaker.<init>(SimpleAopMaker.java:79) DEBUG - Load AopConfigure for anno=org.nutz.ioc.aop.Aop by type=org.nutz.ioc.aop.config.impl.AnnotationAopConfigration
2018-01-01 16:10:31,592 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=conf
2018-01-01 16:10:31,592 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=conf
2018-01-01 16:10:31,605 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(conf) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,606 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'conf'<class org.nutz.ioc.impl.PropertiesProxy>
2018-01-01 16:10:31,606 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'conf' to [app] 
2018-01-01 16:10:31,607 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.ioc.impl.PropertiesProxy without AOP
2018-01-01 16:10:31,746 org.nutz.resource.Scans.scan(Scans.java:280) DEBUG - Found 3 resource by src( custom/ ) , regex( ^.+[.]properties$ )
2018-01-01 16:10:31,746 org.nutz.ioc.impl.PropertiesProxy.setPaths(PropertiesProxy.java:113) DEBUG - load properties from File[D:\WorkSpace\IntelliJIdear_Workspace_No.1\InspeManagement\target\classes\custom\cron.properties]
2018-01-01 16:10:31,748 org.nutz.ioc.impl.PropertiesProxy.setPaths(PropertiesProxy.java:113) DEBUG - load properties from File[D:\WorkSpace\IntelliJIdear_Workspace_No.1\InspeManagement\target\classes\custom\db.properties]
2018-01-01 16:10:31,749 org.nutz.ioc.impl.PropertiesProxy.setPaths(PropertiesProxy.java:113) DEBUG - load properties from File[D:\WorkSpace\IntelliJIdear_Workspace_No.1\InspeManagement\target\classes\custom\mail.properties]
2018-01-01 16:10:31,750 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'nutzJunitTest'<class org.mytest.ty.test.NutzJunitTest>
2018-01-01 16:10:31,751 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=nutzJunitTest
2018-01-01 16:10:31,751 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(nutzJunitTest) in AnnotationIocLoader(packages=[org.visual.reng, org.mytest])
2018-01-01 16:10:31,751 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'nutzJunitTest'<class org.mytest.ty.test.NutzJunitTest>
2018-01-01 16:10:31,752 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'nutzJunitTest' to [app] 
2018-01-01 16:10:31,752 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.mytest.ty.test.NutzJunitTest without AOP
2018-01-01 16:10:31,832 org.nutz.ioc.val.ReferTypeValue.get(ReferTypeValue.java:64) DEBUG - name=inspectionmodule not found, search for type=org.visual.reng.module.InspectionModule
2018-01-01 16:10:31,833 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dao
2018-01-01 16:10:31,836 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(dao) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,837 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=cacheProvider
2018-01-01 16:10:31,849 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(cacheProvider) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,849 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=emailAuthenticator
2018-01-01 16:10:31,851 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(emailAuthenticator) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,852 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=htmlEmail
2018-01-01 16:10:31,854 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(htmlEmail) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,854 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=cacheExecutor
2018-01-01 16:10:31,856 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(cacheExecutor) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,856 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=conf
2018-01-01 16:10:31,856 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(conf) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,856 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dataSource
2018-01-01 16:10:31,869 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,869 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=cacheManager
2018-01-01 16:10:31,869 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(cacheManager) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,869 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(inspectionModule) in AnnotationIocLoader(packages=[org.visual.reng, org.mytest])
2018-01-01 16:10:31,870 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'inspectionModule'<class org.visual.reng.module.InspectionModule>
2018-01-01 16:10:31,870 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=inspectionModule
2018-01-01 16:10:31,870 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(inspectionModule) in AnnotationIocLoader(packages=[org.visual.reng, org.mytest])
2018-01-01 16:10:31,870 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'inspectionModule'<class org.visual.reng.module.InspectionModule>
2018-01-01 16:10:31,870 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'inspectionModule' to [app] 
2018-01-01 16:10:31,870 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.visual.reng.module.InspectionModule without AOP
2018-01-01 16:10:31,873 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'dao'<interface org.nutz.dao.Dao>
2018-01-01 16:10:31,873 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=dao
2018-01-01 16:10:31,873 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dao
2018-01-01 16:10:31,874 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(dao) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,874 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'dao'<interface org.nutz.dao.Dao>
2018-01-01 16:10:31,874 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'dao' to [app] 
2018-01-01 16:10:31,875 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'dataSource'<>
2018-01-01 16:10:31,875 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=dataSource
2018-01-01 16:10:31,875 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=dataSource
2018-01-01 16:10:31,875 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(dataSource) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:31,875 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'dataSource'<>
2018-01-01 16:10:31,876 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'dataSource' to [app] 
2018-01-01 16:10:31,898 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class com.alibaba.druid.pool.DruidDataSource without AOP
2018-01-01 16:10:31,899 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'conf'<>
2018-01-01 16:10:32,406 com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:715) INFO  - {dataSource-1} inited
2018-01-01 16:10:32,412 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.dao.impl.NutDao without AOP
2018-01-01 16:10:32,412 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'dataSource'<>
2018-01-01 16:10:32,509 org.nutz.dao.jdbc.Jdbcs.<clinit>(Jdbcs.java:90) DEBUG - Jdbcs init complete
2018-01-01 16:10:32,510 org.nutz.dao.jdbc.Jdbcs.getExpert(Jdbcs.java:103) INFO  - Get Connection from DataSource for JdbcExpert, if you lock at here, check your database server and configure
2018-01-01 16:10:32,718 org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:188) DEBUG - select expert : org.nutz.dao.impl.jdbc.oracle.OracleJdbcExpert
2018-01-01 16:10:32,722 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:199) DEBUG - JDBC Driver --> 11.2.0.4.0
2018-01-01 16:10:32,722 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:200) DEBUG - JDBC Name   --> Oracle JDBC driver
2018-01-01 16:10:32,722 org.nutz.dao.impl.DaoSupport$1.invoke(DaoSupport.java:202) DEBUG - JDBC URL    --> jdbc:oracle:thin:@//127.0.0.1:1521/orcl
2018-01-01 16:10:32,723 org.nutz.dao.impl.DaoSupport.setDataSource(DaoSupport.java:221) DEBUG - Database info --> ORACLE:[Oracle - Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options]
2018-01-01 16:10:32,726 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'cacheExecutor'<>
2018-01-01 16:10:32,726 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=cacheExecutor
2018-01-01 16:10:32,726 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=cacheExecutor
2018-01-01 16:10:32,727 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(cacheExecutor) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:32,727 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'cacheExecutor'<>
2018-01-01 16:10:32,727 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'cacheExecutor' to [app] 
2018-01-01 16:10:32,728 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.plugins.cache.dao.DaoCacheInterceptor without AOP
2018-01-01 16:10:32,733 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'cacheProvider'<>
2018-01-01 16:10:32,733 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=cacheProvider
2018-01-01 16:10:32,733 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=cacheProvider
2018-01-01 16:10:32,734 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(cacheProvider) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:32,734 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'cacheProvider'<>
2018-01-01 16:10:32,734 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'cacheProvider' to [app] 
2018-01-01 16:10:32,737 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.plugins.cache.dao.impl.provider.EhcacheDaoCacheProvider without AOP
2018-01-01 16:10:32,740 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'cacheManager'<>
2018-01-01 16:10:32,741 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=cacheManager
2018-01-01 16:10:32,741 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=cacheManager
2018-01-01 16:10:32,741 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(cacheManager) in JsonLoader(paths=[ioc/])
2018-01-01 16:10:32,741 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'cacheManager'<>
2018-01-01 16:10:32,741 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'cacheManager' to [app] 
2018-01-01 16:10:32,752 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class net.sf.ehcache.CacheManager without AOP
2018-01-01 16:10:32,760 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'cacheManager'<class net.sf.ehcache.CacheManager>
2018-01-01 16:10:32,760 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'emailService'<interface org.visual.reng.service.EmailService>
2018-01-01 16:10:32,760 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:183) DEBUG - 	 >> Load definition name=emailService
2018-01-01 16:10:32,760 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:163) DEBUG - Found IocObject(emailService) in AnnotationIocLoader(packages=[org.visual.reng, org.mytest])
2018-01-01 16:10:32,761 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:215) DEBUG - 	 >> Make...'emailService'<interface org.visual.reng.service.EmailService>
2018-01-01 16:10:32,761 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'emailService' to [app] 
2018-01-01 16:10:32,761 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.visual.reng.service.EmailServiceImpl without AOP
2018-01-01 16:10:32,764 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:157) DEBUG - Get 'dao'<interface org.nutz.dao.Dao>
2018-01-01 16:10:32,853 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM INS_DEPARTMENT ) T WHERE ROWNUM <= 10) WHERE RN > 0 
2018-01-01 16:10:32,865 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
	at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:140)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
	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.plugins.cache.dao.DaoCacheInterceptor._exec(DaoCacheInterceptor.java:28)
	at org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:187)
	at org.nutz.plugins.cache.dao.DaoCacheInterceptor.filter(DaoCacheInterceptor.java:18)
	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.visual.reng.module.InspectionModule.queryDepartment(InspectionModule.java:39)
	at org.mytest.ty.test.NutzJunitTest.testQueryDepartment(NutzJunitTest.java:79)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:33)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:14)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)

org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM INS_DEPARTMENT ) T WHERE ROWNUM <= 10) WHERE RN > 0 '
PreparedStatement: 
'SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM INS_DEPARTMENT ) T WHERE ROWNUM <= 10) WHERE RN > 0 '
CaseMessage=ORA-00942: 表或视图不存在


	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.plugins.cache.dao.DaoCacheInterceptor._exec(DaoCacheInterceptor.java:28)
	at org.nutz.plugins.cache.dao.CachedNutDaoExecutor.exec(CachedNutDaoExecutor.java:187)
	at org.nutz.plugins.cache.dao.DaoCacheInterceptor.filter(DaoCacheInterceptor.java:18)
	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.visual.reng.module.InspectionModule.queryDepartment(InspectionModule.java:39)
	at org.mytest.ty.test.NutzJunitTest.testQueryDepartment(NutzJunitTest.java:79)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:33)
	at org.nutz.mock.NutTestRunner.runChild(NutTestRunner.java:14)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
	at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:140)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
	... 42 more

2018-01-01 16:10:32,893 org.nutz.ioc.impl.NutIoc.depose(NutIoc.java:261) INFO  - org.nutz.ioc.impl.NutIoc@1632413663 is closing. startup date [18-01-01 16:10:31.589]
2018-01-01 16:10:32,894 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'emailService' ...
2018-01-01 16:10:32,894 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'cacheManager' ...
2018-01-01 16:10:32,894 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'cacheProvider' ...
2018-01-01 16:10:32,894 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'cacheExecutor' ...
2018-01-01 16:10:32,894 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'dao' ...
2018-01-01 16:10:32,894 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'inspectionModule' ...
2018-01-01 16:10:32,894 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'nutzJunitTest' ...
2018-01-01 16:10:32,895 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:108) DEBUG - Depose object 'conf' ...
2018-01-01 16:10:32,895 org.nutz.ioc.impl.ScopeContext.clear(ScopeContext.java:113) DEBUG - Depose object 'dataSource' ...
2018-01-01 16:10:32,907 com.alibaba.druid.pool.DruidDataSource.close(DruidDataSource.java:1444) INFO  - {dataSource-1} closed
2018-01-01 16:10:32,907 org.nutz.ioc.impl.NutIoc.depose(NutIoc.java:274) INFO  - org.nutz.ioc.impl.NutIoc@1632413663 is deposed. startup date [18-01-01 16:10:31.589]

Process finished with exit code -1

wendal

17楼•2547天前

连错数据库吧

qq_4945a577 18楼•2544天前

（我英文不好，确认一下）
@Many(field = "detailedId", key="gennerId") field对应的是“多”的一方的外键 key 对应的是“一”的一方的外键是吗？
而@One(field = "detailedId", key="gennerId") field对应的是（声明@One的）当前类的一方的外键，key 对应的是另一方或者多的一方的外键是吗

wendal

19楼•2544天前

@Many,field是多方, key是一方

@One, field是当前类, key是另外一方

很蛋疼是不是, 写这个的时候commiter脑抽了是不是...

qq_4945a577 20楼•2542天前

是！

请先登陆