I have been asked some questions from potential customers concerning the use of
H2 together in connection with OOBase
and I can`t find any answers in the documentation for H2 or in this forum. My
knowledge in database technicalities is not so deep so
I hope somebody can help me and I have to be absolutely sure:
1) In the H2 Tutorial it is said that to run this database, a Java Runtime
Environment version 1.5 or higher is required.
From an environment with MAX OS X I was asked what happens when JRE 1.7 and
the planned 2.0 enters the market?
In OOBase you can decide what version of JRE you want to use. Can you do
the same in H2 and if so how?
Will H2 be prepared for any future versions?
2) Concerning Backups: In H2 there are several possibillities to do backups and
it seems claer that H2 offers something not possible
in many other softwares: backup while running using the SCRIPT command. Is
this a safe technique?
Can it be used for incremental backups?
The tutorial say: This can be done using the Script tool:
java org.h2.tools.Script -url jdbc:h2:~/test -user sa
-script test.zip -options compression zip
I don`t understand how and where and how to use this type of command. (I
know i lack some basics - but I am eager to leran)
I need some tool I guess - but which?
It is also possible to use the SQL command SCRIPT to create the backup of the
database.
I guess this should be used directly in H2 SQL-window.
SCRIPT CSIMPLE ] [ NODATA ] [ NOPASSWORDS ] [ NOSETTINGS ]
[ DROP ] [ BLOCKSIZE blockSizeInt ]
[ TO fileNameString [ COMPRESSION { DEFLATE | LZF | ZIP | GZIP } ]
[ CIPHER cipher PASSWORD string ] ]
[ CHARSET charsetString ]
There is an example "SCRIPT NODATA". What happens when this command is
performed? Is that enough?
I would like to use this possibillity with a new backup every night performed
automatically.
What way to choose and how to write?
3) When you use the H2 commandline it starts a Mozilla Firefox. Is it the
installed version of MF that is opened or someone else?
4) I also need to ask about some fundamentals: It seems that I don`t have to
start H2 using H2 conmmand line to run a file.
It seems to be connected anyway. Correct?
If I make a copy of a OOBasefile with the same source (jdbc:h2:~/mydb1) and
perform changes in tables in one file also
creates changes in the other one. If you only change queies and reportsare
will that also change the other file?
If I want to use a copy for other purposes do I have to build a new database
(jdbc:h2:~/mydb2) and the migrate tables and queries i ´want use?
Sorry - many questions but easy to answer I hope. Thanks in advance if someone
can help me.
________________________________________________________
Riccard
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
