Use the following command in the command line to start the Derby network server (located in the Derby installation directory\/bin).<\/p>\n
startNetworkServer<\/pre>\nThis will start the network server which can serve an unlimited number of databases. By default the server will be listening on port 1527 but this can be changed via the\u00a0-p\u00a0option.<\/p>\n
startNetworkServer -p 3301<\/pre>\nBy default Derby will only accept connections from the localhost. To make the Derby server accept connections also from other hosts use the following start command. Replace “sampleserver.sampledomain.com” with the name or the IP of the server. The server will then accept connections only from other servers as the localhost.<\/p>\n
startNetworkServer -h sampleserver.sampledomain.com<\/pre>\nIf connections should be allowed from localhost and any other server use the following.<\/p>\n
startNetworkServer -h 0.0.0.0<\/pre>\n <\/p>\n
\u00a0<\/strong>4.1.2.<\/strong> Loading Derby JDBC driver<\/strong><\/p>\nTo connect to the network server via Java code you need to have the derbyclient.jar in your class-path. \u00a0We use the following network client driver to connect with DB<\/p>\n
If you are using Java 5.0 or earlier, you have to load the driver explicitly like this:<\/p>\n
Class.forName(\"org.apache.derby.jdbc.ClientDriver\");<\/pre>\nOr<\/p>\n
DriverManager.registerDriver(new org.apache.derby.jdbc.ClientDriver());<\/pre>\n <\/p>\n
4.1.3. Making Derby JDBC connection examples<\/strong><\/p>\nWith JDBC, there are three different ways to establishing a connection to the database, corresponding to three version of the method\u00a0getConnection()\u00a0of the\u00a0DriverManager\u00a0class:<\/p>\n
\n- Using only a database URL:<\/li>\n<\/ul>\n
String dbURL = \"jdbc:derby:\/\/localhost:1527\/dbname;create=true\";\r\n\r\nConnection conn = DriverManager.getConnection(dbURL);<\/pre>\nIf you want to connect to an existing database you can use the following string.<\/span><\/p>\njdbc:derby:\/\/localhost:1527\/c:\\temp\\ dbname<\/pre>\n
\n- Using a database URL with user and password:<\/li>\n<\/ul>\n
String dbURL = \"jdbc:derby:\/\/localhost:1527\/dbname;create=true\";\r\nString user = \"tom\";\r\nString password = \"secret\";\r\nConnection conn = DriverManager.getConnection(dbURL, user, password);\r\n<\/pre>\n
\n- Using a database URL with a\u00a0Propertiesobject:<\/li>\n<\/ul>\n
String dbURL = \"jdbc:derby:\/\/localhost\/dbname\";\r\nProperties properties = new Properties();\r\nproperties.put(\"create\", \"true\");\r\nproperties.put(\"user\", \"tom\");\r\nproperties.put(\"password\", \"secret\");\r\nConnection conn = DriverManager.getConnection(dbURL, properties);\r\n<\/pre>\n <\/p>\n
4.2. Embedded Mode<\/strong><\/strong><\/p>\nWhen an application accesses a Derby database using the Embedded Derby JDBC driver, the Derby engine does not run in a separate process, database is accessed from one application only and there are no separate database processes to start up and shut down<\/em>. Instead, the Derby database engine runs inside the same Java Virtual Machine (JVM) as the application.<\/p>\n4.2.1. Loading Derby JDBC driver<\/strong><\/p>\nTo connect to the database via Java code you need to have the derby.jar for embedded driver in your class-path. \u00a0We use the following embedded driver to connect with DB<\/p>\n
If you are using Java 5.0 or earlier, you have to load the driver explicitly like this:<\/p>\n
\u00a0 Class.forName(\"org.apache.derby.jdbc.EmbeddedDriver\");<\/pre>\nOr<\/p>\n
DriverManager.registerDriver(new org.apache.derby.jdbc.EmbeddedDriver());<\/pre>\n <\/p>\n
4.2.2 Making Derby JDBC connection examples<\/strong><\/p>\nWith JDBC, there are three different ways to establishing a connection to the database, corresponding to three version of the method\u00a0getConnection()\u00a0of the\u00a0DriverManager\u00a0class.<\/p>\n
If you want to connect to the Derby database in\u00a0embedded mode\u00a0you can use the following command. In this example the database is located at c:\\temp\\db\\FAQ\\db.<\/p>\n