table « hsqldb « Java Database Q&A

  1. Java Database Q&A
  2. hsqldb
  3. table




1. HSQLDB - Changing table mode    stackoverflow.com

Does anybody know if it's there any way one can change the mode of an existing table in a HSQLDB? By default, all of them are in memory mode, but by ...

2. hsqldb table is not empty after it has been cleared and then reconnected to    stackoverflow.com

After inserting some data and running a few queries, i decided to delete data from table. However, when i ran both TRUNCATE TABLE Mytable and DELETE FROM Mytable ,the next time i connect to ...

3. HSQLDB default_table_type not honoured in JDBC URL    stackoverflow.com

I'm using the connection URL jdbc:hsqldb:file:/data/hsqldb/mydb;hsqldb.default_table_type=cached with HSQLDB 2.1. Issuing 'CREATE TABLE' does not persist anything (there's no .data file created). Issuing 'CREATE CACHED TABLE' explicitly works correctly, however. ...

4. unable to drop table in HSQLDB    stackoverflow.com

I am unable to drop table with default user SA(or any user for that matter) in HSQLDB even though I can create table and read them without problem, please see my ...

5. How to use HSQLDB to dynamically generate tables for JDBC application    stackoverflow.com

I want to use HyperSQL as an in-memory database for integration tests of a Java - JDBC application. If I try the following: 

Properties props = new Properties();
props.put("user", "sa");
props.put("password", "");
Class.forName("org.hsqldb.jdbcDriver");
Connection cn = DriverManager.getConnection("jdbc:hsqldb:mem://localhost", ...

6. Table Not Found in hsqldb    coderanch.com

7. HSQLDB Table    coderanch.com

8. HSQLDB Text Table Performance    coderanch.com

I am developing a application that uses HSQLDB. I have created cached tables in HSQLDB. I read that cached tables give low performance and text tables give better performance so i switched to text tables. The first time I ran my application it ran very fast. But since then it is running even slower than when i had cached tables. What ...

9. jdbc hsqldb issue - table not found    coderanch.com

Hi When I try to connect using hsqldb DB Manager same link shows me the table and all queries work fine. Went through a couple of forums... but no solutions seems to work. Have also tried dbUrl/ dbName as jdbc:hsqldb:file:/home/shlahoti/DB/;default_schema=true" (mentioned at a few places... Any other suggestions. One of the topics in the forum says running hsql in server mode ...





10. Getting the last three added rows to a table HSQLDB    coderanch.com

11. table doesnot exist in hsqldb    coderanch.com

Hi, I am using blazeds which has a sampledb.I modified the server.properties as this. server.database.0=file:flexdemodb/flexdemodb server.dbname.0=flexdemodb server.database.1=file:insync/insync server.dbname.1=insync server.port=9002 server.silent=true server.trace=false and i have the java code for connection like this. package insync.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class ConnectionHelper { private String url; private static ConnectionHelper instance; private ConnectionHelper() { String driver = null; try { System.out.println("ConnectionHelper............."); Class.forName("org.hsqldb.jdbcDriver"); ...

12. jdbc hsqldb issue - table not found    forums.oracle.com

Hi i also suspect that your DB location is not the one you are assuming. You know what /home refers to ? (I dont... i have no idea of Unix or Linux, i work with HSQLDB only on Windows) You have an existing DB at this location ? Does this DB already have a CUSTOMER table ? You have your DB ...