wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes HSQLDB Beginning Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "HSQLDB Beginning" Watch "HSQLDB Beginning" New topic
Author

HSQLDB Beginning

Akhilesh Trivedi
Ranch Hand

Joined: Jun 22, 2005
Posts: 1526
I have hsqldb-1.8.0.7.jar with me, is it enough for me to start constructing and using database ? How do I achieve this ? Any initial setup-guides/pointers/links. Unfortunately I have nothing else other than the jar and neither can I download anything else. Thanks!


Keep Smiling Always — My life is smoother when running silent. -paul
[FAQs] [Certification Guides] [The Linux Documentation Project]
Akhilesh Trivedi
Ranch Hand

Joined: Jun 22, 2005
Posts: 1526
This one got me going.

http://www.coderanch.com/t/553739/java/Unable-create-hsqldb-spring

Thanks for watching
Akhilesh Trivedi
Ranch Hand

Joined: Jun 22, 2005
Posts: 1526
However I don't find this driver class....

Class.forName("org.hsqldb.jdbc.JDBCDriver" );
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

Where were you looking for that class, then?
Akhilesh Trivedi
Ranch Hand

Joined: Jun 22, 2005
Posts: 1526
Thanks Paul, I got the class in another jar "hsqldb-2.0.0.jar". However my first program is yet to be executed.


On doing

I get the UI opened and there if I do select * from customer I get around 50 rows returned. But the same in above code doesnt work. on line 6 I get an

java.sql.SQLException: user lacks privilege or object not found: CUSTOMER



My Server start up sequence was as follows


I am on eclipse and have this hsqldb-2.0.0.jar added on build path. Any help? Thanks!
Akhilesh Trivedi
Ranch Hand

Joined: Jun 22, 2005
Posts: 1526
Worked changed line 5 as below
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HSQLDB Beginning
 
Similar Threads
HSQLDB Log Problem
Problems Starting HSQLDB server
HSQLDB and running the scripts in manual installation
not persisting in HSQLDB
HSQLDB Installation