Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HSQLDB Table

 
Maki Jav
Ranch Hand
Posts: 447
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I cannot create the a hsqldb somehow?

Does someone has a small HSQLDB table. I want to do just do some testing.

I used this class but was not able to create table with the latest version hsqldb-1.8.0.2.jar


 
Walter Bernstein
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use SqlTool: http://hsqldb.org/web/hsqlDocsFrame.html
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I used this class but was not able to create table with the latest version hsqldb-1.8.0.2.jar

What does "not able" mean? What exactly happens? (Note that 1.8.0.9 is the latest version of HSQLDB.)

You're throwing away information by handling exceptions like this. Print a stack trace instead, so that you know which line and method call causes the problem.
 
Maki Jav
Ranch Hand
Posts: 447
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ulf,

Hi again at this JDBC.

I have used the same code to make tables using M$Access and SimpleTextDriver as a test successfully. but with this version of HSQLDB I am not getting any exception. All goes okay but no metion of the data or the table in the files so created

I remember that in 2004 I used an earlier version of HSQLBD to create tables just as you would use Java code to create any other vendor database tables. obviously, the driver and database url changes.

I will use the table at my javaserver, you know about that Ulf ;)


Maki Jav
 
Maki Jav
Ranch Hand
Posts: 447
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic