File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How to commit the change Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Storm Applied this week in the Other Open Source APIs forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to commit the change" Watch "How to commit the change" New topic

How to commit the change

prathimaprasun rao
Ranch Hand

Joined: Jun 29, 2006
Posts: 55
Hello sir,
Let me explain what my problem is with an example that best suits my current problem.
For example, I have a jsp page with field "Level".That jsp page contains code(for example, select level from tname order by 2 asc) for that field "Level".If we assume that the field Level has a list box with values "One, Two and so on". Now on the database side I would like to add new value into that Level field "Three".After inserting new value into that field, I commit the change on the database side(sql>commit). When I refresh the jsp page, I could see the new value in the existing list box values.
Coming to the current problem, i sort a list of values through a procedure/function.when I execute format_numeric(function) and sort function, i could get the desired output. But when i refresh that particular jsp, i could not find the values in the sorted order.Could you please let me know what i need to do when i execute the format_numeric function + sort statement.
Eagerly Waiting for reply!.

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 62513

It is considered extremely bad practice to perform SQl operations from a JSP page. I urge you to read up on accepted web practices and restructure your application.

Regardless, this is a JDBC, not a JSP question, so it has been moved to the JDBC forum.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: How to commit the change