You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by sumit grover <su...@yahoo.com> on 2006/12/21 07:31:46 UTC
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.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
Re: Help: Invalid column Type
Posted by Alvaro Coronel <al...@yahoo.com>.
Hello sumit.
Can U post the code please?
Also, have you checked the type of the parameter you are setting?
Thanks,
Álvaro
sumit grover <su...@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
RE: Help: Invalid column Type
Posted by Declan Shanaghy <to...@shanaghy.com>.
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