db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Declan Shanaghy" <tor...@shanaghy.com>
Subject RE: Help: Invalid column Type
Date Fri, 22 Dec 2006 03:35:34 GMT
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:sumit.grover@yahoo.com] 
Sent: Wednesday, December 20, 2006 10:32 PM
To: torque-user@db.apache.org
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message