[h2] Re: Where the heck is my database????

[Thotheolh]

I have created a tool called 'localdb' specifically for handling such a 
case a few years back (and should still be compatible with current H2 
versions since no protocol changes were made for the filesystem jdbc 
access).

Link: https://code.google.com/p/localdb

The wiki page contains the how-to information.

There was a previous case in the h2-database Google Group in the year of 
2011 which you could refer at:
https://groups.google.com/forum/#!topic/h2-database/eoId0GtOgUo

On Monday, February 10, 2014 3:41:09 PM UTC, Alejandro Villamarin wrote:
>
> Hi everyone,
>
> I'm running into a very strange issue, but I'm not sure if it is because 
> of me or because I'm doing something wrong. Let me depict my scenario.
>
> I'm trying to use H2 to embed a database in a Java app. If the db does not 
> exist, should be newly created and saved to disk (file) once the app 
> finishes. 
>
> That said, and regarding the documentation:
>
> Creating New Databases 
>
> By default, if the database specified in the URL does not yet exist, a new 
> (empty) database is created automatically. The user that created the 
> database automatically becomes the administrator of this database. 
>
> Auto-creating new database can be disabled, see Opening a Database Only 
> if it Already 
> Exists. 
>
>
> First thing weird enough is that a new database is not created 
> automaticallyat least not in the filesystem, maybe this is done 
> in-memory ( not sure, is not specified in the docs). This leads me to 
> my other question, where does H2 stores the data once finished? I can't see 
> it anywhere in my filesystem.
>
>
> Here is my code that "creates" the db:
>
> try {
> spath = "jdbc:h2:file:data/sample";
> conn = DriverManager.getConnection(spath, "john", "doe");
>
> } 
> catch (Exception e) {
> System.out.println(e.getMessage());
> }
>
> If right after executing this I look at my relative path + /datathere 
> is nothing...funny thing is that if I execute this right after:
>
> try {
> Statement stat = conn.createStatement();
>  
> //create table
> stat.execute("CREATE TABLE ACTIVITY (ID INTEGER, STARTTIME 
> datetime, ENDTIME datetime,  ACTIVITY_NAME VARCHAR(200),  PRIMARY KEY 
> (ID))");
> 
> //prepared statement
> PreparedStatement prep = conn.prepareStatement("INSERT INTO 
> ACTIVITY (ID, STARTTIME, ENDTIME, ACTIVITY_NAME) VALUES (?,?,?,?)");
> 
> //insert 10 row data
> for (int i = 0; i<10; i++){
> prep.setLong(1, i);
> prep.setTimestamp(2, new 
> Timestamp(System.currentTimeMillis()));
> prep.setTimestamp(3, new 
> Timestamp(System.currentTimeMillis()));
> prep.setString(4, "Activity-" + i);
> 
> //batch insert
> prep.addBatch();
> }
> conn.setAutoCommit(false);
> prep.executeBatch();
> conn.setAutoCommit(true);
> 
> 
> 
> 
> ResultSet rs = stat.executeQuery("Select STARTTIME, ENDTIME, 
> ACTIVITY_NAME from ACTIVITY");
> while (rs.next()) {
> 
> Date start = rs.getTimestamp(1);
> Date end = rs.getTimestamp(2);
> String activityName = rs.getString(3);
> 
> //print query result to console
> System.out.println("activity: " + activityName);
> System.out.println("start: " + start);
> System.out.println("end: " + end);
> System.out.println("--");
> }
> rs.close();
> //close connection
> conn.close();
> } 
> catch (SQLException e) {
> e.printStackTrace();
> }
>
> I get this output:
>
>
> activity: Activity-0
> start: 2014-02-10 15:27:07.414
> end: 2014-02-10 15:27:07.418
> --
> activity: Activity-1
> start: 2014-02-10 15:27:07.418
> end: 2014-02-10 15:27:07.418
> --
> activity: Activity-2
> start: 2014-02-10 15:27:07.418
> end: 2014-02-10 15:27:07.418
> --
> activity: Activity-3
> start: 2014-02-10 15:27:07.418
> end: 2014-02-10 15:27:07.418
> --
> activity: Activity-4
> start: 2014-02-10 15:27:07.418
> end: 2014-02-10 15:27:07.418
> --
> activity: Activity-5
> start: 2014-02-10 15:27:07.418
> end: 2014-02-10 15:27:07.418
> --
> activity: Activity-6
> start: 2014-02-10 15:27:07.418
> end: 2014-02-10 15:27:07.418
> --
> activity: Activity-7
> start: 2014-02-10 15:27:07.418
> end: 2014-02-10 15:27:07.418
> --
> activity: Activity-8
> start: 2014-02-10 15:27

[h2] Feature Request: Transparent Password Security

[Thotheolh]

*Summary:* 
A new feature request to make password authentication and security easy for 
non-security savvy users in the light of poor password security in 
production environments.

*Feature:*

   1. Introduce a new SQL function called authenticate(,) to authenticate a particular field.
   2. Introduce a new SQL data type called Password which will take in 
   plaintext password inputs and perform secure PBKDF2/BCRYPT/SCRYPT functions 
   on the input to be later retrieved.


*Description:*The H2 database should support a new data type called 
Password which would automatically take parsed plaintext input to be 
encoded into a string of secure hashed password in the PBKDF2/BCRYPT/SCRYPT 
format. Users can create a Password type by doing the following:

> create table users (user varchar primary key, hashedpass password);
>

>From the above SQL statement, 'hashedpass' is the type of Password.

If a user wants to do a Password authenticate() function on a particular 
field, say 'hashedpass' field, they would issue the following command:

authenticate(hashedpass,'th1sIsMyP@55w0rd');


The return result would be a boolean of True or False indicating whether 
the authentication of the hashed password is successful or not.

If the user wants to select 'hashedpass' instead of authenticating to view 
the hashed password string, the user may issue the following command:

select hashedpass from users;


This will return a varchar string of the hashed password. The varchar 
string maybe Base64 encoded or Hexadecimal format whichever is preferred. 
BCRYPT and SCRYPT usually return in the form of a Base64 encoded string in 
their own format.

To emulate a real world login SQL statement, the user may issue the 
following two commands:

select hashedpass from users where user='myuser';
> authenticate(hashedpass,'password');

 
The authenticate simply performs a hashed password function to match the 
password. The authenticate() should not be bounded to a primary key.

The choice of ciphers for performing the hashed password should be stored 
in the H2 properties and be configured via SQL statements. Similarly, the 
number of rounds and complexity for the cipher parameters should be 
configured and be configurable as properties within H2 environment 
variables.



-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Re: [h2] Feature Request: Transparent Password Security

[Thotheolh]

I don't see any database making life easy for password authentication to my 
knowledge. H2 may become the first database to implement easy password 
authentication (despite lack of compatibility for other databases).

It would be much more secure if database providers provide a clean Password 
type and password authentication function than to let programmers attempt 
to script them repeatedly and manually in their web scripts.


On Friday, June 27, 2014 8:14:10 AM UTC, Noel Grandin wrote:
>
> Does any other database currently implement such a feature? 
>
> On 2014-06-27 10:03 AM, Thotheolh wrote: 
> > *Summary:* 
> > A new feature request to make password authentication and security easy 
> for non-security savvy users in the light of 
> > poor password security in production environments. 
> > 
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Re: Performance of PK queries when AND, OR or IN is used

[Thotheolh]

Have you tried the test in the latest release (1.0.78) ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~--~~~~--~~--~--~---

build jarSmall

[Thotheolh]

Hi. I am using Win XP and my H2 version is 1.1.100. I tried to 'cd' to
the \h2 directory in my command prompt and type in 'build jarSmall'
and it showed " Error: JAVA_HOME is not defined. 'javac' is not
recognized as an internal or external command, operable program or
batch file. The system cannot find the specific path." What should I
do to build a jarSmall h2 ? When I build a jarSmall version , will my
regular h2 version in the /h2/bin be deleted ? I want to preserve the
regular version too.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~--~~~~--~~--~--~---

Re: build jarSmall

[Thotheolh]

Thanks for your help Thomas. I do already have JDK 6 Update 7 inside
my Win XP when I was trying to build jar small.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~--~~~~--~~--~--~---

Re: H2 and jTable

[Thotheolh]

If you are refering to the Swing GUI jTable, I am not sure if you can
get the jTable to automatically grab the data from H2 and display but
I would recommend you put a timer which would periodically grab data
from H2 to display or refresh when some refresh button is activated.
You can look into OpenSwing Framework (open source swing
implementations) at "http://oswing.sourceforge.net/";. It has a wide
range of GUI stuff you may find useful.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~--~~~~--~~--~--~---

Theories of database engine

[Thotheolh]

Hi. Is there any good articles that teaches the internal structure of
database engines ? Is there anything here that teaches about H2
database engine structures and it's workings ? I just want to know
more about database other than the basics and SQL.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: Theories of database engine

[Thotheolh]

Thanks. I asked because I am interested in how people mae database
engines.

On Jan 8, 5:15 am, "Thomas Mueller" 
wrote:
> Hi,
>
> > Hi. Is there any good articles that teaches the internal structure of
> > database engines ? Is there anything here that teaches about H2
> > database engine structures and it's workings ? I just want to know
> > more about database other than the basics and SQL.
>
> The most important items are b-tree, join processing, transaction log
> (for example 
> ARIES,http://en.wikipedia.org/wiki/Algorithms_for_Recovery_and_Isolation_Ex...).
> Most of it is online somewhere, but I don't have any links. I would
> start with Wikipedia and then maybe use Google to find more
> information. I can't even suggest what book to read because I didn't
> read one related to databasetheory.
>
> Regards,
> Thomas
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: Database damage

[Thotheolh]

Can you post the log and the sql statements you did or whatever you
attempted on H2 ? Do include the H2 version you are using and the Java
you are using.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Getting the last few recent records

[Thotheolh]

Hi. How do I get the last few recent records I entered into a table ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: Getting the last few recent records

[Thotheolh]

Thanks for all the help. Would try them out. :)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: Database Corruption

[Thotheolh]

Hi. maybe you can state what kind of corruption you are worried that
would occur on H2 which happened on HSQLDB ?

On Jan 29, 6:57 am, bludginozzie  wrote:
> Hi,
>
> I am currently using HSQLDB in a production application and getting
> the occasional report of database corruption.  I have had it happen to
> me and the whole database just goes wierd.  I am considering a switch
> to H2 but I am concerned that it will suffer the same problems.  Has
> anyone had problems with corruption in H2 and/or any thoughts on
> this?  aka.. is H2 production ready?
>
> Thanks
>
> Mark
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: H2 Database Engine: New version 1.1.113 available

[Thotheolh]

'A second level soft-references cache is now supported. It speeds up
large databases, but reduces performance for small databases.' What
does it mean ? I have some small personal databases so if I use H2, I
would get a slowed down database for my small personal db ? Do I need
to activate this feature or is it a default in H2 ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Page Store

[Thotheolh]

Hi. Is it possible for a brief summary on this page store file
format ? When will this page store file format be stable for at least
a beta ?

I usually write software using H2 databases as the backend and some of
these softwares are thumbdrive or external device portable. Will page
store have any adverse effects on my external devices or flash
devices ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: From MySQL to H2

[Thotheolh]

If I am not wrong, you can dump MySQL using mysqldump. You can read
article at "http://www.devarticles.com/c/a/MySQL/Backing-Up-Your-MySQL-
Databases-With-MySQLDump/1/". to use the mysqldump. Once the dump is
created, you may have to look through the dump and personally convert
the sql statements to H2 compatible.

On May 24, 3:55 am, "Nitai @ SixSigns"  wrote:
> Hi all,
>
> I got a customer who want to convert his MySQL DB installation to H2.
> H2, has to act as a server model in this way, since remote connections
> have to work as well.
>
> As far, as I understand we have to start the H2 in server mode. How
> can we import the existing tables? Is there some script or is it a
> simple dump to import?
>
> Thanks for any feedback.
>
> Kind Regards,
> Nitai
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: packaging of h2 distribution

[Thotheolh]

Well, if you want h2.jar rather than h2-version.jar ... you can simply
make one copy and rename it to h2.jar so now you have a h2 with
version name and a h2 without version name. It's a bit long winded
path for those who like h2.jar but I doubt Thomas could satisfy all of
our request so I guess we just live with it. I always copy a h2 with
version name and rename it to h2.jar because some of my apps I made or
am making is set to look for h2.jar.

Sometimes I might even have a full h2with all the features and servers
that uses h2.jar and some embedded less feature ones that also use
h2.jar so I make a folder for the full featured h2.jar without
versioning and another folder for the embedded h2.jar. It's a bit more
troublesome to make folders and copies and rename them but isn't it
easy to do (copy files, rename ...etc...) and also make Thomas's job
easy without needing to handle minor stuff like these...

This is my 2 cents.

On Jul 18, 5:59 pm, Thomas Mueller 
wrote:
> Hi,
>
> I used to be "h2.jar" before, but then people complained... I think
> it's not an option to change the jar file to h2.jar, sorry. It doesn't
> make sense to include the file twice. I don't want that there are two
> files with the same content but different name, because that makes
> support harder. But you are free to copy it after installing.
>
> The directory name could be changed to h2-${version}, but that would
> not be "as simple as possible", and wouldn't solve your problem. Most
> software I have installed doesn't include the version in the directory
> name.
>
> So my plan is to keep the current directory and file name convention.
>
> Regards,
> Thomas
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Converting conventional h2 database to page store

[Thotheolh]

Hi. How do I convert my conventional h2 databases to the page store
mechanism ?

Left say I have an existing database already in use for sometime. Do I
simply just add the page store property behind the database url of my
existing database and it would automatically move to page store
mechanism or is that not how it should be ? ... or maybe I need to
create a new database with page store enabled again then copy all the
old data from the existing database and remove the old database to
make way for the new page store database ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: Converting conventional h2 database to page store

[Thotheolh]

Anyway, I tried an experiment on my own anyway. I did a script to
backup my old database then I appended the properties for page store
to the url of the old database. It opened up to a totally new and
blank database. I logout of the page store experinmental database and
thought I could just remove the page store properties and I would be
back inside my old database but no it wasn't the case. The old
database was gone. No tables, no data ... nothing. I also checked the
files made and changed during the proccesses of my experiment. When I
used the pagestore properties, a xxx.h2.db file existed besides the
conventional log and db files of the old database. Anyway, I gave up
on the old database and did a 'drop all objects delete files' to
finally kill it and decided to use the backup script to populate my
old database and move onto the page store mechanism. I think the new
page store seems to be cleaner in terms of the files it generates.

This time, I don't see any temp files around while running my newly
converted database. It only has a db file and a lock file and there's
all...nothing so bulky like the previous old database. I guess H2
would slowly move to the new page store and little by little, ditch
the old stage mechanism and finally phase out the old versions.

During this transitional phase, I wonder if there's some tools so that
users wouldn't end up like me, unknowingly have the old database
emptied while attempting the above experiment I did. Maybe from the
next release onwards, H2 would detect the page store properties in the
url and check if the database is an old one. If it's an old version,
it would do some migration. So all users need to do to migrate from
the old storage mechanism to the page store mech. would be as simple
as appending the page store properties to the url.

On Jul 19, 5:41 pm, Thotheolh  wrote:
> Hi. How do I convert my conventional h2 databases to the page store
> mechanism ?
>
> Left say I have an existing database already in use for sometime. Do I
> simply just add the page store property behind the database url of my
> existing database and it would automatically move to page store
> mechanism or is that not how it should be ? ... or maybe I need to
> create a new database with page store enabled again then copy all the
> old data from the existing database and remove the old database to
> make way for the new page store database ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Build jarSmall on openSuSe 11.0

[Thotheolh]

Hi. I decided to build a jarSmall on one of my machines running
openSUSE 11.0 that I also use for development and hit an error
compiling the jarSmall for 1.1.116

Linux:~/Desktop/h2> ./build.sh jarSmall
Target: jarSmall
Deleting temp
Deleting docs
Downloading 
http://repo1.maven.org/maven2/javax/servlet/servlet-api/2.4/servlet-api-2.4.jar
Downloaded 30428 bytes
Downloaded 9 bytes
Downloaded 66349 bytes
Downloaded 89709 bytes
Downloading 
http://repo1.maven.org/maven2/org/apache/lucene/lucene-core/2.2.0/lucene-core-2.2.0.jar
Downloaded 21667 bytes
Downloaded 36267 bytes
Downloaded 47947 bytes
Downloaded 71307 bytes
Downloaded 94667 bytes
Downloaded 118027 bytes
Downloaded 141387 bytes
Downloaded 164747 bytes
Downloaded 186647 bytesth...@gernux
Downloaded 195407 bytes
Downloaded 215847 bytes
Downloaded 239207 bytesth...@gernux
Downloaded 256727 bytes
Downloaded 272787 bytes
Downloaded 296147 bytes
Downloaded 318047 bytes
Downloaded 341407 bytes
Downloaded 364767 bytes
Downloaded 388127 bytes
Downloaded 411487 bytes
Downloaded 434847 bytes
Downloaded 458207 bytes
Downloaded 481567 bytes
Downloaded 504927 bytes
Downloaded 528287 bytes
Downloading 
http://repo1.maven.org/maven2/org/slf4j/slf4j-api/1.5.0/slf4j-api-1.5.0.jar
Downloading 
http://repo1.maven.org/maven2/org/apache/felix/org.osgi.core/1.2.0/org.osgi.core-1.2.0.jar
Downloaded 17288 bytes
Downloaded 42108 bytes
Compiling 535 classes
java.lang.ClassNotFoundException: com.sun.tools.javac.Main
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at org.h2.build.BuildBase.javac(BuildBase.java:732)
at org.h2.build.Build.compile(Build.java:161)
at org.h2.build.Build.jarSmall(Build.java:337)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.h2.build.BuildBase.invoke(BuildBase.java:203)
at org.h2.build.BuildBase.run(BuildBase.java:193)
at org.h2.build.Build.main(Build.java:31)
javac -g:none -d temp -sourcepath src/main -classpath temp:ext/servlet-
api-2.4.jar:ext/lucene-core-2.2.0.jar:ext/slf4j-api-1.5.0.jar:ext/
org.osgi.core-1.2.0.jar:/usr/lib/jvm/java-1.6.0-sun-1.6.0/jre/../lib/
tools.jar
javac: no source files
Usage: javac  
use -help for a list of possible options
Exception in thread "main" java.lang.Error: An error occurred
at org.h2.build.BuildBase.javac(BuildBase.java:743)
at org.h2.build.Build.compile(Build.java:161)
at org.h2.build.Build.jarSmall(Build.java:337)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.h2.build.BuildBase.invoke(BuildBase.java:203)
at org.h2.build.BuildBase.run(BuildBase.java:193)
at org.h2.build.Build.main(Build.java:31)

I did a java -version:
Linux:~/Desktop/h2> java -version
java version "1.6.0_14"
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
Java HotSpot(TM) Server VM (build 14.0-b16, mixed mode)

I actually have a successful jarSmall build while running it on
LinuxMint 6 distro last weekend on my main development machine for the
same H2 version.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: Security issue: Database structure is exposed

[Thotheolh]

I agree with Sam. If you want to have something to hide from the
users, either encrypt it on maybe use H2 as a base but modify H2 to
what you want it to do. There's no point hiding stuff from users ...
sooner or later , someone's gonna come along and hack the system and
this is evident in many proprietary products where hackers come along
and hack and reveal the supposed secrets.

I even doubt if the users would even bother to touch H2 for the most
of them.

On Aug 9, 1:39 am, Sam Van Oort  wrote:
> I don't think you can disable the Information Schema.  While they show
> as tables, they are actually internal to the system.  What you see
> isn't what's really there.
>
> There is no point in protecting against user access on the local
> system.  Encryption is the standard and proper way to do this -- see
> also how badly DRM and DVD protection fail.
>
> Cheers,
> Sam Van Oort
> (Formerly listed as Bob McGee)
>
> On Aug 8, 1:18 pm, Lahcen  wrote:
>
> > Thanks,
>
> > > SQL is a human readable language.
>
> > Yes i know that, but why the SQL script should stay in the database
> > after it has been created. i have the .sql script but after i run it
> > to create the database than the script should not appear in the
> > database. it is like compiling source code to get object code (such as
> > exe) the source code should not appear in the executable file.
>
> > > To hide the structure you would have to disable INFORMATION_SCHEMA
>
> > How to do it, i just looked into the docs but did not find it or did i
> > miss it?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Get list of existing table names

[Thotheolh]

How do I get a list of table names ? I need to get a list of table
names for a software I am writing so that it can automatically which
database tables are not installed so it can be installed
automatically. I am looking into allowing my software to automate
installation and setting up tables in h2 databases.

I tried to use SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_SCHEMA='PUBLIC' but I noticed that if I do a 'DROP ALL OBJECTS
DELETE FILES' and revisit the same database again, the information
schema would still contain the names of the old tables even though the
tables are already dropped.

Is there any command to quickly get a reliable list of existing table
names which I can execute from a PreparedStatement in Java ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

autosetup problems

[Thotheolh]

I have created a java class to do automatic setup of database using
'RUNSCRIPT' from a setup sql file.

Please go to 'http://www.thotheolh.pastebin.com/m739dcbc9' to get my
codes for the java class.

As for the setup sql script, go to 'http://www.thotheolh.pastebin.com/
m19be7a70'.

To use this class, a sample code as below...

  new AutoSetup(new Connection()).init(new File());

I am not sure if this is some code logic problem or is this H2
database problem so I need some help here.

I am using the 1.1.117 build.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: autosetup problems

[Thotheolh]

The problem seems to lie in that when it's checking for created
tables, the only table left out is the 'ACL' table presumably not
created I guess?

I noticed that if the AutoSetup did do any create tables, the tables
were somehow not found when I use the H2 console to manually login and
browse for the tables. It is as though the runscript did run but
nothing was really created in my opinion.

On Sep 4, 11:13 pm, Thotheolh  wrote:
> I have created a java class to do automatic setup of database using
> 'RUNSCRIPT' from a setup sql file.
>
> Please go to 'http://www.thotheolh.pastebin.com/m739dcbc9'to get my
> codes for the java class.
>
> As for the setup sql script, go to 'http://www.thotheolh.pastebin.com/
> m19be7a70'.
>
> To use this class, a sample code as below...
>
>           new AutoSetup(new Connection( connection>)).init(new File());
>
> I am not sure if this is some code logic problem or is this H2
> database problem so I need some help here.
>
> I am using the 1.1.117 build.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: autosetup problems

[Thotheolh]

I think I found the answer to the problem. The problem is the 'drop
all objects delete file' sql statement.

What I did was to comment off the clean() and to replace the cleaning
function of the database , I added 'drop all objects' in the sql
script before it did all the other create tables and it ran well.

On Sep 5, 12:28 am, Thotheolh  wrote:
> The problem seems to lie in that when it's checking for created
> tables, the only table left out is the 'ACL' table presumably not
> created I guess?
>
> I noticed that if the AutoSetup did do any create tables, the tables
> were somehow not found when I use the H2 console to manually login and
> browse for the tables. It is as though the runscript did run but
> nothing was really created in my opinion.
>
> On Sep 4, 11:13 pm, Thotheolh  wrote:
>
> > I have created a java class to do automatic setup of database using
> > 'RUNSCRIPT' from a setup sql file.
>
> > Please go to 'http://www.thotheolh.pastebin.com/m739dcbc9'toget my
> > codes for the java class.
>
> > As for the setup sql script, go to 'http://www.thotheolh.pastebin.com/
> > m19be7a70'.
>
> > To use this class, a sample code as below...
>
> >           new AutoSetup(new Connection( > connection>)).init(new File());
>
> > I am not sure if this is some code logic problem or is this H2
> > database problem so I need some help here.
>
> > I am using the 1.1.117 build.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

File corruptions in 1.1.119

[Thotheolh]

Hi. I was using 1.1.117 and it worked fine opening my h2 databases. I
did not upgrade any further since the changelog did not show much
significant changes. I noticed that the latest 1.1.119 have good
amount of changes so I decided to use it. When I tried to use my
1.1.119 to open my personal databases... it claimed that it was
corrupted.

File corrupted while reading record: /home/thotheolh/DBStore/
Password.h2.db. Possible solution: use the recovery tool [90030-119]
90030/90030 (Help)

I have been opening my personal databases using 1.1.117 fine a while
ago until this came.

I quickly restored my 1.1.117 and everything's fine again.

I am guessing that 1.1.119 sets the h2 page store as the default
mechanism rather than the old h2 storage mechanism... did I guess
correctly ?

For now, I am using 1.1.117 to be on the save side.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

File corruptions in 1.1.119

[Thotheolh]

Hi. I was using 1.1.117 and it worked fine opening my h2 databases. I
did not upgrade any further since the changelog did not show much
significant changes. I noticed that the latest 1.1.119 have good
amount of changes so I decided to use it. When I tried to use my
1.1.119 to open my personal databases... it claimed that it was
corrupted.

File corrupted while reading record: /home/thotheolh/DBStore/
Password.h2.db. Possible solution: use the recovery tool [90030-119]
90030/90030 (Help)

I have been opening my personal databases using 1.1.117 fine a while
ago until this came.

I quickly restored my 1.1.117 and everything's fine again.

I am guessing that 1.1.119 sets the h2 page store as the default
mechanism rather than the old h2 storage mechanism... did I guess
correctly ?

For now, I am using 1.1.117 to be on the save side.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: File corruptions in 1.1.119

[Thotheolh]

Sry, duplicate post. Hi the post button twice on a hurry.

On Sep 27, 9:31 am, Thotheolh  wrote:
> Hi. I was using 1.1.117 and it worked fine opening my h2 databases. I
> did not upgrade any further since the changelog did not show much
> significant changes. I noticed that the latest 1.1.119 have good
> amount of changes so I decided to use it. When I tried to use my
> 1.1.119 to open my personal databases... it claimed that it was
> corrupted.
>
> File corrupted while reading record: /home/thotheolh/DBStore/
> Password.h2.db. Possible solution: use the recovery tool [90030-119]
> 90030/90030 (Help)
>
> I have been opening my personal databases using 1.1.117 fine a while
> ago until this came.
>
> I quickly restored my 1.1.117 and everything's fine again.
>
> I am guessing that 1.1.119 sets the h2 page store as the default
> mechanism rather than the old h2 storage mechanism... did I guess
> correctly ?
>
> For now, I am using 1.1.117 to be on the save side.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: File corruptions in 1.1.119

[Thotheolh]

Strangely, I could use 1.1.119 to access other of my databases... Is
it because this particular 'corrupted' database was created much
earlier than the other databases that is why it have some sort of a
difference in versions of storage mechanisms ?

On Sep 27, 9:32 am, Thotheolh  wrote:
> Sry, duplicate post. Hi the post button twice on a hurry.
>
> On Sep 27, 9:31 am, Thotheolh  wrote:
>
> > Hi. I was using 1.1.117 and it worked fine opening my h2 databases. I
> > did not upgrade any further since the changelog did not show much
> > significant changes. I noticed that the latest 1.1.119 have good
> > amount of changes so I decided to use it. When I tried to use my
> > 1.1.119 to open my personal databases... it claimed that it was
> > corrupted.
>
> > File corrupted while reading record: /home/thotheolh/DBStore/
> > Password.h2.db. Possible solution: use the recovery tool [90030-119]
> > 90030/90030 (Help)
>
> > I have been opening my personal databases using 1.1.117 fine a while
> > ago until this came.
>
> > I quickly restored my 1.1.117 and everything's fine again.
>
> > I am guessing that 1.1.119 sets the h2 page store as the default
> > mechanism rather than the old h2 storage mechanism... did I guess
> > correctly ?
>
> > For now, I am using 1.1.117 to be on the save side.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: File corruptions in 1.1.119

[Thotheolh]

I think it's my database file that's corrupted. I re-made the database
and every version can open it. How did my file get corrupted but yet
1.1.117 could still open it ?

On Sep 27, 9:37 am, Thotheolh  wrote:
> Strangely, I could use 1.1.119 to access other of my databases... Is
> it because this particular 'corrupted' database was created much
> earlier than the other databases that is why it have some sort of a
> difference in versions of storage mechanisms ?
>
> On Sep 27, 9:32 am, Thotheolh  wrote:
>
> > Sry, duplicate post. Hi the post button twice on a hurry.
>
> > On Sep 27, 9:31 am, Thotheolh  wrote:
>
> > > Hi. I was using 1.1.117 and it worked fine opening my h2 databases. I
> > > did not upgrade any further since the changelog did not show much
> > > significant changes. I noticed that the latest 1.1.119 have good
> > > amount of changes so I decided to use it. When I tried to use my
> > > 1.1.119 to open my personal databases... it claimed that it was
> > > corrupted.
>
> > > File corrupted while reading record: /home/thotheolh/DBStore/
> > > Password.h2.db. Possible solution: use the recovery tool [90030-119]
> > > 90030/90030 (Help)
>
> > > I have been opening my personal databases using 1.1.117 fine a while
> > > ago until this came.
>
> > > I quickly restored my 1.1.117 and everything's fine again.
>
> > > I am guessing that 1.1.119 sets the h2 page store as the default
> > > mechanism rather than the old h2 storage mechanism... did I guess
> > > correctly ?
>
> > > For now, I am using 1.1.117 to be on the save side.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: H2 console on Google App Engine

[Thotheolh]

It's definitely cool to see H2 console running on Google App Engine.
Good work.

>     
>         write-behind-task
>         5/s
>     
> 
>
> if "5/s" means "every 5 seconds", then (60/5) * 60 min per hour * 24
> hour per day = 17280
> "Task Queue API Calls" limited to 1 per day for free accounts.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: JDK 1.5 End-of-Life

[Thotheolh]

Maybe add a support for Java 6 as well ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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
-~--~~~~--~~--~--~---

Re: using h2 to build web 2.0 website?

[Thotheolh]

Hi. I don't have good experience building web 2.0 using H2 or anyone
actually powering a site with H2 database as a backend yet. If you
want to host a website on someone else servers (those web hosting
sites) using H2 as backend, they have to agree ... but most probably
difficult to get them to do so... unless you are hosting a web on your
own machines.

On Jan 9, 10:38 am, surfman  wrote:
> I am totally new to h2 database. I tried searching anything with
> building a high performance web 2.0 website using h2 but failed. Is
> there anybody with such experience in a real project? I am looking for
> the possibility to replace Mysql. Thanks.
-- 
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.

Encryption using java PreparedStatement

[Thotheolh]

Hi. I have a code to execute encryption via SQL prepared statement.
The code fragment is below. I am doing it right ?

public byte[] encrypt(byte[] keyBytes, byte[] data){
try {
PreparedStatement pstmt = getConn().prepareStatement("CALL
ENCRYPT('AES', ?, STRINGTOUTF8(?))");
pstmt.setBytes(1, keyBytes);
pstmt.setBytes(2, data);
ResultSet rs = pstmt.executeQuery();
return rs.getBytes(0); //What should it return ?
} catch (SQLException ex) {
Logger.getLogger(SQLManager.class.getName()).log
(Level.SEVERE, null, ex); //Logging
return null;
}
}

What does it return in the ResultSet ? Do I rs.getBytes(0); or what is
the column name I should get ?

-- 
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.

Re: Encryption using java PreparedStatement

[Thotheolh]

Thanks for the help :)

On Jan 27, 5:05 am, Thomas Mueller 
wrote:
> Hi,
>
> See also my response to "DECRYPT requiring UTF8TOSTRING and TRIM functions"
>
> > You are using STRINGTOUTF8(?) ... on a byte[] (which is not a string)
>
> Yes, use "?" instead of "STRINGTOUTF8(?)", or use setString.
>
> > return rs.getBytes(0); //What should it return ?
>
> This will throw an exception, because the first column is column 1.
> You need to use
>
> return rs.getBytes(1);
>
> > the column name
>
> There is no (regular) column name.
>
> > - You are using CALL ... so should be using a CallableStatement rather
>
> than a PreparedStatement ?
>
> No, PreparedStatement is fine. CallableStatement should also work I
> believe (not sure).
>
> Regards,
> Thomas

-- 
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.

Trailing zeroes in decrypted plain text hex

[Thotheolh]

Hi. I used H2's encrypt and decrypt sql statements and below is the
result all are in hex codes:

Plain text: 54657374696e672043727970746f2031323334
Cipher text:
5effc15fffc46b26ffcd56ffdfffd0113556ffcd2ff9bffd1ffa4670fff1fff640ffc7761ffb5ffb2ffb36ffcb
Plain text: 54657374696e672043727970746f20313233340

Why are there trailing zeroes after I decrypted the plain text ?

If the hex are converted to ascii... the original plain text in ascii
is 'Testing Crypto 1234' and the decrypted text ascii is 'Testing
Crypto 1234???'. It is a match except the trailing ??. What
should i do to remove it ?

-- 
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.

Re: Trailing zeroes in decrypted plain text hex

[Thotheolh]

Hi. I found the answer in the code sample in the topic '
DECRYPT requiring UTF8TOSTRING and TRIM functions '. Sorry for
posting.

On Jan 30, 10:52 pm, Thotheolh  wrote:
> Hi. I used H2's encrypt and decrypt sql statements and below is the
> result all are in hex codes:
>
> Plain text: 54657374696e672043727970746f2031323334
> Cipher text:
> 5effc15fffc46b26ffcd56ffdfffd0113556ffcd2ff9bffd1ffa4670fff1fff640ffc7761ffb5ffb2ffb36ffcb
> Plain text: 54657374696e672043727970746f20313233340
>
> Why are there trailing zeroes after I decrypted the plain text ?
>
> If the hex are converted to ascii... the original plain text in ascii
> is 'Testing Crypto 1234' and the decrypted text ascii is 'Testing
> Crypto 1234???'. It is a match except the trailing ??. What
> should i do to remove it ?

-- 
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.

Maturity and stability of page store

[Thotheolh]

Hi. I am curious of the maturity and stability of page store. I would
like to use the latest h2 database in my java applications and also
update all the previous applications I made that uses h2 as the
backend. I would like to know if changing from the old format to the
page store in the current latest versions since 1.2.127 and 1.2.128
would cause any problems to the databases?

-- 
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.

Bloated text ?

[Thotheolh]

Cipher text:
5effc15fffc46b26ffcd56ffdfffd0113556ffcd2ff9bffd1ffa4670fff1fff640ffc7761ffb5ffb2ffb36ffcb

Encrypted text:
5effc15fffc46b26ffcd56ffdfffd0113556ffcd29ffbd1a4670fff1fff640ffc7761b5b2b36ffcb

Main Codes:
byte[] encryptedBytes = ;
String encryptedHex = ByteToHex(encryptedBytes);
System.out.println("Cipher text: " + encryptedHex);
byte[] encryptedBytes2 = HexToByte(encryptedHex);
System.out.println("Encrypted text: "+ByteToHex
(encryptedBytes2));

I tried to convert some bytes to hex then reconvert the hex back to
bytes. Somehow as you noticed from the results that both text's
patterns are the same except that the encrypted text is far more
'bloated' than the cipher text. It has lots more '' in it.

Below is the HexToByte and ByteToHex codes:

public String ByteToHex(byte[] byteArray) {
StringBuffer hexstr = new StringBuffer();
for (int i = 0; i < byteArray.length; i++) {
String hexcode = Integer.toHexString(byteArray[i]);
hexstr.append(hexcode);
}
return hexstr.toString();
}

public byte[] HexToByte(String hexcode) {
byte[] bytes = new BigInteger(hexcode.toString(),
16).toByteArray();
return bytes;
}

May i know if there's anything wrong with my HexToByte and ByteToHex
codes ?

-- 
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.

Cannot use PAGE_STORE=TRUE parameter on latest version of H2

[Thotheolh]

Hi. I tried using the PAGE_STORE=TRUE parameter in my JDBC url in an
attempt to make it auto convert my old non-page store database and I
got the following error...

org.h2.jdbc.JdbcSQLException: Unsupported connection setting
"PAGE_STORE" [90113-130]

Does that mean the parameter for auto page store conversion is
removed ?

-- 
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.

SHA hashing

[Thotheolh]

Hi. I wanted to hash a password in SHA for encryption. I used the sql
statement for calling of hash to hash my password. I noticed that the
hash kept changing despite the password I use is the same which causes
a problem for my encryption since I use the hashed value of the
password for the AES encryption sql statement.

Is there some random generator in the SHA which causes the hash value
to change whenever I create a new instance of the program ?

-- 
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.

Re: SHA hashing

[Thotheolh]

Hi. I am using JDBC preparedstatement and this is my preparedstatement
"CALL HASH('SHA256', ?, 1000)".

On Mar 7, 10:08 am, Thotheolh  wrote:
> Hi. I wanted to hash a password in SHA for encryption. I used the sql
> statement for calling of hash to hash my password. I noticed that the
> hash kept changing despite the password I use is the same which causes
> a problem for my encryption since I use the hashed value of the
> password for the AES encryption sql statement.
>
> Is there some random generator in the SHA which causes the hash value
> to change whenever I create a new instance of the program ?

-- 
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.

Re: Error in source code of script.java

[Thotheolh]

What command (in exact words) did you use ? Are you calling it
programmatically using Statements or from a web console ?

On Apr 1, 4:36 am, hschmitter  wrote:
> The documentation says
>
> SCRIPT [SIMPLE] [NODATA] [NOPASSWORDS] [NOSETTINGS] [DROP]
>                 [BLOCKSIZE blockSizeInt] [TO fileNameString
>                 [COMPRESSION {DEFLATE|LZF|ZIP|GZIP}]
>                 [CIPHER cipher PASSWORD string]]
> Creates a SQL script with or without the insert statements. The simple
> format does not use multi-row insert statements.
>
> However, I tried the simple-parameter and got an exception because the
> parameter "simple" is never evaluated in Script.run(...). Or did I
> something wrong ? I rather woudl like to get created singel line
> commands instead of bulk commands.

-- 
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.

Changing password for encrypted embedded database

[Thotheolh]

Hi. My project requires me to use a jarSmall embedded database so that
it would have as small foot print as possible. I noticed that there's
an SQL statement for SET PASSWORD to allow the user to set the
password but there is no way to change the encrypted file password.
ChangeFileEncryption tool is not included in the jarSmall as I noticed
too. How should I go about setting the encrypted database file
password while using jarSmall ?

-- 
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.

jarSmall unsupported statements

[Thotheolh]

Hi. I noticed that certain statements like "DROP ALL OBJECTS DELETE
FILES" are not supported on jarSmall builds. Thomas, is it possible
for you to create a page on the H2 site that would show what is
supported on jarSmall ? Is it possible to include "DELETE FILES"
options into the next H2 jarSmall build ? I felt that it is a very
useful command.

-- 
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.

Java files and dependencies

[Thotheolh]

Hi. The h2 jarSmall does not have the change file encryption password.
I have decided to copy the necessary files from h2 source into my
project's codes so to give h2 jarSmall the ability to change file
encryption passwords.

What is the files I need to copy from the h2 sources to add into
jarSmall to give it the change file encryption ability ?

Thanks.

-- 
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.

Re: Java files and dependencies

[Thotheolh]

Hi. Thanks.

I managed to figure out what files are required and it worked. I could
change file encryption by adding the required source codes and
packages to my application.

I could post a list of what I think are the files that are required
for the change file encryption ability if you want me to.

Regards,
Thotheolh.

On Jun 20, 3:37 pm, Thomas Mueller 
wrote:
> Hi,
>
> > to add into jarSmall
>
> Why don't you add it to just your application?
>
> Regards,
> Thomas

-- 
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.

H2 ConnectionInfo's Properties

[Thotheolh]

Hi. I was looking through and trying to access ConnectionInfo class
source code from my own application codes and noticed that there was
this "Properties info" parameter. I wasn't sure what to put in the
"info" parameter and just put "null" in it and it the system threw me
a "SEVERE: null" error. What should I put in the "info" parameter ? I
need some details on what needs to be in the "info"parameter.

-- 
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.

Re: H2 ConnectionInfo's Properties

[Thotheolh]

How do I get the "info" parameter if I have a JDBC url ?

On Jul 3, 11:52 am, Thotheolh  wrote:
> Hi. I was looking through and trying to access ConnectionInfo class
> source code from my own application codes and noticed that there was
> this "Properties info" parameter. I wasn't sure what to put in the
> "info" parameter and just put "null" in it and it the system threw me
> a "SEVERE: null" error. What should I put in the "info" parameter ? I
> need some details on what needs to be in the "info"parameter.

-- 
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.

Re: Database upgrade from 1.1 to 1.2 (non page store to page store) finally made easier

[Thotheolh]

I felt that what we need is just a standalone official "migrate.jar"
or a compact package of tools downloadable on the H2 website. As long
as the H2 file storage format doesn't change, then the migrate tool
would not be updated and allow cross migration between different
formats of H2 storage if ever there's any more H2 file formats to be
created.

In this way, we would have a highly compact migration tool not stuck
to any H2 version where you need certain old versions of H2 (1.2.128)
to open the database and migrate then you jump back to the latest
(1.2.138). That's not going to be an elegant solution.

With a standalone migrate tool, the user could simply just add it to
the application and run file format migrations quietly so as not to
alarm the app user and the main H2 distribution could remain as light
as possible not weighted down by an additional migrate tool.

I have a couple of applications I made still running the old format
and I could not migrate them without running into complex troubles and
using modified distributions.

Sorry, Christian, your modified distribution is a good idea but the
problem is that for every new H2 release, you need to release a
modified distribution and this is not elegant solution to the long
standing issue.

For now, if I want to migrate my old H2 format to the page store, I
need Christian's modified package but I hope an official standalone
migrate tool would forever solve this unresolved issue.

Looking forward to the final elegant solution to put this unresolved
issue to rest.

Regards,
Thotheolh.



-- 
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.

Re: Database upgrade from 1.1 to 1.2 (non page store to page store) finally made easier

[Thotheolh]

Hi Christain. May I know the url to the standalone migration jar file?
I tried to search the h2 website for the standalone download but
couldn't find it.

Thanks alot.

Regards,
Thotheolh.

On Jul 3, 4:54 pm, Christian Peter 
wrote:
> Hi Thotheolh,
>
> Thomas and I work on a solution which soon will be integrated and will
> eventually has the following features:
>
> - Default H2 release can be used
> - Standalonge migration .jar is available from the h2 homepage
> - If H2 finds the migration classes, it will convert the database via
> "script to" and "runscript from" automatically
>
> This should meet your requirements.
>
> Regards
>
> Christian
>
> On Jul 3, 7:35 am, Thotheolh  wrote:
>
>
>
> > I felt that what we need is just a standalone official "migrate.jar"
> > or a compact package of tools downloadable on the H2 website. As long
> > as the H2 file storage format doesn't change, then the migrate tool
> > would not be updated and allow cross migration between different
> > formats of H2 storage if ever there's any more H2 file formats to be
> > created.
>
> > In this way, we would have a highly compact migration tool not stuck
> > to any H2 version where you need certain old versions of H2 (1.2.128)
> > to open the database and migrate then you jump back to the latest
> > (1.2.138). That's not going to be an elegant solution.
>
> > With a standalone migrate tool, the user could simply just add it to
> > the application and run file format migrations quietly so as not to
> > alarm the app user and the main H2 distribution could remain as light
> > as possible not weighted down by an additional migrate tool.
>
> > I have a couple of applications I made still running the old format
> > and I could not migrate them without running into complex troubles and
> > using modified distributions.
>
> > Sorry, Christian, your modified distribution is a good idea but the
> > problem is that for every new H2 release, you need to release a
> > modified distribution and this is not elegant solution to the long
> > standing issue.
>
> > For now, if I want to migrate my old H2 format to the page store, I
> > need Christian's modified package but I hope an official standalone
> > migrate tool would forever solve this unresolved issue.
>
> > Looking forward to the final elegant solution to put this unresolved
> > issue to rest.
>
> > Regards,
> > Thotheolh.

-- 
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.

Encodings of H2 databases

[Thotheolh]

Hi. May I know what is the encoding format (utf 8 ? base 64 ?) for the
old 1.1.119 (non-page store) database and the current page store.

-- 
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.

Re: Database upgrade from 1.1 to 1.2 (non page store to page store) finally made easier

[Thotheolh]

Hi. I took a look at the standalone migration and the modified H2
database Christian made. i noticed both contains the entire H2 source
for the old version. Most applications who wish to migrate already
have a H2 database jar file included and now they have to include
another H2 with everything in it of an older version to do the
migration. Why not rather then having a 'second H2 database' to be
added to classpath for migration, we might as well have a lightweight
format converter that utilizes the H2 that the application have and do
a 'one-to-one' direct file format conversion ? In this way, you don't
need to add more bulk and have something lightweight.

Here's some numbers for my application:

H2 jar v1.2.137: 1.1 MB
H2 standalone migration tool: 1.3 ~ 1.4 MB
Total: ~2.5 MB

It isn't really big in modern standards but the H2 jar have nearly the
same files as the migration tool. If that's the case, why not directly
feed on the H2 jar ?

I was wondering if the H2 migration process is using the old version
in the mig. tool to export out the data in sql then reload the
exported sql to the new version. If that's the case... why not a 'one-
to-one' file convert ? It would be probably even more lightweight then
to export sqls and all those (since database parsers... engines are
required).

Regards,
Thotheolh.

On Jul 4, 4:25 am, Christian Peter 
wrote:
> Hi,
>
> the old really standalone tools are linked in the first message of
> this thread. They are obsolete now.
>
> The new official migration .jar addon is 
> herehttp://h2database.com/h2mig_pagestore_addon.jar
> and can be used with the next release (it is now included in SVN).
>
> Regards
>
> Christian
>
> On Jul 3, 11:04 am,Thotheolh wrote:
>
>
>
> > Hi Christain. May I know the url to the standalone migration jar file?
> > I tried to search the h2 website for the standalone download but
> > couldn't find it.
>
> > Thanks alot.
>
> > Regards,
> >Thotheolh.
>
> > On Jul 3, 4:54 pm, Christian Peter 
> > wrote:
>
> > > HiThotheolh,
>
> > > Thomas and I work on a solution which soon will be integrated and will
> > > eventually has the following features:
>
> > > - Default H2 release can be used
> > > - Standalonge migration .jar is available from the h2 homepage
> > > - If H2 finds the migration classes, it will convert the database via
> > > "script to" and "runscript from" automatically
>
> > > This should meet your requirements.
>
> > > Regards
>
> > > Christian
>
> > > On Jul 3, 7:35 am,Thotheolh wrote:
>
> > > > I felt that what we need is just a standalone official "migrate.jar"
> > > > or a compact package of tools downloadable on the H2 website. As long
> > > > as the H2 file storage format doesn't change, then the migrate tool
> > > > would not be updated and allow cross migration between different
> > > > formats of H2 storage if ever there's any more H2 file formats to be
> > > > created.
>
> > > > In this way, we would have a highly compact migration tool not stuck
> > > > to any H2 version where you need certain old versions of H2 (1.2.128)
> > > > to open the database and migrate then you jump back to the latest
> > > > (1.2.138). That's not going to be an elegant solution.
>
> > > > With a standalone migrate tool, the user could simply just add it to
> > > > the application and run file format migrations quietly so as not to
> > > > alarm the app user and the main H2 distribution could remain as light
> > > > as possible not weighted down by an additional migrate tool.
>
> > > > I have a couple of applications I made still running the old format
> > > > and I could not migrate them without running into complex troubles and
> > > > using modified distributions.
>
> > > > Sorry, Christian, your modified distribution is a good idea but the
> > > > problem is that for every new H2 release, you need to release a
> > > > modified distribution and this is not elegant solution to the long
> > > > standing issue.
>
> > > > For now, if I want to migrate my old H2 format to the page store, I
> > > > need Christian's modified package but I hope an official standalone
> > > > migrate tool would forever solve this unresolved issue.
>
> > > > Looking forward to the final elegant solution to put this unresolved
> > > > issue to rest.
>
> > > > Regards,
> > > >Thotheolh.

-- 
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.

Re: Encodings of H2 databases

[Thotheolh]

I would like to access the files of the old h2 database and the page
store version. Is there a documentation of the database formats and
encodings ?

The reason why I want to access the database files is to create a 'one-
to-one' database migration tool that would read the old database
format files and then convert them to the page store version and
create h2 page store file formats.

I have explained the reason why i felt the current official h2
migration is not very elegant in the post on migration tool that's why
I thought i would like to try my hands on making another migration
tool which does direct file conversion.

On Jul 10, 1:48 pm, Thotheolh  wrote:
> Hi. May I know what is the encoding format (utf 8 ? base 64 ?) for the
> old 1.1.119 (non-page store) database and the current page store.

-- 
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.

Re: Encodings of H2 databases

[Thotheolh]

Does it mean that regardless of the old format or the page store
format, both of them are neither utf-8 nor base64 ?

I was wondering since the old format is already 'out of support', you
could release some hints about it.

I have revised the 'one-to-one' conversion plan in a way that all I
need is to know the encodings of the old format, extract data from the
old data formats and convert into sql format and now all the user
needs is to use the current page store H2 to read in the sql format.
This is even more lightweight then a the old 'one-to-one' conversion
since I don't really need to write a full fledge file converter but
rely on the page store H2 to read in the sql format.

Could you hint which part of the old h2 format source file should I
look into to look for the encoding of the old h2 format ? This hint
would be good enough so I don't need to 'walk-through' so much codes
just to understand the old H2 format. I was thinking, since you are
busy with the main H2 development, why not allow some of us whoever
that is interested to get down and make a more efficient converter for
the H2 file formats ?

On Jul 14, 1:29 am, Thomas Mueller 
wrote:
> Hi,
>
> > Hi. May I know what is the encoding format (utf 8 ? base 64 ?) for the
> > old 1.1.119 (non-page store) database and the current page store.
>
> The file format is internal to H2 and not relevant for the
> application. You can store and read any Java string without losing
> data, that's all you need to know as a user of H2. That said, the
> internal encoding is not UTF-8 and not Base64, but it's relatively
> close to UTF-8. For details, see Data.java.
>
> At some point I do plan to fully document the (current) file format,
> but currently I believe it's not required / needed yet.
>
> > 'one-to-one' database migration tool
>
> That would be very complicated I'm afraid. The hard part is reading
> the transaction log and apply changes in the data file. I don't think
> it would be worth it. If you want to do it, you are on your own. I
> will not be able to help you.
>
> Regards,
> Thomas

-- 
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.

Re: Automatic database upgrade from non page store

[Thotheolh]

Could you post your JDBC connection url ?
According to the Error Analyzer provided on the H2 website:

DATABASE_NOT_FOUND_1 = 90013

The error with code 90013 is thrown when trying to open a database
that does not exist using the flag IFEXISTS=TRUE, or when trying to
access a database object with a catalog name that does not match the
database name.

On Jul 15, 11:37 pm, Duvel  wrote:
> Hello,
>
> I was pleased to see this new feature in the latest release, because
> we were expecting a few migration problems with the release of our new
> version, where we did incorporate a new H2 driver. We use H2 as an
> easy intermediate database between our product and other products. We
> should have had to manually upgrade all these databases.
>
> I tested this with version 1.2.139, but I'm getting the error below,
> so it doesn't seem to go all to well.
>
> I added both h2-1.2.139.jar and h2mig_pagestore_addon.jar to my
> classpath.
>
> What am I doing wrong?
>
> With kind regards,
>
> Remco Schoen
>
> org.h2.jdbc.JdbcSQLException: Database "/Users/remco/dev/topdesk/trunk/
> topdesk4/databasetestcases/target/test-classes/com/topdesk/
> databasetest/h2/target" not found [90013-139]
>         at org.h2.message.DbException.getJdbcSQLException(DbException.java:
> 327)
>         at org.h2.message.DbException.get(DbException.java:167)
>         at org.h2.message.DbException.get(DbException.java:144)
>         at org.h2.engine.Engine.openSession(Engine.java:54)
>         at org.h2.engine.Engine.openSession(Engine.java:146)
>         at org.h2.engine.Engine.getSession(Engine.java:125)
>         at org.h2.engine.Session.createSession(Session.java:122)
>         at
> org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:
> 241)
>         at org.h2.engine.SessionRemote.createSession(SessionRemote.java:219)
>         at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:111)
>         at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:95)
>         at org.h2.Driver.connect(Driver.java:62)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:154)
>         at
> org.h2.upgrade.DbUpgradeNonPageStoreToCurrent.upgrade(DbUpgradeNonPageStore 
> ToCurrent.java:
> 152)
>         at org.h2.upgrade.DbUpgrade.upgradeFromNonPageStore(DbUpgrade.java:
> 55)
>         at org.h2.upgrade.DbUpgrade.upgrade(DbUpgrade.java:42)
>         at org.h2.Driver.connect(Driver.java:60)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:185)
>         at
> com.topdesk.databasetest.h2.ConvertToPageStore.automaticConvert(ConvertToPa 
> geStore.java:
> 40)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp 
> l.java:
> 25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at org.junit.internal.runners.TestMethod.invoke(TestMethod.java:59)
>         at
> org.junit.internal.runners.MethodRoadie.runTestMethod(MethodRoadie.java:
> 98)
>         at org.junit.internal.runners.MethodRoadie$2.run(MethodRoadie.java:
> 79)
>         at
> org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(Method 
> Roadie.java:
> 87)
>         at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:
> 77)
>         at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42)
>         at
> org.junit.internal.runners.JUnit4ClassRunner.invokeTestMethod(JUnit4ClassRu 
> nner.java:
> 88)
>         at
> org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.j 
> ava:
> 51)
>         at org.junit.internal.runners.JUnit4ClassRunner
> $1.run(JUnit4ClassRunner.java:44)
>         at
> org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:
> 27)
>         at
> org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:
> 37)
>         at
> org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:
> 42)
>         at
> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestRe 
> ference.java:
> 46)
>         at
> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:
> 38)
>         at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestR 
> unner.java:
> 467)
>         at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestR 
> unner.java:
> 683)
>         at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner 
> .java:
> 390)
>         at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunne 
> r.java:
> 197)

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-

