db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alvaro Coronel <alvarocorone...@yahoo.com>
Subject Re: Help: Invalid column Type
Date Thu, 21 Dec 2006 15:22:22 GMT
Hello sumit.
Can U post the code please?
Also, have you checked the type of the parameter you are setting?

Thanks,
Álvaro

sumit grover <sumit.grover@yahoo.com> 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 
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message