Hi,
I am trying to sync IDM3.0 with a mySQL database table using JDBCv2
Connector and third-party j/Connector driver.

I have a table named 'Usuaris' on my MySQL database described here :

create table usuaris(
id int(9) PRIMARY KEY auto_increment,
nom varchar(255),
cognom varchar(255),
nomusuari varchar(255), --username
nomentrada varchar(255), --loginname
llargadapass int(9) -- passlength
);

And my Scheema Mapping police is :

<?xml version="1.0" encoding="UTF-8"?><attr-name-map>
<class-name>
<nds-name>Group</nds-name>
<app-name>grp</app-name>
</class-name>
<attr-name class-name="Group">
<nds-name>Owner</nds-name>
<app-name>grp_owner.idu</app-name>
</attr-name>
<attr-name class-name="Group">
<nds-name>Member</nds-name>
<app-name>grp_member.idu</app-name>
</attr-name>
<class-name>
<nds-name>User</nds-name>
<app-name>vUsuari</app-name>
</class-name>
<attr-name class-name="User">
<nds-name>Given Name</nds-name>
<app-name>nom</app-name>
</attr-name>
<attr-name class-name="User">
<nds-name>Surname</nds-name>
<app-name>cognom</app-name>
</attr-name>
<attr-name class-name="User">
<nds-name>Password Minimum Length</nds-name>
<app-name>llargadapass</app-name>
</attr-name>
</attr-name-map>



But , when i create a user in IDM my traces print this :

Drvrs : MySQL ST:
DirXML Log Event -------------------
Driver: \CORPW2000\Labo\drvSetLabo\MySQL
Channel: Subscriber
Object: \CORPW2000\Labo\Usuarios\jdbc\usu2
Status: Error
Message: <description>Unable to add object. Table/view 'usuaris'
is undefined or unsyncable.</description>
<object-dn>O=Labo\OU=Usuarios\OU=jdbc\CN=usu2</object-dn>
<jdbc:document xmlns:jdbc="urn:dirxml:jdbc">
<nds dtdversion="3.0" ndsversion="8.x">
<source>
<product version="3.0.0.20051103 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<add class-name="User" event-id="AD-LB-NDS#20080730142215#1#1"
qualified-src-dn="O=Labo\OU=Usuarios\OU=jdbc\CN=usu2"
src-dn="\CORPW2000\Labo\Usuarios\jdbc\usu2" src-entry-id="33391"
timestamp="1217427735#8">
<add-attr attr-name="Surname">
<value timestamp="1217427735#2" type="string">2</value>
</add-attr>
<add-attr attr-name="Given Name">
<value timestamp="1217427735#8" type="string">usu</value>
</add-attr>
</add>
</input>
</nds>
</jdbc:document>



If I sync with the "default table" named usr ( created executing
1_install_innodb.sql script ) sync runs well, but when i change this
the sync fails.


--
arturnebot
------------------------------------------------------------------------
arturnebot's Profile: http://forums.novell.com/member.php?userid=26694
View this thread: http://forums.novell.com/showthread.php?t=338172