running artimus/scaffold under oracle 9i. (struts connection pool)

[Rajesh Kalluri <rk...@manduca.com>]

Hi, Did any one try to run the artimus example under Oracle 8/9 i, with the
Struts connection pool.

I got some peices running fine with PoolMan but when i use the Struts
Connection pool I get the follwong errors for the same peice of
functionality.


when inside the StatementUtils.java

org.apache.scaffold.lang.ResourceException: ResourceException: A required
resource is not available.
	at org.apache.artimus.article.Access.findAll(Access.java:439)
	at org.apache.artimus.article.FindByLast.execute(FindByLast.java:44)
	at
org.apache.scaffold.struts.ProcessAction.executeLogic(ProcessAction.java:387
)
	at
org.apache.scaffold.struts.BaseHelperAction.executeLogic(BaseHelperAction.ja
va:97)
	at org.apache.scaffold.struts.BaseAction.execute(BaseAction.java:837)
	at org.apache.scaffold.struts.BaseAction.perform(BaseAction.java:769)
	at
org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.ja
va:1787)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)
	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)
ad.run(Thread.java:484)
Caused by:
java.sql.SQLException: Closed Statement: getMetaData
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
	at
oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:
150)
	at
org.apache.scaffold.sql.ResultSetUtils.getCollection(ResultSetUtils.java:410
)
	at
org.apache.scaffold.sql.StatementUtils.getCollection(StatementUtils.java:629
)
	at
org.apache.scaffold.sql.StatementUtils.getCollection(StatementUtils.java:714
)
	at org.apache.artimus.article.Access.findAll(Access.java:434)
	at org.apache.artimus.article.FindByLast.execute(FindByLast.java:44)
	at
org.apache.scaffold.struts.ProcessAction.executeLogic(ProcessAction.java:387
)
	at
org.apache.scaffold.struts.BaseHelperAction.executeLogic(BaseHelperAction.ja
va:97)
	at org.apache.scaffold.struts.BaseAction.execute(BaseAction.java:837)
	at org.apache.scaffold.struts.BaseAction.perform(BaseAction.java:769)
	at
org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.ja
va:1787)


This is my data source config in struts-config.xml.

<data-sources>
    <data-source>
      <set-property property="maxCount"
                       value="50"/>
      <set-property property="minCount"
                       value="2"/>
      <set-property property="description"
                       value="Artimus:oracle Data Source Configuration"/>
      <set-property property="driverClass"
                       value="oracle.jdbc.driver.OracleDriver"/>
      <set-property property="url"
                       value="jdbc:oracle:thin:@10.1.1.47:1521:pandora"/>
      <set-property property="autoCommit"
                       value="true"/>
      <set-property property="user"
                       value="content"/>
      <set-property property="password"
                       value=""/>
    </data-source>
  </data-sources>

Any help is appreciated, i have been breaking my head for a while on this.

Regards
Raj



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>