Hi folks,

Anyone got some experience with the "correct" settings for the JDBC
driver subscriber to correctly sync back to the Identity Vault after a
record has been inserted?

I currently have a single table in mySQL (4.01.22) that I'm updating
based on changes to User objects in my Tree. Up until a few weeks
ago, the record Insert into mySQL and association back into the User
object worked fine. I updated my NetWare server to the most recent
service pack (6.5.6), and now the blasted IDM solution I developed is
giving me grief when I add the record.

Here's the DSTrace I'm seeing:
************************************************** ***
<nds dtdversion="3.0" ndsversion="8.x">
<source>
<product version="3.0.0.20051118 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<add class-name="employees" event-id="CDS_ADMIN#20070920204547#1#1"
qualified-src-dn="O=CDS\OU=CDS_Cincy\OU=KEC\CN=JBond"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KEC\JBond" src-entry-id="42577">
<add-attr attr-name="pk_empname">
<value naming="true" timestamp="1190320047#25"
type="string">JBond</value>
</add-attr>
<add-attr attr-name="emptype">
<value timestamp="1190320047#4" type="string">Part-time killer</value>
</add-attr>
<add-attr attr-name="empfullname">
<value timestamp="1190320047#2" type="string">James Bond</value>
</add-attr>
<add-attr attr-name="EmpHire">
<value type="time">1190321154</value>
</add-attr>
<add-attr attr-name="Active">
<value type="int">1</value>
</add-attr>
<add-attr attr-name="EmpType">
<value type="string">p</value>
</add-attr>
</add>
<modify class-name="employees" event-id="CDS_ADMIN#20070920204547#1#1"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KEC\JBond" src-entry-id="42577">
<modify-attr attr-name="Comment">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="EmpType">
<remove-all-values/>
<add-value>
<value type="string">f</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: Submitting document to
subscriber shim:
16:45:54 AF6635C0 Drvrs: mySQLusersync ST:
<nds dtdversion="3.0" ndsversion="8.x">
<source>
<product version="3.0.0.20051118 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<add class-name="employees" event-id="CDS_ADMIN#20070920204547#1#1"
qualified-src-dn="O=CDS\OU=CDS_Cincy\OU=KEC\CN=JBond"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KEC\JBond" src-entry-id="42577">
<add-attr attr-name="pk_empname">
<value naming="true" timestamp="1190320047#25"
type="string">JBond</value>
</add-attr>
<add-attr attr-name="emptype">
<value timestamp="1190320047#4" type="string">Part-time killer</value>
</add-attr>
<add-attr attr-name="empfullname">
<value timestamp="1190320047#2" type="string">James Bond</value>
</add-attr>
<add-attr attr-name="EmpHire">
<value type="time">1190321154</value>
</add-attr>
<add-attr attr-name="Active">
<value type="int">1</value>
</add-attr>
<add-attr attr-name="EmpType">
<value type="string">p</value>
</add-attr>
</add>
<modify class-name="employees" event-id="CDS_ADMIN#20070920204547#1#1"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KEC\JBond" src-entry-id="42577">
<modify-attr attr-name="Comment">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="EmpType">
<remove-all-values/>
<add-value>
<value type="string">f</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds>
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: BEGIN Transaction
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: INSERT INTO
employees(pk_empname, empfullname, emphire, active, emptype) VALUES
(?, ?, ?, ?, ?)
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: IN @ index 1, field
'pk_empname', length: 5, value = 'JBond'
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: IN @ index 2, field
'empfullname', length: 10, value = 'James Bond'
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: IN @ index 3, field
'emphire', value = 2007-09-20
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: IN @ index 4, field
'active', value = 1
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: IN @ index 5, field
'emptype', length: 1, value = 'p'
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: ROLLBACK
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: SubscriptionShim.execute()
returned:
16:45:54 AF6635C0 Drvrs: mySQLusersync ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070430_1009" instance="mySQLusersync"
version="2.1.7(BETA, NON-PRODUCTION, PRE-RELEASE)">DirXML Driver for
JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="CDS_ADMIN#20070920204547#1#1" level="error"
type="driver-general">
<description>Unable to add object. Unable to retrieve auto-generated
primary key value. Result set is empty.</description>
<object-dn>O=CDS\OU=CDS_Cincy\OU=KEC\CN=JBond</object-dn>
<jdbc:document xml:space="preserve"><nds dtdversion="3.0"
ndsversion="8.x">
<source>
<product version="3.0.0.20051118 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<add class-name="employees"
event-id="CDS_ADMIN#20070920204547#1#1"
qualified-src-dn="O=CDS\OU=CDS_Cincy\OU=KEC\CN=JBond"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KEC\JBond" src-entry-id="42577">
<add-attr attr-name="pk_empname">
<value naming="true" timestamp="1190320047#25"
type="string">JBond</value>
</add-attr>
<add-attr attr-name="emptype">
<value timestamp="1190320047#4" type="string">Part-time
killer</value>
</add-attr>
<add-attr attr-name="empfullname">
<value timestamp="1190320047#2" type="string">James
Bond</value>
</add-attr>
<add-attr attr-name="EmpHire">
<value type="time">1190321154</value>
</add-attr>
<add-attr attr-name="Active">
<value type="int">1</value>
</add-attr>
<add-attr attr-name="EmpType">
<value type="string">p</value>
</add-attr>
</add>
16:45:54 AF6635C0 Drvrs: <modify class-name="employees"
event-id="CDS_ADMIN#20070920204547#1#1_opData1"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KEC\JBond" src-entry-id="42577">
<modify-attr attr-name="Comment">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="EmpType">
<remove-all-values/>
<add-value>
<value type="string">f</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds></jdbc:document>
</status>
</output>
</nds>
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: No input transformation
policies.
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: Applying schema mapping
policies to input.
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: Resolving association
references.
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: Processing returned
document.
16:45:54 AF6635C0 Drvrs: mySQLusersync ST: Processing operation
<status> for .
16:45:54 AF6635C0 Drvrs: mySQLusersync ST:
DirXML Log Event -------------------
Driver: \CDS_TREE\CDS\IdentityMgr\mySQLusersync
Channel: Subscriber
Object: \CDS_TREE\CDS\CDS_Cincy\KEC\JBond
Status: Error
Message: <description>Unable to add object. Unable to retrieve
auto-generated primary key value. Result set is empty.</description>
<object-dn>O=CDS\OU=CDS_Cincy\OU=KEC\CN=JBond</object-dn>
<jdbc:document xml:space="preserve" xmlns:jdbc="urn:dirxml:jdbc"><nds
dtdversion="3.0" ndsversion="8.x">
<source>
<product version="3.0.0.20051118 ">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<input>
<add class-name="employees"
event-id="CDS_ADMIN#20070920204547#1#1"
qualified-src-dn="O=CDS\OU=CDS_Cincy\OU=KEC\CN=JBond"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KEC\JBond" src-entry-id="42577">
<add-attr attr-name="pk_empname">
<value naming="true" timestamp="1190320047#25"
type="string">JBond</value>
</add-attr>
<add-attr attr-name="emptype">
<value timestamp="1190320047#4" type="string">Part-time
killer</value>
</add-attr>
<add-attr attr-name="empfullname">
<value timestamp="1190320047#2" type="string">James
Bond</value>
</add-attr>
<add-attr attr-name="EmpHire">
<value type="time">1190321154</value>
</add-attr>
<add-attr attr-name="Active">
<value type="int">1</value>
</add-attr>
<add-attr attr-name="EmpType">
<value type="string">p</value>
</add-attr>
</add>
<modify class-name="employees"
event-id="CDS_ADMIN#20070920204547#1#1_opData1"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KEC\JBond" src-entry-id="42577">
16:45:54 AF6635C0 Drvrs: <modify-attr attr-name="Comment">
<remove-all-values/>
</modify-attr>
<modify-attr attr-name="EmpType">
<remove-all-values/>
<add-value>
<value type="string">f</value>
</add-value>
</modify-attr>
</modify>
</input>
</nds></jdbc:document>
************************************************** ********

