Examples of org.apache.derby.jdbc.ClientDataSource

org.apache.derby.jdbc.ClientDataSource
ClientDataSource is a simple data source implementation that can be used for establishing connections in a non-pooling, non-distributed environment. The class ClientConnectionPoolDataSource can be used in a connection pooling environment, and the class ClientXADataSource can be used in a distributed, and pooling environment. Use these DataSources if your application runs under JDBC3.0 or JDBC2.0, that is, on the following Java Virtual Machines:
- JDBC 3.0 - Java 2 - JDK 1.4, J2SE 5.0
- JDBC 2.0 - Java 2 - JDK 1.2,1.3
The example below registers a DNC data source object with a JNDI naming service.
```
 org.apache.derby.client.ClientDataSource dataSource = new org.apache.derby.client.ClientDataSource (); dataSource.setServerName ("my_derby_database_server"); dataSource.setDatabaseName ("my_derby_database_name"); javax.naming.Context context = new javax.naming.InitialContext(); context.bind ("jdbc/my_datasource_name", dataSource); 
```
The first line of code in the example creates a data source object. The next two lines initialize the data source's properties. Then a Java object that references the initial JNDI naming context is created by calling the InitialContext() constructor, which is provided by JNDI. System properties (not shown) are used to tell JNDI the service provider to use. The JNDI name space is hierarchical, similar to the directory structure of many file systems. The data source object is bound to a logical JNDI name by calling Context.bind(). In this case the JNDI name identifies a subcontext, "jdbc", of the root naming context and a logical name, "my_datasource_name", within the jdbc subcontext. This is all of the code required to deploy a data source object within JNDI. This example is provided mainly for illustrative purposes. We expect that developers or system administrators will normally use a GUI tool to deploy a data source object.
Once a data source has been registered with JNDI, it can then be used by a JDBC application, as is shown in the following example.
```
 javax.naming.Context context = new javax.naming.InitialContext (); javax.sql.DataSource dataSource = (javax.sql.DataSource) context.lookup ("jdbc/my_datasource_name"); java.sql.Connection connection = dataSource.getConnection ("user", "password"); 
```
The first line in the example creates a Java object that references the initial JNDI naming context. Next, the initial naming context is used to do a lookup operation using the logical name of the data source. The Context.lookup() method returns a reference to a Java Object, which is narrowed to a javax.sql.DataSource object. In the last line, the DataSource.getConnection() method is called to produce a database connection.
This simple data source subclass of ClientBaseDataSource maintains it's own private password property.
The specified password, along with the user, is validated by DERBY. This property can be overwritten by specifing the password parameter on the DataSource.getConnection() method call.
This password property is not declared transient, and therefore may be serialized to a file in clear-text, or stored to a JNDI server in clear-text when the data source is saved. Care must taken by the user to prevent security breaches.

                    slaveDatabasePath+FS+slaveDbSubPath+FS+replicatedDb,
                    simpleLoadTuples);
            // return;
        }


        ClientDataSource ds = new org.apache.derby.jdbc.ClientDataSource();
        ds.setDatabaseName(slaveDatabasePath + FS + slaveDbSubPath + FS +
                           replicatedDb);
        ds.setServerName(slaveServerHost);
        ds.setPortNumber(slaveServerPort);
        ds.setConnectionAttributes(useEncryption(false));
        Connection conn = ds.getConnection();
            
        simpleVerify(conn);
        conn.close();
        /* BEGIN Distributed repl. tests only */
        if ( !slaveServerHost.equalsIgnoreCase("localhost") ){

View Full Code Here

                    masterDatabasePath+FS+masterDbSubPath+FS+replicatedDb,
                    simpleLoadTuples);
            // return;
        }


        ClientDataSource ds = new org.apache.derby.jdbc.ClientDataSource();
        ds.setDatabaseName(masterDatabasePath + FS + masterDbSubPath + FS +
                           replicatedDb);
        ds.setServerName(masterServerHost);
        ds.setPortNumber(masterServerPort);
        ds.setConnectionAttributes(useEncryption(false));
        Connection conn = ds.getConnection();
            
        simpleVerify(conn);
        conn.close();
        /* BEGIN Distributed repl. tests only */
        if ( !masterServerHost.equalsIgnoreCase("localhost") ){

View Full Code Here

            int _noTuplesToInsert)
        throws SQLException
    {
        util.DEBUG("_testInsertUpdateDeleteOnMaster: " + serverHost + ":" +
                   serverPort + "/" + dbPath + " " + _noTuplesToInsert);
        ClientDataSource ds = new org.apache.derby.jdbc.ClientDataSource();
        ds.setDatabaseName(dbPath);
        ds.setServerName(serverHost);
        ds.setPortNumber(serverPort);
        ds.setConnectionAttributes(useEncryption(false));
        Connection conn = ds.getConnection();
        
        PreparedStatement ps = conn.prepareStatement("create table t(i integer primary key, s varchar(64))");
        
        ps.execute();

View Full Code Here

     */
    public void testClientDSConnectionAttributes() throws SQLException {
        if (usingEmbedded())
            return;
        
        ClientDataSource ds = new ClientDataSource();


        // DataSource - EMPTY; expect error 08001 in all cases
        // 08001: Required Derby DataSource property databaseName not set.
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"}, ds);


        // DataSource - connectionAttributes=databaseName=<valid name>
        ds.setConnectionAttributes("databaseName=" + dbName);
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"}, ds);
        ds.setConnectionAttributes(null);


        // Test that (invalid) database name specified in connection
        // attributes is not used
        // DataSource - databaseName=<valid db> and 
        // connectionAttributes=databaseName=kangaroo
        ds.setConnectionAttributes("databaseName=kangaroo");
        ds.setDatabaseName(dbName);
        dsConnectionRequests(new String[]  
            {"OK","08001","OK","OK",
             "08001","08001","OK","OK","OK"}, ds);
        ds.setConnectionAttributes(null);
        ds.setDatabaseName(null);


        // now with ConnectionPoolDataSource
        ClientConnectionPoolDataSource cpds = 
            new ClientConnectionPoolDataSource();
        // ConnectionPoolDataSource - EMPTY

View Full Code Here

            return;


        String traceFile;


        // DataSource
        ClientDataSource ds = new ClientDataSource();
        ds.setDatabaseName(dbName);


        // DataSource - setTransationAttributes
        traceFile = "trace1.out";
        ds.setConnectionAttributes("traceFile="+traceFile);
        // In this scenario, we *only* get a tracefile, if we first get a 
        // successful connection, followed by an unsuccessful connection. 
        // So, we cannot just use ds.getConnection()
        dsGetBadConnection(ds);
        ds.setConnectionAttributes(null);
        // DataSource - setTraceFile
        traceFile = "trace2.out";
        ds.setTraceFile(traceFile);
        ds.getConnection();
        ds.setTraceFile(null);
        ds.setDatabaseName(null);


        // now with ConnectionPoolDataSource
        ClientConnectionPoolDataSource cpds = new ClientConnectionPoolDataSource();
        cpds.setDatabaseName(dbName);

View Full Code Here

        String retrieveMessageTextProperty = "retrieveMessageText";
        Connection conn;


        // DataSource
        // DataSource - retrieveMessageTextProperty
        ClientDataSource ds = new ClientDataSource();
        ds.setDatabaseName(dbName);
        ds.setConnectionAttributes(retrieveMessageTextProperty + "=false");
        conn = ds.getConnection();
        assertMessageText(conn,"false");
        conn.close();
        // now try with retrieveMessageText = true
        ds.setConnectionAttributes(retrieveMessageTextProperty + "=true");
        conn = ds.getConnection();
        assertMessageText(conn,"true");
        ds.setConnectionAttributes(null);
        conn.close();


        // now with ConnectionPoolDataSource
        // ConnectionPoolDataSource - retrieveMessageTextProperty
        ClientConnectionPoolDataSource cpds = new ClientConnectionPoolDataSource();

View Full Code Here

        String setDescription = 
            "Everything you ever wanted to know about this datasource";
        String getDescription;


        // DataSource - setDescription
        ClientDataSource ds = new ClientDataSource();
        ds.setDatabaseName(dbName);
        ds.setDescription(setDescription);
        ds.getConnection();
        getDescription = ds.getDescription();
        assertEquals(setDescription, getDescription);
        ds.setDescription(null);


        // ConnectionPoolDataSource - setDescription
        ClientConnectionPoolDataSource cpds = 
            new ClientConnectionPoolDataSource();
        cpds.setDatabaseName(dbName);

View Full Code Here

                                    javax.naming.Context nameContext,
                                    java.util.Hashtable environment) throws java.lang.Exception {
        javax.naming.Reference ref = (javax.naming.Reference) refObj;


        // Create the proper data source object shell.
        ClientDataSource ds = null;
        if (ref.getClassName().equals(ClientDataSource.className__)) {
            ds = new ClientDataSource();
        } else if (ref.getClassName().equals(ClientXADataSource.className__)) {
            ds = new ClientXADataSource();
        } else if (ref.getClassName().equals(ClientConnectionPoolDataSource.className__)) {
            ds = new ClientConnectionPoolDataSource();
        } else {
            return null;
        }


        // Fill in the data source object shell with values from the jndi reference.
        ds.hydrateFromReference(ref);


        return ds;
    }

View Full Code Here

                     * using DriverManager.getConnection() concurrently
                     * in startMaster and startSlave!
                    Class.forName(DRIVER_CLASS_NAME); // Needed when running from classes!
                    conn = DriverManager.getConnection(URL);
                     */
                    ClientDataSource ds = new org.apache.derby.jdbc.ClientDataSource();
                    ds.setDatabaseName(masterDatabasePath+FS+masterDbSubPath+FS+dbName);
                    ds.setServerName(masterHost);
                    ds.setPortNumber(masterServerPort);
                    ds.setConnectionAttributes("startMaster=true"
                            +";slaveHost="+slaveReplInterface
                            +";slavePort="+slaveReplPort);
                    conn = ds.getConnection();
                    
                    done = true;
                    conn.close();
                    util.DEBUG("startMaster OK");
                }

View Full Code Here

                         * using DriverManager.getConnection() concurrently
                         * in startMaster and startSlave!
                        Class.forName(DRIVER_CLASS_NAME); // Needed when running from classes!
                        conn = DriverManager.getConnection(URL);
                         */
                        ClientDataSource ds = new org.apache.derby.jdbc.ClientDataSource();
                        ds.setDatabaseName(fDbPath);
                        ds.setServerName(fSlaveHost);
                        ds.setPortNumber(fSlaveServerPort);
                        ds.setConnectionAttributes(fConnAttrs);
                        conn = ds.getConnection();
                        conn.close();
                    }
                    catch (SQLException se)
                    {
                        startSlaveException = se;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.derby.jdbc.ClientDataSource

com.subhajit.embeddable.derby.test.TestEmbeddedDerby2

org.apache.derby.client.am.LogWriter

org.apache.derby.client.ClientDataSourceFactory

org.apache.derby.client.net.NetConnection

org.apache.derbyTesting.functionTests.tests.jdbcapi.checkDataSource

org.apache.derbyTesting.functionTests.tests.jdbcapi.DataSourceTest

org.apache.derbyTesting.functionTests.tests.lang.ShutdownDatabaseTest

org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun

org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1

org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.