When using the OTHER data type (serialized Java objects), do
expressions (i.e. NAME='Hi') compare simply the serialized byte array
(for exact equivalence), or is the (deserialized) object's equals
method used? If equals is not currently used, could it be added as
feature request?
Thanks,
Joonas
Hi,
is there a way to restrict the number of different connections to a
tcp server, or to prevent to login with the same username and password
from different IPs?
Bye,
Michael
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this
I feel that Dario already answered this partially but I still feel
obligated to answer this myself.
DATE and TIME types have nothing to do with timezones.
Well, currently they do. See also ResultSet.getDate and getTime(...,
Calendar cal).
I think you are mixing here the database
Did god help you?
- Rami
uugaa wrote:
Help me help me pls
multi connection
Server app it's true
server_url=jdbc:h2:file:./server_storage/acmdb;IFEXISTS=TRUE
server_user=root
server_password=root
server_driver=org.h2.Driver
Cleant app: error
While I am sympathetic to your cause I am not very happy about the OTHER
type.
Why?
Well, what happens when an other language accesses a column like that.
That issue is already concrete when using the ODBC connectivity from
let's say php.
Also there is an other type in jdbc spec called
Hi,
Since it is a java system property it will affect all new databases in
current jvm. Not sure about existing ones.
This setting does not affect the database file, therefore it's save to
use it with existing databases.
Regards,
Thomas
--
You received this message because you are
Hi,
# Application parameters. Add parameters as needed starting from 1
wrapper.app.parameter.1=org.h2.tools.Server
wrapper.app.parameter.2=-tcp
wrapper.app.parameter.3=-web
wrapper.app.parameter.4=-tcpPort 9090
I didn't know you can add two parameters in one line. I would use:
Hi,
50 minutes are needed to open the connection after an unexpected VM
shutdown with MVCC=TRUE, 30 seconds without this parameter.
The next version of H2 will not use MVCC when recovering, so it will
no longer take 50 minutes. However, it would be still good to know why
it takes so long.
Hi,
If you have a read-only database, you could use Read Only Databases
in Zip or Jar File to get a better compression ratio:
http://h2database.com/html/features.html#database_in_zip - but if you
compress the whole file / database, you can't do random access any
longer. That means reading from
Hi,
Yes, I can't reproduce the problem. Could you provide a reproducible
test case? From what you wrote, I created the following script. I had
to change quite a lot to make it actually work:
drop all objects;
create table some_table(id int primary key, some_id int, another_id int);
insert into
Is it presumptuous to assume that God uses H2?
uugaa: I think we need more information.
On Thu, Oct 14, 2010 at 4:35 AM, Rami rami.oja...@gmail.com wrote:
Did god help you?
- Rami
uugaa wrote:
Help me help me pls
multi connection
Server app it's true
Hi,
I noticed a difference between PG and H2 in the following:
select CAST('0100' AS bigint);
PG - 100
H2 - 64
H2 does document that char strings with leading zero are consider to be
octal; however:
-it is inconsistent with PG (which is technically correct I don't know; but
I prefer
I do realize that:
- OTHER type is language specific.
- Comparing them (with equals or compareTo) would require
deserializing each single row, which would be orders of magnitude
slower than comparing primitive types.
- Deserializing at the server side is as security hazard.
- Therefore, in
13 matches
Mail list logo
