Experience using Derby or HSQL in production mode

derby hsqldb
tellme picture tellme · Feb 27, 2009 · Viewed 13.6k times · Source

Anyone ever tried to use Derby or HSQLDB in a production environment? Any good, bad or ugly experiences?

Answer

Alexander Klimetschek picture Alexander Klimetschek · Jul 28, 2009

There is a comparison of embedded databases on the H2 website (H2 is another embedded Java DB that is very fast, BTW):

This should give you some facts.

Related questions

How to check if a database exists in Hsqldb/Derby?

I am looking for information how to check if a database exists -- from Java code -- in hsqldb and in Apache derby. In Mysql it is quite easy, because I can query a system table -- INFORMATION_SCHEMA.SCHEMATA …

Read More
org.hibernate.hql.internal.ast.QuerySyntaxException: table is not mapped

I have example web application Hibernate 4.3.5 + Derby database 10.10.1.1+ Glassfish4.0 with IDE NetBeans 8.0Beta. I have the next exception: Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: CUSTOMERV is not mapped at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.…

Read More
Cannot create JDBC driver of class ' ' for connect URL 'null' : I do not understand this exception

Why does it say null URL and gives a empty ' ' class in the exception when I have provided the database URL? I am trying to connect to a derby database via a servlet while using Tomcat. When the …

Read More