encrypteed temp migration file

[Thotheolh]

I notice that 1.2.140 has a feature to encrypt temp files use during
migration of the db. Is there an option to manually enable or disable
this function. This is a good security feature but it could slow down
migration processes. What is used as the encryption key during the
encrypted migration. The user password or a one time password?

-- 
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.

Incompatibility between 1.2.132 and 1.2.137 jarSmall

[Thotheolh]

Hi. I am having an app that is using jarSmall 1.2.132 in production
environment while my in development app is using the 1.2.137 jarSmall.
I generated a main jarfile for the development app and replaced the
production main jarfile without changing the lib jars or any other
things. It seems to throw an error for getting the connection.

Here is by JDBC: jdbc:h2:file:~/DBStore/Test/
Test;CIPHER=AES;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0

I used my own 1.2.137 web console to attempt to interact and it throws
the following error:

No suitable driver found for db.connection=jdbc:h2:file:~/DBStore/Test/
Test;CIPHER=AES;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0 08001/0

I suspected compatibility issues for the databases since my
development app I tried to deploy in production does not have any
database related changes... all I changed was just some GUI effects.

I went ahead to replace the 1.2.132 jarSmall to a 1.2.137 jarSmall and
everything starts to work again.

I am pretty convinced this is some sort of compatibility issues.

