From the exception stacktrace, I see that the following sql might have
problem.
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
What you can do is go to GWS_USERS and check the column type to see whether
the column type and the preparedStatement setter is setting to the correct
data type. Also watch out for any null field in java properties that going
to be inserted to the db columns.
You can take the insert sql string to filled it with data to make sure the
insert sql is working by executing the SQL string in any sql client like
sqlplus if u using oracle.
Fill the insert sql string in such a way like INSERT INTO GWS_USERS
(USR_LOGIN_N_BY,......) VALUES ('vvv',.......)
If the above work then try to log the sql insert string to see the printout
of the sql string the java code trying to execute.Also remember to print out
the values before you use preparedStatement.setString(xxxx) or whatever
setter you have to see any null value caused the invalid column type
From: "Krishna, Hari (FTT-CInternet)" <[EMAIL PROTECTED]>
Reply-To: "Struts Users Mailing List" <user@struts.apache.org>
To: <user@struts.apache.org>
Subject: Invalid Column Type Exception
Date: Fri, 9 Feb 2007 19:25:53 +0530
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.
_________________________________________________________________
Get MSN Messenger emoticons and display pictures here!
http://ilovemessenger.msn.com/?mkt=en-sg
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
