CODEWITHSUNDEEP
springoracle-databasetestingintegrationin-memory-database
Dave
Dave

Reputation: 31

Spring Integration Testing Oracle Native SQL

I have a legacy application that has recently been ported from Struts to Spring MVC. The data layer is written with native Oracle SQL. I'd like to introduce some integration testing but would like to avoid using an actual Oracle database for obvious reasons. Is there an in-memory DB that can deal with Oracle native SQL? Is this just a dream? Am I just going to end up with Oracle XE in a VM?

Upvotes: 0

Views: 874

Answers (2)

Steven Graves
Steven Graves

Reputation: 911

Isn't Oracle's in-memory database, TimesTen, compatible with standard Oracle?

Upvotes: 0

Dave
Dave

Reputation: 31

I've discovered that H2 actually has an Oracle compatibility mode. Great!

spring.datasource.url=jdbc:h2:mem:testdb;Mode=Oracle
spring.datasource.platform=h2
spring.jpa.hibernate.ddl-auto=none
spring.datasource.continue-on-error=true

Upvotes: 1

Related Questions