marc fleury writes:
> why don't *we* provide the damn counter MBean (off by default) as a standard
> service of our platform (once and for all, gaddamit)
>
> I don't remember the thread so flame if you wish
<grin>Ok...</grin>
The problem with a counter MBean is that you need to use your database
backend to generate at least some of the key to maintain data
consistency. Different databases use defferent sequence mechanisms.
So which is supported by default? Or should one be included for every
known sequence implementation? Not every DMBS has a sequence;
postgres and oracle are the two I know of. And they have different
syntax for accessing them:
Postgres:
CREATE SEQUENCE a_sequence MIN x MAX y START z;
SELECT NEXTVAL( "a_sequence" );
Oracle:
CREATE SEQUENCE a_sequence;
SELECT a_sequence.nextval FROM dual;
Tom
--
Tom Cook - Software Operations
"We rarely find that people have good sense unless they agree
with us."
- Francois, Duc de la Rochefoucauld
LISAsoft Pty Ltd - www.lisa.com.au
--------------------------------------------------
38 Greenhill Rd. Level 3, 228 Pitt Street
Wayville, SA, 5034 Sydney, NSW, 2000
Phone: +61 8 8272 1555 Phone: +61 2 9283 0877
Fax: +61 8 8271 1199 Fax: +61 2 9283 0866
--------------------------------------------------
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
