Peoplesoft: when will a databasechange be committed?
来源:互联网 发布:算法分析和复杂性理论 编辑:程序博客网 时间:2024/05/16 08:16
Peoplesoft: when will a databasechange be committed?
As a Peoplesoft developer (working with Peopletools-release 8.47.08), I have spent quite some time resolving issues caused by unexpected database-commits. As far a I know there’s no overall topic on this in Peoplebooks, therefore I will share my experience via this blog.
1) Database-updates via DML in a SQLExec-statement (e.g. INSERT INTO PS_TEST_TABLE VALUES(‘value_field_1′,’value_field_2′), triggered via an online component:
Peoplebooks states that DML in a SQLExec-statement is only allowed in FieldChange, SavePreChange, Workflow and SavePostChange events.
There’s a big difference in the outcome per event though; when this statement is put in a FieldChange-event, the DML is committed instantly, and this is something you probably don’t want!
2) Database-updates via DML in a SQLExec-statement (e.g. INSERT INTO PS_TEST_TABLE VALUES(‘value_field_1′,’value_field_2′), triggered via an Application Engine:
These updates are being committed according the AppEngine’s commit-settings.
2) Database-updates via a component interface, triggered via an online component (e.g. component A triggers component interface B_CI, triggering component B):
These updates are being committed as soon as the CI save-method is being invoked from the calling component (e.g. component A).
3) Database-updates via a component interface, triggered via an Application Engine (eg. AppEngine AE_1 triggers component interface B_CI, triggering component B):
These updates are being committed according the AppEngine’s commit-settings.
An exception to this rule I just recently encountered: the GetFile-statement leads to an immediate commit, even when used in an AppEngine-context!
Viewed 4445 times by 1248 visitors
- Peoplesoft: when will a databasechange be committed?
- The “button-press-event” signal: button-press-event signal will be emitted when a button(typically f
- When will the moon be clear and bright ...
- Summary on 20080820: when hibernate session will be flushed
- gcc compiler warning: “will be initialized after/when initialized here”
- 英语练习73 When will you be moving
- gcc compiler warning: “will be initialized after/when initialized here”
- i will be a post graduate!!!!!!!!!
- Perhaps it will be a deep cold...
- Tomorrow will be a new beginning
- Caffe——when a blob will copy data
- Will She Be A FRIEND Or A LOVER?
- It will be a corner on Information Security.
- I will be telling this with a sigh
- 警告: A docBase has been specified, and will be ignored
- Chapter2.A Trip to Objectville.There will be objects.
- How many String objects will be created when this method is invoked?
- When it comes to two corresponding names,one of them will be forces \( \)
- HDU 1498 50 years, 50 colors(多次进行最小点覆盖运算)
- hash partition 平衡分布数据的测试
- 第六天 C#面相对象以及Winform小结
- 将List<Object[]>按照某字段值分类,对数据重新封装。
- HDU-3074-Multiply game
- Peoplesoft: when will a databasechange be committed?
- php数组
- 如何通过函数修改实参的值
- linux多线程编程
- 结构体的使用概述
- 开发每个静态网站是的模版代码(自己开发是长期优化过的觉得最简的代码)
- const char*, char const*, char*const的区别
- 文件过滤驱动DEMO版
- HTML5全球普及加速:有望终结iOS与安卓界限