Hello,

I'm running eDir 8.8.6 on SLES 11 SP1 with Identity Manager
3.6.10.36503 and JDBC Driver Version 3.5.5.
There's a JDBC Driver reading data from a MySQL table in triggerless
Publication mode. On the publisher side all is working fine: after the
last command transformation rule the appropriate data is written into
eDirectory but the resulting status events are not processed in the
output transformation. It just says: End transaction. (Subscriber
channel is not disabled.)
Below is a level 3 trace of the driver initialization:

Code:
--------------------
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.10.4747">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<init-params src-dn="...">
...
<driver-options>
<jdbc-class display-name="Third-party JDBC driver class name:">org.gjt.mm.mysql.Driver</jdbc-class>
<ignore1 display-name="Show the database scoping parameters?">show</ignore1>
<sync-filter display-name="Synchronization filter:">list</sync-filter>
<sync-tables display-name="Table or view names:">PA</sync-tables>
<time-syntax display-name="Time syntax:">3</time-syntax>
<state-dir display-name="State directory:">/home/admin/state/viva_pa</state-dir>
<ignore11 display-name="Show connectivity parameters?">show</ignore11>
<use-single-connection display-name="Use minimal number of connections?">_</use-single-connection>
<connection-init display-name="Connection initialization statements:"></connection-init>
<connection-properties display-name="Connection properties:"></connection-properties>
<ignore3 display-name="Show the compatibility parameters?">show</ignore3>
<ignore4 display-name="Use custom descriptor files?">0</ignore4>
<jdbc-driver-descriptor display-name="JDBC driver descriptor filename:"></jdbc-driver-descriptor>
<database-descriptor display-name="Database descriptor filename:"></database-descriptor>
<ignore12 display-name="Show backward compatibility parameters?">show</ignore12>
<enable-refs display-name="Enable table referential attribute support?">_</enable-refs>
<enable-meta-identifiers display-name="Enable view meta-identifier support?">_</enable-meta-identifiers>
<ignore5 display-name="Show transaction-related parameters?">show</ignore5>
<use-manual-transactions display-name="Use manual transactions?">_</use-manual-transactions>
<transaction-isolation-level display-name="Transaction isolation level:">read committed</transaction-isolation-level>
<ignore6 display-name="Show statement-related parameters?">show</ignore6>
<reuse-statements display-name="Reuse statements?">_</reuse-statements>
<handle-stmt-results display-name="Number of returned result sets:">_</handle-stmt-results>
<enable-locking display-name="Enable statement-level locking?">0</enable-locking>
<ignore13 display-name="Use the custom lock statement generator class?">0</ignore13>
<lock-generator-class display-name="Lock statement generator class:"></lock-generator-class>
<force-username-case display-name="Force username case:">_</force-username-case>
<left-outer-join-operator display-name="Left outer-join operator:">_</left-outer-join-operator>
<minimal-metadata display-name="Retrieve minimal metadata?">_</minimal-metadata>
<function-return-method display-name="Function return method:">_</function-return-method>
<supports-schemas-in-metadata-retrieval display-name="Supports schemas in metadata retrieval?">_</supports-schemas-in-metadata-retrieval>
<column-position-comparator display-name="Sort column names by:">_</column-position-comparator>
</driver-options>
</init-params>
</input>
</nds>
[10/28/10 16:49:34.517]:viva_pa ST:Loading descriptors.
[10/28/10 16:49:34.559]:viva_pa ST:Loaded.
[10/28/10 16:49:34.560]:viva_pa ST:Parameter: 'jdbc-class' Value: 'org.gjt.mm.mysql.Driver'
[10/28/10 16:49:34.561]:viva_pa ST:Parameter: 'jdbc-driver-descriptor' Value: null
[10/28/10 16:49:34.561]:viva_pa ST:Parameter: 'database-descriptor' Value: null
[10/28/10 16:49:34.562]:viva_pa ST:Searching for driver descriptor file matching 'org.gjt.mm.mysql.Driver'.
[10/28/10 16:49:34.577]:viva_pa STescriptor file '_mysql_connectorj.xml' successfully loaded.
[10/28/10 16:49:34.578]:viva_pa ST:Third-Party JDBC Driver is "MySQL Connection/J"
[10/28/10 16:49:34.578]:viva_pa ST:Applying declared imports to driver descriptor '_mysql_connectorj.xml'.
[10/28/10 16:49:34.579]:viva_pa ST:Applying import '_mysql_codes.xml'.
[10/28/10 16:49:34.582]:viva_pa ST:Parameter: 'sync-filter' Value: 'list'
[10/28/10 16:49:34.582]:viva_pa ST:Parameter: 'sync-schema' Value: null
[10/28/10 16:49:34.583]:viva_pa ST:Parameter: 'sync-tables' Value: [PA]
[10/28/10 16:49:34.583]:viva_pa STriver is schema-aware.
[10/28/10 16:49:34.584]:viva_pa ST:Parameter: 'force-username-case' Value: null
[10/28/10 16:49:34.584]:viva_pa ST:Parameter: 'server' Value: 'jdbc:mysql://idmdb.rz.uni-passau.de:3306/viva?useSSL=true'
[10/28/10 16:49:34.585]:viva_pa ST:Parameter: 'user' Value: 'viva'
[10/28/10 16:49:34.586]:viva_pa ST:Parameter: 'connection-properties' Value: ''
[10/28/10 16:49:34.586]:viva_pa ST:Parameter: 'reuse-statements' Value: [descriptor-dependent]
[10/28/10 16:49:34.587]:viva_pa ST:Parameter: 'use-manual-transactions' Value: [descriptor or metadata-dependent]
[10/28/10 16:49:34.588]:viva_pa ST:Parameter: 'transaction-isolation-level' Value: [descriptor-dependent]
[10/28/10 16:49:34.588]:viva_pa ST:Parameter: 'use-single-connection' Value: [descriptor-dependent]
[10/28/10 16:49:34.589]:viva_pa ST:Parameter: 'minimal-metadata' Value: [descriptor-dependent]
[10/28/10 16:49:34.590]:viva_pa ST:Parameter: 'handle-stmt-results' Value: [descriptor-dependent]
[10/28/10 16:49:34.591]:viva_pa ST:Parameter: 'connection-tester-class' Value: 'com.novell.nds.dirxml.driver.jdbc.util.connect.JD BCConnectionTester'
[10/28/10 16:49:34.592]:viva_pa ST:Parameter: 'enable-refs' Value: true
[10/28/10 16:49:34.592]:viva_pa ST:Parameter: 'enable-meta-identifiers' Value: true
[10/28/10 16:49:34.593]:viva_pa ST:Parameter: 'left-outer-join-operator' Value: [descriptor-dependent]
[10/28/10 16:49:34.593]:viva_pa ST:Parameter: 'include-table-filter' Value: [descriptor-dependent]
[10/28/10 16:49:34.594]:viva_pa ST:Parameter: 'exclude-table-filter' Value: [descriptor-dependent]
[10/28/10 16:49:34.595]:viva_pa ST:Parameter: 'function-return-method' Value: [descriptor-dependent]
[10/28/10 16:49:34.596]:viva_pa ST:Parameter: 'state-dir' Value: '/home/admin/state/viva_pa'
[10/28/10 16:49:34.596]:viva_pa ST:Parameter: 'supports-schemas-in-metadata-retrieval' Value: [descriptor-dependent]
[10/28/10 16:49:34.597]:viva_pa ST:Parameter: 'column-position-comparator' Value: 'com.novell.nds.dirxml.driver.jdbc.util.config.com p.StringByteComparator'
[10/28/10 16:49:34.598]:viva_pa ST:Parameter: 'time-syntax' Value: '3'
[10/28/10 16:49:34.598]:viva_pa ST:Parameter: 'enable-locking' Value: false
[10/28/10 16:49:34.600]:viva_pa STriverShim.init() returned:
[10/28/10 16:49:34.600]:viva_pa ST:

