How to commit the change

[prathimaprasun rao]

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!.

Prathima

[Bear Bibeault]

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.