Can't get columns from oracle table.

[Marin Velikov]

Hi all,

Please help me. I can't get columns in table. This is a source:

import java.sql.*;
import java.io.*;
import java.util.*;
import oracle.*;

public class Connect {
  oracle.jdbc.driver.OracleConnection aidcon;
  DatabaseMetaData dmd;

  String user_id = "gggg";
  String password = "pppp";
  String ipaddress = "192.168.14.50";
  String port = "1521";
  String sid = "ORCL";
  String dbUrl = "jdbc:oracle:thin:" + user_id + "/" + password + "@" +
ipaddress + ":" + port + ":" + sid;
  Statement stat;

  public ResultSet res=null;
  public Connect(){
    try{
      Class.forName("oracle.jdbc.driver.OracleDriver");
      aidcon = (oracle.jdbc.driver.OracleConnection)
DriverManager.getConnection(dbUrl);
      dmd = aidcon.getMetaData();
    }catch(Exception e){
      System.out.println("Hello the error is here");
      System.out.println(e);
    }
    System.out.println("Success");
  }

  public ResultSet getResult() throws SQLException{
    stat = aidcon.createStatement();
    res = dmd.getColumns( null, null,"FIRM",null);   // FIRM is table name
    return (res == null ) ? null : res;
  }

  public static void main(String args[])throws Exception{
    Connect c = new Connect();
    ResultSet rs = c.getResult();
    while( rs.next()){
      System.out.println("rsnext=" + rs.getString(3));
    }
    System.out.println("End.");
  }
}


Thanks.
Marin Velikov

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets