Introduction to Derby (java DB)
Welcome to
Derby! Derby is a full-featured, open source relational database management
system (RDBMS) that is based on Java(TM) and SQL. Derby is written and
implemented completely in the Java programming language. Derby provides users
with a small-footprint standards-based database engine that can be tightly
embedded into any Java based solution. Derby ensures data integrity and
provides
Sophisticated
transaction support. In the default configuration there is no separate database
server to be installed or maintained by the end user. For more information on Derby,
visit the Derby Web site at http://db.apache.org/derby.
Java DB is
Oracle's supported distribution of the Apache Derby open source database. It
supports standard ANSI/ISO SQL through the JDBC and Java EE APIs. Java DB is
included in the JDK.
At a Glance on Java DB:
Full-featured
and easy-to-use
Transaction-protected
and crash-recoverable
Embeddable in
applications
Pure Java and
portable and across CDC FP 1.1, Java 5, Java 6, and Java 7 (everywhere from
tablets to mainframes)
Included in the
JDK
Compact (2.6
MB)
Installing Java DB on Windows
Verify Derby
Run the sysinfo
command, as shown below, to output Derby system information:
Java DB (Apache Derby) tools:
§ sysinfo: The Derby
sysinfo tool displays information about your Java environment and your version
of Derby.
§ ij: The Derby
ij tool is a JDBC tool that you can use to run scripts or interactive queries
against a Derby database.
§ dblook: The Derby
dblook utility is a Data Definition Language (DDL) generation utility.The
dblook utility is a simple utility that dumps all or parts of the DDL of a
user-specified database to either a console or a file. The generated DDL can
then be used for such things as recreating all or parts of a database, viewing
a subset of the objects in a database (for example, those objects that pertain
to specific tables and schemas), or documenting the schema of a database.
The tools are
available at the bin folder of your Derby installation path
To use it from
any folder just add its folder to you PATH environment variable.
OR
OR
Depedent Jars
to work with Java DB Demo App.
C:\Users\IB1587\.m2\repository\org\apache\derby\derby\10.8.2.2\derby-10.8.2.2.jar
C:\Users\IB1587\.m2\repository\org\apache\derby\derbyclient\10.8.2.2\derbyclient-10.8.2.2.jar
C:\Users\IB1587\.m2\repository\org\apache\derby\derbynet\10.8.2.2\derbynet-10.8.2.2.jar
C:\Users\IB1587\.m2\repository\org\apache\derby\derbytools\10.8.2.2\derbytools-10.8.2.2.jar
No comments:
Post a Comment