5

I'm looking for embedded db with Java API for testing purposes. Also i need pl/sql support because we use oracle in production and migrations are written in pl/sql.

I want to test my DAO objects and i need to create db in memory in process of unit test using migration scripts.

Now we use HSQLDB but it does't support pl/sql.

Can you recommend anything?

Bozho
  • 588,226
  • 146
  • 1,060
  • 1,140
Chuprin
  • 1,147
  • 1
  • 13
  • 18

3 Answers3

7

According to the wikipedia page about PL/SQL, the databases supporting PL/SQL are Oracle and DB2:

If these don't suit you, there's nothing else. PL/SQL is a creation of Oracle, so it's not expected to be widely spread.

Bozho
  • 588,226
  • 146
  • 1,060
  • 1,140
  • In-memory doesn't mean embedded. I mean i need to have dedicated instance of db somewhere. But i want to create an instance in runtime. – Chuprin Nov 19 '10 at 16:26
  • Thanks. will take a look. first look: db2 has only c++ api. oracle's site is full of unuseful information. still search for docs about solution. – Chuprin Nov 19 '10 at 19:34
  • I found Berkley DB. But it supports plsql only with 3rd-party modules (also has only c++ api). I think i want impossible. – Chuprin Nov 19 '10 at 19:42
1

We use Firebird's pl/sql extensively. It has an embedded server you can access through JDBC.

jcalfee314
  • 4,642
  • 8
  • 43
  • 75
1

You could try installing Oracle XE on your local developer workstation and Continuous Integration server. Then connect with the SYS as SYSDBA or SYSTEM user to create your schema(s) before executing your unit tests.

Robert Greathouse
  • 1,024
  • 1
  • 10
  • 18