[MarkLogic Dev General] How to
do Transaction Management inMarklogic - reg.,
Santhosh Raj
santhosh.raj at tcs.com
Thu May 7 21:35:01 PDT 2009
Danny,
Thanks for your reply.,
The xcc API has these methods for transaction management, but it is of now
use.,
May be Marklogic will support Multi-request transaction management in
future release. (It is the basic criteria of any database. )
Thanks & Regards,
Santhosh Rajasekaran
Tata Consultancy Services
Mailto: santhosh.raj at tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
Danny Sokolsky <Danny.Sokolsky at marklogic.com>
Sent by: general-bounces at developer.marklogic.com
05/07/2009 09:36 PM
Please respond to
General Mark Logic Developer Discussion <general at developer.marklogic.com>
To
General Mark Logic Developer Discussion <general at developer.marklogic.com>
cc
Subject
RE: [MarkLogic Dev General] How to do Transaction Management
inMarklogic - reg.,
No, there is no way to change it.
From: general-bounces at developer.marklogic.com [
mailto:general-bounces at developer.marklogic.com] On Behalf Of Santhosh Raj
Sent: Thursday, May 07, 2009 4:32 AM
To: General Mark Logic Developer Discussion
Subject: RE: [MarkLogic Dev General] How to do Transaction Management
inMarklogic - reg.,
Hi Danny,
As you said getAutoCommit() is always true, so the commit() call is a
no-op.
Is there any option to change AutoCommit value?
I tried to call the setAutoCommit(false) - But this function is
implemented in such a way that it throws UnSupportedException.
Is there any way to change it.,
Regards,
Santhosh
Danny Sokolsky <Danny.Sokolsky at marklogic.com>
Sent by: general-bounces at developer.marklogic.com
05/06/2009 12:18 AM
Please respond to
General Mark Logic Developer Discussion <general at developer.marklogic.com>
To
General Mark Logic Developer Discussion <general at developer.marklogic.com>
cc
Subject
RE: [MarkLogic Dev General] How to do Transaction Management
inMarklogic - reg.,
You cannot manage transaction in XCC per se. Use MarkLogic Server to
manage transactions by pushing them down to the server, as in Geert's
example. Each request to MarkLogic Server is a transaction, and will
follow the transactional rules of MarkLogic (see the "Understanding
Transactions" chapter in the Developer's Guide for some background). In
the XCC example below, there are two transactions: the
ContentFactory.newContent is one transaction, and the
session.newAdhocQuery is another.
The commit() call in your java code does not do what you think it does. In
MarkLogic Server, getAutoCommit() is always true, so the commit() call is
a no-op.
If you want to manage those as a single transaction, you have the
following choices:
1) write java code to manage the transactions in your application
(note--this might be hard)
2) push down the logic to XQuery and run it as a single transaction.
To expand on Geert's XQuery example, consider the following XQuery:
xdmp:node-replace(doc("/doc1.xml")/a/b, <b>goodbye</b>),
fn:error("woops")
In this case, the node replace will not happen, because an exception was
thrown. That exception simulates what would happen if a different update
(to doc2 for example) throws an exception.
Hope that helps.
-Danny
-----Original Message-----
From: general-bounces at developer.marklogic.com [
mailto:general-bounces at developer.marklogic.com] On Behalf Of Geert Josten
Sent: Tuesday, May 05, 2009 7:36 AM
To: General Mark Logic Developer Discussion
Subject: RE: [MarkLogic Dev General] How to do Transaction Management
inMarklogic - reg.,
Hi Santhosh,
I am not very familiar with the XCC api itself, but I was told that there
should be options to explicitly manage transactions. Perhaps there is XCC
documentation on this matter? (Someone out there that could give a
pointer?)
But my other approach is usefull here as well, I think. You are performing
two separate function calls on the session object to perform different
actions, but it should be possible to combine those in a single adhoc
query call. You can use xdmp:filesystem-file to retrieve a document from
file-system, so you won't need to use the 'insertContent' call. Try doing
something like:
session.newAdhocQuery("
xdmp:document-insert(\"transaction1.xml\",
xdmp:unquote(xdmp:filesystem-file(\"C:\\MarkLogic\\abc.xml\"))),
xdmp:document-insert(\"111.xml\", \"<a1> abc 111</a1>\")
");
Xdmp:filesystem-file returns a string, so you will need xdmp:unquote to
parse that to XML nodes.
Kind regards,
Geert
> -----Original Message-----
> From: general-bounces at developer.marklogic.com
> [mailto:general-bounces at developer.marklogic.com] On Behalf Of
> Santhosh Raj
> Sent: dinsdag 5 mei 2009 15:41
> To: General Mark Logic Developer Discussion
> Subject: RE: [MarkLogic Dev General] How to do Transaction
> Management inMarklogic - reg.,
>
>
> Hi Geert,
>
> URI uri = new URI
> ("xcc://admin:admin@localhost:9000/training");
> ContentSource contentSource;
> contentSource =
> ContentSourceFactory.newContentSource(uri);
> session = contentSource.newSession();
>
> session = contentSource.newSession();
>
> File file = new
> File("C:\\MarkLogic\\abc.xml");
> InputStream is = new FileInputStream(file);
> ContentCreateOptions createOptions =
> new ContentCreateOptions();
> createOptions.setFormatBinary();
> Content content =
> ContentFactory.newContent("transaction1.xml", is, createOptions);
> session.insertContent(content);
> System.out.println(" Document Inserted:" );
>
> Request request =
> session.newAdhocQuery("xdmp:document-insert(\"111.xml\"
> ,\"<a1> abc 111</a1>\") );
>
> ResultSequence rs =
> session.submitRequest(request);
> session.commit();
>
>
> In this example I want to execute 2 request in the same
> transation, But it is not possible.
>
> 1) we can't do session.setAutoCommit(false) - This will
> throw unsupported exception.
>
> 2) Here eventhough if there is error in the second request
>
> Request request =
> session.newAdhocQuery("xdmp:document-insert(\"111.xml\"
> ,\"<a1> abc 111</a1>\") );
>
> It still create the transaction1.xml in the marklogic
> server. But acutally i do not what that to be created if any
> one request fails. I guess there is no option to propagate
> the transaction to both request. What is your idea?
>
> Thanks and Regards,
> Santhosh Rajasekaran
>
>
>
> Geert Josten <Geert.Josten at daidalos.nl>
> Sent by: general-bounces at developer.marklogic.com
>
> 05/05/2009 06:03 PM
> Please respond to
> General Mark Logic Developer Discussion
> <general at developer.marklogic.com>
>
> To
> General Mark Logic Developer Discussion
> <general at developer.marklogic.com>
> cc
> Subject
> RE: [MarkLogic Dev General] How to do Transaction Management
> inMarklogic - reg.,
>
>
>
>
>
>
> Hi Santhosh,
>
> There should be explicit transaction management functions in
> the XCC library, but that requires a connection from Java or .Net.
>
> You can also put the update statements in one Xquery and call
> the Xquery through HTTP (or from XCC for the same matter).
> Statements in one Xquery file are typically executed as one
> transaction, and rolled back all together if any exception occurs.
>
> (This, unless you explicitly use a semi-colon in the Xquery
> main body. That ends the transaction for the first part of
> the Xquery body, and opens a new one.)
>
> Kind regards,
> Geert
>
> >
>
>
> Drs. G.P.H. Josten
> Consultant
>
>
> http://www.daidalos.nl/ <http://www.daidalos.nl/>
> Daidalos BV
> Source of Innovation
> Hoekeindsehof 1-4
> 2665 JZ Bleiswijk
> Tel.: +31 (0) 10 850 1200
> Fax: +31 (0) 10 850 1199
> http://www.daidalos.nl/ <http://www.daidalos.nl/>
> KvK 27164984
> De informatie - verzonden in of met dit emailbericht - is
> afkomstig van Daidalos BV en is uitsluitend bestemd voor de
> geadresseerde. Indien u dit bericht onbedoeld hebt ontvangen,
> verzoeken wij u het te verwijderen. Aan dit bericht kunnen
> geen rechten worden ontleend.
>
>
> > From: general-bounces at developer.marklogic.com
> > [mailto:general-bounces at developer.marklogic.com
> <mailto:general-bounces at developer.marklogic.com> ] On Behalf Of
> > Santhosh Raj
> > Sent: dinsdag 5 mei 2009 14:22
> > To: General Mark Logic Developer Discussion
> > Subject: [MarkLogic Dev General] How to do Transaction
> > Management in Marklogic - reg.,
> >
> >
> > Hi all,
> >
> > Suppose I have 2 xml documents (doc1.xml , doc2.xml
> > ), I have to insert nodes to both documents.
> >
> > If i have inserted successfully in doc1.xml and if any error
> > occurs while inserting to doc2.xml, then i have to rollback
> > the node inserted in the doc1.xml
> >
> > How to manage it?
> >
> > Thnaks and Regards,
> > Santhosh Rajasekaran
> >
> > =====-----=====-----=====
> > Notice: The information contained in this e-mail message
> > and/or attachments to it may contain confidential or
> > privileged information. If you are not the intended
> > recipient, any dissemination, use, review, distribution,
> > printing or copying of the information contained in this
> > e-mail message and/or attachments to it are strictly
> > prohibited. If you have received this communication in error,
> > please notify us by reply e-mail or telephone and immediately
> > and permanently delete the message and any attachments. Thank you
> >
> >
> >
>
> _______________________________________________
> General mailing list
> General at developer.marklogic.com
> http://xqzone.com/mailman/listinfo/general
> <http://xqzone.com/mailman/listinfo/general>
>
> ForwardSourceID:NT0000AE12
>
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>
> _______________________________________________
General mailing list
General at developer.marklogic.com
http://xqzone.com/mailman/listinfo/general
_______________________________________________
General mailing list
General at developer.marklogic.com
http://xqzone.com/mailman/listinfo/general
ForwardSourceID:NT00002436
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
_______________________________________________
General mailing list
General at developer.marklogic.com
http://xqzone.com/mailman/listinfo/general
ForwardSourceID:NT0000AF72
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://xqzone.marklogic.com/pipermail/general/attachments/20090508/4b57a8cc/attachment-0001.html
More information about the General
mailing list