Hi,
Like most settings, you can add it to the database URL:
;LOCK_TIMEOUT=1. to find out which connection is holding the lock,
see INFORMATION_SCHEMA.LOCKS.
Regards,
Thomas
On Wednesday, August 4, 2010, Rami Ojares rami.oja...@gmail.com wrote:
Hi,
Is there any way to define a default
I need to get the primary key for the affected row after performing a
MERGE statement, regardless of whether the row got inserted or
updated. Is there a standard way to do that? Using the generated key
from the statement was my first idea, but it doesn't work quite that
way:
To answer the second part of your question, IDENTITY columns do default to
start at 1 and increment by 1.
I notice that it doesn't seem to be documented anywhere, but you actually
define the start and increment values when you define the IDENTITY column,
like this:
create table blah(id
Hi,
never mind would be just a great feature for me. Is this on some todo
list on the near future? But no hurry I just want to know. Btw thanks
for your always fast replies. :)
The stack trace looks like this:
WITH TLink(sub, super) AS (
SELECT sub, super
FROM subClass
On Thu, Aug 5, 2010 at 06:51, Joe joe.w...@gmail.com wrote:
Couple of thoughts:
1) The JDBCConnectionPool setLoginTimeout method says the default
timeout is 5 minutes. However, the default is actually set to '30' in
the code. That appears that is supposed to be '30' seconds.
The default
Hi
I am doing a Mac OS X widget.
Somehow I want this Widget to be able to access data in a H2 database.
I want to be able to get data from
the database and also insert new data to the database. A widget in OS
X is written in html and javascript.
What is the best option to get this to work?
Hello. I'm a spanish developer with a serious problem ( at least for
me :-D ).
How can this sentence work in h2 database?
SELECT *
FROM Customers
WHERE Name LIKE '[aeiou]%'
What i mean i that i can't do this with h2database. I want to show all
customers beginning their names with a vowel.
In
Hi,
thanks for the support, in the meantime I have upgraded the oracle
driver (table linked is a oracle table) and it seems to improve the
situation..
It seems from the trace that that the where clause seems to be missing
for the linked
table under some circumstances When I got more details
I think you want to use REGEXP rather than LIKE:
create table blah(name varchar(10));
insert into blah (name) values ('adam');
insert into blah(name) values ('bill');
insert into blah(name) values('erin');
select * from blah where name regexp '^[aeiou]';
I don't know why LIKE doesn't work
On Aug 2, 2:31 pm, Thomas Mueller thomas.tom.muel...@gmail.com
wrote:
You have a serious complexity problem here.
No I don't ;)
These are aggregating reports that do some pretty nifty aggregation
calculation on a daily basis. And in order to re-use the intermediate
results CTEs are very
10 matches
Mail list logo
