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:HKrishn1@(protected)]
Inviato: venerdì 9 febbraio 2007 14.56
A: user@(protected)
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: user-unsubscribe@(protected)
For additional commands, e-mail: user-help@(protected)