Coding help required

[Kerin Kapoor]

Hi,

Below is what I want to achieve but I'm having trouble extracting records from Oracle...

1. Extract guid from a table in Oracle
2. Connect to ldap and pass the guid to retrieve some information out of LDAP - complete
3. insert the extracted records into a table in Oralce.

The 2 errors I'm getting are as follows -

1. non-static variable this cannot be referenced from a static context
this.oguid = rs.getString(1);

2. cannot find symbol
symbol : varibale oguid
location: class Gname
this.oguid = rs.getString(1);

I'm new to java so any help would be appreciated!! Thanks in Advance!!!

import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Hashtable;
import java.util.Properties;

import javax.naming.Context;
import javax.naming.NamingEnumeration;
import javax.naming.NamingException;
import javax.naming.directory.SearchControls;
import javax.naming.directory.SearchResult;
import javax.naming.ldap.InitialLdapContext;
import javax.naming.ldap.LdapContext;
import java.sql.*;

public class Gname {
public static void main (String[] args) {

Hashtable<String, String> env = new Hashtable<String, String>();
env.put(Context.INITIAL_CONTEXT_FACTORY, "com.sun.jndi.ldap.LdapCtxFactory");
env.put(Context.PROVIDER_URL, "ldap://10.1.1.1:389");   //Just change this to the actual IP and Port
env.put(Context.SECURITY_AUTHENTICATION, "simple");
env.put("java.naming.ldap.attributes.binary", "objectGUID");    //Important!
env.put(Context.SECURITY_PRINCIPAL, "[e-mail]");
env.put(Context.SECURITY_CREDENTIALS, "password");
LdapContext ctx;
String ret = null;
String oguid;
int count=0;

try {
    Connection con = DriverManager.getConnection("jdbc: default: connection:");
    Statement stmt = con.createStatement();

	//The below query returns multiple guid records and I'm trying to print and insert the top 5 records  
   ResultSet rs = stmt.executeQuery("SELECT OBJECTGUID FROM TEST");
   
   if (rs.next() && count < 5) {
      this.oguid = rs.getString(1);
     count++;
	 
   //Authenticate the logon user with LDAP
   ctx = new InitialLdapContext(env, null);
   //Start checking if the user is within the organization unit(s)
   String searchBase = "DC=ABC,DC=test,DC=com";
  
   String searchFilter = "(&(objectClass=person)(objectGUID="+ oguid +"))";
   SearchControls sCtrl = new SearchControls();
   sCtrl.setSearchScope(SearchControls.SUBTREE_SCOPE);

   NamingEnumeration<SearchResult> answer = ctx.search(searchBase, searchFilter, sCtrl);

   if (answer.hasMore()) {
    SearchResult sr = answer.next();
 
	ret = (String) sr.getAttributes().get("sAMAccountName").get();
	System.out.println(ret);
}

// create new connection for insert query/*
 Connection coni = DriverManager.getConnection("jdbc: default: connection:");
    Statement stmti = coni.createStatement();
    ResultSet rsi = stmti.executeQuery("INSERT INTO itest (username, GUID) VALUES ('" + ret + "','" + oguid + "')" );
    rsi.close();
    stmti.close();
//end of insert query

} // end of the top select query
	rs.close();
    stmt.close();
} catch (NamingException ex) {
  System.out.println("Exception generated" ); // Do something with the exception...
}
} //end main
} // end Gname class

[Swastik Dey]

1. non-static variable this cannot be referenced from a static context

The error message itself is self explanatory. this is a non-static variable, main is a static method. I hope you can now guess where the problem is.

[Kerin Kapoor]

Hi,

Thanks for the reply...I understand what youmean - that I cannot use this inside main.

But how to I fix this and then compile it??.. I'm New to java so any pointers will be appreciated...
Thank you..

[Swastik Dey]

You have declared the variable in main method itself, i.e. it's a method local variable. So remove this. , you don't need object.variable name to refer to method local variables.

[Campbell Ritchie]

Why have you got such a long main method?

[Kerin Kapoor]

Hi,

Thanks for pointing my silly mistake.

Though I was able to resolve the previous error. I'm getting a new error on the statements where I'm trying to connect to Oracle and execute queries..

The error is given below -

unreported exception java.sql.SQLException; must be caught or declared to be thrown..

I've tried connecting to Oracle using below mentioned methods -

Connection con = DriverManager.getConnection("jdbc:‍oracle:thin:@hostname:portnumber:testdb","username","password");
Connection con = DriverManager.getConnection("jdbc:derby://hostname:portnumber/testDB","username","password");

Any pointers will be appreciated.

Thank you..

[Campbell Ritchie]

I have got rid of the inappropriate in your post; if that happens again try putting ‍ between : and o or clicking the “disable smilies…” box below.

You can find out all about Exceptions in the Java Tutorials.

[Kerin Kapoor]

Thanks for the reply..

I kind-off figured it out how to use exception handling in java by using your link...

and found out that my program is unable to find the driver for connecting to oracle data base..

Please refer to my post here - https://coderanch.com/t/627823/JDBC/databases/Java-program-Connect-database

The error is given below -
The program gets compiled but I get the below error while running the program -

java.lang.classNotFoundException: 3Doracle.jdbc.driver.OracleDriver
JDBC Class found
SQL exception occured java.sql.SQLException: No suitable driver found for jdbc: oracle thin:@hostname:port:dbname


How do I make my java program look for the driver present under wlserver_10.3/server/lib/ojdbc6_g.jar

Thanks, Gaurav

[Campbell Ritchie]

Where did you put the files with the driver in? How are you adding that to your classpath?