coddz
Posts: 19
|
| Posted: 09/22/2009, 7:14 PM |
|
CCS 4.2
Usually, a page can raise some db operations, and these operations will merge in a TRANSACTION.
Anyone tell me how the CCS complete commit options at the beginning or last position of some db operations, thank a lot.
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 10/05/2009, 4:24 PM |
|
coddz
Can you give us more information. I don't know if I fully understand what you are asking. Also, what language and database are you developing with?? Maybe this link maybe what you are looking for: http://docs.codecharge.com/studio40/html/index.html?htt...ection.html?toc
|
|
|
|
coddz
Posts: 19
|
| Posted: 10/05/2009, 10:14 PM |
|
ok, mamboBROWN.
CCS 4.2
JSP
ORACLE or MySQL
CCS may not process commit.
getJDBCConnection(java.lang.String connectionName) maybe ......
|
|
|
|
mrachow
Posts: 509
|
| Posted: 10/06/2009, 12:42 AM |
|
You have execute transaction related commands like other SQL staements by yourself.
Usually any database is is NOT driven in mode autocommit, e.g. every change after open connection is a temporarely one until you let execute a commit.
I'm not sure if begin transaction is SQL default or if syntax will depend on datase system.
For MySQL the version is important because they added support for transactions late.
_________________
Best regards,
Michael |
|
|
|
coddz
Posts: 19
|
| Posted: 10/06/2009, 4:55 PM |
|
ok. mrachow.
the extend point of transaction should be left, set the manual commit option and beginTrans, endTrans even rollbackTrans.
a user submit may execute some db operations, and wrap these db operations into a transaction may be important.
|
|
|
|
|
