wangguoyou(提问者)感谢,但显示导入成功后在数据库中找不到这些表,重新建了一个新用户后提示导入失败,如下报错:
com.fr.third.org.hibernate.exception.SQLGrammarException: could not execute statement
at com.fr.third.org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at com.fr.third.org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
at com.fr.third.org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:91)
at com.fr.third.org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:60)
at com.fr.third.org.hibernate.hql.internal.ast.exec.DeleteExecutor.execute(DeleteExecutor.java:111)
at com.fr.third.org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:429)
at com.fr.third.org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:374)
at com.fr.third.org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1360)
at com.fr.third.org.hibernate.internal.QueryImpl.executeUpdate(QueryImpl.java:102)
at com.fr.stable.db.extra.interceptor.impl.EmptyStringConvertInterceptor$WrappedQuery.executeUpdate(Unknown Source)
at com.fr.decision.migration.manager.AbstractTransferManager.truncateTable(Unknown Source)
at com.fr.decision.migration.manager.AbstractTransferManager.truncateTables(Unknown Source)
at com.fr.decision.migration.manager.AbstractTransferManager.transfer(Unknown Source)
at com.fr.decision.migration.manager.AbstractTransferManager.startTransfer(Unknown Source)
at com.fr.decision.migration.MigrationContext$TransferManagerCollection.startTransfer(Unknown Source)
at com.fr.decision.migration.MigrationContext$1.run(Unknown Source)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3422)
at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:252)
at com.fr.third.org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
... 15 more