ORA-01461 troubleshooting

Source: Internet
Author: User
ORA-01461: canbindaLONGvalueonlyforinsertintoaLONGcolumn was originally using the weblogic connection pool, no problem. Switch to tomcat or directly j

ORA-01461: can bind a LONG value only for insert into a LONG column is originally used weblogic connection pool, no problem. Switch to tomcat or directly j

ORA-01461 error Solution:

ORA-01461: can bind a LONG value only for insert into a LONG column
The connection pool of weblogic is used, and there is no problem.
Switch to tomcat or direct jdbc call, and an error is returned.
Cause: Use ojdbc14.jar and update it to ojdbc6. Weblogic connection pool does not need the lib ojdbc. jar under the WEB-INF.

Detailed error message:
Debug SQL execute time: 0.0 s
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 [Foshan, 441422199108292310, 0, 17:14:45. 0, null, 31507, null, 1, 1868880 XXXX, Gui Qiang, 528000, 1000139, Gui Qiang, 16:07:08. 0, 1000139]
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.exe cute_for_rows (T4CPreparedStatement. java: 543)
At oracle. jdbc. driver. OracleStatement. doExecuteWithTimeout (OracleStatement. java: 1028)
At oracle.jdbc.driver.OraclePreparedStatement.exe cuteInternal (OraclePreparedStatement. java: 2888)
At oracle.jdbc.driver.OraclePreparedStatement.exe cuteUpdate (OraclePreparedStatement. java: 2960)
At org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.exe cuteUpdate (DelegatingPreparedStatement. java: 105)
At org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.exe cuteUpdate (DelegatingPreparedStatement. java: 105)
At com.company.dbframework.jdbc.ParameterStatement.exe cuteUpdate (ParameterStatement. java: 99)
At com.company.dbframework.jdbc.DaoManager.exe cuteUpdate (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

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Sharing pool for Oracle Performance Optimization

,

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.