Is there an internal mechanism in H2 that does a check for backwards
compatibility issues ?

-- 
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.

Re: Incompatibility between 1.2.132 and 1.2.137 jarSmall

[Thotheolh]

Yes, it's file based access.

What I did was just include the h2 jar file into the classpath and run
them for the applications. only by upgrading the h2 jarfile for my
production version did it work with my codes that are compiled while
using the 1.2.137 version of H2 for development.

For the web console, I just double clicked on the H2's 1.2.137 main
jar file which would auto launch a web app and from that h2 console
web app, i attempted to access the JDBC url but it did not work until
I replaced the old h2 with a new one and ran the production app once
(which became successful due to the change of the h2 database) then
did the web app began to work.

My production database files and development database files' jdbc url
are different to prevent conflict of database data btw.

On Aug 8, 3:03 pm, Christian Peter 
wrote:
> Hi,
>
> there is no special mechanism other than an internal TCP protocol
> version number which isn't used in your case (since it's file:
> access).
>
> Is this right?
>
> - New application
> - Old driver 1.2.132
>
> How do you access the "old driver" with your 1.2.137 web console?
>
> Regards
>
> Christian
>
> On Aug 8, 5:54 am, Thotheolh  wrote:
>
>
>
> > Hi. I am having an app that is using jarSmall 1.2.132 in production
> > environment while my in development app is using the 1.2.137 jarSmall.
> > I generated a main jarfile for the development app and replaced the
> > production main jarfile without changing the lib jars or any other
> > things. It seems to throw an error for getting the connection.
>
> > Here is by JDBC: jdbc:h2:file:~/DBStore/Test/
> > Test;CIPHER=AES;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0
>
> > I used my own 1.2.137 web console to attempt to interact and it throws
> > the following error:
>
> > No suitable driver found for db.connection=jdbc:h2:file:~/DBStore/Test/
> > Test;CIPHER=AES;TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0 08001/0
>
> > I suspected compatibility issues for the databases since my
> > development app I tried to deploy in production does not have any
> > database related changes... all I changed was just some GUI effects.
>
> > I went ahead to replace the 1.2.132 jarSmall to a 1.2.137 jarSmall and
> > everything starts to work again.
>
> > I am pretty convinced this is some sort of compatibility issues.
>
> > Is there an internal mechanism in H2 that does a check for backwards
> > compatibility issues ?

