Hi Sebastian, Thank you for your reply. That is somewhat clearer now. With the current mechanism, given that the query only returns the first row, is there is something that deletes that row from the table or marks it as processed? Perhaps I am making assumptions about how async mode functions - could you give me a quick summary of how it works?
Thanks, Trevor From: Sébastien Bahloul [mailto:[email protected]] Sent: April-10-14 12:38 AM To: Fong, Trevor Cc: [email protected] Subject: Re: [lsc-users] Asynchronous Mode 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]<mailto:[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]<mailto:[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
