Package com.sun.appserv.jdbc

Interface DataSource

  • All Superinterfaces:
    CommonDataSource, DataSource, Wrapper
    public interface DataSource
extends DataSource
    The javax.sql.DataSource implementation of SunONE application server will implement this interface. An application program would be able to use this interface to do the extended functionality exposed by SunONE application server.

    A sample code for getting driver's connection implementation would like the following. 

     InitialContext ic = new InitialContext();
 com.sun.appserv.DataSource ds = (com.sun.appserv.DataSOurce) ic.lookup("jdbc/PointBase");
 Connection con = ds.getConnection();
 Connection drivercon = ds.getConnection(con);

 // Do db operations.

 con.close();
    Author:
    Binod P.G

    • Method Detail

      • getConnection

        Connection getConnection​(Connection con)
                  throws SQLException
        Retrieves the actual SQLConnection from the Connection wrapper implementation of SunONE application server. If an actual connection is supplied as argument, then it will be just returned.
        Parameters:
        con - Connection obtained from Datasource.getConnection()
        Returns:
        java.sql.Connection implementation of the driver.
        Throws:
        SQLException

      • getNonTxConnection

        Connection getNonTxConnection()
                       throws SQLException
        Gets a connection that is not in the scope of any transaction. This can be used to save performance overhead incurred on enlisting/delisting each connection got, irrespective of whether its required or not. Note here that this meethod does not fit in the connector contract per se.
        Returns:
        java.sql.Connection
        Throws:
        SQLException

      • getNonTxConnection

        Connection getNonTxConnection​(String userName,
                              String password)
                       throws SQLException
        Gets a connection that is not in the scope of any transaction. This can be used to save performance overhead incurred on enlisting/delisting each connection got, irrespective of whether its required or not. Note here that this meethod does not fit in the connector contract per se.
        Parameters:
        user - User name for authenticating the connection
        password - Password for authenticating the connection
        Returns:
        java.sql.Connection
        Throws:
        SQLException

      • markConnectionAsBad

        void markConnectionAsBad​(Connection conn)
        API to mark a connection as bad. If the application can determine that the connection is bad, using this api, it can notify the resource-adapter which inturn will notify the connection-pool. Connection-pool will drop and create a new connection. eg: 
                com.sun.appserv.jdbc.DataSource ds=
           (com.sun.appserv.jdbc.DataSource)context.lookup("dataSource");
              Connection con = ds.getConnection();
              Statement stmt = null;
              try{
                      stmt = con.createStatement();
                      stmt.executeUpdate("Update");
             }catch(BadConnectionException e){
                     dataSource.markConnectionAsBad(con) //marking it as bad for removal
             }finally{
                     stmt.close();
                     con.close(); //Connection will be destroyed while close or Tx completion
        }
        Parameters:
        conn - java.sql.Connection