Re: [Exist-open] two mysql commands in one xql file

[Adam R. <ad...@ex...>]

Indeed you should only use the one connection within a single query. I
cannot actually understand why anyone would actually need more than
one connection as the query execution is linear anyway...

On 8 February 2011 13:30, Withanage, Dulip
<wit...@as...> wrote:
> Hi Anton,
>
> Thanks for the help. Worked fine.
>
> TC,
> Dulip
>
> -----Original Message-----
> From: Anton Kolev [mailto:ak...@de...]
> Sent: Tuesday, February 08, 2011 1:03 PM
> To: Withanage, Dulip
> Cc: exi...@li...; Adam Retter
> Subject: Re: [Exist-open] two mysql commands in one xql file
>
> Hi Dulip,
>
> On 08.02.2011 13:02, Withanage, Dulip wrote:
>> I want to add two sql queries in one xql file and having some trouble.
>
> In this particular case, using only one connection is more appropriate,
> because related SQL transactions must be sequenced in single session (or
> surely committed).
>
> In general, ConcurrentModificationException exception is known [1] issue
> on both of 1.4.x and 1.5 lines currently, which occurs *after* the
> execution of the xquery with more than one sql connections opened.
>
> Best Regards,
> Anton
>
> [1] http://exist.markmail.org/message/yscajnnofuaseir2
>
> declare variable $connection := sql:get-connection($driver, $db, $user,
> $password);
>
> <all>
>  <delete>{
>     sql:execute($connection, $mods-delete-sql, fn:false())
>  }</delete>
>  <insert>{
>     for $mods in collection('/db/myfile’)//mods:mods
>         let $mods-insert-sql := local:generate-sql-insert($mods)
>             return sql:execute($connection, $mods-insert-sql, fn:false())
>  }</insert>
> </all>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> Exist-open mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-open
>



-- 
Adam Retter

eXist Developer
{ United Kingdom }
ad...@ex...
irc://irc.freenode.net/existdb