hi am having this error when saving value in my application am using adf bc.the error is java.sql.SQLException: Invalid column type
the problem am able to save value when testing in model but when i run my application and try to update vale am geting the error where must i start to debug to find the problem
ADFLogger> <addContextData> Estimated row count
<Utils> <buildFacesMessage> ADF: Adding the following JSF error message: Invalid column type
java.sql.SQLException: Invalid column type
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:150)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:399)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:581)
at oracle.jdbc.driver.OracleCallableStatementWrapper.registerOutParameter(OracleCallableStatementWrapper.java:1765)
at oracle.jbo.server.OracleSQLBuilderImpl.bindUpdateStatement(OracleSQLBuilderImpl.java:2243)
at oracle.jbo.server.EntityImpl.bindDMLStatement(EntityImpl.java:10524)
at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:412)
at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:8575)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:6816)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3290)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:3093)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2097)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2378)
at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1615)
at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1417)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1437)
at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2150)
at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:740)
at oracle.adf.controller.v2.lifecycle.PageLifecycleImpl.executeEvent(PageLifecycleImpl.java:402)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding._execute(FacesCtrlActionBinding.java:252)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlActionBinding.execute(FacesCtrlActionBinding.java:185)
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 com.sun.el.parser.AstValue.invoke(Unknown Source)
at com.sun.el.MethodExpressionImpl.invoke(Unknown Source)
at org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)
at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBinding(UIXComponentBase.java:1256)
at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:183)
at oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:148)
at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.broadcastEvents(LifecycleImpl.java:1018)
at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:386)
at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:194)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:205)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:106)
at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)
at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)
at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
<LoopDiagnostic> <dump> [5032] variableIterator variables passivated >>> TrackQueryPerformed def SearchAppliedCriteria def SearchAppliedCriteria=IntUsersCriteria
<DCUtil> <findSpelObject> [5033] DCUtil, returning:oracle.jbo.uicli.binding.JUFormBinding, for view_pageDefs_IntUsrPageDef_WEB_INF_Upninttask_flow_definition_xml_Upninttask_flow_definition
<DCIteratorBinding> <releaseDataInternal> [5034] Releasing iterator binding:chkidList_1241
<DCIteratorBinding> <releaseDataInternal> [5035] Releasing iterator binding:TitlecodeList_1239
<DCIteratorBinding> <releaseDataInternal> [5036] Releasing iterator binding:CountrycodeList_1242
<DCIteratorBinding> <releaseDataInternal> [5037] Releasing iterator binding:BranchcodeList_1235
<DCIteratorBinding> <releaseDataInternal> [5038] Releasing iterator binding:OfficecodeList_1236
<DCIteratorBinding> <releaseDataInternal> [5039] Releasing iterator binding:RoleaccesscodeList_1237
<DCIteratorBinding> <releaseDataInternal> [5040] Releasing iterator binding:StatuscodeList_1238
<DCIteratorBinding> <releaseDataInternal> [5041] Releasing iterator binding:GenderList_1240
<JUCtrlHierNodeBinding> <release> [5042] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_34, value:IntUsers1Iterator
<DCIteratorBinding> <releaseDataInternal> [5043] Releasing iterator binding:UamUserdetailsView1Iterator
<DCIteratorBinding> <releaseDataInternal> [5044] Releasing iterator binding:UamUserextensionView1Iterator
<DCIteratorBinding> <releaseDataInternal> [5045] Releasing iterator binding:UamPractitionersView1Iterator
<JUCtrlHierNodeBinding> <release> [5046] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_34, value:IntUsers1Iterator
<DCIteratorBinding> <releaseDataInternal> [5047] Releasing iterator binding:IntUsers1Iterator
<DCIteratorBinding> <releaseDataInternal> [5048] Releasing iterator binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlListBinding_1140List_1141
<DCIteratorBinding> <releaseDataInternal> [5049] Releasing iterator binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlListBinding_1158List_1159
<DCIteratorBinding> <releaseDataInternal> [5050] Releasing iterator binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlListBinding_1176List_1177
<JUCtrlHierNodeBinding> <release> [5051] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_32, value:vcRowsIterator
<DCIteratorBinding> <releaseDataInternal> [5052] Releasing iterator binding:operators_1073
<DCIteratorBinding> <releaseDataInternal> [5053] Releasing iterator binding:listIter
<DCIteratorBinding> <releaseDataInternal> [5054] Releasing iterator binding:values_1076
<DCIteratorBinding> <releaseDataInternal> [5055] Releasing iterator binding:values_1076
<DCIteratorBinding> <releaseDataInternal> [5056] Releasing iterator binding:nestedViewCriteria_1078
<DCIteratorBinding> <releaseDataInternal> [5057] Releasing iterator binding:nestedViewCriteria_1078
<DCIteratorBinding> <releaseDataInternal> [5058] Releasing iterator binding:operators_1073
<DCIteratorBinding> <releaseDataInternal> [5059] Releasing iterator binding:operators_1080
<DCIteratorBinding> <releaseDataInternal> [5060] Releasing iterator binding:listIter
<DCIteratorBinding> <releaseDataInternal> [5061] Releasing iterator binding:values_1083
<DCIteratorBinding> <releaseDataInternal> [5062] Releasing iterator binding:values_1083
<DCIteratorBinding> <releaseDataInternal> [5063] Releasing iterator binding:nestedViewCriteria_1085
<DCIteratorBinding> <releaseDataInternal> [5064] Releasing iterator binding:nestedViewCriteria_1085
<DCIteratorBinding> <releaseDataInternal> [5065] Releasing iterator binding:operators_1080
<DCIteratorBinding> <releaseDataInternal> [5066] Releasing iterator binding:operators_1087
<DCIteratorBinding> <releaseDataInternal> [5067] Releasing iterator binding:values_1090
<DCIteratorBinding> <releaseDataInternal> [5068] Releasing iterator binding:values_1090
<DCIteratorBinding> <releaseDataInternal> [5069] Releasing iterator binding:nestedViewCriteria_1092
<DCIteratorBinding> <releaseDataInternal> [5070] Releasing iterator binding:nestedViewCriteria_1092
<DCIteratorBinding> <releaseDataInternal> [5071] Releasing iterator binding:operators_1087
<DCIteratorBinding> <releaseDataInternal> [5072] Releasing iterator binding:operators_1094
<DCIteratorBinding> <releaseDataInternal> [5073] Releasing iterator binding:values_1097
<DCIteratorBinding> <releaseDataInternal> [5074] Releasing iterator binding:values_1097
<DCIteratorBinding> <releaseDataInternal> [5075] Releasing iterator binding:nestedViewCriteria_1099
<DCIteratorBinding> <releaseDataInternal> [5076] Releasing iterator binding:nestedViewCriteria_1099
<DCIteratorBinding> <releaseDataInternal> [5077] Releasing iterator binding:operators_1094
<DCIteratorBinding> <releaseDataInternal> [5078] Releasing iterator binding:operators_1101
<DCIteratorBinding> <releaseDataInternal> [5079] Releasing iterator binding:values_1104
<DCIteratorBinding> <releaseDataInternal> [5080] Releasing iterator binding:values_1104
<DCIteratorBinding> <releaseDataInternal> [5081] Releasing iterator binding:nestedViewCriteria_1106
<DCIteratorBinding> <releaseDataInternal> [5082] Releasing iterator binding:nestedViewCriteria_1106
<DCIteratorBinding> <releaseDataInternal> [5083] Releasing iterator binding:operators_1101
<DCIteratorBinding> <releaseDataInternal> [5084] Releasing iterator binding:criteriaItemsForSearch_1064
<DCIteratorBinding> <releaseDataInternal> [5085] Releasing iterator binding:viewObjectBindVars_1067
<DCIteratorBinding> <releaseDataInternal> [5086] Releasing iterator binding:viewObjectBindVars_1067
<DCIteratorBinding> <releaseDataInternal> [5087] Releasing iterator binding:properties_1069
<DCIteratorBinding> <releaseDataInternal> [5088] Releasing iterator binding:properties_1069
<DCIteratorBinding> <releaseDataInternal> [5089] Releasing iterator binding:criteriaItemsForSearch_1064
<JUCtrlHierNodeBinding> <release> [5090] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_33, value:vcRowsIterator
<JUCtrlHierNodeBinding> <release> [5091] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_32, value:vcRowsIterator
<JUCtrlHierNodeBinding> <release> [5092] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_33, value:vcRowsIterator
<DCIteratorBinding> <releaseDataInternal> [5093] Releasing iterator binding:vcRowsIterator
<DCIteratorBinding> <releaseDataInternal> [5094] Releasing iterator binding:variableIterator
<DCUtil> <findSpelObject> [5095] DCUtil, returning:oracle.adfinternal.view.faces.model.binding.FacesCtrlSearchBinding, for IntUsersCriteriaQuery
<JUCtrlHierNodeBinding> <release> [5096] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_32, value:vcRowsIterator
<JUCtrlHierNodeBinding> <release> [5097] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_33, value:vcRowsIterator
<JUCtrlHierNodeBinding> <release> [5098] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_32, value:vcRowsIterator
<JUCtrlHierNodeBinding> <release> [5099] released: ROOT node binding:noCtrl_oracle_adfinternal_view_faces_model_binding_FacesCtrlHierNodeBinding_33, value:vcRowsIterator
<DCIteratorBinding> <releaseDataInternal> [5100] Releasing iterator binding:vcRowsIterator
<DCIteratorBinding> <releaseDataInternal> [5101] Releasing iterator binding:variableIterator
<ApplicationPoolMessageHandler> <doPoolMessage> [5102] **** PoolMessage REQ ATTACH LWS