I am developing a medium sized client-server application and I am trying to decide which database to use. I would like to use Hypersonic but I read somewhere that it is not very suitable for client server applications and that it does not support foreing keys. Is this true?
Can anyone who has experience in using Hypersonic please tell me how they found it. What are the pros and cons?
Like many other technologies that JBoss uses, Hypersonic is a separate project. You can get more information about Hypersonic at the Hypersonic SourceForge site - http://sourceforge.net/projects/hsqldb/.
For medium to large scale EJB projects, you should probably use a more full featured DBMS such as MySQL, PostgreSQL, DB2, Oracle et al.