[h2] Cache hits

2017-08-05 Thread vicenrico
Hello. Is there any way to know whether a database row has been loaded from the db cache and not from disk? Many thanks in advance -- 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

[h2] Database updates

2017-02-04 Thread vicenrico
Hello. I don't know how h2 database works internally, so I would like to ask a question: In my code I have this: ud3Text.addModifyListener(new ModifyListener() { @Override public void modifyText(ModifyEvent arg0) { if (!ud3Text.isFocusControl()) return;

[h2] load entire database in memory

2016-08-06 Thread vicenrico
Hello. I have a question. I'm developing a program and I would like how to improve my db scheme desing. Currently I'm developing a movie manager program with 20 tables. The main table is the movie table with 30 fields.I'd like to know whether I should load the entire table into a movies object

Best method to load a database

2012-06-17 Thread vicenrico
Hello. As I'm a newbie, I would like to better learn use of databases. Which is the best method to load a database, supposing I have about 4000-5000 rows that consist of 30 columns. I don't know if it's better to load Select * from table and load all the objects into an array or it's better

Re: Mix two different tables

2012-06-13 Thread vicenrico
Thansks for your great reply. I did this code so far. Could you have a look into it , and tell me if I'm doing something wrong?. I tell you so because for importing 4000 movies, my program needs 6 minutes, and I think is a lot... CODE ---

Mix two different tables

2012-06-12 Thread vicenrico
Hello!. I'm a software developer who has a program to catalog movies. I have two questions that I would like you to ask me, please. My program is currently version 1.0. I have a table, for example: Table (long id, long key, String title, String category, Date year ) I would like to import data

Re: Mix two different tables

2012-06-12 Thread vicenrico
Well. In fact , I would like to know if I could do the next things: 1)Open old database 2)Select tables/rows of this database and create linked tables. 3)open new database 4)Pass the data from linked tables to new tables with create table as select... However, I have the new tables created,

Range of values in SELECT * LIKE

2010-08-05 Thread vicenrico
Hello. I'm a spanish developer with a serious problem ( at least for me :-D ). How can this sentence work in h2 database? SELECT * FROM Customers WHERE Name LIKE '[aeiou]%' What i mean i that i can't do this with h2database. I want to show all customers beginning their names with a vowel. In