On Wed, Mar 2, 2016 at 12:00 PM, <[email protected]>
wrote:

> Seems you use a SELECT instead of an UPDATE to write in your database.
> See
>
> http://lsc-project.org/wiki/documentation/latest/configuration/database/persistence#writing_data_with_sql_queries


 Hi Clement,

I'm not using SELECT instead of UPDATE.
See:
```
        <select id="insertInetOrgPerson" parameterClass="java.util.Map">
                INSERT INTO users(uname, pwd, first_name, last_name, title,
mail)
                VALUES(#uname#, #pwd#, #first_name#, #last_name#, #title#,
#mail#)
        </select>

```
And, just now, I realized that I have put INSERT statement into select tag.

But, is it possible to put ibatis library into debug logging mode?
I imagine that I need to use logback.xml for that...

I've added:
        <logger name="com.ibatis" level="DEBUG">
                <appender-ref ref="CONSOLE"/>
        </logger>

But that did not work to get more detailed info on ibatis error.

I will now try to sync while changing tag names
in sql-map-config.d/InetOrgPerson.xml
for insert update and delete. Initialy I have C/P select block and only
changed SQL statements inside.

It works!

Now just one more question...

I see that some records in the database are null and that is the case when
object from the LDAP does not have certain attribute (some are optional)...
Can I somehow force that such fields (usually string values) become empty
strings "" ?

I tried putting:
          <defaultValues>
            <string>""</string>
          </defaultValues>
for such LDAP attributes but it did not work.

Regards,
Mišel
_______________________________________________________________
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