hai frnd.
u look at your query and ur while loop code...
dont u feel a typing mismatch?
u r selecting VCHNAME,VCHUNAME,VCHUPWD
but in while loop u r trying to access strUsername=res1.getString("VCHNAME");
here the spelling mistake makes the error

thanks and regards
prashu
prashobvee@gmail.com

Hi friend,


I check it the Problem in mismatching of fields in query.

Qry="select VCHNAME,VCHUNAME,VCHUPWD from APARNA.TBL_LIMS_ADMINUSERMASTER where VCHUNAME='"+strUserid.trim()+"' and VCHUPWD='"+strPassword.trim() +"'";


and in While loop

while(res1.next());
{
System.out.println("Inside while");
strUserid1=res1.getString("VCHNAME");
System.out.println("Inside while112");
System.out.println(strUserid1);
strPassword1=res1.getString("VCHUPWD");
System.out.println("Inside while2");
strUsername=res1.getString("VCHNAME");
System.out.println(strUserid1);
}

Do some changes :

strUsername=res1.getString("VCHNAME");

replace "VCHNAME" with "VCHUNAME"


For more information on jdbc visit to :

http://www.roseindia.net/jdbc/

Thanks