hi all,
I am extremely sorry that I have kept you and myself puzzled for a few days now. The mistake was mine.
My hsqldb jar file that I downloaded with defective!
So I was having problem.
I downloaded other versions like hsqldb_1_4_4_src, hsqldb_1_6_1_src,
hsqldb_1_7_2_11 and 1_7_3_3, and hsqldb_1_8_0_9 of using a download utility and I got the table I wanted using version 1.7.2.11
So sorry.
For smaller to medium size project where there is not complexity regarding databases, I like SimpleText Driver database. It is fast.
To retrieve the same type of data in SimpleText, Ms Access, Hypersonic, on windows
I got these times:
SimpleText 73 milliseconds
Ms Access 493 milliseconds
Hypersonic above 1000 milliseconds
Thanks,
Maki Jav
Simple Text