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.comwrote:
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
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.comwrote:
[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?
basex-talk@mailman.uni-konstanz.de
-
Christian Grün -
Erol Akarsu