Nutz
  1. 主页/
  2. 问答
NutzCN Logo
问答 nutz 插入报无效字符问题
发布于 2577天前 作者 苍蓝猛兽 1155 次浏览 复制 上一个帖子 下一个帖子
标签: 无 
插入语句
insert into statdba.stat_monappsysmonitor
  (corporationid,
   dictid,
   id,
   time,
   subtypecode,
   name,
   firstdate,
   flackedkpinum,
   fkpiid,
   seconddate,
   slackedkpinum,
   skpiid)
values
  ('0300',
   '00800',
   'weblogicid8',
   to_date('2017-03-31 10:23:29', 'yyyy-mm-dd hh24:mi:ss'),
   '0601',
   '',
   to_date('2017-02-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),
   2,
   '0717001,0717030',
   to_date('2017-02-12 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),
   1,
   '0717030');
   
   
   表结构
   
   create table STATDBA.STAT_MONAPPSYSMONITOR
    (
      corporationid VARCHAR2(10) not null,
      dictid        VARCHAR2(20) not null,
      id            VARCHAR2(20) not null,
      time          DATE not null,
      subtypecode   VARCHAR2(200),
      name          VARCHAR2(200),
      firstdate     DATE,
      flackedkpinum NUMBER(20),
      fkpiid        VARCHAR2(2000),
      seconddate    DATE,
      slackedkpinum NUMBER(20),
      skpiid        VARCHAR2(2000),
      flag          NUMBER(1) default 0
    )
    
    错误提示
    
    java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符
    
    
    在plsql中执行插入sql，提示插入成功，这种是怎么回事？？？
15 回复

time是关键字

insert into statdba.stat_monappsysmonitor
  (corporationid,
   dictid,
   id,
   "TIME",
   subtypecode,
   name,
   firstdate,
   flackedkpinum,
   fkpiid,
   seconddate,
   slackedkpinum,
   skpiid)
values
  ('0300',
   '00800',
   'weblogicid8',
   to_date('2017-03-31 10:33:57', 'yyyy-mm-dd hh24:mi:ss'),
   '0601',
   '',
   to_date('2017-02-25 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),
   2,
   '0717001,0717030',
   to_date('2017-02-18 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),
   1,
   '0717030');

改成这样后，依旧不能插入

    楼上sql在plsql中可以执行。。

   insert into statdba.stat_monappsysmonitor
	  (corporationid,
	   dictid,
	   id,
	   "TIME",
	   subtypecode,
	   name,
	   firstdate,
	   flackedkpinum,
	   fkpiid,
	   seconddate,
	   slackedkpinum,
	   skpiid)
	values
	  (@corporationid,
	   @dictid,
	   @id,
	   to_date(@time, 'yyyy-mm-dd hh24:mi:ss'),
	   @subtypecode,
	   @name,
	   to_date(@firstdate, 'yyyy-mm-dd hh24:mi:ss'),
	   @flackedkpinum,
	   @fkpiid,
	   to_date(@seconddate, 'yyyy-mm-dd hh24:mi:ss'),
	   @slackedkpinum,
	   @skpiid);

sqls文件中定义的sql

@wendal

贴完整报错信息

For example:> "insert into statdba.stat_monappsysmonitor
(corporationid,
dictid,
id,
"TIME",
subtypecode,
name,
firstdate,
flackedkpinum,
fkpiid,
seconddate,
slackedkpinum,
skpiid)
values
('0300',
'00800',
'weblogicid8',
to_date(''2017-03-31 10:38:48'', 'yyyy-mm-dd hh24:mi:ss'),
'0601',
'',
to_date(''2017-02-14 00:00:00'', 'yyyy-mm-dd hh24:mi:ss'),
2,
'0717001,0717030',
to_date(''2017-02-07 00:00:00'', 'yyyy-mm-dd hh24:mi:ss'),
1,
'0717030');"
03-31 10:38:48.856 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [exec]
			- SQLException
java.sql.SQLException: 无效的列索引
	at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5386) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5374) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:282) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.setString(DruidPooledPreparedStatement.java:365) ~[druid-1.0.18.jar:1.0.18]
	at org.nutz.dao.jdbc.Jdbcs$Adaptor$2.set(Jdbcs.java:288) ~[nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:318) ~[nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:248) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:973) [nutz-1.r.60.jar:?]
	at com.nari.nwims.skengine.modules.sk20096.dao.SK20096Dao.saveMonAppsysMonitor(SK20096Dao.java:136) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20096.SK20096Calc.saveMonAppsysMonitor(SK20096Calc.java:62) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094Calc.run(SK20094Calc.java:138) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094CalcTest.calc(SK20094CalcTest.java:16) [test-classes/:?]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.6.0_45]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[?:1.6.0_45]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[?:1.6.0_45]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[?:1.6.0_45]
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.12.jar:4.12]
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363) [junit-4.12.jar:4.12]
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) [.cp/:?]

