• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Ganesh Patekar
  • Frits Walraven
  • Tim Moores
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Stephan van Hulst
  • salvin francis
  • Tim Holloway

HSQLDB Table  RSS feed

 
Ranch Hand
Posts: 473
  • 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


 
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use SqlTool: http://hsqldb.org/web/hsqlDocsFrame.html
 
Rancher
Posts: 42974
76
  • 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: 473
  • 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: 473
  • 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!