-- 
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.

FOG algorithm

[Thotheolh]

My personal opinion is that rather then hiding data using a
cryptographically weak algorithm, why not use something like XTEA
which is already in-built and is fast, small and is fairly strong
cryptographically ?

Hiding text and data away from text editors is not a very good use
case. It's better to just encrypt and decrypt the text as it's more
secure but if it's about speed, then use XTEA.

-- 
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.

Re: FOG algorithm

[Thotheolh]

Hi. It's good to know that FOG is a faster and AES and XTEA but it's
apparent insecurity is still insecurity.

It's the same as hiding the house key under the door mat and the
concept of using 'unauthorized decryption is illegal' would not have
much impacts because even up till now, there are still so many people
cracking and hacking games... softwares...etc...regardless how legal
or illegal it is.

To protect data, it needs something solid like AES ecryption with a
good and strong password and mechanisms in-built to make it very very
tough for attackers.

Using concepts of legal or illegal is not very viable and flimsy way
to protect data.

I would like to suggest that if H2 wants to protect data, use the
AES / XTEA which H2 already have.

It has always been a trade off between security and speed.

Security via obscurity is not a good way to protect data.

This is my few cents worth of personal opinion.

Regards,
Thotheolh.

On Aug 25, 1:11 am, Thomas Mueller 
wrote:
> Hi,
>
> > My personal opinion is that rather then hiding data using a
> > cryptographically weak algorithm, why not use something like XTEA
> > which is already in-built and is fast, small and is fairly strong
> > cryptographically ?
>
> Originally, the main reason to support XTEA was speed. But I found out
> that XTEA is actually slower than AES (at least it's slower using Java
> 6 on Mac OS). Therefore, most likely XTEA will be removed in future
> version of H2 (maybe H2 1.4.x, not sure yet).
>
> The main reason for FOG is speed. It's much faster than AES and XTEA.
> It's not secure; probably it's relatively easy to write program to
> decrypt a database encrypted with FOG (I didn't do that so far, but I
> do consider trying to write one). I'm not sure if it does make sense
> to support FOG. It's just an added barrier so that data is not stored
> in clear text, but the barrier is low (which is documented). But I
> could argue unauthorized decryption is illegal, therefore FOG is safe
> unless the attacker does something illegal :-)
>
> Regards,
> Thomas

