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.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.
<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
