HSQLDB Table

[Maki Jav]

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

    
String url="jdbc:hsqldb:htest;ifexists=true";
String driver="org.hsqldb.jdbcDriver";
try{
Class.forName(driver);
Connection con=DriverManager.getConnection(url);
 

Statement st=con.createStatement();
 

st.execute("CREATE TABLE PROPTYPE ("+
"TYPEID NUMERIC,"+
"TYPE VARCHAR);"
 
);
 

st.execute("INSERT INTO PROPTYPE (TYPEID,TYPE)"+
" VALUES ("+
"1,"+
"'FLAT');");
st.execute("INSERT INTO PROPTYPE (TYPEID,TYPE)"+
" VALUES ("+
"2,"+
"'BUNGLOW');");
con.close();
 
System.out.println("CONNECTION CLOSED SUCCESSFULLY. "+(System.currentTimeMillis()-start));
 

}
catch(ClassNotFoundException cnfe){System.out.println(cnfe);}
catch(SQLException e){System.out.println(e);}
 

[Walter Bernstein]

Use SqlTool: http://hsqldb.org/web/hsqlDocsFrame.html

[Ulf Dittmer]

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.)

catch(ClassNotFoundException cnfe){System.out.println(cnfe);}
catch(SQLException e){System.out.println(e);}

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]

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]

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