导出数据时,总是报错,怎么解决呢


最佳答案
这个可能性有点多,阔以在百度上搜一下ORA-00907: 缺失右括号,这个报错检查一下sql语句书写
https://blog.csdn.net/xuemoyao/article/details/50557812
6个回答
908791215 发表于 2020-1-6 10:20
把这个报错详情用txt传上来看一下~
正在导出
100 %下载收起详情
2020-01-06 09:53:45.690 开始导出结果集
2020-01-06 09:53:45.691 源连接池:assistant
2020-01-06 09:53:45.694 导出结果集出错java.lang.RuntimeException: ORA-00907: 缺失右括号
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1313)
at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
at com.esen.jdbc.pool.impl.oracle.OraclePooledStatement.executeQuery(OraclePooledStatement.java:22)
at com.esen.jdbc.dialect.impl.DialectImpl.getResultMetaData(DialectImpl.java:245)
at com.esen.jdbc.dialect.impl.DialectImpl.getQueryResultMetaData(DialectImpl.java:308)
at com.esen.jdbc.data.impl.DataReaderFromDb.initTableMeta(DataReaderFromDb.java:71)
at com.esen.jdbc.data.impl.DataReaderFromDb.getMeta(DataReaderFromDb.java:130)
at com.esen.jdbc.data.impl.DataWriteToCSV.writeData(DataWriteToCSV.java:46)
at com.esen.jdbc.data.DataCopyImpl.exportDataToCSV(DataCopyImpl.java:484)
at com.esen.jdbc.data.DataCopyImpl.exportDataToCSV(DataCopyImpl.java:471)
at com.esen.jdbc.data.DataCopyImpl.exportDataToCSV(DataCopyImpl.java:462)
at com.esen.jdbc.data.DataCopyImpl.exportDataToCSV(DataCopyImpl.java:441)
at com.esen.platform.sysmgr.dbmgr.DbEditExportTable.exportTable(DbEditExportTable.java:180)
at com.esen.platform.sysmgr.dbmgr.DbEditExportResult.exportResult(DbEditExportResult.java:108)
at com.esen.platform.sysmgr.dbmgr.DbEditExportResult.doRun(DbEditExportResult.java:61)
at com.esen.platform.sysmgr.dbmgr.DbRequestTask.call(DbRequestTask.java:70)
at com.esen.platform.common.req.RequestTaskRunner.call(RequestTaskRunner.java:75)
at com.esen.thread.LocaleTask.call(LocaleTask.java:60)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.esen.jdbc.pool.impl.oracle.OraclePooledSQLException: ORA-00907: 缺失右括号
... 31 more
2020-01-06 09:53:45.695 导出操作出现异常,已停止导出
这个可能性有点多,阔以在百度上搜一下ORA-00907: 缺失右括号,这个报错检查一下sql语句书写
https://blog.csdn.net/xuemoyao/article/details/50557812