Forums Register Login

Regarding java.sql.SQLException

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
Hi rajesh,

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

Regards,
Danish
+Pie Number of slices to send: Send
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 }
+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
Hi Rajesh

please check whether your coloum is of number datatype and you assign it with string datatype
He was expelled for perverse baking experiments. This tiny ad is a model student:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1110 times.
Similar Threads
servlet destroy method and session
jndi.properties
how to upload files to My sql with jsp
Developing JSP in Eclipse Europa (Eclipse SDK 3.3)
Cannot parse POST parameters of request
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 07:25:02.