@wendal

发错了

For example:> "insert into statdba.stat_monappsysmonitor
(corporationid,
dictid,
id,
"TIME",
subtypecode,
name,
firstdate,
flackedkpinum,
fkpiid,
seconddate,
slackedkpinum,
skpiid)
values
('0300',
'00800',
'weblogicid8',
to_date('2017-03-31 10:43:20', 'yyyy-mm-dd hh24:mi:ss'),
'0601',
'',
to_date('2017-02-15 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),
2,
'0717001,0717030',
to_date('2017-02-08 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),
1,
'0717030');"
03-31 10:43:20.535 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [exec]
			- SQLException
java.sql.BatchUpdateException: ORA-00911: 无效字符

	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:559) ~[druid-1.0.18.jar:1.0.18]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:322) ~[nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:248) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:973) [nutz-1.r.60.jar:?]
	at com.nari.nwims.skengine.modules.sk20096.dao.SK20096Dao.saveMonAppsysMonitor(SK20096Dao.java:136) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20096.SK20096Calc.saveMonAppsysMonitor(SK20096Calc.java:62) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094Calc.run(SK20094Calc.java:138) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094CalcTest.calc(SK20094CalcTest.java:16) [test-classes/:?]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.6.0_45]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[?:1.6.0_45]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[?:1.6.0_45]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[?:1.6.0_45]
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.12.jar:4.12]
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363) [junit-4.12.jar:4.12]
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) [.cp/:?]
03-31 10:43:20.540 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [exec]
			- SQL NextException
java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10298) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10404) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:559) ~[druid-1.0.18.jar:1.0.18]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:322) ~[nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:248) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:973) [nutz-1.r.60.jar:?]
	at com.nari.nwims.skengine.modules.sk20096.dao.SK20096Dao.saveMonAppsysMonitor(SK20096Dao.java:136) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20096.SK20096Calc.saveMonAppsysMonitor(SK20096Calc.java:62) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094Calc.run(SK20094Calc.java:138) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094CalcTest.calc(SK20094CalcTest.java:16) [test-classes/:?]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.6.0_45]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[?:1.6.0_45]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[?:1.6.0_45]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[?:1.6.0_45]
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.12.jar:4.12]
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363) [junit-4.12.jar:4.12]
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) [.cp/:?]

是这个错误

@wendal 楼上的错误

前面还有几行，贴一下

03-31 10:43:17.283 DEBUG [main] org.nutz.resource.Scans [<init>]
			- Locations for Scans:
