Advertisement
ExaGridDba

Barebones UCP connection

May 5th, 2017
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.84 KB | None | 0 0
  1. CLASSPATH=ucp.jar:ojdbc6.jar
  2.  
  3. import java.sql.Connection;
  4. import java.sql.SQLException;
  5. import oracle.ucp.jdbc.PoolDataSource;
  6. import oracle.ucp.jdbc.PoolDataSourceFactory;
  7.  
  8. public final class UcpConn
  9. {
  10.         public static void main(String[] args)
  11.                 throws SQLException
  12.         {
  13.                 final PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource();;
  14.  
  15.                 pds.setConnectionFactoryClassName("oracle.jdbc.pool.OracleDataSource");
  16.                 final String url = "jdbc:oracle:thin:@//hostname:1521/SVC";
  17.                 pds.setURL( url );
  18.                 final String username = "usr";
  19.                 pds.setUser( username );
  20.                 final String password = "pw";
  21.                 pds.setPassword( password );
  22.                 final Connection conn = pds.getConnection();
  23.         }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement