ora-01461: can bind a long value only for insert into a long column原来是用weblogic的连接池，没有问题。转为tomcat或直接j
ora-01461错误解决方法：
ora-01461: can bind a long value only for insert into a long column
原来是用weblogic的连接池，没有问题。
转为tomcat或直接jdbc调用，报错。
原因:使用了ojdbc14.jar，更新为ojdbc6即可。weblogic连接池是不用web-inf下的lib的ojdbc.jar的。
详细错误信息：
debug sql execute time: 0.0s
debug sql update tf_sp_user_person set address = ?,certificate_no = ?,certificate_type = ?,create_time = ?,cust_level = ?,cust_no = ?,cust_risk = ?,head_file_id = ?,is_fund_flag = ?,mobile_phone = ?,person_name = ?,post_code = ?,risk_end_date = ?,sp_user_id = ?,sp_user_name = ?,update_time = ? where sp_user_id = ?
debug param [佛山, 441422199108292310, 0, 2015-01-23 17:14:45.0, null, 31507, , null, 1, 1868880xxxx, 桂强, 528000, , 1000139, 桂强, 2015-01-28 16:07:08.0, 1000139]
error error sql update tf_sp_user_person set address = ?,certificate_no = ?,certificate_type = ?,create_time = ?,cust_level = ?,cust_no = ?,cust_risk = ?,head_file_id = ?,is_fund_flag = ?,mobile_phone = ?,person_name = ?,post_code = ?,risk_end_date = ?,sp_user_id = ?,sp_user_name = ?,update_time = ? where sp_user_id = ?
org.apache.tapestry.applicationruntimeexception: unable to invoke method personlogin on ]: null
at org.apache.tapestry.listener.listenermap.invoketargetmethod(listenermap.java:283)
at org.apache.tapestry.listener.listenermap.access$100(listenermap.java:46)
at org.apache.tapestry.listener.listenermap$syntheticlistener.invoke(listenermap.java:97)
at org.apache.tapestry.listener.listenermap$syntheticlistener.actiontriggered(listenermap.java:102)
at com.company.webframework.tapestry.components.ajaxcomponent.mappservice.service(mappservice.java:78)
at org.apache.tapestry.engine.abstractengine.service(abstractengine.java:889)
at org.apache.tapestry.applicationservlet.doservice(applicationservlet.java:198)
at org.apache.tapestry.applicationservlet.dopost(applicationservlet.java:327)
at javax.servlet.http.httpservlet.service(httpservlet.java:643)
at javax.servlet.http.httpservlet.service(httpservlet.java:723)
at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:290)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206)
at com.company.filter.rightfilter.dofilter(rightfilter.java:37)
at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206)
at com.company.filter.autologinfilter.dofilter(autologinfilter.java:56)
at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206)
at com.company.filter.security.xss.xsssecurityfilter.dofilter(xsssecurityfilter.java:36)
at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:235)
at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:206)
at org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:233)
at org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:191)
at org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:127)
at org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:103)
at org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:109)
at org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:293)
at org.apache.coyote.http11.http11processor.process(http11processor.java:861)
at org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:620)
at org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:489)
at java.lang.thread.run(thread.java:662)
caused by: java.lang.reflect.invocationtargetexception
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.tapestry.listener.listenermap.invoketargetmethod(listenermap.java:257)
... 30 more
caused by: java.sql.sqlexception: ora-01461: can bind a long value only for insert into a long column
at oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:125)
at oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:305)
at oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:272)
at oracle.jdbc.driver.t4c8oall.receive(t4c8oall.java:623)
at oracle.jdbc.driver.t4cpreparedstatement.dooall8(t4cpreparedstatement.java:181)
at oracle.jdbc.driver.t4cpreparedstatement.execute_for_rows(t4cpreparedstatement.java:543)
at oracle.jdbc.driver.oraclestatement.doexecutewithtimeout(oraclestatement.java:1028)
at oracle.jdbc.driver.oraclepreparedstatement.executeinternal(oraclepreparedstatement.java:2888)
at oracle.jdbc.driver.oraclepreparedstatement.executeupdate(oraclepreparedstatement.java:2960)
at org.apache.tomcat.dbcp.dbcp.delegatingpreparedstatement.executeupdate(delegatingpreparedstatement.java:105)
at org.apache.tomcat.dbcp.dbcp.delegatingpreparedstatement.executeupdate(delegatingpreparedstatement.java:105)
at com.company.dbframework.jdbc.parameterstatement.executeupdate(parameterstatement.java:99)
at com.company.dbframework.jdbc.daomanager.executeupdate(daomanager.java:244)
at com.company.dbframework.jdbc.daomanager.update(daomanager.java:989)
at com.company.dbframework.jdbc.daomanager.save(daomanager.java:1319)
at com.company.dbframework.jdbc.daomanager.save(daomanager.java:1274)
at com.company.dbframework.jdbc.daomanager.save(daomanager.java:1235)
at com.company.dbframework.jdbc.daomanager.save(daomanager.java:1246)
at com.company.thfund.bean.register.registerdao.updateperson(registerdao.java:50)
at com.company.thfund.bean.login.loginbean.modifypersoninfo(loginbean.java:243)
at com.company.thfund.view.login.personlogin(login.java:99)
... 35 more
error execute failed, rollback...sdcen1
在centos 6.4下安装oracle 11gr2(x64)
oracle 11gr2 在vmware虚拟机中安装步骤
debian 下 安装 oracle 11g xe r2
oracle性能优化 之 共享池
本文永久更新链接地址：
，