[Dir[path=D:\workspace\java\sk\nwims-statkpi-engine2], Jar[path=E:\maven\.m2\repository\org\nutz\nutz\1.r.60\nutz-1.r.60.jar], Dir[path=D:\tools\eclipse\eclipse\configuration\org.eclipse.osgi\362\0\.cp], Dir[path=D:\tools\eclipse\eclipse\configuration\org.eclipse.osgi\361\0\.cp], Dir[path=D:\workspace\java\sk\nwims-statkpi-engine2\target\test-classes], Dir[path=D:\workspace\java\sk\nwims-statkpi-engine2\target\classes], Jar[path=E:\maven\.m2\repository\org\nutz\nutzmongo\1.r.60\nutzmongo-1.r.60.jar], Jar[path=E:\maven\.m2\repository\org\mongodb\mongo-java-driver\3.2.2\mongo-java-driver-3.2.2.jar], Jar[path=E:\maven\.m2\repository\org\apache\logging\log4j\log4j-1.2-api\2.3\log4j-1.2-api-2.3.jar], Jar[path=E:\maven\.m2\repository\org\apache\logging\log4j\log4j-api\2.3\log4j-api-2.3.jar], Jar[path=E:\maven\.m2\repository\org\apache\logging\log4j\log4j-core\2.3\log4j-core-2.3.jar], Jar[path=E:\maven\.m2\repository\com\oracle\ojdbc6\11.2.0.4.0\ojdbc6-11.2.0.4.0.jar], Jar[path=E:\maven\.m2\repository\com\alibaba\druid\1.0.18\druid-1.0.18.jar], Jar[path=E:\maven\.m2\repository\com\lmax\disruptor\3.3.6\disruptor-3.3.6.jar], Jar[path=E:\maven\.m2\repository\com\google\guava\guava\19.0\guava-19.0.jar], Jar[path=E:\maven\.m2\repository\junit\junit\4.12\junit-4.12.jar], Jar[path=E:\maven\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar]]
03-31 10:43:17.297 DEBUG [main] org.nutz.resource.Scans [scan]
			- Found 1 resource by src( js ) , regex( ^(.+[.])(js|json)$ )
03-31 10:43:17.345 DEBUG [main] org.nutz.castor.Castors [reload]
			- Using 95 castor for Castors
03-31 10:43:17.368 DEBUG [main] org.nutz.resource.Scans [scan]
			- Found 35 resource by src( com/nari/nwims/skengine/ ) , regex( ^.+[.]class$ )
03-31 10:43:17.440 DEBUG [main] org.nutz.resource.Scans [scan]
			- Found 2 resource by src( etc/ ) , regex( ^.+[.]properties$ )
2017-3-31 10:43:17 com.mongodb.diagnostics.logging.JULLogger log
信息: Cluster created with settings {hosts=[10.144.100.101:27017], mode=MULTIPLE, requiredClusterType=UNKNOWN, serverSelectionTimeout='30000 ms', maxWaitQueueSize=500}
2017-3-31 10:43:17 com.mongodb.diagnostics.logging.JULLogger log
信息: Adding discovered server 10.144.100.101:27017 to client view of cluster
2017-3-31 10:43:17 com.mongodb.diagnostics.logging.JULLogger log
信息: No server chosen by ReadPreferenceServerSelector{readPreference=primary} from cluster description ClusterDescription{type=UNKNOWN, connectionMode=MULTIPLE, all=[ServerDescription{address=10.144.100.101:27017, type=UNKNOWN, state=CONNECTING}]}. Waiting for 30000 ms before timing out
2017-3-31 10:43:17 com.mongodb.diagnostics.logging.JULLogger log
信息: Opened connection [connectionId{localValue:1, serverValue:39}] to 10.144.100.101:27017
2017-3-31 10:43:17 com.mongodb.diagnostics.logging.JULLogger log
信息: Monitor thread successfully connected to server with description ServerDescription{address=10.144.100.101:27017, type=STANDALONE, state=CONNECTED, ok=true, version=ServerVersion{versionList=[3, 2, 10]}, minWireVersion=0, maxWireVersion=4, maxDocumentSize=16777216, roundTripTimeNanos=530346}
2017-3-31 10:43:17 com.mongodb.diagnostics.logging.JULLogger log
信息: Discovered cluster type of STANDALONE
2017-3-31 10:43:17 com.mongodb.diagnostics.logging.JULLogger log
信息: Opened connection [connectionId{localValue:2, serverValue:40}] to 10.144.100.101:27017
03-31 10:43:18.618 DEBUG [main] org.nutz.resource.Scans [scan]
			- Found 4 resource by src( sqls ) , regex( .(sql|sqlx|sqls)$ )
03-31 10:43:18.618 DEBUG [main] org.nutz.dao.impl.FileSqlManager [refresh]
			- load >> base.sqls from root=sqls
