Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

sql - Why do I get an open transaction when just selecting from a database View? -


if execute simple select statement in pl/sql developer against database table, standard set of results expect.

recently, pasted query stored procedure happened select view, , noticed transaction seemingly left open. appraent rollback , commit options available in pl/sql developer.

a poll of other developers revealed seems affect not others, lead me suspect pl/sql developer settings.

why on earth case? view itelf has dblink database, wouldn't expect have effect.

any thoughts?

any sql statement starts transaction in oracle.

from manual:

a transaction begins first executable sql statement. transaction ends when committed or rolled back, either explicitly commit or rollback statement or implicitly when ddl statement issued. [...] executable sql statement sql statement generates calls instance, including dml , ddl statements

most not seing running in auto-commit mode transaction started statement committed after statement has finished.

others have claimed select not dml, again the manual states:

data manipulation language (dml) statements query or manipulate data in existing schema objects. enable to:

   * retrieve or fetch data 1 or more tables or views (select)
   * add new rows of data table or view (insert)
[...]

Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -