aspose file tools*
The moose likes JDBC and the fly likes Regarding java.sql.SQLException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regarding java.sql.SQLException" Watch "Regarding java.sql.SQLException" New topic
Author

Regarding java.sql.SQLException

rajesh kethepalle
Greenhorn

Joined: Jul 21, 2008
Posts: 3
Hai friends,
iam facing problem in servlet the following error
java.sql.SQLException RA-1722:invalid number
This is the problem iam facing in servlet in jdbc forum please help somebody
Danish Araquei
Greenhorn

Joined: Jul 05, 2006
Posts: 19
Hi rajesh,

can you post code for our reference and also the scenario when you getting the error

Regards,
Danish
rajesh kethepalle
Greenhorn

Joined: Jul 21, 2008
Posts: 3
Hai Danish hai dinesh, thanks for your reply i have written query like this: select *from Project_Login where StaffCode=+"Staffcode"+,UserName=+"Username"+,Password=+"Password"+; the record is success fully excuted after that by error and trace method i got next statement excuted after that i have written : At this step iam getting that problem if(rs.next()) { requestdipatcher statement }
Amit Ghorpade
Bartender

Joined: Jun 06, 2007
Posts: 2709
    
    5

Hi rajesh kethepalle welcome to Javaranch,
Please CarefullyChooseOneForum.

Only getting a database error in a servlet does not make it a servlet question.
Someone from the bartenders will move it to a proper place.

And i think the exception is because of the inconsistency in the field type present in the database and the one you are using.


Hope this helps


SCJP, SCWCD.
|Asking Good Questions|
Danish Araquei
Greenhorn

Joined: Jul 05, 2006
Posts: 19
Hi Rajesh

please check whether your coloum is of number datatype and you assign it with string datatype
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding java.sql.SQLException
 
Similar Threads
Developing JSP in Eclipse Europa (Eclipse SDK 3.3)
jndi.properties
how to upload files to My sql with jsp
servlet destroy method and session
Cannot parse POST parameters of request