ORA-01461 troubleshooting

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