03-31 10:43:18.619 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[base.save.statdba.$table.has_no_dimension], sql=[insert into statdba.$table(corporationid,kpiid,time,value) values(@corporationid,@kpiid,to_date(@time,'yyyy-mm-dd hh24:mi:ss'),@value)]
03-31 10:43:18.619 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[base.query.statdba.$table.year_avg_by_kpi], sql=[select t.corporationid , avg(t.value) value
from statdba.$table t
where t.kpiid = @kpiid
and t.time between to_date(@begin, 'yyyy-mm-dd') and
to_date(@end, 'yyyy-mm-dd')
group by t.corporationid]
03-31 10:43:18.620 DEBUG [main] org.nutz.dao.impl.FileSqlManager [refresh]
			- load 2 sql >> base.sqls from root=sqls
03-31 10:43:18.621 DEBUG [main] org.nutz.dao.impl.FileSqlManager [refresh]
			- load >> sk10001.sqls from root=sqls
03-31 10:43:18.621 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[10001.select.PERFPORT], sql=[SELECT * FROM PERFDBA.PERF_PORT
]
03-31 10:43:18.622 DEBUG [main] org.nutz.dao.impl.FileSqlManager [refresh]
			- load 1 sql >> sk10001.sqls from root=sqls
03-31 10:43:18.622 DEBUG [main] org.nutz.dao.impl.FileSqlManager [refresh]
			- load >> sk20094.sqls from root=sqls
03-31 10:43:18.622 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[20094.select.stat_conf], sql=[select REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(t.confval, '"', ''),
'{',
''),
'}',
'') confval,
case
when t.des like '%WINDOWS%' then
'WINDOWS'
when t.des like '%LINUX%' then
'LINUXANDUNIX'
when t.des like '%ORACLEINSTANCE%' then
'ORACLE'
when t.des like '%SQLSERVER%' then
'SQLSERVER'
when t.des like '%WEBLOGIC%' then
'WEBLOGIC'
when t.des like '%WEBSPERE%' then
'WEBSPHERE'
when t.des like '%JBOSS%' then
'JBOSS'
when t.des like '%IIS%' then
'IIS'
when t.des like '%TOMCAT%' then
'TOMCAT'
when t.des like '%APPSYSTEM%' then
'APPSYSTEM'
end des
from statdba.stat_conf t
where t.kpiid = '20094']
03-31 10:43:18.623 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[20094.select.host.windows], sql=[select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.host tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode = '0201')
group by areacode]
03-31 10:43:18.623 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[20094.select.host.linuxAndUnix], sql=[select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.host tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode in ('0202','0203'))
group by areacode]
03-31 10:43:18.623 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[20094.select.monitorType], sql=[select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.$table tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode]
03-31 10:43:18.624 DEBUG [main] org.nutz.dao.impl.FileSqlManager [refresh]
			- load 4 sql >> sk20094.sqls from root=sqls
03-31 10:43:18.624 DEBUG [main] org.nutz.dao.impl.FileSqlManager [refresh]
			- load >> sk20096.sqls from root=sqls
03-31 10:43:18.625 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[20096.select.host.windows], sql=[select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.host tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode = '0201')]
03-31 10:43:18.625 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[20096.select.host.linuxAndUnix], sql=[select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.host tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode in ('0202','0203'))]
03-31 10:43:18.625 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[20096.select.monitorType], sql=[select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.$table tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)]
03-31 10:43:18.626 DEBUG [main] org.nutz.dao.impl.FileSqlManager [addSql]
			- key=[20096.save.statdba.stat_monappsysmonitor], sql=[insert into statdba.stat_monappsysmonitor
(corporationid,
dictid,
id,
"TIME",
subtypecode,
name,
firstdate,
flackedkpinum,
fkpiid,
seconddate,
slackedkpinum,
skpiid)
values
(@corporationid,
@dictid,
@id,
to_date(@time, 'yyyy-mm-dd hh24:mi:ss'),
@subtypecode,
@name,
to_date(@firstdate, 'yyyy-mm-dd hh24:mi:ss'),
@flackedkpinum,
@fkpiid,
to_date(@seconddate, 'yyyy-mm-dd hh24:mi:ss'),
@slackedkpinum,
@skpiid);]
03-31 10:43:18.626 DEBUG [main] org.nutz.dao.impl.FileSqlManager [refresh]
			- load 4 sql >> sk20096.sqls from root=sqls
