hsqldb « hsqldb « Java Database Q&A

1. Storing arrays in databases    stackoverflow.com

What is the most efficient way to store large arrays (10000x100) in a database, say, hsqldb? I need to do this for a certain math program that I'm writing in java. ...

2. Creating a shared HSQLDB database    stackoverflow.com

In-process HSQLDB database are not expected to be opened by others, even for file-based storage. The documentation hints that this is possible: Server Modes, Advanced Topics, but I've ...

3. HSQLDB - hiding database structure/contents from users    stackoverflow.com

I'm considering using HSQLDB in a desktop app for storing local data. From what I can see, the database is stored on disk as a number of SQL statements to ...

4. A quick-switch alternative for HSQLDB file mode (I need concurrent access now)    stackoverflow.com

I was happily working with HSQLDB by just having my DB URL like this:

jdbc:hsqldb:file:target/testdb;

5. How to run a HSQLDB server in memory-only mode    stackoverflow.com

In the documentation of the HSQLDB is a command line statement to start a HSQLDB server (HSQLDB Doc). But there is this "file:mydb" property, so I assume its not ...

6. Storage-In-File Database for C#/.NET 3.5?    stackoverflow.com

Is there something like HSQLDB (for Java) which can be run in a storage-in-file mode for C#/.NET 3.5?

7. Storing UUID in HSQLDB database    stackoverflow.com

