Package com.sun.appserv.jdbc
Interface DataSource
- All Superinterfaces:
CommonDataSource
,DataSource
,Wrapper
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 Summary
Modifier and TypeMethodDescriptiongetConnection
(Connection con) Retrieves the actual SQLConnection from the Connection wrapper implementation of SunONE application server.Gets a connection that is not in the scope of any transaction.getNonTxConnection
(String userName, String password) Gets a connection that is not in the scope of any transaction.void
API to mark a connection as bad.Methods inherited from interface javax.sql.CommonDataSource
createShardingKeyBuilder, getParentLogger
Methods inherited from interface javax.sql.DataSource
createConnectionBuilder, getConnection, getConnection, getLoginTimeout, getLogWriter, setLoginTimeout, setLogWriter
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
-
Method Details
-
getConnection
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 fromDatasource.getConnection()
- Returns:
java.sql.Connection
implementation of the driver.- Throws:
SQLException
-
getNonTxConnection
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
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:
password
- Password for authenticating the connectionuser
- User name for authenticating the connection- Returns:
java.sql.Connection
- Throws:
SQLException
-
markConnectionAsBad
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
-