cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian P Millett <...@ec-group.com>
Subject Re: draft final version of the esql namespace
Date Mon, 06 Nov 2000 22:20:42 GMT
Donald Ball wrote:

> after much discussion and cogitation, i submit the following pseudoschema
> as the proposed final skeleton of the esql namespace:
>
> <esql:connection>

Looks good Donald, how about the pool stuff?

  <esql:pool-name> name in connection pool </esql:pool-name>

>  <esql:driver>org.postgresql.Driver</esql:driver>
>  <esql:dburl>jdbc:postgresql://localhost/test</esql:dburl>
>  <esql:username>test</esql:username>
>  <esql:password>test</esql:password>
>  <esql:execute-query>
>   <esql:query>select id,name from department_table</esql:query>
>   <esql:results>
>    <header>header info</header>
>    <esql:row-results>
>     <id><esql:get-int column="id"/></id>
>     <name><esql:get-string column="name"/></name>
>    </esql:row-results>
>    <footer>footer info</footer>
>   </esql:results>
>   <esql:update-results>
>    there were <esql:get-updated-rows/> rows updated
>   </esql:update-results>
>   <esql:error-results>
>    the query failed for some reason: <esql:get-message/>
>   </esql:error-results>
>  </esql:execute-query>
> </esql:connection>
>
> conformant implementations shall work as follows:
>
> 1. connections are opened at the start connection element tag and closed
> at the end connection element tag.

This would be that connections in the pool are retrieved at start connection and returned
at the end
connection element tag?

> 2. multiple queries may be executed in the same connection
>
> 3. if a query returns a resultset, the children of the results element, if
> any, are instantiated and the children of the results element's
> row-results child are instantiated for each row in the resultset.
>
> 4. if a query returns a number of rows, the children of the update-results
> element are instantiated.
>
> 5. if a query results in a sql error and an error-results element exists,
> its children are instantiated and the processor will attempt to
> continue.
>
> 6. the execute-query and connection elements may appear underneath the
> results, row-results, update-results, or connection elements.
>
> comments and suggestions are welcome. if everything thinks this is okay,
> i'll flesh out the namespace with all of the extras (max-rows, get-xml,
> etc.) begin writing a formal schema for this and bring the c1 and c2
> implementations into line with the specification.
>
> - donald
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org

--
Brian Millett
Enterprise Consulting Group   "Shifts in paradigms
(314) 205-9030               often cause nose bleeds."
bpm@ec-group.com                           Greg Glenn




Mime
View raw message