The code is as follows
class InterviewFeedBack{
public static void main(
String[] args) {
InterviewFeedBack interviewback=new InterviewFeedBack();
interviewback.getDetails("189");
try {
interviewback.DateFunction("Patrick","2006-06-01","2006-06-30");
} catch (NullPointerException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public void getDetails(String CandidateID){
Connection connection=null;
ResultSet resultSet=null;
Statement statement=null;
CandidateInterviewDate =new ArrayList();
InterviewResult =new ArrayList ();
InterviewerName =new ArrayList ();
CandFeedBack =new ArrayList ();
candidateId=new ArrayList();
try {
connection=getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
try{
statement = connection.createStatement();
resultSet=statement.executeQuery("select Candidate_id,Candidate_Interview_Date ,Candidate_Interview_Result,Candidate_Interviewer_Name,Candidate_Feedback from CANDIDATE_INTERVIEW_RECORD inner join cms_candidate on cms_candidate.cand_id = CANDIDATE_INTERVIEW_RECORD.candidate_id ");
System.out.println("The Result Set ="+resultSet);
while(resultSet.next())
{
System.out.println("I am enetering");
this.CandidateInterviewDate.add((String) resultSet.getString("Candidate_Interview_Date"));
this.InterviewResult.add((String)resultSet.getString("Candidate_Interview_Result"));
this.InterviewerName.add((String)resultSet.getString("Candidate_Interviewer_Name"));
this.CandFeedBack.add((String)resultSet.getString("Candidate_Feedback"));
this.candidateId.add((String)resultSet.getString("Candidate_id"));
System.out.println("I am leaving");
}
System.out.println(CandidateInterviewDate.size());
resultSet.close();
statement.close();
connection.close();
System.out.println("The arraylist from DB "+CandidateInterviewDate);
} catch (SQLException e) {
e.printStackTrace();
}
catch(NullPointerException e){
e.printStackTrace();
}
catch(Exception e){
e.printStackTrace();
}
}
}
The Exception thrown is
sun.jdbc.odbc.JdbcOdbcConnection@201f9
The Result Set =sun.jdbc.odbc.JdbcOdbcResultSet@1ffb8dc
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at cms.history.candidate.InterviewFeedBack.getDetails(InterviewFeedBack.java:173)
at cms.history.candidate.InterviewFeedBack.main(InterviewFeedBack.java:195)
I am enetering
The Result Set =sun.jdbc.odbc.JdbcOdbcResultSet@dc840f
The arraylist from DB 0
Thanks in adavnce if you suggest me.I think the problem is with connection broker.java file.
I am alos trying to debug it.
regards
amit bhadre