O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Uncataloged Connections

Occasionally, you might want to write an application that enables users to create connections to databases without going through the hassle of cataloging the node and database from the command line. It is possible to create a data source name (DSN) for use within CLI, ODBC, Perl, PHP, and Python applications to connect to an Apache Derby database through the DB2 client without requiring a cataloged connection. The syntax for the uncataloged connection DSN is a single string; substitute the real host name, database name, and port number on which the Apache Derby Network Server is listening in the following example:

DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=pook.apache.org;
DATABASE=YMLD;PROTOCOL=TCPIP;PORT=1527;

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required