Hello sumit.
Can U post the code please?
Also, have you checked the type of the parameter you are setting?
Thanks,
Álvaro
sumit grover <[EMAIL PROTECTED]> wrote: Hi All,
Thanks a lot for taking time out to help me. I have been digging my
head into the issue since a long time now but to no avail. I hope I will be
able to get some good help on this forum.
I do not much experience on torque and am facing an issue, where a select
query on a specific table fails with SQLException: Invalid Column Type.
The stack trace :-
<<< Exception >>>>
<<< Query:SELECT
SEC_MASTER_RESOURCE.MR_ID
FROM
SEC_MASTER_RESOURCE
WHERE
SEC_MASTER_RESOURCE.MR_ID = ?
<<< Parms:[1061]
java.sql.SQLException: Invalid column type
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3088)
at
oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3107)
at
com.workingdogs.village.QueryDataSetPS.setPreparedStatementValue(Unknown Source)
at com.workingdogs.village.QueryDataSetPS.(Unknown Source)
at org.apache.torque.util.BasePeer.executeQueryPS(BasePeer.java:1739)
at org.apache.torque.util.BasePeer.doSelectPS(BasePeer.java:1535)
at
com.csgsystems.fx.security.persist.BaseSecMasterResourcePeer.doSelectVillageRecords(BaseSecMasterResourcePeer.java:389)
at
com.csgsystems.fx.security.persist.BaseSecMasterResourcePeer.doSelect(BaseSecMasterResourcePeer.java:336)
at
com.csgsystems.fx.security.persist.BaseSecMasterResourcePeer.retrieveByPK(BaseSecMasterResourcePeer.java:728)
at
com.csgsystems.fx.security.persist.BaseSecMasterResourcePeer.retrieveByPK(BaseSecMasterResourcePeer.java:705)
at
com.csgsystems.fx.security.persist.BaseSecFxResource.getSecMasterResource(BaseSecFxResource.java:430)
at
com.csgsystems.fx.security.util.AdminAuditHelper.formatAuditResInfo(AdminAuditHelper.java:95)
at
com.csgsystems.fx.security.actions.policymgr.role.RoleResourceRemoveAssociationAction.localExecute(RoleResourceRemoveAssociationAction.java:152)
at
com.csgsystems.fx.security.actions.SecurityBaseAction.execute(SecurityBaseAction.java:220)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at
com.csgsystems.fx.security.util.AuthenticationFilter.doFilter(AuthenticationFilter.java:57)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
at java.lang.Thread.run(Thread.java:534)
The Tables definition in Schema and Database is the same and looks like.
Please do take some time to reply back if you have any idea of this issue or
have faced a similar problem in the past with a brief of how you resolved it.
It'll be a great help
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