03-31 10:43:18.657 INFO  [main] org.nutz.filepool.NutFilePool [<init>]
			- Init file-pool by: C:\Users\zhu_longxiang/.nutz/tmp/dao/ [200000]
03-31 10:43:18.657 DEBUG [main] org.nutz.filepool.NutFilePool [<init>]
			- file-pool.home: 'C:\Users\zhu_longxiang\.nutz\tmp\dao'
03-31 10:43:18.658 INFO  [main] org.nutz.filepool.NutFilePool [<init>]
			- file-pool.cursor: 0
03-31 10:43:18.665 DEBUG [main] org.nutz.dao.jdbc.Jdbcs [<clinit>]
			- Jdbcs init complete
03-31 10:43:18.665 INFO  [main] org.nutz.dao.jdbc.Jdbcs [getExpert]
			- Get Connection from DataSource for JdbcExpert, if you lock at here, check your database server and configure
03-31 10:43:18.674 DEBUG [main] org.nutz.dao.impl.DaoSupport [setDataSource]
			- select expert : org.nutz.dao.impl.jdbc.oracle.OracleJdbcExpert
03-31 10:43:18.681 DEBUG [main] org.nutz.dao.impl.DaoSupport [invoke]
			- JDBC Driver --> 11.2.0.4.0
03-31 10:43:18.681 DEBUG [main] org.nutz.dao.impl.DaoSupport [invoke]
			- JDBC Name   --> Oracle JDBC driver
03-31 10:43:18.681 DEBUG [main] org.nutz.dao.impl.DaoSupport [invoke]
			- JDBC URL    --> jdbc:oracle:thin:@10.144.100.117:1521/orcl
03-31 10:43:18.682 DEBUG [main] org.nutz.dao.impl.DaoSupport [setDataSource]
			- 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]
03-31 10:43:18.685 DEBUG [main] org.nutz.dao.impl.DaoSupport [setSqlManager]
			- SqlManager Sql count=11
03-31 10:43:18.758 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(t.confval, '"', ''),
'{',
''),
'}',
'') confval,
case
when t.des like '%WINDOWS%' then
'WINDOWS'
when t.des like '%LINUX%' then
'LINUXANDUNIX'
when t.des like '%ORACLEINSTANCE%' then
'ORACLE'
when t.des like '%SQLSERVER%' then
'SQLSERVER'
when t.des like '%WEBLOGIC%' then
'WEBLOGIC'
when t.des like '%WEBSPERE%' then
'WEBSPHERE'
when t.des like '%JBOSS%' then
'JBOSS'
when t.des like '%IIS%' then
'IIS'
when t.des like '%TOMCAT%' then
'TOMCAT'
when t.des like '%APPSYSTEM%' then
'APPSYSTEM'
end des
from statdba.stat_conf t
where t.kpiid = '20094'
03-31 10:43:18.783 WARN  [main] org.nutz.dao.impl.entity.AnnotationEntityMaker [make]
			- No @Table found, fallback to use table name='model' for type 'com.nari.nwims.skengine.common.base.bean.Model'
03-31 10:43:18.787 DEBUG [main] org.nutz.dao.impl.jdbc.AbstractJdbcExpert [setupEntityField]
			- Table 'model' doesn't exist!