-- 
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.

Why is this statement not accepted

[Thotheolh]

May I know why this SQL statement doesn't work ?

UPDATE USERBASE
SET USERNAME = ? , PASSWORD = ? , REQUIRED_PLACE = ?
WHERE USERNAME = ? , PASSWORD = ? , REQUIRED_PLACE = ?

The Schema states that username, password and required_place are all
primary key.

ALTER TABLE PUBLIC.USERBASE ADD CONSTRAINT PUBLIC.USERBASE_PK PRIMARY
KEY(USERNAME, PASSWORD, REQUIRED_PLACE);

I would like the above to execute. How should I allow all fields to be
editable ?

Is it possible to obtain and make use of some sort of in-built system
row id if the above is not possible ?

-- 
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.

Re: Why is this statement not accepted

[Thotheolh]

Ops... sorry... forget about that. Lol.

On Sep 15, 12:21 pm, Peter  wrote:
> This has nothing to do with primary keys. The WHERE clause syntax
> needs
> AND in place of the commas.
>
> On Sep 15, 11:52 am, Thotheolh  wrote:
>
>
>
> > May I know why this SQL statement doesn't work ?
>
> > UPDATE USERBASE
> > SET USERNAME = ? , PASSWORD = ? , REQUIRED_PLACE = ?
> > WHERE USERNAME = ? , PASSWORD = ? , REQUIRED_PLACE = ?
>
> > The Schema states that username, password and required_place are all
> > primary key.
>
> > ALTER TABLE PUBLIC.USERBASE ADD CONSTRAINT PUBLIC.USERBASE_PK PRIMARY
> > KEY(USERNAME, PASSWORD, REQUIRED_PLACE);
>
> > I would like the above to execute. How should I allow all fields to be
> > editable ?
>
> > Is it possible to obtain and make use of some sort of in-built system
> > row id if the above is not possible ?

