用于检查数据库(连接)是否存在的 Ant 任务?

2021-11-11 00:00:00 oracle ant ora-01017

在 ANT 中是否有可能在不导致构建失败的情况下检查数据库(连接)是否存在?

is there a possibility in ANT to check whether a database (connection) exists or not without failing the build?

例如:

<target name="check-database-available">
    <sql
        classpath="${oracle.jar}" driver="oracle.jdbc.OracleDriver"
        url="jdbc:oracle:thin:@${my.db.host}:${my.db.port}:${my.db.sid}" 
        userid="${my.db.user}" 
        password="${my.db.pw}"
        onerror="continue" errorproperty="exit.status">
        select * from dual;
    </sql>
    <echo message="### exit status = ${exit.status}" />
</target>

这将始终失败并显示 BUILD FAILED 和

This will always fail with BUILD FAILED and

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

因为数据库还不存在.将onerror"设置为continue"并检查errorproperty"将不起作用，因为任务似乎没有被执行.

because the db does not exist yet. Setting "onerror" to "continue" and checking the "errorproperty" won't work as the task seems not to be executed.

推荐答案

这是一个设置 db.present 属性的解决方法(checkpresence.sql 是一个简单的选择语句)

Here is a workaround which sets a db.present property (checkpresence.sql is a simple select statement)

<target name="check-db-presence">
  <echo message="Checking database presence at: ${db.url}"/>
  <delete file="tmp/db.present"/>
  <sql driver="${db.driver}" url="${db.url}"
                     userid="${db.userName}" password="${db.password}"
                     failOnConnectionError="false" onerror="continue" warningproperty="db.empty" errorproperty="db.empty" 
                      src="scripts/${db.platform}/checkpresence.sql"
                    print="true" output="tmp/db.present"/>
  <condition property="db.present">
    <available file="tmp/db.present"/>
  </condition>
</target>

相关文章