import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.Date;

/**

*

* @author xx

*/

public class TestJDBC {

  static Connection conn= null;

  static String url="jdbc:oracle:thin:@pnd:1521:pnd";

  static String username="pnadm";

  static String password="password";

  public TestJDBC()

{

  try{

  String driverclass="oracle.jdbc.driver.OracleDriver";

  Class.forName(driverclass).newInstance();

  conn=DriverManager.getConnection(url,username,password);

   }catch(Exception e){

                        e.printStackTrace();

                        }

  }

  public static void getDate(){

  String sql="select object_name from all_objects where rownum<2";

  try{

        Statement stmt=conn.createStatement();

        ResultSet rs1=stmt.executeQuery(sql);

        while(rs1.next()){

                        System.out.print(rs1.getString("object_name")+" ");

                        }

                }catch(Exception e){

                        e.printStackTrace();

                        }

}

public static void main(String[] args) {

   TestJDBC t = new TestJDBC();

    for (int i=0;i <30 ; i++)

                t.getDate();

     try {

            Thread.sleep(30000);

        } catch (InterruptedException e) {

        }

    for (int i=0;i <280 ; i++)

                t.getDate();

     try {

            Thread.sleep(300000);

        } catch (InterruptedException e) {

        }

 }

}

export CLASS_PATH=/opt/oracle/product/10.2/jdbc/lib/ojdbc14.jar