在用hibernate向Mysql插入1000万条数据 在插入将近一万条数据的时候 不多查询数据库发现插入成功 有数据 不过程序出现报错了2010-5-23 20:32:53 org.springframework.core.CollectionFactory <clinit>
信息: JDK 1.4+ collections available
2010-5-23 20:32:53 org.springframework.core.CollectionFactory <clinit>
信息: Commons Collections 3.x available
2010-5-23 20:32:53 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [ApplicationContext.xml]
2010-5-23 20:32:54 org.springframework.context.support.AbstractRefreshableApplicationContext refreshBeanFactory
信息: Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=26281671]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,jdbcExceptionTranslator,hibernateTemplate,transactionManager,pmc.model.facade.dao.UserDao,pmc.model.facade.UserFacade]; root of BeanFactory hierarchy
2010-5-23 20:32:54 org.springframework.context.support.AbstractApplicationContext refresh
信息: 7 beans defined in application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=26281671]
2010-5-23 20:32:54 org.springframework.context.support.AbstractApplicationContext initMessageSource
信息: Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@1462851]
2010-5-23 20:32:54 org.springframework.context.support.AbstractApplicationContext initApplicationEventMulticaster
信息: Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@1865b28]
2010-5-23 20:32:54 org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
信息: Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,jdbcExceptionTranslator,hibernateTemplate,transactionManager,pmc.model.facade.dao.UserDao,pmc.model.facade.UserFacade]; root of BeanFactory hierarchy]
2010-5-23 20:32:54 org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
信息: Loaded JDBC driver: com.mysql.jdbc.Driver
2010-5-23 20:32:54 org.hibernate.cfg.Environment <clinit>
信息: Hibernate 3.2.6
2010-5-23 20:32:54 org.hibernate.cfg.Environment <clinit>
信息: hibernate.properties not found
2010-5-23 20:32:54 org.hibernate.cfg.Environment buildBytecodeProvider
信息: Bytecode provider name : cglib
2010-5-23 20:32:54 org.hibernate.cfg.Environment <clinit>
信息: using JDK 1.4 java.sql.Timestamp handling
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.PmcUser -> pmc_user
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.Province -> t_province
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.City -> t_city
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.Town -> t_town
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.Content -> t_content
2010-5-23 20:32:54 org.springframework.orm.hibernate3.LocalSessionFactoryBean afterPropertiesSet
信息: Building new Hibernate SessionFactory
2010-5-23 20:32:54 org.hibernate.cfg.Environment verifyProperties
警告: Property [hibernate.cglib.use_reflection_optimizer] has been renamed to [hibernate.bytecode.use_reflection_optimizer]; update your properties appropriately
2010-5-23 20:32:54 org.hibernate.connection.ConnectionProviderFactory newConnectionProvider
信息: Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: RDBMS: MySQL, version: 5.0.18-nt
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.8 ( Revision: ${svn.Revision} )
2010-5-23 20:32:54 org.hibernate.dialect.Dialect <init>
信息: Using dialect: org.hibernate.dialect.MySQLDialect
2010-5-23 20:32:54 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
信息: Using default transaction strategy (direct JDBC transactions)
2010-5-23 20:32:54 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
信息: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Automatic flush during beforeCompletion(): disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Automatic session close at end of transaction: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JDBC batch size: 15
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JDBC batch updates for versioned data: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Scrollable result sets: enabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JDBC3 getGeneratedKeys(): enabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Connection release mode: on_close
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Maximum outer join fetch depth: 2
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Default batch fetch size: 1
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Generate SQL with comments: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Order SQL updates by primary key: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Order SQL inserts for batching: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
信息: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2010-5-23 20:32:54 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
信息: Using ASTQueryTranslatorFactory
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Query language substitutions: {}
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JPA-QL strict compliance: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Second-level cache: enabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Query cache: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory createCacheProvider
信息: Cache provider: org.hibernate.cache.HashtableCacheProvider
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Optimize cache for minimal puts: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Structured second-level cache entries: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Statistics: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Deleted entity synthetic identifier rollback: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Default entity-mode: pojo
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Named query checking : enabled
2010-5-23 20:32:54 org.hibernate.impl.SessionFactoryImpl <init>
信息: building session factory
2010-5-23 20:32:55 org.hibernate.impl.SessionFactoryObjectFactory addInstance
信息: Not binding factory to JNDI, no JNDI name configured
2010-5-23 20:32:55 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
信息: JDK 1.4+ collections available
2010-5-23 20:32:53 org.springframework.core.CollectionFactory <clinit>
信息: Commons Collections 3.x available
2010-5-23 20:32:53 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [ApplicationContext.xml]
2010-5-23 20:32:54 org.springframework.context.support.AbstractRefreshableApplicationContext refreshBeanFactory
信息: Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=26281671]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,jdbcExceptionTranslator,hibernateTemplate,transactionManager,pmc.model.facade.dao.UserDao,pmc.model.facade.UserFacade]; root of BeanFactory hierarchy
2010-5-23 20:32:54 org.springframework.context.support.AbstractApplicationContext refresh
信息: 7 beans defined in application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=26281671]
2010-5-23 20:32:54 org.springframework.context.support.AbstractApplicationContext initMessageSource
信息: Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@1462851]
2010-5-23 20:32:54 org.springframework.context.support.AbstractApplicationContext initApplicationEventMulticaster
信息: Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@1865b28]
2010-5-23 20:32:54 org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
信息: Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,sessionFactory,jdbcExceptionTranslator,hibernateTemplate,transactionManager,pmc.model.facade.dao.UserDao,pmc.model.facade.UserFacade]; root of BeanFactory hierarchy]
2010-5-23 20:32:54 org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
信息: Loaded JDBC driver: com.mysql.jdbc.Driver
2010-5-23 20:32:54 org.hibernate.cfg.Environment <clinit>
信息: Hibernate 3.2.6
2010-5-23 20:32:54 org.hibernate.cfg.Environment <clinit>
信息: hibernate.properties not found
2010-5-23 20:32:54 org.hibernate.cfg.Environment buildBytecodeProvider
信息: Bytecode provider name : cglib
2010-5-23 20:32:54 org.hibernate.cfg.Environment <clinit>
信息: using JDK 1.4 java.sql.Timestamp handling
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.PmcUser -> pmc_user
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.Province -> t_province
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.City -> t_city
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.Town -> t_town
2010-5-23 20:32:54 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
信息: Mapping class: pmc.model.pojo.Content -> t_content
2010-5-23 20:32:54 org.springframework.orm.hibernate3.LocalSessionFactoryBean afterPropertiesSet
信息: Building new Hibernate SessionFactory
2010-5-23 20:32:54 org.hibernate.cfg.Environment verifyProperties
警告: Property [hibernate.cglib.use_reflection_optimizer] has been renamed to [hibernate.bytecode.use_reflection_optimizer]; update your properties appropriately
2010-5-23 20:32:54 org.hibernate.connection.ConnectionProviderFactory newConnectionProvider
信息: Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: RDBMS: MySQL, version: 5.0.18-nt
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.8 ( Revision: ${svn.Revision} )
2010-5-23 20:32:54 org.hibernate.dialect.Dialect <init>
信息: Using dialect: org.hibernate.dialect.MySQLDialect
2010-5-23 20:32:54 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
信息: Using default transaction strategy (direct JDBC transactions)
2010-5-23 20:32:54 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
信息: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Automatic flush during beforeCompletion(): disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Automatic session close at end of transaction: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JDBC batch size: 15
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JDBC batch updates for versioned data: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Scrollable result sets: enabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JDBC3 getGeneratedKeys(): enabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Connection release mode: on_close
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Maximum outer join fetch depth: 2
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Default batch fetch size: 1
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Generate SQL with comments: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Order SQL updates by primary key: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Order SQL inserts for batching: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
信息: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2010-5-23 20:32:54 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
信息: Using ASTQueryTranslatorFactory
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Query language substitutions: {}
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: JPA-QL strict compliance: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Second-level cache: enabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Query cache: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory createCacheProvider
信息: Cache provider: org.hibernate.cache.HashtableCacheProvider
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Optimize cache for minimal puts: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Structured second-level cache entries: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Statistics: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Deleted entity synthetic identifier rollback: disabled
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Default entity-mode: pojo
2010-5-23 20:32:54 org.hibernate.cfg.SettingsFactory buildSettings
信息: Named query checking : enabled
2010-5-23 20:32:54 org.hibernate.impl.SessionFactoryImpl <init>
信息: building session factory
2010-5-23 20:32:55 org.hibernate.impl.SessionFactoryObjectFactory addInstance
信息: Not binding factory to JNDI, no JNDI name configured
2010-5-23 20:32:55 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2010-5-23 20:32:55 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
信息: SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
2010-5-23 20:32:55 org.springframework.orm.hibernate3.HibernateTransactionManager afterPropertiesSet
信息: Using DataSource [org.springframework.jdbc.datasource.DriverManagerDataSource@1554d32] of Hibernate SessionFactory for HibernateTransactionManager
2010-5-23 20:33:28 org.hibernate.util.JDBCExceptionReporter logExceptions
警告: SQL Error: 0, SQLState: 08001
2010-5-23 20:33:28 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
2010-5-23 20:33:28 org.hibernate.util.JDBCExceptionReporter logExceptions
警告: SQL Error: 0, SQLState: 08001
2010-5-23 20:33:28 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
2010-5-23 20:33:28 org.hibernate.event.def.AbstractFlushingEventListener performExecutions
严重: Could not synchronize database state with session
org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2229)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:394)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:614)
at pmc.model.facade.dao.hibernate.DAOSupport.insert(DAOSupport.java:44)
at test.Test01.main(Test01.java:19)
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:348)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
at
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:241)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 18 more
Caused by: com.mysql.jdbc.CommunicationsException: The driver was unable to create a connection due to an inability to establish the client portion of a socket.This is usually caused by a limit on the number of sockets imposed by the operating system. This limit is usually configurable. For Unix-based platforms, see the manual page for the 'ulimit' command. Kernel or system reconfiguration may also be required.For Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288)
... 29 more
Caused by: java.net.BindException: Address already in use: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
... 30 more
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [08001]; error code [0]; Could not create connection to database server. Attempted reconnect 3 times. Giving up.; nested exception is com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:348)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:241)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2229)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:394)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:614)
at pmc.model.facade.dao.hibernate.DAOSupport.insert(DAOSupport.java:44)
at test.Test01.main(Test01.java:19)
Caused by: com.mysql.jdbc.CommunicationsException: The driver was unable to create a connection due to an inability to establish the client portion of a socket.This is usually caused by a limit on the number of sockets imposed by the operating system. This limit is usually configurable. For Unix-based platforms, see the manual page for the 'ulimit' command. Kernel or system reconfiguration may also be required.For Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288)
... 29 more
Caused by: java.net.BindException: Address already in use: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
... 30 more
2010-5-23 20:33:28 org.hibernate.event.def.AbstractFlushingEventListener performExecutions
严重: Could not synchronize database state with session
org.hibernate.exception.JDBCConnectionException: Cannot open connection你这个数据库是在本机吗?? 没有打开的连接= =
以前我用这个导入500万条只要2秒,不过要是txt格式
一个Connection,在没有close之前,使用了N多个Statement/PreparedStatment
10楼正解