03-31 10:43:18.787 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.host tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode in ('0202','0203'))
group by areacode
03-31 10:43:18.968 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.host tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode in ('0202','0203'))
03-31 10:43:19.186 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.host tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode = '0201')
group by areacode
03-31 10:43:19.343 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.host tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode = '0201')
03-31 10:43:19.566 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.WEBSPHERE tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:19.569 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.WEBSPHERE tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:19.573 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.TOMCAT tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:19.576 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.TOMCAT tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:19.578 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.IIS tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:19.581 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.IIS tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:19.583 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.WEBLOGIC tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:19.659 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.WEBLOGIC tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:19.777 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.JBOSS tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:19.779 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.JBOSS tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:19.783 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.SQLSERVER tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:19.837 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.SQLSERVER tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:19.946 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.host tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode in ('0202','0203'))
group by areacode
03-31 10:43:20.027 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.host tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode in ('0202','0203'))
03-31 10:43:20.104 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.host tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode = '0201')
group by areacode
03-31 10:43:20.190 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.host tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid
and tt0.subtypecode = '0201')
03-31 10:43:20.298 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.WEBSPHERE tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:20.300 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.WEBSPHERE tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:20.301 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.TOMCAT tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:20.305 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.TOMCAT tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:20.307 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.IIS tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:20.309 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.IIS tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:20.311 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.WEBLOGIC tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:20.339 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.WEBLOGIC tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:20.395 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.JBOSS tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:20.397 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.JBOSS tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:20.399 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode,
listagg(resourceid, ',') within group(order by resourceid) as resourceid
from (select tt0.resourceid, tt0.areacode
from resourcedba.SQLSERVER tt0,
(select t0.resourceid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
group by areacode
03-31 10:43:20.430 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- select areacode, resourceid, dictid, id, subtypecode, name
from (select tt0.resourceid,
tt0.areacode,
tt1.dictid,
tt0.id,
tt0.subtypecode,
tt0.name
from resourcedba.SQLSERVER tt0,
(select t0.resourceid, t1.dictid
from resourcedba.appsystem t0, dictdba.statdata t1
where t0.name in
(select regexp_substr(t1.dictnamemapping,
'[^,]+',
1,
level,
'i') as str
from dual
connect by level <=
length(t1.dictnamemapping) -
length(regexp_replace(t1.dictnamemapping,
',',
'')) + 1)
and t1.dicttypeid = '1') tt1
where tt0.appsystemid = tt1.resourceid)
03-31 10:43:20.492 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [printSQL]
			- insert into statdba.stat_monappsysmonitor
(corporationid,
dictid,
id,
"TIME",
subtypecode,
name,
firstdate,
flackedkpinum,
fkpiid,
seconddate,
slackedkpinum,
skpiid)
values
(?,
?,
?,
to_date(?, 'yyyy-mm-dd hh24:mi:ss'),
?,
?,
to_date(?, 'yyyy-mm-dd hh24:mi:ss'),
?,
?,
to_date(?, 'yyyy-mm-dd hh24:mi:ss'),
?,
?);
    |    1 |     2 |             3 |                   4 |    5 |      6 |                   7 | 8 |               9 |                  10 | 11 |      12 |
    |------|-------|---------------|---------------------|------|--------|---------------------|---|-----------------|---------------------|---|---------|
    | 0300 | 00800 | weblogicid8   | 2017-03-31 10:43:20 | 0601 |        | 2017-02-15 00:00:00 | 2 | 0717001,0717030 | 2017-02-08 00:00:00 | 1 | 0717030 |
    | 0300 | 00800 | weblogicid1   | 2017-03-31 10:43:20 | 0601 |        | 2017-02-15 00:00:00 | 2 | 0717001,0717030 | 2017-02-08 00:00:00 | 1 | 0717030 |
    | 0304 | 00700 | sqlserverid2  | 2017-03-31 10:43:20 | 0504 |        | 2017-02-15 00:00:00 | 2 | 0714001,0714009 | 2017-02-08 00:00:00 | 1 | 0714009 |
    | 0302 | 00800 | weblogicid7   | 2017-03-31 10:43:20 | 0601 |        | 2017-02-15 00:00:00 | 2 | 0717001,0717030 | 2017-02-08 00:00:00 | 1 | 0717030 |
    | 0300 | 01100 | hostid10      | 2017-03-31 10:43:20 | 0203 |        | 2017-02-15 00:00:00 | 1 | 0208001         | 2017-02-08 00:00:00 | 1 | 0208001 |
    | 0300 | 00700 | hostid5       | 2017-03-31 10:43:20 | 0201 |        | 2017-02-15 00:00:00 | 1 | 0207001         | 2017-02-08 00:00:00 | 1 | 0207001 |
    | 0300 | 00100 | hostid1       | 2017-03-31 10:43:20 | 0201 | host01 | 2017-02-15 00:00:00 | 1 | 0207001         | 2017-02-08 00:00:00 | 1 | 0207001 |
    | 0300 | 00700 | hostid6       | 2017-03-31 10:43:20 | 0201 |        | 2017-02-15 00:00:00 | 1 | 0207001         | 2017-02-08 00:00:00 | 1 | 0207001 |
    | 0302 | 00600 | hostid7       | 2017-03-31 10:43:20 | 0202 |        | 2017-02-15 00:00:00 | 1 | 0208001         | 2017-02-08 00:00:00 | 1 | 0208001 |
    | 0301 | 00700 | sqlserverid3  | 2017-03-31 10:43:20 | 0504 |        | 2017-02-15 00:00:00 | 2 | 0714001,0714009 | 2017-02-08 00:00:00 | 1 | 0714009 |
 -- Only display first 10 lines , don't show the remaining record(count=30)
  For example:> "insert into statdba.stat_monappsysmonitor
(corporationid,
dictid,
id,
"TIME",
subtypecode,
name,
firstdate,
flackedkpinum,
fkpiid,
seconddate,
slackedkpinum,
skpiid)
values
('0300',
'00800',
'weblogicid8',
to_date('2017-03-31 10:43:20', 'yyyy-mm-dd hh24:mi:ss'),
'0601',
'',
to_date('2017-02-15 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),
2,
'0717001,0717030',
to_date('2017-02-08 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),
1,
'0717030');"
03-31 10:43:20.535 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [exec]
			- SQLException
java.sql.BatchUpdateException: ORA-00911: 无效字符

	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:559) ~[druid-1.0.18.jar:1.0.18]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:322) ~[nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:248) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:973) [nutz-1.r.60.jar:?]
	at com.nari.nwims.skengine.modules.sk20096.dao.SK20096Dao.saveMonAppsysMonitor(SK20096Dao.java:136) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20096.SK20096Calc.saveMonAppsysMonitor(SK20096Calc.java:62) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094Calc.run(SK20094Calc.java:138) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094CalcTest.calc(SK20094CalcTest.java:16) [test-classes/:?]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.6.0_45]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[?:1.6.0_45]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[?:1.6.0_45]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[?:1.6.0_45]
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.12.jar:4.12]
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363) [junit-4.12.jar:4.12]
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) [.cp/:?]
03-31 10:43:20.540 DEBUG [main] org.nutz.dao.impl.sql.run.NutDaoExecutor [exec]
			- SQL NextException
