开发者

Does iBatis have any analog of Hibernate's `hbm2ddl` for integration testing with in-memory database?

开发者 https://www.devze.com 2023-04-01 10:03 出处：网络

I\'m considering adding integration tests to a Java-Struts-Spring-iBatis-Oracle legacy application. In the past I\'ve used HSQL as an in-memory database for integration tests for applications that us

相关专题：hsqldb ibatis integration-testing

I'm considering adding integration tests to a Java-Struts-Spring-iBatis-Oracle legacy application.

In the past I've used HSQL as an in-memory database for integration tests for applications that used Hibernate as an ORM. With Hibernate's hbm2ddl, it can automatically create the table structure in HSQL when integration tests are run.

Is it possible to do this with iBatis? Or is it necessary to run SQL scripts to create table?开发者_开发知识库

(In that case, I'm curious if there is a reasonable way to maintain this script. Since Oracle and HSQL have significant syntax differences.)

HSQLDB 2.2.5 and later has an Oracle syntax mode and supports a lot of Oracle table defintion syntax. This covers type name differences, functions, default clauses etc.