ORA-01461 troubleshooting

ORA-01461 troubleshooting

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 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

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