--------------------

After the last command transformation rule is processed, an
Organizational Unit and Organizational Role are created, but the status
events don't go through output transformation:

Code:
--------------------
[10/28/10 16:51:08.988]:viva_pa ST:Filtering out notification-only attributes.
[10/28/10 16:51:08.988]:viva_pa ST:Pumping XDS to eDirectory.
[10/28/10 16:51:08.988]:viva_pa ST:Performing operation add for uni-passau\person\17964.
[10/28/10 16:51:08.988]:viva_pa ST:Adding entry uni-passau\person\17964.
[10/28/10 16:51:08.989]:viva_pa ST:Creating RDN 17964 in context uni-passau\person.
[10/28/10 16:51:08.997]:viva_pa ST:Performing operation add for uni-passau\person\17964\v1.
[10/28/10 16:51:08.997]:viva_pa ST:Adding entry uni-passau\person\17964\v1.
[10/28/10 16:51:08.997]:viva_pa ST:Creating RDN v1 in context uni-passau\person\17964.

[10/28/10 16:51:09.006]:viva_pa ST:Processing returned document.
[10/28/10 16:51:09.006]:viva_pa ST:Processing operation <status> for .
[10/28/10 16:51:09.006]:viva_pa ST:
DirXML Log Event -------------------
Driver: \IMUPTEST\service\drivers\viva_pa
Channel: Subscriber
Status: Success
Message: <application>DirXML</application>
<module>viva_pa</module>
<object-dn>PK_PERNR=97578813+PK_IT1001_BEGDA=2011-01-01+PK_IT1001_OBJID_PLANS=20220613,table=PA (uni-passau\person\17964)</object-dn>
<component>Subscriber</component>
[10/28/10 16:51:09.007]:viva_pa ST:Processing operation <status> for .
[10/28/10 16:51:09.007]:viva_pa ST:
DirXML Log Event -------------------
Driver: \IMUPTEST\service\drivers\viva_pa
Channel: Subscriber
Status: Success
Message: <application>DirXML</application>
<module>viva_pa</module>
<object-dn>PK_PERNR=97578813+PK_IT1001_BEGDA=2011-01-01+PK_IT1001_OBJID_PLANS=20220613,table=PA (uni-passau\person\17964)</object-dn>
<component>Subscriber</component>
[10/28/10 16:51:09.007]:viva_pa ST:End transaction.

--------------------


Any ideas?


--
absmeier
------------------------------------------------------------------------
absmeier's Profile: http://forums.novell.com/member.php?userid=21170
View this thread: http://forums.novell.com/showthread.php?t=424608