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.
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
Subscribe to Tutorials
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
Archived Comments
1. Astonishingly individual pleasant site. Immense de
View Tutorial By: salon de massage lyon at 2017-06-14 13:36:22