oracle connection with jsp application

• • Reply

  15 years ago

  by muhammadfahad_18

  fahad masud

  lahore, United States

  Joined 15 years ago

  i am in a great problem;
  plz help me to solve it
  i am running tomcat server 5.028 on my machinewhich is running jsp pages
  but it is not connecting with oracle so that exchange of data can occur plz help me how shall i sort out this problem
  i am using this following code to establish connection in my java classes
  

  
   public void establishConnection ( ){
     try {
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; // loading class for database connection driver
       accBookConnection = DriverManager.getConnection("jdbc:odbc:system","scott","tiger") ; // opening DSN
       accBookStatement = accBookConnection.createStatement() ; // statement to execute queries
       //System.out.println("connection establish");
     }
  

  
     catch (Exception e) {
       e.printStackTrace() ; // printing exception trace
     }
   }
  NOTE:- system is the instance name in odbc32

  Report abuse