How to retrieve the latest created db entry?

Question

I have the following class and need to manually increment the nextId field.

class SomeIdClass {

Family family
Integer nextId = 0
long timeCreated = new Date().time }

So far I've been trying to retrieve and the latest db entry to increment it and I'm just not having any luck with that. Or am I just going about it in a totally wrong manner?

Thaks

ps: this is what I tried but get a list of Package.SomeId objects

 def si = SomeId.executeQuery(" from SomeId where nextId =  (select max( nextId ) from SomeId) ")

Answer 1

You can do this:

def maxNextId = DomainClass.executeQuery("select max(nextId) from DomainClass")[0]

Without seeing the whole context, it's hard to tell what you're doing, but as an aside, this looks pretty questionable. This method to assign ids to domain objects is probably the wrong way to go about it. But in any case, what if a new object gets inserted into the database with a greater nextId in between the time you do the query and use the value?