-- 
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.

Re: FOG algorithm

[Thotheolh]

Hi Thomas.

I used version 1.2.143 to open a database created using 1.2.137.
Versions like 1.2.137 are non-FOG since they don't contain the FOG
security feature. Good to note that non-FOG versions could still be
accessed.

I used the 1.2.143 version to create a database and populate it as I
have done with the exact same data I used to populate in the 1.2.137
version. I opened the database file for 1.2.137 and 1.2.143 and
spotted the plain text data I have inserted in the FOG and non-FOG
version. I used GNU emacs to open the database files.

Do I need to use some paramters to enable FOG in 1.2.143 or is it
transparent to the users and integrated into H2 ?

I have non-FOG versions currently deployed in my applications I am
developing since i am concerned of the maturity of FOG and how it may
generate any impacts.

Would there be any impacts if I replace my 1.2.137 H2 jar files with
1.2.143 jar files e.g. compatibility issues ?

Regards,
Thotheolh.

On Aug 28, 3:58 pm, Thomas Mueller 
wrote:
> Hi,
>
> > We also can suggest Thomas to use ROT13. This is even more faster...
>
> Yes, but the data doesn't look as random as withFOG.
>
> Regards,
> Thomas

-- 
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.

Re: Help me pls, pls : help me god

[Thotheolh]

Please disassociate religious stuff from tech stuff. Thank you.

> org.h2.jdbc.JdbcSQLException: Wrong password format, must be: file
> password  user password [90050-102]

The above error is a likely indicator that your database file was
encrypted.

Most of the time, when you use encrypted database mode for H2, you
would need your password in "" format.

Judging from both of your two JDBC urls, you did not specify the use
of encryption mode and that is the problem.

It is more likely that previously, your H2 database was created with
encryption mode either in XTEA or AES mode switched on 'CIPHER=;' appended to the rear of the url as a parameter for H2.

So now what you need is to find out which encryption was used (XTEA or
AES) when the database was created and find out the encryption
password.

if you could not find the encryption password, there is no way around
it to read the data as it is encrypted data (no backdoors).

-- 
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.

Re: File format of the .h2.db file

[Thotheolh]

I think there is no documentation for either the old or new h2
database files. I have been searching for them in the documentations
for sometime and there were none to be found. It is better off using
them standard H2 engine to handle databases.

Regards,
Thotheolh.

On Oct 29, 4:27 am, sheng  wrote:
> Hi,
>
> I've been looking around for the document that explains the detail of
> the file format of the h2 db file, but couldn't find any. Is there any
> documents that explains the file format of the .h2.db file? So
> that I can know how to interpret the header of the db file, and also
> understand how does tables and rows being stored in the .h2.db
> file.
>
> Regards,
> Sheng

-- 
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.

Re: h2small.jar vs. regular database

[Thotheolh]

H2 jarSmall:

 - You don't get to use any form of console (CLI or Web).
 - No web server / tcp server (which means no SSL / TLS).
 - No clusters
 - Password hash is available
 - Encrypted database (AES / XTEA)
 - You don't get upgrades unless a new jarSmall is made to replace it.

The main H2 jar file contains all the features but H2 jarSmall is a
"slimmed down" version for embedding into lightweight applications.

Regards,
Thotheolh.

On Nov 2, 1:13 pm, Terence Truong  wrote:
> Hello,
>
> What is the differences between the h2small.jar file that you get when
> you run build.sh jarSmall other than the size?
>
> The reason I am asking is because I would like to use the h2small.jar
> in my android device, but need to be able to use the advance features
> of h2database like:
>
> 1. SSL/TLS Connections
> 2. Clustering / High Availability
> 3. Password Hash
> 4. Security Protocols
> 5. Database Upgrades
>
> Thank you.

-- 
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.

Re: h2small.jar vs. regular database

[Thotheolh]

What do you want your android to do or have what features ?


