Re: [basex-talk] [FORG0006] Unknown method:
Hi Erol (cc to the list),
That solved the issue! Thanks for your help
I like to know what is difference between xs:int and xs:integer ?
Values of type xs:integer may be bigger than Java integers. You'll need BigInteger to accept these values in a Java function. Hope this helps, Christian
Christian, That unknown method has gone, thanks for your help. Now, I am getting this error after I called multiple sql:execute-prepared calls [BXSQ0001] An SQL exception occurred: 'ORA-01000: maximum open cursors exceeded This error is called when we have exceed certain number of cursors in DB
A JDBC *ResultSet* is supported by a single *cursor* on the database. When close() is called on the ResultSet, the cursor is released.
When basex made call for sql:execute-prepared, does it close statement and resultset? Erol Akarsu On Wed, May 28, 2014 at 4:14 AM, Christian Grün <christian.gruen@gmail.com>wrote:
Hi Erol (cc to the list),
That solved the issue! Thanks for your help
I like to know what is difference between xs:int and xs:integer ?
Values of type xs:integer may be bigger than Java integers. You'll need BigInteger to accept these values in a Java function.
Hope this helps, Christian
[BXSQ0001] An SQL exception occurred: 'ORA-01000: maximum open cursors exceeded
Did you close your prepared statements via sql:close [1]? Best, Christian [1] http://docs.basex.org/wiki/SQL_Module#sql:close
Christian, I have to make multiple calls to prepared statement so that it is convenient to close SQL connection with sql:close every time an statement is executed sql:close is for connection to SQL server but prepared statement? On Wed, May 28, 2014 at 3:47 PM, Christian Grün <christian.gruen@gmail.com>wrote:
[BXSQ0001] An SQL exception occurred: 'ORA-01000: maximum open cursors exceeded
Did you close your prepared statements via sql:close [1]?
Best, Christian
Christian, I tried to close prepared statement and got this exception: [BXSQ0002] No opened connection with id 1 It throws exception at line let $clres := sql:close($prep) let $prep := sql:prepare($conn,$sqlStmt) let $params := <sql:parameters> <sql:parameter type='string'>{$useType}</sql:parameter> </sql:parameters> let $result := sql:execute-prepared($prep, $params) let $clres := sql:close($prep) On Wed, May 28, 2014 at 3:51 PM, Christian Grün <christian.gruen@gmail.com> wrote:
sql:close is for connection to SQL server but prepared statement?
If I remember right, it's for both. Did you have a try?
Thanks Erol, I had time to revise the code. Please check out the latest snapshot [1], in which prepared statements can now be closed, too. Christian [1] http://files.basex.org/releases/latest/ On Thu, May 29, 2014 at 3:03 PM, Erol Akarsu <eakarsu@gmail.com> wrote:
Christian,
I tried to close prepared statement and got this exception:
[BXSQ0002] No opened connection with id 1
It throws exception at line
let $clres := sql:close($prep)
let $prep := sql:prepare($conn,$sqlStmt) let $params := <sql:parameters> <sql:parameter type='string'>{$useType}</sql:parameter> </sql:parameters> let $result := sql:execute-prepared($prep, $params) let $clres := sql:close($prep)
On Wed, May 28, 2014 at 3:51 PM, Christian Grün <christian.gruen@gmail.com> wrote:
sql:close is for connection to SQL server but prepared statement?
If I remember right, it's for both. Did you have a try?
participants (2)
-
Christian Grün -
Erol Akarsu