ORA-01461 troubleshooting

Source: Internet
Author: User

ORA-01461 troubleshooting
ORA-01461 troubleshooting
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 com. company. thfund. view. Login $ Enhance_1 @ 627bc7 [thfund. Login]: 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

Related Article

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.