Your primary key is a double. Using "equals" on a double...that may be part of the problem
Have u tried executing the query in an sql shell rather than torque? Next step I would try is to download the torque source and step into OraclePreparedStatement.java:3088 -----Original Message----- From: sumit grover [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 20, 2006 10:32 PM To: [email protected] Subject: Help: Invalid column Type 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.<init>(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.doSelectVillage Records(BaseSecMasterResourcePeer.java:389) at com.csgsystems.fx.security.persist.BaseSecMasterResourcePeer.doSelect(BaseSe cMasterResourcePeer.java:336) at com.csgsystems.fx.security.persist.BaseSecMasterResourcePeer.retrieveByPK(Ba seSecMasterResourcePeer.java:728) at com.csgsystems.fx.security.persist.BaseSecMasterResourcePeer.retrieveByPK(Ba seSecMasterResourcePeer.java:705) at com.csgsystems.fx.security.persist.BaseSecFxResource.getSecMasterResource(Ba seSecFxResource.java:430) at com.csgsystems.fx.security.util.AdminAuditHelper.formatAuditResInfo(AdminAud itHelper.java:95) at com.csgsystems.fx.security.actions.policymgr.role.RoleResourceRemoveAssociat ionAction.localExecute(RoleResourceRemoveAssociationAction.java:152) at com.csgsystems.fx.security.actions.SecurityBaseAction.execute(SecurityBaseAc tion.java:220) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces sor.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(Application FilterChain.java:284) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:204) at com.csgsystems.fx.security.util.AuthenticationFilter.doFilter(Authentication Filter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:204) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:257) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext Valve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.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(StandardValveContex t.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164 ) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.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(StandardValveContex t.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.processConne ction(Http11Protocol.java:732) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:688) at java.lang.Thread.run(Thread.java:534) The Tables definition in Schema and Database is the same and looks like. <table name="SEC_MASTER_RESOURCE"> <column name="MR_ID" primaryKey="true" required="true" size="18" type="DECIMAL"/> <column name="MR_NAME" required="true" size="2000" type="VARCHAR"/> <column name="MR_CANONICAL_NAME" required="true" size="2000" type="VARCHAR"/> <column name="MR_RESOURCE_REALM" required="true" size="200" type="VARCHAR"/> <column name="MR_RESOURCE_TYPE" required="true" size="500" type="VARCHAR"/> <column name="MR_ACTIONS" size="2000" type="VARCHAR"/> <id-method-parameter name="default" value="MR_SEQ"/> </table> 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
