Re: [eclipselink-users] Sequence generator - as a service

["Tim Hollosy" <hollosyt@xxxxxxxxx>]

Yes you can :)

Here's a quick snippet that executes a query (sql is your sql string)
and returns a list of SomeRandomPojo (that is not an entity).

	Query q = getEntityManager().createNativeQuery(sql);

		q.setParameter(1, whatever);

		List<Vector> results = (List<Vector>)q.getResultList();

		if(results !=null && !results.isEmpty())
		{
			finalResults = new ArrayList<SomeRandomPojo>();
			for (Vector res : results) {
				finalResults.add(new
SomeRandomPojo((String)res.get(0),(String)res.get(1),(String)res.get(2)));
			}

			return finalResults;
		}


./tch



On Wed, Aug 6, 2008 at 5:55 PM, Jan Vissers <Jan.Vissers@xxxxxxxxxx> wrote:
> So basically I was wondering whether I can use EclipseLink outside of the
> context of an Entity.
>
>> Might be a silly/hard to understand question...
>>
>> How would I use EclipseLink as a means to implement sequence block
>> pattern? What I want to do is this:
>>
>>
>> a. Remote client (Flex) calls Java service do so work, amongst others it
>>    passes in an identifier (initially '0').
>>
>> b. Java service uses 'sequence block' to obtain next unique identifier
>>    (not '0') when the passed in identifier is '0'. --> this would be
>>    the place where I would want to use EclipseLink <--
>>
>> c. Java service performs requested work and returns the identifier, which
>>    might have been not '0' in the first place i.e. passed in at a.
>>    or initialized at b.
>>
>> d. Remote client (Flex) continues to call a. as long as there is work to
>>    be done. If everything is completed continues with e.
>>
>> e. Remote client (Flex) calls into (another) Java service to 'finalize'
>> the
>>    operation. It passes in the not '0' identifier and other stuff.
>>
>> f. Java service uses not '0' identifier as the primary key (@Id) via
>>    setId() of a record to be created.
>>
>> Now, let us first wait and see who understands what I'm trying to do here
>> ;-)
>>
>> Thanks,
>> Jan.
>>
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>
>
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>