Thamu Gurung
,
Ranch Hand
Mar 29, 2010 18:20:13
hi ,
I have a .jsp file which has a form , and that data goes to servlet and I want to pass all those datas into MYsql (in a particular database and particular table).
I am trying to make a 3-tier application. JSP being being the view , Servlets the Controller and MYsql being the database.
Hope to have the overview of the logic doing this.
Regards,
David Newton
,
Author
Mar 29, 2010 18:57:58
What, specifically, are you having an issue with? Getting the form data? Using the DB?
Thamu Gurung
,
Ranch Hand
Mar 29, 2010 19:26:42
hi David its with the DB.....
cant use the prepared statement...
Devaka Cooray
,
Sheriff
staff
Mar 29, 2010 22:01:27
Thamu Gurung wrote: cant use the prepared statement...
What did you try? And, what was happened when you tried? Please TellTheDetails
Rajkumar balakrishnan
,
Ranch Hand
Mar 29, 2010 22:47:12
Without having enough details how you expect us to help you? Post the code where error resides....
Thamu Gurung
,
Ranch Hand
Apr 02, 2010 06:35:05
hi ,
The error msg which i'm getting is like this :-
java.sql.SQLException: Column count doesn't match value count at row 1
My files are like this
1.form.jsp
2. insertData.java
3. Table creation in MYSQL
-
4. Web.xml file
Please Help in this
Regards,
Fatih Keles
,
Ranch Hand
Apr 02, 2010 09:47:24
Is there a trigger on the table?
Thamu Gurung
,
Ranch Hand
Apr 02, 2010 10:26:51
No, there is no trigger in the table..
Fatih Keles
,
Ranch Hand
Apr 03, 2010 02:25:28
What if you try ?
It should be working.
Jan Cumps
,
Bartender
staff
Apr 03, 2010 02:30:53
That is well spotted, Fatih!
Thamu Gurung
,
Ranch Hand
Apr 03, 2010 21:21:11
yah ,
thankyou its working now ,, as simple mistakes ,,makes crazy ,,
please check my JSP thread ,,i got problem there
abhi vazhakalil
,
Greenhorn
Apr 07, 2010 01:08:45
Hey This Program works fine.
What are your superhero powers? Go ahead and try them on this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com