Thanks for the reply. As I was following simple instructions and getting
errors from the tests I was begining to feel that I was doing something
stupid :)
Roger
On Tuesday, April 1, 2014 6:48:13 AM UTC+1, Thomas Mueller wrote:
>
> Hi,
>
> Sorry, that was my mistake, I added a feature and (parti
Hello,
Actually the regular JdbcRowSet, essentially a connected result set, seems to
work fine. The CachedRowSet also works fine for a query, but when a
acceptChange()
is applied back to the database table the following error occurs.
SQLException: Column "NAME" not found; SQL statement:
INSERT IN
Hi,
we have a java application with embedded h2 and hibernate and use for the
fileencryption and db password ONE password which we hash and take the
first part as fileencryption-password and the last part as db-password.
But now the problem is that we want to offer the user to change the
passwo
Hello,
In the following test case, col2 is a computed column depending on col1. I
try to drop col1, which is obviously a bad idea:
CREATE TABLE test(col1 INT);
INSERT INTO test VALUES (1);
ALTER TABLE test ADD COLUMN col2 INT AS col1*2;
ALTER TABLE test DROP COLUMN COL1;
The error message doesn
Hi,
> We close the database with the Close method of theEntityManagerFactory,
but the h2 database file is still locked.
Well, it looks like the database is not closed then.
You could execute the command "shutdown":
http://h2database.com/html/grammar.html#shutdown
Regards,
Thomas
On Tue, Apr
Hi all, I'm sure I'm overlooking something simple. Here's the situation:
I'm connecting to an embedded h2 file database using a connection string
like this:
jdbc:h2:file:db/mydb
This code is a snippet from a class called LinkDao.update() method. It uses
spring JdbcDaoSupport (and JdbcTem
Hi,
Try using an absolute path in the database URL:
jdbc:h2:file:/data/db/mydb
or a path relative to the current user home directory:
jdbc:h2:file:~/db/mydb
Regards,
Thomas
On Tuesday, April 1, 2014, wrote:
> Hi all, I'm sure I'm overlooking something simple. Here's the situation:
>
Hi,
Some identifiers are quoted (surrounded with double quotes) and others are
not. Depending on how the table was created, that's wrong. I would try:
INSERT INTO KEY_TABLES.PUBLIC."key_table5" ("name", "color", "price")
VALUES (?, ?, ?)
I would consistently _not_ use double quotes, but then