嵌入式或托管Oracle实例以进行集成测试 [英] Embedded or managed Oracle instance for integration tests

问题描述

对于MySQL，MXJ连接器非常容易启动托管的MySQL实例.

For MySQL, the MXJ connector makes it very easy to launch a managed MySQL instance.

我知道Oracle为快速设置提供了 Oracle XE ，但我只发现需要安装的RPM发行版.是否有一个包装整齐的jar，可以放在类路径中，然后通过调用特定的JDBC URL，la HSQLDB或MXJ来启动它?

I know that Oracle provides Oracle XE for quick setup, but I've only found an RPM distribution that needs to be installed. Is there a neatly packaged jar that I can just drop in the classpath and start up by calling a specific JDBC url, a la HSQLDB or MXJ?

我有兴趣让开发人员在本地以及在我们的持续集成服务器上使用它来运行测试.

I'm interested in having developers use this locally for running tests, as well as on our continuous integration server.

推荐答案

最简单的答案是:否.Oracle是数据库中的一大块肉.除其他事项外，它通常期望自己由自己的特殊用户而不是客户端用户运行.

The short answer is No. Oracle is a big meaty chunk of database. Amongst other things, it generally expects itself to be run by its own special user rather than the client user.

为简单起见，最好的选择是一台单独的数据库服务器，每个开发人员在数据库中都有自己的用户名/密码(并因此拥有自己的独立模式).

For simplicity, your best bet is a separate DB server with each of your developers having their own username/password (and hence their own independent schema) in the database.

这篇关于嵌入式或托管Oracle实例以进行集成测试的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！