Derby Lock Escalation: Deadlocks

2013-08-07 Thread Jasmeet Bhatia (jasmbhat)
I am troubleshooting a derby deadlock and need help. (setup - -Derby 10.7.1 + in-memory DB + Hibernate 3.6.9 + spring 3.0.3) Inside a transaction, I execute delete on a specific instance of an entity that has a 1-* relationship with another entity. This results in an update SQL that tries to b

Re: Cursor as out parameter in stored function

2013-08-07 Thread Rick Hillegas
On 8/7/13 6:37 AM, Vargan wrote: Hi folks, I'm using Derby as in-memory database for unit-testing. There's a way to define a stored procedure as a CURSOR as out parameter? if yes, how? I tried in many ways, but I got always exceptions. Thanks! Hi Samuele, If what you're trying to do is return

Cursor as out parameter in stored function

2013-08-07 Thread Vargan
Hi folks, I'm using Derby as in-memory database for unit-testing. There's a way to define a stored procedure as a CURSOR as out parameter? if yes, how? I tried in many ways, but I got always exceptions. Thanks! -- View this message in context: http://apache-database.10148.n7.nabble.com/Curso