How to use Derby database

Well, I directly jump into the subject matter instead of taking you through its history and detail; because you may be already aware or if not you can google it.

Please follow these following steps:-

1. Download the Apache Derby binary distribution (e.g., v10.6) from the Apache Derby web site ( http://db.apache.org/derby/
) and extract it to a directory of your choice to complete the installation. Say for instance you have extracted it into 'c:\derby' folder.
2. Set ‘DERBY_INSTALL’ as user environment variable in you computer first.
3. Go to the physical location of ‘DERBY_INSTALL’ .and start the bat file ‘C:\derby\bin\startNetworkServer.bat’ by double clicking it . This will start the database server. Minimize this started command prompt.
4. Now, open a new command prompt
5. set CLASSPATH=%DERBY_INSTALL%\lib\derby.jar;%DERBY_INSTALL%\lib\derbytools.jar;%CLASSPATH%
6. To run the sysinfo utility, type the following in a command window or shell: java org.apache.derby.tools.sysinfo
7. Then type in command line ij;
8. ij> will appear, there you type connect 'jdbc:derby:/DerbyDB/vehicle;create=true';
9. This creates a new folder like DerbyDB in c: -> the directory tree C:\DerbyDB\vehicle
10. To create the tables, create a txt file (C:\DerbyDB\vehicle\create_sql.txt) which will contain all the sql commands in it to create tables.
11. Then run this command:-> run 'C:/DerbyDB/vehicle/create_sql.txt';
12. This will create a new tables. NOTE:- Remember this file was containig only create command for table.
13. To insert data in those tables create a separate txt file and run them as per the previous command.
14. To quit ij simple enter: exit;

Note: Remember instead of writing query in a txt file and executing it, can be avoided by directly typing the SQL command in console itself. But remember each command must end with a semicolon.



Using Derby in Eclipse IDE

Please follow these steps :

1
To install the Derby plugins manually, you will need to download the Apache Derby Eclipse Plugins from this website: http://db.apache.org/derby/derby_downloads.html.

2
The plugins are named 'derby_core_plugin_xx.zip' and 'derby_ui_plugin_xx.zip'.
Download both of these ZIP and unzip them. From these unziped folders copy these three folders and paste them into 'c:\eclipse\plugin' folder:

org.apache.derby.core_10.4.2,
org.apache.derby.ui_1.1.2, and
org.apache.derby.plugin.doc_1.1.2.


3
Re-start the eclipse
Select the project -> right click-> Apache derby-> Add Apache derby Nature.
Select the project -> right click-> Apache derby-> Start derby Network server

You will get the console output in eclipse:
Apache Derby Network Server - 10.5.3.0 - (802917) started and ready to accept connections on port 1527


4
Select the project -> right click-> Apache derby-> ij (ij Interactive SQL)
In Eclipse console type:
connect 'jdbc:derby:/DerbyDB/testDB;create=true';

This will create a database named 'testDB' inside the eclipse folder. ie, if eclipse is inside c:\eclipse, then you will find a new folder named 'testDB' is created as -> c:\eclipse\testDB

5
To creat a table in testDB:in Elipse console type:
CREATE TABLE BOOK_TABLE (BOOK_ISBN VARCHAR(50) );

it will give the output:-> 0 rows inserted/updated/deleted
this means it will create a table.



Thus, you will get the Database and Tables created in Derby database.

Comments

Post a Comment

Popular posts from this blog

Java

Image
Some Methods syntax needs to be remembered: protected Object readResolve() { return getInstance(); } protected void finalize() throws Throwable { try { close(); // close open files } finally { super.finalize (); // This is mandatory to write } } //normally it should be overridden to clean-up non-Java resources ie closing a file //in singleton classs public Object clone() throws CloneNotSupportedException { throw new CloneNotSupportedException(); } } –pleae note that this method is present in Object class not in Cloneable Interface as it is marker interface MultiThreading means: thread-safe = true. Overloading is providing multiple methods with the same name but different arguments (and potentially return type). Overriding is changing the behavior of a method in a subclass. Only objects are instantiated in the Java Runtime Environment (JRE) and held in a division of the program's memory allocation called the heap. S...
Read more

RTC - Repository : How to Revert Back the Changes

Image
HOW TO REVERT BACK THE CHANGES WHICH HAVE COMMITED INTO RTC REPOSITORY: = IN ECLIPSE Right click on the owning component in the Pending Changes view and select Show->History. The change set will appear in the History view.   Right click on the change set and choose Discard... This will discard the change set from your workspace. So your workspace should now have all change from the stream *except* the one you want to remove. You can verify this by checking that your bad change set is the only thing you see Incoming.   Right click on the component and choose "Replace in [your stream name]..."  RTC (Jazz) : How to point your stream to different stream and take codes into your local: Example: you have local worskapce set up from dev stream, but now you have PATCH stream and want to take latest code. Go to ‘Pending Changes’ and select “Change Flow Target” to the required stream. How to remove namespace from xml file ? Step 1: ...
Read more
Image
Hibernate - How to implement a 'Composite Key' : Suppose we have a Table in database which has many coulumns, among which two columns are PRIMARY KEY : UNIQUE_ID, NOTIFICATION_CHANNEL. We will write a separate Class which will contain these two columsn which are a part of COMPOSIT PRIMARY KEY. We will write a separate class for rest of the fields in that Table; and this class will also hold the reference of COMPOSIT PRIMARY KEY classs :->
Read more