As you can see it's an SQL Exception. I suggest to print out the insert statement and then try to execute the SQL insert in a SQL client. I think yuu'll get the problem. Just to show an example it does'nt work no more : do you have any stored procedure that calculate a field id before insert ? Verify it works and you have the right to execute in the new enviroment.
Marcello Savino ALDEBRA S.p.A. tel. 0461302441 -----Messaggio originale----- Da: Krishna, Hari (FTT-CInternet) [mailto:[EMAIL PROTECTED] Inviato: venerdì 9 febbraio 2007 14.56 A: user@struts.apache.org Oggetto: Invalid Column Type Exception Hi all, I am working in a webapplication where we have Spring JDBC in DAO layer. Everything is fine till recent time as I am getting this exception though I didn't make any changes in the code base.The only change is migration of data base from 9i to 10g and JDK from 1.4.2.8 to 1.4.2.11.This exception is arising only in the case of insert operation and not in update operation.Please let me know how best we can fix it. <Feb 9, 2007 6:54:01 PM IST> <Error> <HTTP> <BEA-101019> <[ServletContext(id=33117811,name=web,context-path=)] Servlet failed with IOException java.rmi.RemoteException: EJB Exception: ; nested exception is: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO GWS_USERS(USR_LOGIN_N _BY, USR_PROF_UPDATE_DATE, USR_SYS_NO, USR_DISPLAY_FUND_WATCHLIST, USR_REESTABLISH, USR_EMAIL_SUPPRESSION_FLAG, USR_PEGA_SHARE_ID, USR_USER_TYPE, USR_EMAIL_ lumn type; nested exception is java.sql.SQLException: Invalid column type at weblogic.ejb20.internal.EJBRuntimeUtils.throwRemoteException(EJBRuntimeU tils.java:102) at weblogic.ejb20.internal.BaseEJBHome.handleSystemException(BaseEJBHome.ja va:307) at weblogic.ejb20.internal.BaseEJBObject.postInvoke(BaseEJBObject.java:284) at weblogic.ejb20.internal.StatelessEJBObject.postInvoke(StatelessEJBObject .java:168) at com.frk.ci.gws.user.facade.bean.ProfileServicesBean_es1nk_EOImpl.createP rofile(ProfileServicesBean_es1nk_EOImpl.java:2434) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.remoting.rmi.RmiClientInterceptorUtils.doInvoke(RmiC lientInterceptorUtils.java:103) at org.springframework.ejb.access.SimpleRemoteSlsbInvokerInterceptor.doInvo ke(SimpleRemoteSlsbInvokerInterceptor.java:75) at org.springframework.ejb.access.AbstractRemoteSlsbInvokerInterceptor.invo ke(AbstractRemoteSlsbInvokerInterceptor.java:114) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref lectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo pProxy.java:176) at $Proxy11.createProfile(Unknown Source) at com.frk.ci.gws.user.web.action.ProfileCreationAction.handleCreateProfile (ProfileCreationAction.java:540) at com.frk.ci.gws.user.web.action.ProfileCreationAction.handleValidation(Pr ofileCreationAction.java:389) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.j ava:270) at com.frk.ci.gws.framework.web.GWSBaseDispatchAction.execute(GWSBaseDispat chAction.java:74) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at com.frk.ci.gws.framework.web.GWSBaseActionServlet.process(GWSBaseActionS ervlet.java:26) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Se rvletStubImpl.java:1077) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl. java:465) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl. java:348) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.r un(WebAppServletContext.java:7051) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSu bject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121 ) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServl etContext.java:3902) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl. java:2773) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183) Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO GWS_USERS(USR_LOGI TED_BY, USR_PROF_UPDATE_DATE, USR_SYS_NO, USR_DISPLAY_FUND_WATCHLIST, USR_REESTABLISH, USR_EMAIL_SUPPRESSION_FLAG, USR_PEGA_SHARE_ID, USR_USER_TYPE, USR_EMA column type; nested exception is java.sql.SQLException: Invalid column type at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translat e(SQLStateSQLExceptionTranslator.java:96) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.tran slate(SQLErrorCodeSQLExceptionTranslator.java:257) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:493 ) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:692) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:754) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:762) at com.frk.ci.gws.user.dao.db.ProfileDAODBImpl.createUserProfile(ProfileDAO DBImpl.java:489) at com.frk.ci.gws.user.services.profile.SHProfileManager.createProfile(SHPr ofileManager.java:301) at com.frk.ci.gws.user.services.ProfileServicesImpl.createProfile(ProfileSe rvicesImpl.java:163) at com.frk.ci.gws.user.facade.bean.ProfileServicesBean.createProfile(Profil eServicesBean.java:89) at com.frk.ci.gws.user.facade.bean.ProfileServicesBean_es1nk_EOImpl.createP rofile(ProfileServicesBean_es1nk_EOImpl.java:2424) ... 35 more Caused by: java.sql.SQLException: Invalid column type at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273) at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.jav a:4560) at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStateme nt.java:869) at weblogic.jdbc.wrapper.PreparedStatement.setNull(PreparedStatement.java:5 39) at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(St atementCreatorUtils.java:96) at org.springframework.jdbc.core.JdbcTemplate$ArgPreparedStatementSetter.se tValues(JdbcTemplate.java:1161) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcT emplate.java:696) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:476 ) ... 43 more Regards, I.HariKrishna | Software Engineer | Franklin Templeton International Services (India) Pvt. Ltd. | Franklin Templeton Centre,1st Floor, No.7,Third Cross Street, Kasturba Nagar, Adyar, Chennai 600020 | Tel: +91 44 24407000 | Extn: 17123 | Fax: +91 44 24453661 | Mobile: +91 9884528587 | www.franklintempleton.com Notice: All email and instant messages (including attachments) sent to or from Franklin Templeton Investments (FTI) personnel may be retained, monitored and/or reviewed by FTI and its agents, or authorized law enforcement personnel, without further notice or consent. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]