Creating Database Tables Using ANT
By: Sri Ganesh
First, you can use a properties file to feed ANT, which has a simple sql
target. Create a simple properties file, such as the one below:
# Database properties are in derby.properties db.delimiter=; db.root=${javaee.home}/derby db.driver=org.apache.derby.jdbc.ClientDriver db.datasource=org.apache.derby.jdbc.ClientDataSource db.host=localhost db.port=1527 db.sid=sun-appserv-samples db.url=jdbc:derby://${db.host}:${db.port}/${db.sid};create=true; db.user=APP db.pwd=APP
Next, create a build.xml
file that includes targets for
compiling the Java code as well as a target similar to the following:
<target name="create-db_common" depends="init,start-db,delete-db" description="Create database tables and populate database."> - <sql driver="${db.driver}" url="${db.url}" userid="${db.user}" password="${db.password}" classpathref="db.classpath" delimiter="${db.delimiter}" autocommit="false" onerror="abort"> <transaction src=" {javaee.tutorial.home}/examples/common/sql/${db.vendor}/tutorial.sql"/> </sql> </target>
The tutorial.sql
file can contain the commands to create the
tables and, possibly, populate the tables if need be, such as the example below:
create table COFFEES(cof_name varchar32, price int, sup_id int, price float, sales int, total int);
The ';' matches the db.delimiter
property.
NetBeans contains everything you need, including the Java DB and ANT.
You can Download NetBeans from
here.
Archived Comments
1. Astonishingly individual pleasant site. Immense details available on couple of clicks
on.
View Tutorial By: salon de massage lyon at 2017-06-14 13:36:22
Comment on this tutorial
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
Related Tutorials
TEXT datatype SPLIT in MSSQL - to solve the 8000 limit set by varchar
What is Referential Integrity in databases?
Handling CSV in Stored Procedures
java.lang.NoClassDefFoundError and java.lang.NoSuchMethodError
Calling a Stored Procedure from JDBC in Java
setSavepoint and releaseSavepoint Example in Java
PreparedStatement Example in Java
Creating Database Tables Using ANT
Using the DriverManager Class vs Using a DataSource Object for a connection
Stored Procedures example in SQL