2

I'm studying Play!. I'm using the HSQLDB embedded inside the framewok. It works fine for my needs, but I need to connect to it using a SQL client.

I tried with Squirrel SQL but I could not connect. I need to "see" the db and to operate on it using SQL statements outside my app.

I'm using the in memory database.

Do you have any information on how to connect with a sql client to the HSQLDB embedded in Play! ?

I hope you can give me some help.

Pere Villega
  • 16,429
  • 5
  • 63
  • 100
marco tardis
  • 21
  • 2
  • 2
    Do you mean H2 database because HSQLDB has been replaced by H2 in 1.2 version. Maybe this thread on play framework may help you: http://groups.google.com/group/play-framework/browse_thread/thread/c43b11fb03e48080/d410e97e461d18e8?hl=en&lnk=gst&q=h2#d410e97e461d18e8 – mandubian May 26 '11 at 11:47
  • See also http://stackoverflow.com/questions/6265957/access-mem-or-fs-database-tables-using-h2-console – David d C e Freitas Sep 12 '11 at 12:00

1 Answers1

3

If you are actually using Play 1.1, and therefore using HSQLDB, then it is possible, by using the following settings

According to this link, you should be able to do the following.

Driver: org.hsqldb.jdbcDriver
URL: jdbc:hs;qldb:mem:aname
user: "sa"
password: ""

I have got this working before, but I am away from my work PC, so can't confirm the exact settings.

However, I would suggest upgrading to Play 1.2. In this version of Play, it has change from HSQLDB to H2 and it comes with its own embedded SQL viewer, which you can access using the following URL.

http://localhost:9000/@db

This approach is far simpler!

Codemwnci
  • 54,176
  • 10
  • 96
  • 129