Hi Trevor,

You have perfectly understood the current JDBC asynchronous service
implementation. It has been implemented quite quickly and is probably too
tight from the internal mecanisms of LSC (which handles id per id). I agree
that the request getNextId should be able to handle a list of ids that
should be cached by the JDBC async service.

Please open a feature request, we will look to add such capability.

Thanks,

Sebastien BAHLOUL
IAM / Security specialist
Ldap Synchronization Connector : http://lsc-project.org
Blog : http://sbahloul.wordpress.com/


2014-04-10 1:17 GMT+02:00 Fong, Trevor <[email protected]>:

>  Hi There,
>
>
>
> I'm trying to understand how asynchronous mode works in lsc with database
> sources.
>
> In the documentation, I'm given to understand that if the
> requestNameForNextId node is provided then it is used to get the next id to
> process.
>
> When browsing around the lsc-users message archives, I came across a post
> that references a the postgresql sample:
>
>
> https://lsc-project.org/svn/lsc/trunk/sample/postgresql/etc-postgresql2opendj/sql-map-config.d/InetOrgPerson.xml
>
> That file gives an example of the getNextIndetOrgPersonId select that the
> requestNameForNextId node references:
>
>
>
>         <select id="getNextInetOrgPersonId"
> resultClass="java.util.HashMap">
>
>                 SELECT mail as mail
>
>                 FROM inetorgperson
>
>                 ORDER by id DESC
>
>                 LIMIT 1
>
>         </select>
>
>
>
> That query clearly only returns the first row.   How does it get the other
> id's that have been updated?
>
> Please excuse the beginner question.
>
>
>
> Thanks in advance,
>
> Trevor Fong
>
> _______________________________________________________________
> Ldap Synchronization Connector (LSC) - http://lsc-project.org
>
> lsc-users mailing list
> [email protected]
> http://lists.lsc-project.org/listinfo/lsc-users
>
>
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org

lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users

Reply via email to