Meaningless Drivel is fun!
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
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: 63852

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] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: How to commit the change
It's not a secret anymore!