UC知道MySQL 中连续插入数据出现的问题
来源：百度知道 编辑：UC知道 时间：2024/05/22 06:31:49
我是在spring+hibernate+struts的基础上做了一个插入数据的测试
首先我把 MySQL默认的 max_connections 修改为 2000
然后做了一个 i<1000 的循环来连续插入数据
然后我发现每次插入 146 条后就出现以下错误：
2009-01-19 15:54:54,140 INFO [org.hibernate.cfg.SettingsFactory] - Echoing all SQL to stdout
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.OutOfMemoryError: Java heap space
Caused by: java.lang.OutOfMemoryError: Java heap space
2009-01-19 15:54:54,546 INFO [org.hibernate.cfg.SettingsFactory] - Statistics: disabled
2009-01-19 15:54:54,546 INFO [org.hibernate.cfg.SettingsFactory] - Deleted entity synthetic identifier rollback: disabled
2009-01-19 15:54:54,546 INFO [org.hibernate.cfg.SettingsFactory] - Default entity-mode: pojo
2009-01-19 15:54:54,546 INFO [org.hibernate.cfg.Settin
首先我把 MySQL默认的 max_connections 修改为 2000
然后做了一个 i<1000 的循环来连续插入数据
然后我发现每次插入 146 条后就出现以下错误：
2009-01-19 15:54:54,140 INFO [org.hibernate.cfg.SettingsFactory] - Echoing all SQL to stdout
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.OutOfMemoryError: Java heap space
Caused by: java.lang.OutOfMemoryError: Java heap space
2009-01-19 15:54:54,546 INFO [org.hibernate.cfg.SettingsFactory] - Statistics: disabled
2009-01-19 15:54:54,546 INFO [org.hibernate.cfg.SettingsFactory] - Deleted entity synthetic identifier rollback: disabled
2009-01-19 15:54:54,546 INFO [org.hibernate.cfg.SettingsFactory] - Default entity-mode: pojo
2009-01-19 15:54:54,546 INFO [org.hibernate.cfg.Settin
连续插入数据内存超出Java默认允许的范围了，如果用的Tomcat的解压缩版可以修改tomcat/bin/catalina.bat，用记事本打开，加入下边这句话set JAVA_OPTS=-Xms32m -Xmx256m，也可以在windows环境变量里配置一个JAVA_OPTS：-Xms32m -Xmx256m，JAVA_OPTS是名称，冒号后面的是值