On Nov 3, 6:22 am, Terence Truong  wrote:
> Hello Thotheolh,
>
> Thank you for that explanation. I may have to start looking for a
> different way of working h2database into my android setup.
>
> Thanks again,
>
> Terence
>
> On Nov 2, 8:59 am, Thotheolh  wrote:
>
> > H2 jarSmall:
>
> >  - You don't get to use any form of console (CLI or Web).
> >  - No web server / tcp server (which means no SSL / TLS).
> >  - No clusters
> >  - Password hash is available
> >  - Encrypted database (AES / XTEA)
> >  - You don't get upgrades unless a new jarSmall is made to replace it.
>
> > The main H2 jar file contains all the features but H2 jarSmall is a
> > "slimmed down" version for embedding into lightweight applications.
>
> > Regards,
> > Thotheolh.
>
> > On Nov 2, 1:13 pm, Terence Truong  wrote:
>
> > > Hello,
>
> > > What is the differences between the h2small.jar file that you get when
> > > you run build.sh jarSmall other than the size?
>
> > > The reason I am asking is because I would like to use the h2small.jar
> > > in my android device, but need to be able to use the advance features
> > > of h2database like:
>
> > > 1. SSL/TLS Connections
> > > 2. Clustering / High Availability
> > > 3. Password Hash
> > > 4. Security Protocols
> > > 5. Database Upgrades
>
> > > Thank you.

-- 
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.

Re: H2 DB filename

[Thotheolh]

There isn't any known way to do so and .h2.db is the default h2
storage file format in the latest versions of H2 databases.

Why would you need to rename the h2 database file extension ?

On Nov 3, 11:44 pm, timbo  wrote:
> Is there a way to force H2 not to append .h2.db to the filename?
> Thanks in advance!

-- 
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.

File extension independent H2 format

[Thotheolh]

I was reading the forum and noticed that there are requests to change
file extensions or to somehow customize extensions.

I would like to propose a method in H2 format that would make H2
discoverable and independent from file extension format so to give
freedom for people to have any extension they want for the H2 database
files they would like to name it as.

H2 in Page Store format seems to have a header that says "-- H2 0.5/B
--" and it may have three lines of that header. It could be used to
identify H2 files from other files by the header rather then file
extensions and so users can simply make up their extensions as they
want as long as the header is intact.

H2 could also allow users to target specific database files .e.g. "~/
DB/MyDbFiles.myExt" so by doing that, users could have their own
extensions as long as the files have the correct formatting. H2 would
need to read the header of the file and check basic formatting to
positively ID that the file is genuinely H2 too.

I know H2 have trace and log files too and the ability to extend the
proposed ability to allow users to have free control over the file
extensions do apply. I would like to propose a change of H2 header
format to allow the extensibility and unify formats across H2.

Below is my proposal and is designed to have as minimal disruptions as
possible to the current H2 format if possible.

Skeletal format:
--H2/--
Example: "-- H2 0.5/B D 1.2.147--" means: H2, version 0.5 protocol
Beta and filetype: D. Engine of creation is 1.2.147 database.

The format should be able to accept users who refuse to include the
engine version in case they do not wish to specify which version of H2
they are using to create the database.

Datatype available:
B - blobs
C - clobs
D - normal database file
T - trace / log files

End of file format:
-- H2 eof -- //H2 end of file
It is not necessary to have eof (end-of-file) but it is a good
practise to do so.

Possible drawbacks:
 - Slower engine ? Could be tweaked and enhanced just to handle it.
 - Additional space for headers and eofs ? Not really big actually.
 - Changing H2 page store format versions is troublesome ? Proper and
lightweight conversion / file IO tools.
 - "Header overload" syndrome whereby taking advantage of
extensibility of header, could dump all information  and metadata into
header ? Strict formatting of header.

Possible advantages:
 - Clearer distinction by using a better header and possibly with eofs
(enders).
 - Customizability of file extensions
 - Protocol longevity and extensibility.

For those who may want to compare headers and everything:

Currently some H2 have 3 lines of "-- H2 0.5/B --" but it could be
reduced to 1 single line of header as I proposed.
I estimate that 3 lines of the current H2 header is 14 characters in
UTF-8 and in total 3 lines which is about 336 bits or 42 bytes.
(Disclaimer: I cannot say this numbers are correct to the point as I
am no expert in H2 format.)

With the proposed headers and eofs with only 1 line needed for header
and an optional eof including optional specification of type of
database engine being used in creation of file: 35 characters in UTF-8
= 280 bits or 35 bytes.

Additional goodies:
If you have a header and a eof I proposed, you can add additional data
in front of the header and end of eof in the below manner which can
make the file even more flexible to your liking.

...your other stuff...

//Main H2 data
-- H2 0.5/B D 1.2.147--

-- H2 eof --

 //Another H2 CLOB stored
-- H2 0.5/B C 1.2.147--

-- H2 eof --

 //Another H2 Trace stored
-- H2 0.5/B T 1.2.147--

-- H2 eof --

... your other stuff ...

What happens is that you could literally add stuff before and after H2
data and maybe you could store blobs, normal h2 data and logs together
in a file but the bad thing is once the file is gone, all is lost.
Another possible thing is that you can store multiple instance of H2
databases and H2 items in a single file but that is really really
complex.

Thanks for reading this really long message post. Thanks

Regards,
Thotheolh.





-- 
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.

Re: File extension independent H2 format

[Thotheolh]

It's true that H2 should be in-charge of the H2 data and the proper
practise for most of the file formats out there is to not add
unnecessary data to protect file integrity and that's true.

Do post your opinions here and add in ideas you have if you want
to. :D

Regards,
Thotheolh.

-- 
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.

Re: H2 Database Engine: New version 1.3.148 Beta available

[Thotheolh]

Hi. The change log states that:

* The database upgrade (to upgrade from H2 version 1.1.x) has been
simplified.

Does this mean that upon using this 148 version, it would
automatically upgrade old database format to page store without
additional stuff like some old H2 database engine jar files or
conversion jar files ?

On Dec 12, 7:57 pm, Thomas Mueller 
wrote:
> Hello,
>
> A new version of H2 is available athttp://www.h2database.com
> (you may have to click 'Refresh').
>
> For details, see the 'Change Log' 
> athttp://www.h2database.com/html/changelog.html
>
> For future plans, see the 'Roadmap' page 
> athttp://www.h2database.com/html/roadmap.html
>
> P.S. If you reply to this message please use a different subject.
>
> Have fun,
> Thomas

-- 
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.

Version 1.3.148 database upgrade function

[Thotheolh]

Hi. The change log states that:

* The database upgrade (to upgrade from H2 version 1.1.x) has been
simplified.

Does this mean that upon using this 148 version, it would
automatically upgrade old database format to page store without
additional stuff like some old H2 database engine jar files or
conversion jar files ?

-- 
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.

Re: File extension independent H2 format

[Thotheolh]

Hi. Thomas, I think using a long string like 'h2database.xxx' maybe
abit too long. I think it is better to have as short a header as
possible to reduce space needed for header. Indeed the main header
data should not be changed else risk corrupting the data.

Thomas, why does the second and third line of the '-- H2 0.5/B --' may
get encrypted for encrypted databases ? Is it use as some kind of
string to check if decryption succeed ? If it is so, maybe a shortened
check string like '-- c --' or '? c ?' could come in handy and only
use a single string rather then a couple of them.

To bundle clob and blobs into the main database files can make the
main database file very bulky and slow down H2 significantly. It is
better to leave clobs and blobs on their own for now rather then
allowing them to slow H2 i guess.

Regards,
Thotheolh.

-- 
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.

Re: i want to add anything new to H2 database a my course subject.

[Thotheolh]

Hi. This is a discussion discussing H2 database technology. Please
respect this area as a discussion for H2 technology, not a project or
homework help area unless it is related to H2 database. We do not give
homework or project implementation ideas here.

Do you have a specific valid question to ask in this forum e.g. some
problems with using H2 database, some patches, some features, bugs or
problems with H2 database or some doubts about H2 database which may
may try to help ?

Do go to Java Ranch (www.javaranch.com), Stack Overflow
(www.stackoverflow.com) or other reputable Java or technology forums
for help if you have problems with implementations or technology. Note
that Stack Overflow have a H2 tag where questions on H2 database can
be posted and answered too.

-- 
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.

Re: H2 Database (embedded) connection timeout

[Thotheolh]

Your JDBC String:"jdbc:h2:C:\Users\Michael\.myadd
\db;AUTO_SERVER=TRUE;CIPHER=AES", includes a server. I think that's
why it timed out because of the server. Why do you open a server when
you are attempting to use embedded mode ?

-- 
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.

Re: H2 Database (embedded) connection timeout

[Thotheolh]

By the way, you can use '~' character in your JDBC URL String to
represent user home folder. Something like 'jdbc:h2:~/.myadd/db'.

-- 
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.

Re: Corrupted LobStorage when LOBs are in database

[Thotheolh]

Hi. Can you post a trace log here ? It would be easier to know what
went wrong with a trace log.

-- 
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.

Re: File extension independent H2 format

[Thotheolh]

Hi Thomas. It's true that the advantages and disadvantages are as you
said but would a single storage file slow down H2 engine from looking
for and getting or writing data since all the clobs and blobs which
can be rather huge, are bunched together with the main database too ?

> > To bundle clob and blobs into the main database files can make the
> > main database file very bulky and slow down H2 significantly.
>
> There are many advantages to use one file, for example it prevents the
> 'too many open files' problems. Also, there are many problems because
> of lost / deleted files. De-duplication is easier. One disadvantage is
> that the database file can't shrink quickly after deleting many LOBs.

Regards,
Thotheolh.

-- 
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.

Re: File extension independent H2 format

[Thotheolh]

That's a good idea using one for normal tables and the other for huge
storages. It did propose to split the huge storage to CLOBS and BLOBS
so that there wouldn't be a need to mix binary and character based
storage and make it hard for locators to locate resources.

Regards,
Thotheolh.

On Dec 18, 3:49 am, Dario Fassi  wrote:
> Hi,
> What think you of using only 2 files, one for all normal columns and 
> otherspecialized for long data types(LOBS).
> Something similar to "Regular Tablespaces" and "Large Tablespaces" in oldies 
> DB2s.
>
> That way you have both goodies, only two files and one of them specialized 
> fileStore to contain all lobs columns ( used only if lobs are referenced) , 
> that can facilitate locator's implementation too.
>
> regards,
> Dario.

-- 
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.

Re: File extension independent H2 format

[Thotheolh]

It would be good if H2 could finally squeeze clobs and blobs and all
the data storage into a single file without an significant drop of
performances.

It would be so much easier to handle a single H2 data file then handle
seperated files.

Maybe the H2 data files containing all the data has some sort of data
compression in-built into it by default ?

I think the meaning of 'facilitate locator's implementation' in the
previous reply meant that every time data is fetched from the
database, it is usually sequential from the head to the end of the
data file. If all the data are mixed into just one file (especially
clobs and blobs) which sometimes can have too much data to be loaded
into the memory for caching, when a read operation is done (and the
data or data sets are too big to be stored into a memory cache), data
have to be read sequentially and it would take alot of time to do so.

I am not very good at file based data storage operations since I don't
have much experience in creating database engines. Generally, what
would be used so that blobs and clobs could be stored together in the
same database file as the main data without affecting database
performances ?

Regards,
Thotheolh.

-- 
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.

Is H2 license compatible with LGPL ?

