Java Code for Connecting to Database using DataSource

//package _Connect;

import java.sql.Connection;

import java.sql.DatabaseMetaData;

//import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

//import java.sql.*;

import java.util.*;

import javax.naming.*;

import java.util.Calendar;

import java.util.Date;

//import java.util.Properties;

public class DataSourceQuery

{

public static void main(String[] args) throws Exception

{

Calendar cal = Calendar.getInstance();

long startMilis = 0;

long endMilis = 0;

Connection con = null;

Context ctx = null;

Hashtable ht = new Hashtable();

ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");

ht.put(Context.PROVIDER_URL,"t3://localhost:7001");

try

{

ctx = new InitialContext(ht);

// Enter the JNDI Name here

javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("JNDI_Name");

con = ds.getConnection();

DatabaseMetaData dbmd = con.getMetaData();

System.out.println("Connected to : " + dbmd.getDatabaseProductVersion());

System.out.println("JDBC Driver: " + dbmd.getDriverVersion());

System.out.println(dbmd.getURL());

PreparedStatement ps = con.prepareStatement("select * from dual");

ps.setQueryTimeout(5);

cal.setTime(new Date());

startMilis = cal.getTimeInMillis();

System.out.println("start query ");

ps.execute();

ResultSet rs = ps.getResultSet();

int counter = 0;

while (rs.next())

{

counter++;

}

ps.close();

}

catch (Exception e)

{

System.out.println(e);

}

finally

{

cal.setTime(new Date());

endMilis = cal.getTimeInMillis();

System.out.println("end query - Elapsed : " + ((endMilis - startMilis) / 1000) + "seconds");

//con.close();

}

}

}