将mysql数据库改成 oracle后 启动tomcat时提示一下错误：
ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01461: can bind a LONG value only for insert into a LONG column
谁能帮助解答一下
全部错误代码如下：
2009-12-18 10:24 ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01461: can bind a LONG value only for insert into a LONG column
2009-12-18 10:24 ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01461: can bind a LONG value only for insert into a LONG column
2009-12-18 10:24 ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655) [spring-orm-2.5.6.jar:2.5.6]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) [spring-tx-2.5.6.jar:2.5.6]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) [spring-tx-2.5.6.jar:2.5.6]
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) [spring-tx-2.5.6.jar:2.5.6]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) [spring-tx-2.5.6.jar:2.5.6]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) [spring-aop-2.5.6.jar:2.5.6]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) [spring-aop-2.5.6.jar:2.5.6]
at $Proxy8.loadAllWebsiteToCache(Unknown Source) [na:na]
at com.jeecms.core.web.ApplicationListener.contextInitialized(ApplicationListener.java:26) [ApplicationListener.class:na]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830) [catalina.jar:na]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337) [catalina.jar:na]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) [catalina.jar:na]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) [catalina.jar:na]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) [catalina.jar:na]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920) [catalina.jar:na]
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883) [catalina.jar:na]
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) [catalina.jar:na]
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) [catalina.jar:na]
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) [catalina.jar:na]
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) [catalina.jar:na]
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) [catalina.jar:na]
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) [catalina.jar:na]
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) [catalina.jar:na]
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) [catalina.jar:na]
at org.apache.catalina.core.StandardService.start(StandardService.java:516) [catalina.jar:na]
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) [catalina.jar:na]
at org.apache.catalina.startup.Catalina.start(Catalina.java:566) [catalina.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_10-rc2]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [na:1.6.0_10-rc2]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.6.0_10-rc2]
at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_10-rc2]
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) [bootstrap.jar:na]
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) [bootstrap.jar:na]
Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:8739) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [na:1.6.0_10-rc2]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [na:1.6.0_10-rc2]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.6.0_10-rc2]
at java.lang.reflect.Method.invoke(Method.java:597) [na:1.6.0_10-rc2]
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) [proxool-0.9.1.jar:na]
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) [proxool-0.9.1.jar:na]
at oracle.jdbc.OraclePreparedStatement$$EnhancerByProxool$$e5d2e581.executeBatch(<generated>) [proxool-cglib.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
... 40 common frames omitted
2009-12-18 22:24:10 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class com.jeecms.core.web.ApplicationListener
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [update CORE_WEBSITE set DOMAIN=?, RES_PATH=?, LFT=?, RGT=?, RES_DOMAIN=?, BASE_DOMAIN=?, DOMAIN_ALIAS=?, NAME=?, SHORT_NAME=?, SUFFIX=?, CURRENT_SYSTEM=?, COOKIE_KEY=?, OWNER_NAME=?, OWNER_IDENTITY=?, COMPANY=?, COPYRIGHT=?, RECORD_CODE=?, EMAIL=?, PHONE_CODE=?, MOBILE_CODE=?, CREATE_TIME=?, EMAIL_CHARSET=?, EMAIL_HOSTNAME=?, EMAIL_ACCOUNT=?, EMAIL_USER_NAME=?, EMAIL_USER_ID=?, EMAIL_USER_PWD=?, EMAIL_SUBJECT=?, EMAIL_CONTENT=?, CONTROL_FRONT_IPS=?, CONTROL_ADMIN_IPS=?, CONTROL_RESERVED=?, CONTROL_NAME_MINLEN=?, CLOSE_REASON=?, IS_CLOSE=?, PARENT=?, GLOBAL_ID=? where WEBSITE_ID=?]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column
; nested exception is java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateTransactionManager.convertJdbcAccessException(HibernateTransactionManager.java:801)
at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:787)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy8.loadAllWebsiteToCache(Unknown Source)
at com.jeecms.core.web.ApplicationListener.contextInitialized(ApplicationListener.java:26)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
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:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:8739)
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:597)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at oracle.jdbc.OraclePreparedStatement$$EnhancerByProxool$$e5d2e581.executeBatch(<generated>)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
... 32 more
2009-12-18 22:24:10 org.apache.catalina.core.StandardContext start
严重: Error listenerStart
2009-12-18 22:24:10 org.apache.catalina.core.StandardContext start
严重: Context [/jeecms_src] startup failed due to previous errors
2009-12-18 22:24:10 org.apache.catalina.core.ApplicationContext log
信息: Closing Spring root WebApplicationContext
2009-12-18 10:24 ERROR org.logicalcobwebs.proxool.DbPool - Prototype
java.lang.NullPointerException
at oracle.sql.CharacterSet.make(CharacterSet.java:429) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:126) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:739) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:219) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) [Oracle_10g_10.1.0.2_JDBC_ojdbc14.jar:"Oracle JDBC Driver version - 10.1.0.2.0"]
at java.sql.DriverManager.getConnection(DriverManager.java:582) [na:1.6.0_10-rc2]
at java.sql.DriverManager.getConnection(DriverManager.java:154) [na:1.6.0_10-rc2]
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39) [proxool-0.9.1.jar:na]
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159) [proxool-0.9.1.jar:na]
at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102) [proxool-0.9.1.jar:na]
at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44) [proxool-0.9.1.jar:na] |
|
