CECS 323 - NetBeans/JavaDB(Derby) Setup

CSU Long Beach
CECS 323
Database Fundamentals

NetBeans/JavaDB(Derby Setup for Home)

Download the latest Java Development Kit: https://www.oracle.com/java/technologies/javase-downloads.html
Install on your computer per Oracle's instructions.
Download the latest version of NetBeans (as of January 2021 this is version 12.1): https://netbeans.apache.org/download/
Install on your computer per NetBean's instuctions.
Download Derby: https://mirror.csclub.uwaterloo.ca/apache/db/derby/db-derby-10.14.2.0/
Choose the lib.zip file.
Unzip this to any location you choose.
Once NetBeans is running, select the Services tab, expand the Databases entry, right-click on JavaDB, select Properties.
For the Derby location, enter the directory where you installed the Derby library.
For the databases location, you can choose any directory you want. This location is where the databases you create are stored.

Select the latest version of NetBeans and start it.
Open the Services window (available from the window menu in NetBeans)
Right-click Java DB and start the server... if you get a warning about security preventing this, there will be an option to disable this check. Disable it and restart the server
Once server is started, create a database: right-click on Java DB and choose create database and fill out the information. This will create a JDBC connection URL.
Right-click the JDBC connection URL for the database you created and connect to it.
Once connected, right-click again on connection and choose to execute commands
This will open a window where you type SQL. The results will be shown in another window below the editor.