• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to insert rec in DB from JSP

 
kashif iftikhar
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi everyone,
i am using oracle8i,weblogic 6.0 and JSP pages.
i have a problem in executing "INSERT" query from with in JSP......meanwhile "SELECT" queries are woring fine.....
Thanks....
 
James Carman
Ranch Hand
Posts: 580
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by kashif iftikhar:
hi everyone,
i am using oracle8i,weblogic 6.0 and JSP pages.
i have a problem in executing "INSERT" query from with in JSP......meanwhile "SELECT" queries are woring fine.....
Thanks....

You might want to re-think your design. Typically, you aren't supposed to be doing this sort of thing in a JSP page. You should use business logic beans (or EJBs) to do this sort of work.
 
kashif iftikhar
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes you are rightly says but i want to do this directly through JDBC(without EJB).if you know how please tell me
Thanks for reply
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by kashif iftikhar:
hi everyone,
i am using oracle8i,weblogic 6.0 and JSP pages.
i have a problem in executing "INSERT" query from with in JSP......meanwhile "SELECT" queries are woring fine.....
Thanks....

what is the SQLException thrown and the relevant code throwing the error?
see here for sample insert.
Jamie
 
kashif iftikhar
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks for your reply and related link....i will apply it and hope it will work.....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic