StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » DB2 CRUD

DB2 CRUD

Keith Chisarik — Wed, 07 Nov 2007 09:25:38 GMT

What are the default CRUD settings when using the SF DB2 Client? specifically as they relate to concurrency.

RE: DB2 CRUD

Keith Chisarik — Wed, 07 Nov 2007 09:25:38 GMT

THAT IS AWESOME, thanks!

RE: DB2 CRUD

StrataFrame Team — Wed, 07 Nov 2007 09:17:56 GMT

Yeah, I would recommend using row versioning over the all fields concurrency. So, either use row versioning with DB2 or just turn all concurrency checking off if you don't have a need for it or you don't care about it.

As for needing sprocs for the updates, you don't have to have them for row versioning... you just need an extra int column to store off the row version. Then put the name of that column in the RowVersionOrTimestamp column property on the business object and the BO will take care of the rest.

RE: DB2 CRUD

Keith Chisarik — Tue, 06 Nov 2007 17:15:56 GMT

yes it was exactly what i was looking for confirmation of, thank you very much.

Is is safe to assume that OptimisticAllFields could lead to significant performance issues, hence why you suggest row versioning in your classes and documentation?

If I want that with DB2 I would have to write my own update sprocs eh?

Thanks.

RE: DB2 CRUD

StrataFrame Team — Tue, 06 Nov 2007 09:01:39 GMT

The default settings are the same for DB2 as they are for SQL Server... UpdateConcurrencyType is set to OptimisticAllFields and the DeleteConcurrencyType is set to Off.

Is that what you were wondering?