[Thotheolh]

Hi. Thomas Mueller, I would like to know if H2 license is compatible
with LGPL v3 license ? My software I am developing would contain some
fragments of H2 codes primarily used to complement H2 functions.

Is it OK to use LGPL license for my software (operates using H2
database and some H2 codes) ?

-- 
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.

Re: problem using Lucene again

[Thotheolh]

Have you tried the latest version 1.3.148. The version you are using
is very very old and should be updated as soon as possible since the
latest builds may include fixes to certain problems.

Lucene is built by Apache Lucene and H2 simply just use the Lucene
engine as a feature.

Please be patient with the H2 support.

Thanks and Regards,
Thotheolh. (A H2 database consumer).

-- 
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.

PasswordStore - H2 Password Manager

[Thotheolh]

Hi Thomas,

I have used H2 jarSmall as the database backend engine to power
PasswordStore, a lightweight password manager.

It uses some H2 codes for AES Encryption and Hashing to complement for
the apparent lack of these functions in jarSmall variants. It also
includes some hacking just to create my version of the database backup
and restore features since jarSmall also do not have such a support.
By the way, jarSmall is used because it doesn't need the bulk of a
full H2 database server and all it's features (TCP, Web, SSL, Console,
JaQU, FOG  ) so abit of haking is required.

The H2 codes still retain their H2 license while the native
PasswordStore codes would simply use the LGPL v3.

This FOSS product is now ready for use and download.

The links are below:
https://sites.google.com/site/thothtech/product-release/passwordstore
http://freshmeat.net/projects/passwordstore
https://launchpad.net/passwordstore

Thanks and Regards,
Thotheolh.

-- 
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.

Re: PasswordStore - H2 Password Manager

[Thotheolh]

The AES Encryption and Hashing access is for the API access (to
encrypt database backups which H2 jarSmall lacks this feature) . The
database is simply encrypted by appending the CIPHER=AES; keyword to
the JDBC as per normal.

On Jan 2, 9:52 pm, Thotheolh  wrote:
> Hi Thomas,
>
> I have used H2 jarSmall as the database backend engine to power
> PasswordStore, a lightweight password manager.
>
> It uses some H2 codes for AES Encryption and Hashing to complement for
> the apparent lack of these functions in jarSmall variants. It also
> includes some hacking just to create my version of the database backup
> and restore features since jarSmall also do not have such a support.
> By the way, jarSmall is used because it doesn't need the bulk of a
> full H2 database server and all it's features (TCP, Web, SSL, Console,
> JaQU, FOG  ) so abit of haking is required.
>
> The H2 codes still retain their H2 license while the native
> PasswordStore codes would simply use the LGPL v3.
>
> This FOSS product is now ready for use and download.
>
> The links are 
> below:https://sites.google.com/site/thothtech/product-release/passwordstorehttp://freshmeat.net/projects/passwordstorehttps://launchpad.net/passwordstore
>
> Thanks and Regards,
> Thotheolh.

-- 
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.

Re: H2 Database Engine: New version 1.3.149 (Beta) available

[Thotheolh]

The changelog contains two 1.3.148 beta instead of a 1.3.149 beta
changelog.

On Jan 7, 3:57 pm, Thomas Mueller 
wrote:
> Hello,
>
> A new version of H2 is available athttp://www.h2database.com
> (you may have to click 'Refresh').
>
> For details, see the 'Change Log' 
> athttp://www.h2database.com/html/changelog.html
>
> For future plans, see the 'Roadmap' page 
> athttp://www.h2database.com/html/roadmap.html
>
> P.S. If you reply to this message please use a different subject.
>
> Have fun,
> Thomas

-- 
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.

Re: H2 Database Engine: New version 1.3.149 (Beta) available

[Thotheolh]

The changelog contains two 1.3.148 beta changelog instead of a 1.3.149
beta changelog.

On Jan 7, 3:57 pm, Thomas Mueller 
wrote:
> Hello,
>
> A new version of H2 is available athttp://www.h2database.com
> (you may have to click 'Refresh').
>
> For details, see the 'Change Log' 
> athttp://www.h2database.com/html/changelog.html
>
> For future plans, see the 'Roadmap' page 
> athttp://www.h2database.com/html/roadmap.html
>
> P.S. If you reply to this message please use a different subject.
>
> Have fun,
> Thomas

-- 
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.

Re: H2 support experts for hire??

[Thotheolh]

I think the best expert on H2 is still here in the forums where Thomas
Mueller could provide support and response.

-- 
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.

Re: How can i deploy my java application with H2 database ?

[Thotheolh]

You could look at this Java project called 'localdb' in Google Codes:
http://code.google.com/p/localdb/

The wiki page have methods of usage. It simply locates the current URL
of your portable apps and retrieves it's URL and then you append to
usual 'jdbc:h2:file:' in front fo the retrieved URL and the database
name behind the URL. You can modify it for your own use. This is kind
of hacking based method to get it running though.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: Recommendation

[Thotheolh]

Hi. Could you provide more details on what you are trying to do ?

Regards,
Thotheolh.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: NPE on executeQuery (on 1.3.148)

[Thotheolh]

Please post your schemas, database connection jdbc urls and trace logs
if possible or maybe a viable test case where it could be reproduced.
The information you gave was too little.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: Purge Data / Permanently Delete

[Thotheolh]

If the table concerned are disk-based data, then you need to
cryptographically wipe it which is not supported here. Another way is
to encrypt your database to begin with so that even if the files are
recovered, they are still encrypted anyway.

If it's a memory-based database for temporary storage, then a reboot
of the hardware could clean it up for sure but in database servers,
it's going to be hard to simply reboot as and when you like and
setting the values to something else does not guarantee the data in
the temporary memory has been cleaned out.

Whatever ways, I think the best way for disk-based databases is to
encrypt it in the first place and never to store passwords in
configuration files (in case they recovered your configuration files)
and for memory-based, you need to reboot the hardware.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: Purge Data / Permanently Delete

[Thotheolh]

Removing primary key values and timestamps does minimal things. Anyone
with the tools, knowledge, will and if possible, backed by a legal
warrant, can use legal resources to dig up 'removed' data.

You need to consider that there are temp files, file slacks, memory
slacks... especially in the NTFS filesystem which may contain residues
of unencrypted database files that have been supposedly 'deleted'.

It is still best to encrypt the file from the very start of it's
creation so that the fragments of it, even if retrieved and recovered,
would still have to bypass the AES 128 encryption H2 uses for
encrypted storage if you use it's option right from the start.

Removing values selectively or randomly from a file can be recovered
via computer forensics mean and thus insecure.

Leaving the database unencrypted in the beginning and later on encrypt
it, I am afraid some fragments may have been somewhere in the disk
where it can be recovered.

If you are not allowed to encrypt the database, and you try to encrypt
just the blobs, the other data in the main database (non-lobs) would
simply betray the contents of the blob and also, simply selectively
encrypting only blobs or selective manipulation parts of H2 data is
not in H2 features unless you want to make your own libraries to
compliment it.

> The database is disk-based..
> Yes, encrypting the database would work but unfortunately that is not
> an option for reasons i cannot disclose.
>
> Simply wiping all traces of the primary key values and timestamp
> columns for each row would be enough i suppose...
>
> I might encrypt the blobs to work around that problem maybe.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: script file data.db

[Thotheolh]

By all means, you should NOT manipulate a raw database file of any
database. It is way too dangerous to manipulate a raw database file.
Use the interfaces it provides to interact with the data stores rather
than raw manipulation of data files. The '.data.db' is an old H2
format and the current version of H2 file format is '.h2.db'.

Do look into upgrading your H2 to the latest version.

H2 has it's unique format for database. It is not totally UTF8 so most
text editors would detect it as some weird bunch of texts and may
reject to read it. GNU Emacs is capable of reading it as it reads the
bytes and it could read it in hex as well. Even with Emacs, you need
to be prepared to look into a pile of hex codes (I have tried to dig
into the data files in the past) and it ain't nice to do so.

Regardless of reasons, you NEED to use an interface to interact. A
documentation of the H2 format is not yet out in my knowledge.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: Purge Data / Permanently Delete

[Thotheolh]

When you attempt to overwrite a value on a hard drive, Java doesn't
have the final say which place or sector it has to do so and therefore
there is no gaurantee whatsoever that the 'replaced value' is 'wiped'.
The only way to secure a data via encryption is to create the file as
encrypted right from the start because the enciphered data, regardless
the fragmentation of the file in the file system, would still be
encrypted. If you have used a file that is not encrypted right from
the start, you may need to handle chances of slack spaces,
fragmentations, temp files...etc. which allows fragments of
unencrypted file data to be thrown all over the hard disk.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: Auto_increment(1, 1) sometimes goes haywire

[Thotheolh]

Have you tried it on the latest 1.3.150 ?

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: Suggestions for extending/enhancing H2

[Thotheolh]

You could take a look at the road map and select the features you want
to help build and make a patch and submit here to this forum.

It would be great to have contributions here.

On Feb 13, 7:37 am, Philip Lee  wrote:
> Hello,
>
> I'm part of a group of graduate students at the University of Illinois
> and we've been tasked, as part of a course on databases, to add novel
> or interesting functionality to an open source database.  Details
> here:https://agora.cs.illinois.edu/display/cs411sp11/Project+Track+2
>
> I've used H2 in the past and found it very good and so I'd love to be
> able to commit something back to the community.  Does anyone have any
> suggestions for things that you'd like to see tried out?  Anything
> wacky that you haven't had time to experiment with?  I had a look at
> the roadmap on the website but it's a little overwhelming.  Any
> comments would be much appreciated.
>
> Thanks,
> Phil Lee

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: H2 Database Engine: New version 1.3.151 available

[Thotheolh]

Hi Thomas. When would H2 have the Beta status removed and transit to
something like a stable build ?

On Feb 12, 10:44 pm, Thomas Mueller 
wrote:
> Hello,
>
> A new version of H2 is available athttp://www.h2database.com
> (you may have to click 'Refresh').
>
> For details, see the 'Change Log' 
> athttp://www.h2database.com/html/changelog.html
>
> For future plans, see the 'Roadmap' page 
> athttp://www.h2database.com/html/roadmap.html
>
> P.S. If you reply to this message please use a different subject.
>
> Have fun,
> Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: Performance Improvements

[Thotheolh]

Do you have the test case available where it could be reproduced and
uploaded here ?

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.

Re: H2 Database Engine: New version 1.3.152 (Beta) available

[Thotheolh]

Hi Thomas. Your changelog is not updated for 1.3.152.

On Mar 2, 4:07 am, Thomas Mueller 
wrote:
> Hello,
>
> A new version of H2 is available athttp://www.h2database.com
> (you may have to click 'Refresh').
>
> For details, see the 'Change Log' 
> athttp://www.h2database.com/html/changelog.html
>
> For future plans, see the 'Roadmap' page 
> athttp://www.h2database.com/html/roadmap.html
>
> P.S. If you reply to this message please use a different subject.
>
> P.P.S. This is the last beta unless bigger problems are found. There
> will be another release (non-beta) next week.
>
> Have fun,
> Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@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.