I wish to store UUIDs created using java.util.UUID in a HSQLDB database. The obvious option is to simply store them as strings (in the code they will probably just be treated as ...

8. DDD Sample Application - Where's the hsqldb?    stackoverflow.com

I downloaded the DDD Sample Application (based on book by Eric Evans) and it uses a hsqldb. However, I can't seem to find how this db is set up. I opened ...

9. How do you delete the default database/schema in hsqldb    stackoverflow.com

I've created an in memory hsqldb and am using the default database/schema. Now I want to drop and recreate the database programatically. How do I do that? Thanks Daniel

10. Using HSQLDB in production environments    stackoverflow.com

I want to use HSQLDB in a production environment for stroring some data in memory and for data export using files. Does anybody have experience with using hsqldb in production environments? ...

11. How can I start and keep running hsqldb in server mode from within my web application?    stackoverflow.com

I don't want to use it in embedded mode as I may allow other external applications to access it as well. And I want to execute the startup of the ...

12. HSQLDB - Convertion from HEX VARCHAR MAC address to BIGINT    stackoverflow.com

I have a HSQLDB table in which the MAC address is stored as a varchar, which is not quite efficient. I'd like to convert it to BIGINT, but I found no ...

13. JENA: initializing a HSQLDB RDF datastore    stackoverflow.com

I'm trying to initialize a RDF datastore using Jena and HSQLDB. From http://jena.sourceforge.net/DB/hsql-howto.html I wrote the following code:

import com.hp.hpl.jena.db.DBConnection;
import com.hp.hpl.jena.db.IDBConnection;
import com.hp.hpl.jena.db.impl.Driver_HSQL;
import com.hp.hpl.jena.rdf.model.Model;
import com.hp.hpl.jena.rdf.model.ModelFactory;
import com.hp.hpl.jena.rdf.model.ModelMaker;

public class Test
    ...

14. Multiple Java Applications accessing one HSQLDB causes app to hang    stackoverflow.com

This is semi-related to my previous question. As that previous question states, I have a desktop app that calls off to a different Main method that will kick off ...

15. Migrating From HSQL DB 1.8 to 2.0    stackoverflow.com

Recently I came across this issue. I’m maintaining a software product which was written in Java and HSQLDB is the back end database engine version 1.8. But recently we upgraded HSQLDB ...

16. Where can I find a tutorial how to build a SAIL for sesame2 store?    stackoverflow.com

I would like to implement a SAIL (for sesame2) that lets me to store triples in hsqldb. I have found basic documentation on the sesame ...

17. hsqldb from java app    stackoverflow.com

I am writing a desktop app in java to add/display employees.I thought of using hsqldb.I created the program as below

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class HSQLDBManualOp {

    ...

18. How to deal with enums that aren't really enums because they can be changed?    stackoverflow.com

I'm working on a web app for a class. It's basically a project management system, similar to a watered down version of Bugzilla, but specifically tailored for an academic environment. ...

19. How can I make HSQLDB a windows service?    stackoverflow.com

As per the subject, I know how to run HSQLDB from command line as well as from my code, but I need help with making HSQLDB a windows service. Thanks in advance ...

20. Why is class not in classpath inside gmaven-plugin script?    stackoverflow.com

This is my pom.xml:

<project>
  [...]
  <build>
    <plugins>
      <plugin>
        <groupId>org.codehaus.gmaven</groupId>
      ...

21. hsqldb messing up with my server´s logs    stackoverflow.com

I have a server I made in Java that needs to use a database, I chose HSQLDB. So I have a lot of entries in my server like:

Logger.getLogger(getClass().getName()).  severe or info ...

22. Difficulty getting PK in HSQLDB    stackoverflow.com

I'm using hsqldb for a unit test (NOT production). These tests need to access the table's primary key, but I cant seem to get it to work. BTW, I'm using the ...

23. HSQLDB - which is the main database file    stackoverflow.com

i am using HSQLDB in the embedded mode. "jdbc:hsqldb:file:abc\TESTDB; after creating the database the folder abc has following files TESTDB.lck TESTDB.script TESTDB.log TESTDB.properties my application is working properly But my question is which is the main ...

24. In-process Hypersonic database shared among similar web apps    stackoverflow.com

I'm deploying the same Java web application multiple times in a web server. I would like to share an in-process Hypersonic database (without using sockets). The database will be updated ...

25. Strange behavior by using the keyword of HSQLDB    stackoverflow.com

I have a strange result when creating a new table in HSQLDB. From the documentation of HSQLDB, "user" is a keyword, normally, we can't use this value for table name or ...

26. fine tuning hsqldb    bytes.com

27. Start a HSQLDB from method    coderanch.com

28. HSQLDB and 64bits Systems    java-forums.org

Hello everybody. I have this problem. Some months ago I developed a program that uses HSQLDB in embedded mode. Everything was going fine until my customer decided to buy a new 64bits computer. My program can't retrieve any data from the database, there's an error that says "table BLAH was not found" or something like that, despite there are all the ...

29. How do I import jar package of HSQLDB?    forums.oracle.com

30. problem in using hsqldb    forums.oracle.com

Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in .class file at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:620) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124) at java.net.URLClassLoader.defineClass(URLClassLoader.java:260) at java.net.URLClassLoader.access$100(URLClassLoader.java:56) at java.net.URLClassLoader$1.run(URLClassLoader.java:195) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:57) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:410) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292) at com.lara.Manager.main(Manager.java:18) Please tell me ...

31. problems in starting hsqldb..    forums.oracle.com

georgemc-first of all thanx for replying!!!well even i m not understanding the problem...every where on internet they have given this procedure to start db!! anyway this is the name of the file i downloaded "hsqldb-1.9.0-rc6".. and other concerns i think i have taken care of , by updating the class path to this hsqldb.jar from the lib folder!!!! any other thing ...

32. Problem Address already in use: JVM_Bind with HSQLDB    forums.oracle.com

hi im using NetBeans5.0 and hsqldb1.8 with jdk1.4. after starting the database server frm code when my application launches and try to acess database it gives me error below. i tried using command "netstat" so that i can findout the alreasy used port and make it free for my application. but port im usiing oening port-8084 and shutdown port 9081, both ...

33. HSQLDB    forums.oracle.com

34. My app went in the X dimension : squirrel and Hsqldb    forums.oracle.com

Hi, I have more information. I changed the way I connect with squirrel, using 192.168.0.102 (my ip address) instead 127.0.0.1. Nothing change, I see only the sole line I've created with squirrel. After that I changed in the same way in my app and...all my lines have disapeared ! It's like if the table was empty !! If I change 192.168.0.102 ...