Re: [vox-tech] hsqldb

2011-03-23 Thread Bill Kendrick
On Tue, Mar 22, 2011 at 10:42:25AM -0700, Brian Lavender wrote:
 Many of you have probably used HSQLDB without realizing it. 
 OpenOffice uses it!

Hey that reminds me, can I get your slides/notes/example code from
Monday's talk?  Thanks!

-bill!
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] hsqldb

2011-03-23 Thread Brian Lavender
The example I referenced was taken from Harnessing Hibernate. I will
put together some slides/notes. 

On Wed, Mar 23, 2011 at 01:25:53PM -0700, Bill Kendrick wrote:
 On Tue, Mar 22, 2011 at 10:42:25AM -0700, Brian Lavender wrote:
  Many of you have probably used HSQLDB without realizing it. 
  OpenOffice uses it!
 
 Hey that reminds me, can I get your slides/notes/example code from
 Monday's talk?  Thanks!
 
 -bill!
 ___
 vox-tech mailing list
 vox-tech@lists.lugod.org
 http://lists.lugod.org/mailman/listinfo/vox-tech

-- 
Brian Lavender
http://www.brie.com/brian/

There are two ways of constructing a software design. One way is to
make it so simple that there are obviously no deficiencies. And the other
way is to make it so complicated that there are no obvious deficiencies.

Professor C. A. R. Hoare
The 1980 Turing award lecture
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


[vox-tech] hsqldb

2011-03-22 Thread Brian Lavender
Many of you have probably used HSQLDB without realizing it. 
OpenOffice uses it!

Here is some info on HSQLDB. A lot of tutorials for Java use HSQLDB, but
you can use HSQLDB with PERL too. You can start an HSQLDB server with a
single command. The following will start a database with called EMPLOYEE.

java -cp path to/hsqldb.jar org.hsqldb.Server -database.0 file:db/employee 
-dbname.0 EMPLOYEE

The data for EMPLOYEE will be stored in the sub-directory db.

HSQLDB comes with a nice GUI tool too! 

java -cp path to/hsqldb.jar org.hsqldb.util.DatabaseManager -driver 
org.hsqldb.jdbcDriver -url jdbc:hsqldb:hsql://localhost/empoloyee -user sa

You can download hsqldb from the below site. Thus far, I have used 1.8.0 
version. There is a new version,
but I believe it works a bit different. But,... it probably comes with more 
features.
http://www.hsqldb.org

Here is some documentation using HSQLDB with PERL.
http://hsqldb-ber.sourceforge.net/

brian
-- 
Brian Lavender
http://www.brie.com/brian/

There are two ways of constructing a software design. One way is to
make it so simple that there are obviously no deficiencies. And the other
way is to make it so complicated that there are no obvious deficiencies.

Professor C. A. R. Hoare
The 1980 Turing award lecture
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] hsqldb

2011-03-22 Thread Harold Lee
I've used HSQLDB for unit testing in the past. I wrote JUnit test
cases that access an in-memory HSQLDB database (which is created with
sample data each time the unit tests are run): very fast, and you
don't need to run a separate database server for your tests. Works
great!

Harold

On Tue, Mar 22, 2011 at 10:42 AM, Brian Lavender br...@brie.com wrote:
 Many of you have probably used HSQLDB without realizing it.
 OpenOffice uses it!

 Here is some info on HSQLDB. A lot of tutorials for Java use HSQLDB, but
 you can use HSQLDB with PERL too. You can start an HSQLDB server with a
 single command. The following will start a database with called EMPLOYEE.

 java -cp path to/hsqldb.jar org.hsqldb.Server -database.0 file:db/employee 
 -dbname.0 EMPLOYEE

 The data for EMPLOYEE will be stored in the sub-directory db.

 HSQLDB comes with a nice GUI tool too!

 java -cp path to/hsqldb.jar org.hsqldb.util.DatabaseManager -driver 
 org.hsqldb.jdbcDriver -url jdbc:hsqldb:hsql://localhost/empoloyee -user sa

 You can download hsqldb from the below site. Thus far, I have used 1.8.0 
 version. There is a new version,
 but I believe it works a bit different. But,... it probably comes with more 
 features.
 http://www.hsqldb.org

 Here is some documentation using HSQLDB with PERL.
 http://hsqldb-ber.sourceforge.net/

 brian
 --
 Brian Lavender
 http://www.brie.com/brian/

 There are two ways of constructing a software design. One way is to
 make it so simple that there are obviously no deficiencies. And the other
 way is to make it so complicated that there are no obvious deficiencies.

 Professor C. A. R. Hoare
 The 1980 Turing award lecture
 ___
 vox-tech mailing list
 vox-tech@lists.lugod.org
 http://lists.lugod.org/mailman/listinfo/vox-tech

___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech