Hi, I've been working on using multiple pivot attributes in JBDC source services. This has been working on LDAP sources for a while now, and is very useful. For example, you could match entries on first name *and* last name, or on employeeNumber *and* location.
To achieve this, I have found that iBatis lets you use java Maps for parameters, and replaces the string #name# in SQL queries with the value of name in the Map. I wrote a Map that extends HashMap but with case insensitive keys. This has the advantage of making clean work with db2ldap again (it was broken). This patch changes basic JDBC source descriptions quite a bit - therefore, I would like your opinion before committing it. Attached is: - the proposed patch (lsc-proposed-patch-multiple-pivots-JDBC.patch) - a sample XML file for a JDBC source object (Person.xml) Please let me know your comments. Jonathan -- -------------------------------------------------------------- Jonathan Clarke - jonathan at phillipoux.net 4 avenue d'Epremesnil, 78400 Chatou, France Mobile: +33 (0)6 99 60 03 10 -------------------------------------------------------------- Ldap Synchronization Connector (LSC) - http://lsc-project.org -------------------------------------------------------------- -------------- next part -------------- A non-text attachment was scrubbed... Name: lsc-proposed-patch-multiple-pivots-JDBC.patch Type: text/x-diff Size: 8691 bytes Desc: not available Url : http://lists.lsc-project.org/pipermail/lsc-dev/attachments/20090126/0426b7f4/attachment.patch -------------- next part -------------- A non-text attachment was scrubbed... Name: Person.xml Type: text/xml Size: 1024 bytes Desc: not available Url : http://lists.lsc-project.org/pipermail/lsc-dev/attachments/20090126/0426b7f4/attachment.bin
