Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #19820

Re: Java daemon

Show all headers | View raw

On Sun, 18 Nov 2012 20:41:19 -0500, Arne Vajhøj wrote:

> On 11/18/2012 8:05 PM, Martin Gregorie wrote:
>> On Sun, 18 Nov 2012 16:43:39 -0500, Arne Vajhøj wrote:
>>> And most of the non-standard SQL problems went away with MySQL 4.1 and
>>> 5.0 back in 2005 and 2006.
>>>
>> So, you're telling me its now ditched auto-incrementing fields and has
>> implemented sequences?
> 
> No.
> 
> But then auto increment is also the standard (with IDENTITY keyword
> though).
> 
> And it is also the most widely supported: MySQL,
> SQLServer, DB2 etc..
> 
> PostgreSQL has it in the form of SERIAL (even though it is just
> syntactic sugar for a sequence).
> 
> Sequences is really an Oracle and PostgreSQL proprietary thing.
>
I haven't looked at the SQL standard for quite a while and thought 
sequences were in it. My bad.
  
I have to say I like sequences a lot better than auto-incrementing fields 
for one reason: you know what the unique value is before doing the 
INSERT, which seems cleaner to me that doing the INSERT and then reading 
the new row to find out what the auto-incremented value is. 

In fact, for this exact reason I'd prefer do what I've had to do with 
DBMSs that don't have either sequences of auto-incrementing: namely to 
'fake' a sequence by updating a singleton row in a dedicated table rather 
than use auto-increment. 

Needless to say, this should also happen within an explicit commitment 
unit and, of course, ymmv.
 
> MySQL are trying to converge towards standards not away from standards.
>
I'm pleased to hear it: SQL standards are A Good Thing.


-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Java daemon "sl@exabyte" <sb5309@hotmail.com> - 2012-11-12 22:17 +0800
  Re: Java daemon David Lamb <dalamb@cs.queensu.ca> - 2012-11-12 09:25 -0500
    Re: Java daemon "sl@exabyte" <sb5309@hotmail.com> - 2012-11-12 23:55 +0800
      Re: Java daemon Martin Gregorie <martin@address-in-sig.invalid> - 2012-11-12 22:07 +0000
        Re: Java daemon "sl@exabyte" <sb5309@hotmail.com> - 2012-11-13 10:56 +0800
          Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-12 22:08 -0500
          Re: Java daemon "SL" <sb5309@hotmail.com> - 2012-11-13 13:59 +0800
          Re: Java daemon Martin Gregorie <martin@address-in-sig.invalid> - 2012-11-13 21:50 +0000
            Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-18 16:43 -0500
              Re: Java daemon Martin Gregorie <martin@address-in-sig.invalid> - 2012-11-19 01:05 +0000
                Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-18 20:41 -0500
                Re: Java daemon Martin Gregorie <martin@address-in-sig.invalid> - 2012-11-20 00:32 +0000
                Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-19 20:07 -0500
                Re: Java daemon Arved Sandstrom <asandstrom2@eastlink.ca> - 2012-11-19 20:38 -0400
                Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-19 20:22 -0500
                Re: Java daemon Arved Sandstrom <asandstrom2@eastlink.ca> - 2012-11-20 17:46 -0400
              Re: Java daemon Lew <lewbloch@gmail.com> - 2012-11-18 20:10 -0800
                Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-19 10:50 -0500
        Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-12 22:06 -0500
          Re: Java daemon Martin Gregorie <martin@address-in-sig.invalid> - 2012-11-13 21:36 +0000
            Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-13 17:31 -0500
              Re: Java daemon Martin Gregorie <martin@address-in-sig.invalid> - 2012-11-14 21:33 +0000
                Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-14 16:55 -0500
                Re: Java daemon Martin Gregorie <martin@address-in-sig.invalid> - 2012-11-15 02:09 +0000
    Re: Java daemon "SL" <sb5309@hotmail.com> - 2012-11-13 14:40 +0800
      Re: Java daemon Peter Duniho <NpOeStPeAdM@NnOwSlPiAnMk.com> - 2012-11-12 23:39 -0800
        Re: Java daemon "SL" <sb5309@hotmail.com> - 2012-11-13 16:16 +0800
      Re: Java daemon Arved Sandstrom <asandstrom2@eastlink.ca> - 2012-11-13 06:37 -0400
      Re: Java daemon David Lamb <dalamb@cs.queensu.ca> - 2012-11-13 08:46 -0500
      Re: Java daemon "John B. Matthews" <nospam@nospam.invalid> - 2012-11-13 21:23 -0500
      Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-18 16:52 -0500
      Re: Java daemon markspace <-@.> - 2012-11-18 14:02 -0800
        Re: Java daemon jlp <jlp@jlp.com> - 2012-11-19 20:39 +0100
          Re: Java daemon "SL@maxis" <ecp_gen@my-rialto.com> - 2012-11-20 15:23 +0800
  Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-12 09:41 -0500
  Re: Java daemon Jim Janney <jjanney@shell.xmission.com> - 2012-11-12 14:24 -0700
    Re: Java daemon Lew <lewbloch@gmail.com> - 2012-11-12 13:35 -0800
      Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-12 22:05 -0500
    Re: Java daemon Arne Vajhøj <arne@vajhoej.dk> - 2012-11-18 16:40 -0500

csiph-web