• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

HSQLDB Table

 
Ranch Hand
Posts: 473
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Use SqlTool: http://hsqldb.org/web/hsqlDocsFrame.html
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
reply
    Bookmark Topic Watch Topic
  • New Topic