• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regarding java.sql.SQLException

 
rajesh kethepalle
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi rajesh,

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

Regards,
Danish
 
rajesh kethepalle
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2854
10
Fedora Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Danish Araquei
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rajesh

please check whether your coloum is of number datatype and you assign it with string datatype
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic