Hi Jason,
It does the update/delete operation but it also throws an exception (17090
operation not allowed).
I tried with standalone program and it is not throwing any exception (with same
jar).
Thanks
-Chetan
From: [email protected]
Subject: Re: [MarkLogic Dev General] MLSQL update/delete operation
Date: Mon, 22 Feb 2010 09:13:08 -0800
To: [email protected]
Maybe this explains it?
http://forum.springsource.org/showthread.php?p=283913
-jh-
On Feb 22, 2010, at 8:55 AM, Chetan Patel wrote:
Hello,
I am getting following error when I try update or delete operation (oracle 10
database) using MLSQL (insert and select works fine). Does anyone know how to
solve this problem?
import module namespace sql = "http://xqdev.com/sql"; at "sql.xqy"
sql:executeUpdate("update test set title =
'xxxxx'","http://localhost:8080/mlsql/mlsql";, ())
<sql:result xmlns:sql="http://xqdev.com/sql";>
<sql:meta>
<sql:rows-affected>1</sql:rows-affected>
<sql:exceptions>
<sql:exception type="java.sql.SQLException">
<sql:reason>operation not allowed</sql:reason>
<sql:sql-state />
<sql:vendor-code>17090</sql:vendor-code>
</sql:exception>
</sql:exceptions>
</sql:meta>
</sql:result>
Thanks
-Chetan Patel
Elsevier
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up
now._______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/201469229/direct/01/_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
