port artimus to oracle
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Claire_Chang
Posted On:   Wednesday, July 23, 2003 10:53 AM

I am trying to port artimus to run on oracle. so far, I've changed sql_articles.properties and sql_keys.properties to use the oracle sql. I go the two tables created. But when the program runs to Access.findAll and it executes the following sql: SELECT article,marked,contributed,contributor,creator,cost,title,content FROM artimus_article WHERE marked=0 I got exception. Any one port artimus to oracle and weblogic before? Thanks, java.sql.SQLException: Closed Resultset: getMetaData at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) at oracle.jdbc.dbaccess.DBError.check_error(DBError.jav   More>>

I am trying to port artimus to run on oracle. so far, I've changed sql_articles.properties and sql_keys.properties to use the oracle sql. I go the two tables created. But when the program runs to Access.findAll and it executes the following sql:


SELECT article,marked,contributed,contributor,creator,cost,title,content FROM artimus_article WHERE marked=0
I got exception. Any one port artimus to oracle and weblogic before? Thanks,


java.sql.SQLException: Closed Resultset: getMetaData

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)

at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:775)

at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:131)

at org.apache.commons.dbcp.DelegatingResultSet.getMetaData(DelegatingResultSet.java:176)

at org.apache.commons.scaffold.sql.ResultSetUtils.getCollection(Unknown Source)

at org.apache.commons.scaffold.sql.StatementUtils.getCollection(Unknown Source)

at org.apache.commons.scaffold.sql.StatementUtils.getCollection(Unknown Source)

at org.apache.commons.scaffold.sql.AccessBase.findCollection(Unknown Source)

at org.apache.artimus.article.Access.findAll(Unknown Source)

at org.apache.artimus.CreateResources.execute(Unknown Source)

at org.apache.struts.scaffold.ProcessAction.executeLogic(Unknown Source)

at org.apache.struts.scaffold.BaseHelperAction.executeLogic(Unknown Source)

at org.apache.struts.scaffold.BaseAction.execute(Unknown Source)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)

at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1014)

at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:257)

at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:417)

at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:300)

at org.apache.struts.action.RequestProcessor.processActionForward(RequestProcessor.java:390)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:271)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)

at java.lang.Thread.run(Thread.java:479)

processActionForward(/do/Menu, false)

   <<Less
About | Sitemap | Contact