Tagged: SQL

Java Stored Procedures with Derby

Stored procedures provide a very powerful capability. They enable the execution of many SQL statements within the context of conditional programming logic, via a single database call. Stored procedures execute in the database, thus making them an excellent place for computationally intense db operations. Stored procedures do come at cost. Some database vendors offer extensions to SQL e.g. PL/SQL, T-SQL, PL/pgSQL . These extensions may be proprietary or may comform...

Quick Start with Apache Derby

Download and Install Derby Download the Apache Derby database. Note: At the time of this post, I am using version 10.10 To install, simply unpack the download to your favorite directory. We’ll refer to this directory as $DERBY_HOME Start Derby server $DERBY_HOME/bin/startNetworkServer Connect to Derby Run Derby’s interactive SQL tool: $DERBY_HOME/bin/ij ij>connect ‘jdbc:derby://localhost:1527/sample-db;create=true;user=APP;password=APP’; Note: This command will connect to the Derby server running on localhost on Derby’s default port, 1527. create=true will...