天天看點

Java導入sql失敗_使用外部資料庫導入資料總是失敗

11:24:04 Thread-48 ERROR [standard] Error accessing index information: finedb.fine_dep_role

com.fr.third.org.hibernate.exception.JDBCConnectionException: Error accessing index information: finedb.fine_dep_role

at com.fr.third.org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)

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.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.convertSQLException(InformationExtractorJdbcDatabaseMetaDataImpl.java:100)

at com.fr.third.org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getIndexes(InformationExtractorJdbcDatabaseMetaDataImpl.java:753)

at com.fr.third.org.hibernate.tool.schema.extract.internal.TableInformationImpl.indexes(TableInformationImpl.java:122)

at com.fr.third.org.hibernate.tool.schema.extract.internal.TableInformationImpl.getIndex(TableInformationImpl.java:138)

at com.fr.third.org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyUniqueKeys(AbstractSchemaMigrator.java:366)

at com.fr.third.org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:85)

at com.fr.third.org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:203)

at com.fr.third.org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:110)

at com.fr.third.org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)

at com.fr.third.org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)

at com.fr.third.org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:476)

at com.fr.third.org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:422)

at com.fr.third.org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:710)

at com.fr.third.org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:726)

at com.fr.stable.db.session.SessionManager.createSessionFactory(Unknown Source)

at com.fr.stable.db.session.SessionManager.createNewSessionFactory(Unknown Source)

at com.fr.stable.db.DBContext.init(Unknown Source)

at com.fr.decision.migration.manager.AbstractTransferManager.transfer(AbstractTransferManager.java:134)

at com.fr.decision.migration.manager.AbstractTransferManager.startTransfer(AbstractTransferManager.java:57)

at com.fr.decision.migration.MigrationContext$TransferManagerCollection.startTransfer(MigrationContext.java:216)

at com.fr.decision.migration.MigrationContext$1.run(MigrationContext.java:93)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed.

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:526)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:505)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:479)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:489)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:66)

at com.mysql.cj.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:1882)

at com.mysql.cj.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:1861)

at com.mysql.cj.jdbc.ConnectionImpl.getMetadataSafeStatement(ConnectionImpl.java:2147)

at com.mysql.cj.jdbc.DatabaseMetaData.getIndexInfo(DatabaseMetaData.java:2821)

at com.fr.third.org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getIndexes(InformationExtractorJdbcDatabaseMetaDataImpl.java:713)

... 20 more

Caused by: com.mysql.cj.core.exceptions.ConnectionIsClosedException: No operations allowed after connection closed.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)

at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:93)

at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:133)

at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:931)

at com.mysql.cj.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java)

... 24 more