When I look at the mySQL log file, it shows the record getting added
correctly to the table:

************************************************** ********
2 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
2 Prepare [1] SELECT pk_empname FROM employees WHERE pk_empname =
? ORDER BY pk_empname
2 Execute [1] SELECT pk_empname FROM employees WHERE pk_empname =
'JBond' ORDER BY pk_empname
2 Query SHOW WARNINGS
2 Query SET autocommit=0
2 Prepare [2] INSERT INTO employees(pk_empname, empfullname,
emphire, active, emptype) VALUES (?, ?, ?, ?, ?)
2 Execute [2] INSERT INTO employees(pk_empname, empfullname,
emphire, active, emptype) VALUES ('JBond', 'James Bond', '2007-09-20',
1, 'p')
2 Query SHOW WARNINGS
2 Query rollback
2 Query SHOW WARNINGS
************************************************** ********

Here's the subscriber settings on my driver:

<subscriber-options>
<disable display-name="Disable subscriber?">_</disable>
<ignore10 display-name="Show primary key parameters?">show</ignore10>
<key-gen-method display-name="Generation/retrieval method
(table-global):">auto</key-gen-method>
<key-gen-timing display-name="Retrieval timing
(table-global):">_</key-gen-timing>
<key-gen display-name="Method and timing
(table-local):">employees(auto)</key-gen>
<disable-locking display-name="Disable statement-level
locking?">0</disable-locking>
<check-update-count display-name="Check update
counts?">_</check-update-count>
</subscriber-options>

I'm not sure why the NetWare upgrade would have messed up anything,
but after re-reading through the IDM Driver manual for the JDBC driver
and mySQL, I don't see any specific mySQL settings that need to be in
place (in case the my.cnf file was re-written). I've downloaded the
latest mySQL/J connector and installed that JAR file, still with the
same results. The only other thing I can see is that there are two
'mysql-connector-java*' modules being loaded - a 3.1.11 being loaded
from JAVA\LIB\EXT, and the recent update I installed, 5.0.7, loaded
from SYSTEM\LIB.

There's a lot of stuff here, but any help would be appreciated.
Thanks!

Bill