Hi Thomas,
On Apr 28, 4:44 pm, Thomas Mueller
wrote:
> Are SQL states really standardized to the last digit? When searching
> for "sqlstate23503" in Google, I find IBM DB2 documentation, but no
> link to any standard.
I managed to get my hands on the SQL:2008 draft. I finally have a
conclusive a
Hi Thomas,
I'm looking at the v1.2.147 code, sorry I can't get the latest version
yet.
I think the problem is in
AlterTableAlterColumn#cloneTableStructure(...){
:
:
for (String sql : triggers) {
execute(sql, true);
}
return newTable;
}
If you c
Hi,
In my application, it create databases for users on demand and each
user can have multiple databases.
eg:
jdbc:h2:mem:/
After understanding the behaviour of H2 Database, there's no reason,
why I can't implement it as jdbc:h2:mem:-
Thanks for your help.
Anthony
On May 13, 5:32 am, Thomas
Hi,
> But don't you think the statement below should show columns from s1.t1
> by default instead of public.t1?
According to my test it does work in the newest version. Please tell
me if it doesn't.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H
Hi,
1. General database error (unrecoverable). Perhaps "retry later" when
> service is back up.
> 2. Client violated integrity constraints (attempted to insert an Employee
> with an invalid Company id)
>
The first two characters of the SQL state should work in this case.
Recoverable are:
- Class
Hi,
> Hi, I'm using H2 as a local database system for development.
> I looking for the best performance and resource efficiency settings,
> memory is not a problem and I would gladly change anything to get the
> fastest response time it can offer.
Most of this is documented here:
http://h2databas
Hi,
Thanks! I can now reproduce the problem. Yes, it's a bug, and it will
be fixed in the next release. The URL will be an embedded URL, not a
remote URL (so it will be jdbc:h2:mem:test in your example).
Regards,
Thomas
--
You received this message because you are subscribed to the Google Group
Hi,
Currently, "alter table drop column" is implemented as:
- create a new table (with the name TEMP_TABLE_...)
- copy the data
- rename the old table
- rename the temp table
- drop the old table
The new table is created with a temporary name because at any time,
only one table with a given name
Hi,
I understand. Unfortunately, there is currently no way to get the unique
name from the database, except if you use unique database names such as:
jdbc:h2:mem:abc -> catalog name=abc
jdbc:h2:mem:xyz -> catalog name=xyz
Is there a reason why you need to use mem:abc/test instead of mem:abc or
m
And it works with PostgreSQL and Oracle.
On 5月12日, 午後8:25, HK wrote:
> Hello,
>
> > Why do you have all of those "on 1=1" statements?
>
> My SQL is this.
>
> from
> (
> TEST_GROUP_CLASS GC
> left join TEST_GROUPM GI1 on GC.GCL_SID1 = GI1.GRP_SID)
> left join TEST_GROUPM GI2
Hello,
> Why do you have all of those "on 1=1" statements?
My SQL is this.
from
(
TEST_GROUP_CLASS GC
left join TEST_GROUPM GI1 on GC.GCL_SID1 = GI1.GRP_SID)
left join TEST_GROUPM GI2 on GC.GCL_SID2 = GI2.GRP_SID)
left join TEST_GROUPM GI3 on GC.GCL_SID3 = GI3.GRP_SID)
Why do you have all of those "on 1=1" statements?
That's not valid SQL.
HK wrote:
> Hello,
>
>
> I'll write an error message.
>
> Exception in thread "main" org.h2.jdbc.JdbcSQLException: Syntax error
> in SQL statement "SELECT
> GC.GCL_SID1 AS GCL_SID1,
> GC.GCL_SID2 AS GCL_SID2,
> GC
Hello,
I'll write an error message.
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Syntax error
in SQL statement "SELECT
GC.GCL_SID1 AS GCL_SID1,
GC.GCL_SID2 AS GCL_SID2,
GC.GCL_SID3 AS GCL_SID3,
GC.GCL_SID4 AS GCL_SID4,
GC.GCL_SID5 AS GCL_SID5,
GI1.GRP_NAME AS
I don't think Thomas has been tagging releases, he just creates a build from
trunk.
But when you download H2, it always includes the source code for that release.
Jason Tesser wrote:
> I am checking here
> http://code.google.com/p/h2database/source/browse/#svn%2Ftags
> but the tags seem to ens
Each connection will take up a certain amount of memory, but memory is cheap
these days.
If you are using a connection pool inside your application to connect to the
server, then setting the number of
connections to anything above (2 * no_cores on server) is probably going to be
counter-product
what error message are you getting?
HK wrote:
> Hello,
>
> I was using the h2 1.2, an update to 1.3.
>
> 1.2 worked fine in SQL there.
> But an error in 1.3.
>
>
> create table TEST_GROUP_CLASS
> (
> GCL_SID1integer not null,
> GCL_SID2integer not null,
>
16 matches
Mail list logo
