Hi all,
We've seen a problem today where we have several threads querying our
database and when one gets interrupted the others are stuck waiting for a
lock. Here is the stack trace for the stuck thread(s):
daemon prio=4
DefaultExecutorService-pool-1-thread-47 Id=98 WAITING on
On 21.06.10 09:20, Luke Quinane wrote:
Hi all,
We've seen a problem today where we have several threads querying our
database and when one gets interrupted the others are stuck waiting
for a lock. Here is the stack trace for the stuck thread(s):
daemon prio=4
Hello,
Derby version = db-derby-10.5.1.1
I need to pick up the value of myTable.size as soon as the record is inserted
and need to update the targetable.size column
Where myTable .myTableID = targetable.MyTableID using a Trigger.
Please help me out on this.
CREATE TABLE myTable
I can't get a procedure to execute. It's in the database, and the code is in
the classpath. But it doesn't get called. I'm probably overlooking something
simple. I'm using Spring/Hibernate/Atomikos in a Java console app; Derby is an
embedded database used in file mode as a temp database for the
One issue is that the method has to be static, but making it static didn't
change the behavior.
-Original Message-
From: Clark, Harry
Sent: Mon 6/21/2010 12:27 PM
To: derby-user@db.apache.org
Cc:
Subject:Procedure issue
I can't get a procedure to execute. It's in
Actually it did change the behavior, .class and source were out of synch. I
also had to put the bean for the procedure before the derby initializer bean in
the Spring config so the app context is set before the temp db is intialized
and the proc called. There are still problems with executing
Clark, Harry harry.cl...@knovalent.com writes:
create procedure createTempSchema (in schemaName char(254))
language java parameter style java modifies sql data
external name
'com.kve.vanguard.model.orm.dao.TempSchemaGenerator.createTempSchema';
:
call app.createTempSchema('temp00');