the process and what needs to be done
to connect from multiple JVM's apache derby network client driver.
My app builds the DB (schoolofdb) and I (right or wrong) told the app to put the DB in the
(server) which is in the dir of the %DERBY_INSTALL% dir .
how do get the code to start apache derby client network?
error :
CLASS
public cclass StartDerbyNetwork {:
--> in public void start() {<--
:
jdbc:derby://localhost:1527// : schoolofdb var : protocol+AND+dbName :
CLASS
public cclass StartDerbyNetwork {:
--> in public void start() {<--
: jdbc:derby://localhost:1527//schoolofdb var : host :
CLASS
public cclass StartDerbyNetwork {:
--> in public void start() {<--
: admin : admin var : username+AND+password :
TABLE NAMES : /////////////////////////////////////////: :
error message is: : No suitable driver found for jdbc:derby://localhost:1527//schoolofdb : AT// CLASS
public cclass StartDerbyNetwork {:
: : :
error message is: No suitable driver found for jdbc:derby://localhost:1527//schoolofdb
TABLE NAMES : 10.6.2.1 - (999685): :
TABLE NAMES : Apache Derby: :
TABLE NAMES : Apache Derby Embedded JDBC Driver: :
TABLE NAMES : 10.6.2.1 - (999685): :
TABLE NAMES : /////////////////////////////////////////: :
TABLE NAMES : ADMIN: :
TABLE NAMES : ADMIN_AVAILABLE: :
TABLE NAMES : BOOKING: :
TABLE NAMES : BOOKING_TOTALS: :
TABLE NAMES : BOOKING_TOTALS_STORAGE: :
TABLE NAMES : INSTRUCTOR: :
TABLE NAMES : INSTRUCTOR_INSTRUMENT: :
TABLE NAMES : INSTRUCTOR_STUDENT_MAPPING: :
TABLE NAMES : INSTRUMENT: :
TABLE NAMES : INSTR_AVAILABLE: :
TABLE NAMES : LOCATION: :
TABLE NAMES : LOCATION_AVAILABLE: :
TABLE NAMES : NORM_AVAILABLE: :
TABLE NAMES : PAYEE: :
TABLE NAMES : PAYEE_AVAILABLE: :
TABLE NAMES : PAYEE_STUDENT_MAPPING: :
TABLE NAMES : PAYMENT: :
TABLE NAMES : PAYMENT_STORAGE: :
TABLE NAMES : PAYROLL: :
TABLE NAMES : STUDENT: :
TABLE NAMES : STUDENT_AVAILABLE: :
TABLE NAMES : STUDENT_INSTRUMENT: :
TABLE NAMES : UNENROLLED: :
TABLE NAMES : USER_: :
TABLE NAMES : USER_GROUP: :
DERBY_INSTALL : DIR
Volume in drive C has no label.
Volume Serial Number is DA5B-72C1
Directory of C:\db-derby-10.11.1.1-bin
09/18/2014 11:33 PM <DIR> .
09/18/2014 11:33 PM <DIR> ..
09/17/2014 07:27 AM <DIR> bin
09/15/2014 03:10 AM <DIR> demo
09/18/2014 11:33 PM 475 derby.log
09/15/2014 03:10 AM <DIR> docs
08/01/2014 06:25 AM 4,993 index.html
09/15/2014 03:10 AM <DIR> javadoc
08/07/2014 10:17 AM 39,891 KEYS
09/17/2014 07:28 AM <DIR> lib
08/07/2014 10:17 AM 11,560 LICENSE
08/07/2014 10:17 AM 13,272 NOTICE
08/07/2014 10:17 AM 66,020 RELEASE-NOTES.html
09/18/2014 11:33 PM <DIR> schoolofdb
09/15/2014 03:10 AM <DIR>
test
6 File(s) 136,211 bytes
9 Dir(s) 900,386,172,928 bytes free
DERBY_INSTALL :
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package view;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import model.ModelUtils;
/**
*
* @author Steves
*/
public class StartDerbyNetwork {
///sys//////////////////////////////////////////////////////////////////////
///sys//////////////////////////////////////////////////////////////////////
private static
String AND = (" : ");
private static String BL = "CLASS \n";
private static String c = (" , ");
private static String blank = "\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n";
private static String C = BL + "public cclass StartDerbyNetwork {:\n";
private static String keyStr = "keyStr\n" + C + "\nXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX !MARK! XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX\nXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX !MARK! XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX\nXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX !MARK! XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX\nXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX !MARK! XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX\nXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX !MARK! XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX\nXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX !MARK! XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX";
private static String xBreak = (" XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ");
private static String yBreak = (" YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY ");
/*
* driver = "org.apache.derby.jdbc.ClientDriver";
...
Class.forName(driver).newInstance();
*
* protocol = "jdbc:derby://localhost:1527/";
...
conn = DriverManager.getConnection(protocol + "derbyDB;create=true", props);
That connection URL, fully constructed, looks like this:
jdbc:derby://localhost:1527/derbyDB;create=true
*
* Stop the Network server by executing the stopNetworkServer.bat (Windows) or stopNetworkServer.ksh
*
*
* C:\> cd %DERBY_INSTALL%\bin
C:\Apache\db-derby-10.4.1.3-bin\bin> setNetworkServerCP.bat
C:\Apache\db-derby-10.4.1.3-bin\bin> stopNetworkServer.bat
*
*
*
*
* XML PROPERTIES FOR THE EMBEDDED AND NETWORK CONFIG
* <!--
Derby embedded no network Config
******************************************************************************************************** config-->
<entry key="derbyDriver">org.apache.derby.jdbc.EmbeddedDriver</entry>
<entry key="derbyURL">jdbc:derby:</entry>
-->
<!--
Derby Config network
******************************************************************************************************** config-->
<entry key="derbyDriverNetwork">org.apache.derby.jdbc.ClientDriver</entry>
<entry key="networkProtocol">jdbc:derby://localhost:1527//</entry>
<entry key="musicSysDB">schoolofdb</entry>
<!-- ************************************************************************************
actually I do not have a username or password for the apache derby server
*****************************************************************************************-->
<entry key="derbyNetworkPassword">admin</entry>
<entry key="derbyNetworkUserName">admin</entry>
*/
