invalid cursor state

invalid cursor state

View Answers

October 16, 2008 at 12:51 PM

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
[email protected]

October 16, 2008 at 1:04 PM

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

Ads









Related Tutorials/Questions & Answers:
invalid cursor state - JSP-Servlet
invalid cursor state  what is Invalid cursor state in java and how to solve this my code is below   hai frnd. u look at your query and ur while loop code... dont u feel a typing mismatch? u r selecting
invalid configuration
invalid configuration  hello I create hibernate.cfg.xml file Like...#noconfig for more info. **ERROR***org.hibernate.MappingException: invalid...(CreateStudent.java:13) Caused by: org.hibernate.MappingException: invalid
Advertisements
cursor location
cursor location   hi,please how to change cursor location by java code ,i use this code but not change the location JTextArea a=new JtextArea(); if(resultText.equalsIgnoreCase("class")){ a.append("a { \n }"); PointerInfo
invalid class exception
invalid class exception  Wondering why invalid class exception occurs
hibernate session invalid in jpa
hibernate session invalid in jpa  hibernate session invalid in jpa
cursor by java code
cursor by java code  hi, please how change cursor location automatically in java code
ModuleNotFoundError: No module named 'cursor'
ModuleNotFoundError: No module named 'cursor'  Hi, My Python... 'cursor' How to remove the ModuleNotFoundError: No module named 'cursor'... to install padas library. You can install cursor python with following command
ModuleNotFoundError: No module named 'cursor'
ModuleNotFoundError: No module named 'cursor'  Hi, My Python... 'cursor' How to remove the ModuleNotFoundError: No module named 'cursor'... to install padas library. You can install cursor python with following command
chown error invalid user
chown error invalid user  I'm getting the following error on buliding the app in XCode. Can anyone explain me why this error occurred?   Error chown: MYDOMAIN\domain users: Invalid argument Command /usr/sbin/chown
java code for cursor
java code for cursor   hi,please how to change cursor location by java code ,iam use this code but not change the location JTextArea a=new JtextArea(); if(resultText.equalsIgnoreCase("class")){ a.append("a { \n }"); PointerInfo
ModuleNotFoundError: No module named 'invalid-scraper'
ModuleNotFoundError: No module named 'invalid-scraper'  Hi, My... named 'invalid-scraper' How to remove the ModuleNotFoundError: No module named 'invalid-scraper' error? Thanks   Hi, In your python
MySQL Cursor
MySQL Cursor       Here we are going to describe about the MySQL cursor and how to declare, open, fetch and close it. Cursor can be created inside the stored procedures, functions
Changing the Cursor in Java
Changing the Cursor in Java     ... cursor in java. Changing the cursor means showing cursor in many different ... the cursor goes upon it, cursor shape changes to hand shape. If you move the mouse
Invalid console appender in JBoss console
Invalid console appender in JBoss console  "ERROR: invalid console appender config detected, console stream is looping" The above is the error i am getting while starting the server after deploying the ear file into the jboss. I
runtime error:Invalid column name
runtime error:Invalid column name  Hello, Can anyone please help me on this query? Programatically it is showing run time error. But in sql query...; } } Console Output: Getting Results! java.sql.SQLException: Invalid column name
How to get system current cursor type
How to get system current cursor type  In Windows how can i get the current mouse/keyboard cursor type like 'text cursor' from my java application
ModuleNotFoundError: No module named 'invalid-pic-detector'
ModuleNotFoundError: No module named 'invalid-pic-detector'  Hi...: No module named 'invalid-pic-detector' How to remove the ModuleNotFoundError: No module named 'invalid-pic-detector' error? Thanks   Hi
ModuleNotFoundError: No module named 'odoo8-addon-web-invalid-tab'
ModuleNotFoundError: No module named 'odoo8-addon-web-invalid-tab'  ...: No module named 'odoo8-addon-web-invalid-tab' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-web-invalid-tab' error? Thanks
ModuleNotFoundError: No module named 'django-cursor-pagination'
ModuleNotFoundError: No module named 'django-cursor-pagination'  Hi...: No module named 'django-cursor-pagination' How to remove the ModuleNotFoundError: No module named 'django-cursor-pagination' error? Thanks  
ModuleNotFoundError: No module named 'django-cursor-pagination-dtkav'
ModuleNotFoundError: No module named 'django-cursor-pagination-dtkav' ...: No module named 'django-cursor-pagination-dtkav' How to remove the ModuleNotFoundError: No module named 'django-cursor-pagination-dtkav' error
ModuleNotFoundError: No module named 'selenium-move-cursor'
ModuleNotFoundError: No module named 'selenium-move-cursor'  Hi...: No module named 'selenium-move-cursor' How to remove the ModuleNotFoundError: No module named 'selenium-move-cursor' error? Thanks   Hi
Moving Cursor within ResultSet
.style1 { text-align: center; } .style2 { background-color: #FFFFCC; } Moving Cursor Within ResultSet There are many methods are given to move within result set. They makes easy to read data within result set. An example
Using while loop to loop through a cursor
Using while loop to loop through a cursor       Cursor in SQL is used to define a set... while loop to loop through a cursor'. The Example create a table Stu_Table
File Upload in struts2 - Invalid field value for field
File Upload in struts2 - Invalid field value for field   Hi I am... : Invalid field value for field "upload". My webContents->Web-Inf->lib...) { this.uploadFileName = uploadFileName; } } As i click submit .. i get Invalid field
ModuleNotFoundError: No module named 'state'
ModuleNotFoundError: No module named 'state'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'state' How to remove the ModuleNotFoundError: No module named 'state'
error http status-500 invalid path was requested
error http status-500 invalid path was requested  I am using netbeans 6.8 + struts 1.3 + glassfish v3.I am not able to open add.jspx which contains add form.please help. index.jsp [code] <%@page contentType
error http status-500 invalid path was requested
error http status-500 invalid path was requested  I am using netbeans 6.8 + struts 1.3 + glassfish v3.I am not able to open add.jspx which contains add form.please help. index.jsp [code] <%@page contentType
error http status-500 invalid path was requested
error http status-500 invalid path was requested  I am using netbeans 6.8 + struts 1.3 + glassfish v3.I am not able to open add.jspx which contains add form.please help. index.jsp [code] <%@page contentType
error http status-500 invalid path was requested
error http status-500 invalid path was requested  I am using netbeans 6.8 + struts 1.3 + glassfish v3.I am not able to open add.jspx which contains add form.please help. index.jsp [code] <%@page contentType
Version of com.thesett>state dependency
List of Version of com.thesett>state dependency
Using while loop to loop through a cursor
Using while loop to loop through a cursor       Cursor in SQL is used to define a set... while loop to loop through a cursor'. The Example create a table Stu_Table

Ads