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: [email protected]
> [mailto:[email protected]] 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:ad...@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 <[email protected]>
> Sent by: [email protected]
>
> 05/05/2009 06:03 PM
> Please respond to
> General Mark Logic Developer Discussion
> <[email protected]>
>
> To
> General Mark Logic Developer Discussion
> <[email protected]>
> 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: [email protected]
> > [mailto:[email protected]
> <mailto:[email protected]> ] 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
> [email protected]
> 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
[email protected]
http://xqzone.com/mailman/listinfo/general