yes - i think your're right when it comes to the multiple query/combine result issue - using DAO in this case would definitely make more sense. but in case DAO doesn't fit my model i still want to be able to built my own 'multilpe query executor' so i would be nice if i could cancel statments on the SQLMap layer. but maybe the problem is too specific to support it on a generic framework level. anyway ;)

Brice Ruth wrote:
I could see this being done in a DAO layer, perhaps ... I'm not sure that the SqlMap layer is necessarily the right place for it. What do you think?

On 4/18/05, *Michael Zurke* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

    i think it would make sense if ibatis would support something like
    multiple query processing (e.g. a query executed in parallel on
    different database clusters. then the abstraction layer should combine
    the results. in that case it would be handy to specify a timeout to get
    results back from the most responsive clusters only (-> cancel). but
    this is theoretical since ibatis doesn't support such functionality
    (right?). but still - if there would be something like SQLMap.cancel()
    one could implement the parallel querying quite easy, i guess.

    mish

    Brandon Goodin wrote:
     > It is not a funciton that is available. But, i'm not sure why it
     > wouldn't be available. iBatis uses straight JDBC underneath. It could
     > provide some functionlaity to cancel. But, i'm not sure how we would
     > provide the criteria for a cancel. Please expound on "why" you would
     > cancel.
     >
     > Brandon
     >
     > On 4/18/05, Brice Ruth <[EMAIL PROTECTED]
    <mailto:[EMAIL PROTECTED]>> wrote:
     >
     >>iBATIS is thread-local. The cancel() method requires that a
    separate thread
     >>cancel a statement in an executing thread. I don't believe this
    would be
     >>supported in this type of framework.
     >>
     >>Reference:
     >>http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#cancel()
     >>
     >>BR
     >>
     >>
     >>
     >>On 4/18/05, Michael Zurke <[EMAIL PROTECTED]
    <mailto:[EMAIL PROTECTED]>> wrote:
     >>
     >>>is it somehow possible to cancel an executed query via SQLMaps?
     >>>as far as i know PreparedStatement has a cancel() method for
    that puropse.
     >>>
     >>
     >>
     >>
     >>--
     >>Brice Ruth
     >>Software Engineer, Madison WI
     >
     >




-- Brice Ruth Software Engineer, Madison WI



Reply via email to