Database access with Ant!
You can access a database with Ant. This can be useful when you want to create a database and fill it with some default data at the start/deployment of a project, but also when you want to reset the contents of your database just before invoking your tests!
Example of an Ant target to create a table:
CREATE TABLE br_vote
(
voteid INTEGER NOT NULL,
reviewid INTEGER NOT NULL,
votevalue INTEGER DEFAULT 5 NOT NULL
);
The accompanying build.properties for MySQL access in this case reads:
mysql.password = MyDatabaseUserPassword
mysql.user = MyDatabaseUserName
mysql.driver = com.mysql.jdbc.Driver
mysql.url = jdbc:mysql://localhost/myDatabase
mysql.classpath = /classpath/to/mysql-jdbc.jar
Mutatis mutandum for the build.properties, I was also able to successfully access an Oracle DB (LUDO).
Of course, you can also populate a DB this way, by just formulating a different target and putting the appropriate SQL statements in.
-
Comments are closed
-
#2 written by Lucas 8 years ago
-
-
#4 written by Jay 8 years ago
Could you give an example ? Because even with a very simple procedure, and without any comment,
I still dont’manage to get any compilation error. For example :Create OR Replace Package pkg_utils_date
AS
Function rdc_date_get_jou(
p_datin IN DATE
)
Return VARCHAR2;
nd pkg_utils_date;As you can see the “End” keyword is missing one character and ant says it completed successfully…
-
#5 written by Lucas 8 years ago
It seems all PL/SQL code is seen as one very long line. That means that any — style (normally
used as end of line) comments prevent the remainder of the line to be compiled. This basically means that any PL/SQL program unit with end-of-line comments will create incorrectly. I have not yet found a workaround other than leaving out end of line comments (and only use /* */ style comments). -
#6 written by Jay 8 years ago
Hi,
I tried what Lucas suggested (delimiter=”/” and delimiterType=”row”). It indeed seems to be the only way for Ant
to be able to read the content of the file. But it does not see any compilation error ! If I have a look to Oracle
the pl/sql code has been loaded but is in invalid state (and does not compile) but ant says it has completed succesfully.Setting the onerrror attribute has no effect as the default value is abort.
What Am I doing wrong ?
Thanks,
Jay -
#7 written by Lucas Jellema 8 years ago
The task not only may contain complete SQL statements but also references to files that contain SQL statements. Thye following task was used for invoking a number of DDL scripts to set up a database. These same scripts can be used from SQL*Plus.
<target name="_buildTables" depends="_init" > <sql driver="oracle.jdbc.driver.OracleDriver" url="${database.url}" userid="${database.username}" password="${database.password}"> <fileset dir="${database.ddl.dir}"> <include name="als_tables.sql"/> </include></fileset> </sql> </target>Files containing PL/SQL code it is important to specify how the ANT task can identify the end of the code units. For example:
<target name="_buildPackageSpecs" depends="" > <sql driver="oracle.jdbc.driver.OracleDriver" url="${database.url}" userid="${database.username}" password="${database.password}" delimiter="/" delimitertype="row" > <fileset dir="${database.ddl.dir}"> <include name="CG$ERRORS.PKS"/> <include name="CG$ALS_AUTHORS.PKS"/> </include></include></fileset> </sql> </target>see also http://www.bris.ac.uk/is/projects/portal/team/lilian/AntSql.
-
#8 written by Zeger Hendrikse 8 years ago
- Comment Feed for this Post
Good article and site. Congratulations