aspose file tools*
The moose likes JDBC and the fly likes HSQLDB Table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HSQLDB Table" Watch "HSQLDB Table" New topic
Author

HSQLDB Table

Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 437
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




Help gets you when you need it!
Walter Bernstein
Ranch Hand

Joined: Dec 19, 2007
Posts: 57
Use SqlTool: http://hsqldb.org/web/hsqlDocsFrame.html
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42592
    
  65
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.


Ping & DNS - my free Android networking tools app
Maki Jav
Ranch Hand

Joined: May 09, 2002
Posts: 437
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

Joined: May 09, 2002
Posts: 437
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HSQLDB Table