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









Related Tutorials/Questions & Answers:
invalid cursor state - JSP-Servlet
] Invalid cursor state   Hi friend, Please give Database...invalid cursor state  Dear sir here my query is executing properly but i can't able to get the value of strUserid1 in while loop.when I am running
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
Advertisements
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
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
The cursor in scrollable resultset
The cursor in scrollable resultset   How to move the cursor in scrollable resultset
How to set the cursor to wait?
How to set the cursor to wait?  How to set the cursor to wait
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
Cursor hiding in jQuery
Cursor hiding in jQuery  Hello sir I want to hide the mouse cursor... is very simple. Use the following code given below to hide cursor : $('body').css('cursor', 'none
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
change cursor on my website - WebSevices
change cursor on my website  i want to change cursor on website. i am..., Code to help in solving the problem : Test function cursor_wait() { document.body.style.cursor = 'wait'; } function cursor_clear
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
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
State in flex
State in flex  Hi.... just tell me about What is state? what.... Thanks in advance  Ans: State: The State class defines a view state... view states; a base view state with minimal information, and a rich view state
Show different types of Cursor
Show different types of Cursor   ... of the cursor. Using SWT we can change the style of cursor, by using the class Cursor of package org.eclipse.swt.graphics. To show the hand cursor, we have
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 '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 '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
current application cursor - Java Beginners
in which application has the cursor pointer presently). Second
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
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
Flex Cursor Manager Example
CursorManager in Flex:- CurserManager provide the full control of the cursor in your flex application. The most important work of the cursor manager.... If the user don't want to use the system cursor then cursor manager
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'
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... an example on 'Using while loop to loop through a cursor'. The Example create
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
Help to maintain state of checkbox
Help to maintain state of checkbox  hi, all I want to maintain the state of checkboxes across pages. What happens is when i check one checkbox and then go to say 2nd page then check one checkbox there and when i return
Button hover state
Button hover state  hi........ How do I manually trigger a buttons hover state in flex? please tell me about it..ADS_TO_REPLACE_1 Thanks   Ans: button.setStyle('skin', button.getStyle('upSkin')); I think
Java window state event
Java window state event  Two java windows, one on top of another... Window at the back is deactivated when the other is on the top. Can iconify when there is only one window using win+d key. In windows, press win+d, window
Attribute dojoType invalid for tag iterate according to TLD - Ajax
Attribute dojoType invalid for tag iterate according to TLD   Attribute dojoType invalid for tag iterate according to TLD what should i do if i want to implement it on previously developed Struts application
maintain previoous state on a Jsp
maintain previoous state on a Jsp  i am work on an app where combo box is define in each row of table in a jsp. when i select the specfic color from... the detail of the same id, previous state of colors can be show in a jsp which i have
ModuleNotFoundError: No module named 'app-state'
ModuleNotFoundError: No module named 'app-state'  Hi, My Python... 'app-state' How to remove the ModuleNotFoundError: No module named 'app-state' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'harmeet-state'
ModuleNotFoundError: No module named 'harmeet-state'  Hi, My... 'harmeet-state' How to remove the ModuleNotFoundError: No module named 'harmeet-state' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'harmeet-state'
ModuleNotFoundError: No module named 'harmeet-state'  Hi, My... 'harmeet-state' How to remove the ModuleNotFoundError: No module named 'harmeet-state' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-state'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-state'  Hi...: No module named 'odoo10-addon-l10n-fr-state' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-state' error? Thanks
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-state'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-state'  Hi...: No module named 'odoo10-addon-l10n-fr-state' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-l10n-fr-state' error? Thanks
ModuleNotFoundError: No module named 'odoo11-addon-l10n-fr-state'
ModuleNotFoundError: No module named 'odoo11-addon-l10n-fr-state'  Hi...: No module named 'odoo11-addon-l10n-fr-state' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-l10n-fr-state' error? Thanks

Ads