You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by "Krishna, Hari (FTT-CInternet)" <HK...@Templeton.com> on 2007/02/09 14:55:53 UTC
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.