java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10298) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10404) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) ~[ojdbc6-11.2.0.4.0.jar:11.2.0.4.0]
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:559) ~[druid-1.0.18.jar:1.0.18]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:322) ~[nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64) [nutz-1.r.60.jar:?]
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:248) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236) [nutz-1.r.60.jar:?]
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:973) [nutz-1.r.60.jar:?]
	at com.nari.nwims.skengine.modules.sk20096.dao.SK20096Dao.saveMonAppsysMonitor(SK20096Dao.java:136) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20096.SK20096Calc.saveMonAppsysMonitor(SK20096Calc.java:62) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094Calc.run(SK20094Calc.java:138) [classes/:?]
	at com.nari.nwims.skengine.modules.sk20094.SK20094CalcTest.calc(SK20094CalcTest.java:16) [test-classes/:?]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.6.0_45]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[?:1.6.0_45]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[?:1.6.0_45]
	at java.lang.reflect.Method.invoke(Method.java:597) ~[?:1.6.0_45]
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.12.jar:4.12]
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) [junit-4.12.jar:4.12]
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) [junit-4.12.jar:4.12]
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) [junit-4.12.jar:4.12]
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363) [junit-4.12.jar:4.12]
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) [.cp/:?]
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) [.cp/:?]

@wendal

报错信息不一样了? 这次变成exec的时候报错 "ORA-00911: 无效字符", 之前的是setString的时候报 "java.sql.SQLException: 无效的列索引"

去掉末尾的分号，那是pl/sql工具用来分隔sql语句的，不是oracle的。

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