• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Regarding java.sql.SQLException

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 }
 
Bartender
Posts: 2856
10
Firefox Browser Fedora Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Rajesh

please check whether your coloum is of number datatype and you assign it with string datatype
 
It's just a flesh wound! Or a tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic