文件太长了,报的异常如下:
问题如下:
当启动tomcat的时候,回报如下异常:
INFO main net.sf.hibernate.cfg.Environment - Hibernate 2.1.2
INFO main net.sf.hibernate.cfg.Environment - hibernate.properties not found
INFO main net.sf.hibernate.cfg.Environment - using CGLIB reflection optimizer
INFO main net.sf.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
INFO main net.sf.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
ERROR main net.sf.hibernate.cfg.Configuration - problem parsing configuration/hibernate.cfg.xml
org.dom4j.DocumentException: Illegal character in URL Nested exception: Illegal character in URL
at org.dom4j.io.SAXReader.read(SAXReader.java:358)
at net.sf.hibernate.cfg.Configuration.doConfigure(Configuration.java:912)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:856)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:842)
at test.TestHBMServlet.init(TestHBMServlet.java:33)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:683)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:964)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at org.apache.catalina.core.StandardService.start(StandardService.java:476)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)
Nested exception:
java.net.MalformedURLException: Illegal character in URL
at sun.net.www.http.HttpClient.getURLFile(HttpClient.java:671)
at sun.net.www.protocol.http.HttpURLConnection.writeRequests(HttpURLConnection.java:219)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:625)
at org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.startEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.startDTDEntity(Unknown Source)
at org.apache.xerces.impl.XMLDTDScannerImpl.setInputSource(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.dom4j.io.SAXReader.read(SAXReader.java:339)
at net.sf.hibernate.cfg.Configuration.doConfigure(Configuration.java:912)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:856)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:842)
at test.TestHBMServlet.init(TestHBMServlet.java:33)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:683)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:964)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at org.apache.catalina.core.StandardService.start(StandardService.java:476)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)
ERROR main test.TestHBMServlet - 映射错误:net.sf.hibernate.HibernateException: problem parsing configuration/hibernate.cfg.xml
问题如下:
当启动tomcat的时候,回报如下异常:
INFO main net.sf.hibernate.cfg.Environment - Hibernate 2.1.2
INFO main net.sf.hibernate.cfg.Environment - hibernate.properties not found
INFO main net.sf.hibernate.cfg.Environment - using CGLIB reflection optimizer
INFO main net.sf.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
INFO main net.sf.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
ERROR main net.sf.hibernate.cfg.Configuration - problem parsing configuration/hibernate.cfg.xml
org.dom4j.DocumentException: Illegal character in URL Nested exception: Illegal character in URL
at org.dom4j.io.SAXReader.read(SAXReader.java:358)
at net.sf.hibernate.cfg.Configuration.doConfigure(Configuration.java:912)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:856)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:842)
at test.TestHBMServlet.init(TestHBMServlet.java:33)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:683)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:964)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at org.apache.catalina.core.StandardService.start(StandardService.java:476)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)
Nested exception:
java.net.MalformedURLException: Illegal character in URL
at sun.net.www.http.HttpClient.getURLFile(HttpClient.java:671)
at sun.net.www.protocol.http.HttpURLConnection.writeRequests(HttpURLConnection.java:219)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:625)
at org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.startEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.startDTDEntity(Unknown Source)
at org.apache.xerces.impl.XMLDTDScannerImpl.setInputSource(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.dom4j.io.SAXReader.read(SAXReader.java:339)
at net.sf.hibernate.cfg.Configuration.doConfigure(Configuration.java:912)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:856)
at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:842)
at test.TestHBMServlet.init(TestHBMServlet.java:33)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:683)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:964)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at org.apache.catalina.core.StandardService.start(StandardService.java:476)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)
ERROR main test.TestHBMServlet - 映射错误:net.sf.hibernate.HibernateException: problem parsing configuration/hibernate.cfg.xml
hibernate-configuration>
<session-factory>
<property name="connection.datasource">/jdbc/myoracle</property>
<property name="show_sql">false</property>
<property name="dialect">net.sf.hibernate.dialect.OracleDialect</property>
<!-- Mapping files -->
<mapping resource="Userlist.hbm.xml"/>
</session-factory>
</hibernate-configuration>
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration> <session-factory> <property name="connection.datasource">java:/mservice</property>
<property name="hibernate.dialect">net.sf.hibernate.dialect.PostgreSQLDialect</property>
<property name="hibernate.show_sql">true</property>
<!--<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>-->
<!--<property name="hibernate.connection.url">jdbc:postgresql://192.168.1.150/mservice</property>-->
<!--<property name="hibernate.connection.username">postgres</property>-->
<!--<property name="hibernate.connection.password"></property>-->
<!--<property name="hibernate.connection.pool.size">20</property>-->
<!--<property name="jdbc.fetch_size">50</property>-->
<!--<property name="jdbc.batch_size">25</property>-->
<!--<property name="jdbc.use_scrollable_resultset">false</property>-->
<!-- Mapping files -->
<mapping resource="JobInfo.hbm.xml"/>
<mapping resource="ItemDetail.hbm.xml"/>
<mapping resource="JobStatus.hbm.xml"/>
<mapping resource="ItemInfo.hbm.xml"/>
<mapping resource="ManParts.hbm.xml"/>
<mapping resource="UserInfo.hbm.xml"/>
<mapping resource="UserStatus.hbm.xml"/>
<mapping resource="Table1.hbm.xml"/>
<mapping resource="Table2.hbm.xml"/>
<mapping resource="Table3.hbm.xml"/>
<mapping resource="Table4.hbm.xml"/>
<mapping resource="Table5.hbm.xml"/>
<mapping resource="TableDefine.hbm.xml"/>
</session-factory></hibernate-configuration>
你的连接池在hibernate里配置也没问题,就是文件其他地方的问题
你的hibernate.cfg.xml配置好像也有问题
WARN main net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 1401, SQLState: 23000
ERROR main net.sf.hibernate.util.JDBCExceptionReporter - ORA-01401: 插入的值对于列过大WARN main net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 1401, SQLState: 23000
ERROR main net.sf.hibernate.util.JDBCExceptionReporter - ORA-01401: 插入的值对于列过大ERROR main net.sf.hibernate.util.JDBCExceptionReporter - Could not execute JDBC batch update
java.sql.SQLException: ORA-01401: 插入的值对于列过大 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:2883)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeBatch(DelegatingPreparedStatement.java:231)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2385)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204)
at test.TestHBMServlet.init(TestHBMServlet.java:67)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at org.apache.catalina.core.StandardService.start(StandardService.java:476)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)
ERROR main net.sf.hibernate.impl.SessionImpl - Could not synchronize database state with session
net.sf.hibernate.JDBCException: Could not execute JDBC batch update
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:129)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2385)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204)
at test.TestHBMServlet.init(TestHBMServlet.java:67)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
at org.apache.catalina.core.StandardService.start(StandardService.java:476)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)
Caused by: java.sql.SQLException: ORA-01401: 插入的值对于列过大 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:2883)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeBatch(DelegatingPreparedStatement.java:231)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122)
... 22 more
ERROR main test.TestHBMServlet - Hibernate Insert1 错误net.sf.hibernate.JDBCException: Could not execute JDBC batch update
好象是说 class TestHBMServlet的 s.flush();这一句有问题!不知道大家碰到过没有,望指点!!!
不是这样的吧,我的表字段够长,程序里只是1~10的循环啊!SQL> desc userlist;
名称 空? 类型
----------------------------------------- -------- ----------------------- USERID NOT NULL VARCHAR2(10)
USERNAME NOT NULL VARCHAR2(20)
PASSWORD NOT NULL VARCHAR2(20)
2004-12-14 10:04:01 [net.sf.hibernate.cfg.Environment]-[INFO] Hibernate 2.1.2
2004-12-14 10:04:01 [net.sf.hibernate.cfg.Environment]-[INFO] hibernate.properti
es not found
2004-12-14 10:04:01 [net.sf.hibernate.cfg.Environment]-[INFO] using CGLIB reflec
tion optimizer
2004-12-14 10:04:01 [net.sf.hibernate.cfg.Configuration]-[INFO] configuring from
resource: /hibernate.cfg.xml
2004-12-14 10:04:01 [net.sf.hibernate.cfg.Configuration]-[INFO] Configuration re
source: /hibernate.cfg.xml
2004-12-14 10:04:01 [net.sf.hibernate.cfg.Configuration]-[INFO] Mapping resource
: Userlist.hbm.xml
2004-12-14 10:04:01 [net.sf.hibernate.cfg.Binder]-[INFO] Mapping class: struts.h
ibernate.Userlist -> USERLIST
2004-12-14 10:04:02 [net.sf.hibernate.cfg.Configuration]-[INFO] Configured Sessi
onFactory: null
2004-12-14 10:04:02 [net.sf.hibernate.cfg.Configuration]-[INFO] processing one-t
o-many association mappings
2004-12-14 10:04:02 [net.sf.hibernate.cfg.Configuration]-[INFO] processing one-t
o-one association property references
2004-12-14 10:04:02 [net.sf.hibernate.cfg.Configuration]-[INFO] processing forei
gn key constraints
2004-12-14 10:04:02 [net.sf.hibernate.dialect.Dialect]-[INFO] Using dialect: net
.sf.hibernate.dialect.OracleDialect
2004-12-14 10:04:02 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] Use outer join
fetching: true
2004-12-14 10:04:02 [net.sf.hibernate.util.NamingHelper]-[INFO] JNDI InitialCont
ext properties:{}
2004-12-14 10:04:02 [net.sf.hibernate.connection.DatasourceConnectionProvider]-[
INFO] Using datasource: java:comp/env/jdbc/myoracle
2004-12-14 10:04:02 [net.sf.hibernate.transaction.TransactionManagerLookupFactor
y]-[INFO] No TransactionManagerLookup configured (in JTA environment, use of pro
cess level read-write cache is not recommended)
2004-12-14 10:04:04 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] Use scrollable
result sets: true
2004-12-14 10:04:04 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] Use JDBC3 getG
eneratedKeys(): false
2004-12-14 10:04:04 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] Optimize cache
for minimal puts: false
2004-12-14 10:04:04 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] echoing all SQ
L to stdout
2004-12-14 10:04:04 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] Query language
substitutions: {}
2004-12-14 10:04:04 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] cache provider
: net.sf.ehcache.hibernate.Provider
2004-12-14 10:04:04 [net.sf.hibernate.cfg.Configuration]-[INFO] instantiating an
d configuring caches
2004-12-14 10:04:04 [net.sf.hibernate.impl.SessionFactoryImpl]-[INFO] building s
ession factory
2004-12-14 10:04:06 [net.sf.hibernate.impl.SessionFactoryObjectFactory]-[INFO] n
o JNDI name configured
2004-12-14 10:04:06 [test.TestHBMServlet]-[INFO] Open Session OK
Hibernate: insert into HYH.USERLIST (USERNAME, PASSWORD, USERID) values (?, ?, ?
)
2004-12-14 10:04:07 [net.sf.hibernate.util.JDBCExceptionReporter]-[WARN] SQL Err
or: 1401, SQLState: 23000
2004-12-14 10:04:07 [net.sf.hibernate.util.JDBCExceptionReporter]-[ERROR] ORA-01
401: 插入的值对于列过大2004-12-14 10:04:07 [net.sf.hibernate.util.JDBCExceptionReporter]-[WARN] SQL Err
or: 1401, SQLState: 23000
2004-12-14 10:04:07 [net.sf.hibernate.util.JDBCExceptionReporter]-[ERROR] ORA-01
401: 插入的值对于列过大2004-12-14 10:04:07 [net.sf.hibernate.util.JDBCExceptionReporter]-[ERROR] Could
not execute JDBC batch update
java.sql.SQLException: ORA-01401: 插入的值对于列过大 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822
)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1371)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePrepare
dStatement.java:2883)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeBatch(Dele
gatingPreparedStatement.java:231)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.
java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2385)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204)
at test.TestHBMServlet.init(TestHBMServlet.java:96)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1019)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.jav
a:687)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:144)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
ContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16
0)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:793)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:702)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:571)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:644)
at java.lang.Thread.run(Thread.java:534)
2004-12-15 09:19:33 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] Use scrollable
result sets: false
2004-12-15 09:19:33 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] Use JDBC3 getG
eneratedKeys(): false
2004-12-15 09:19:33 [net.sf.hibernate.cfg.SettingsFactory]-[INFO] Optimize cache
for minimal puts: false是不是这里有问题?