I created this JDBC driver from scratch in an IDM 3.5 environment.

My last XML doc prior to submit contains the following:

<add class-name="user" event-id="fox2#20080919213931#99#1" qualified-src-dn="O=idauto\OU=users\OU=employees\CN=cblack" src-dn="\IDAUTO-TREE\idauto\users\employees\cblack" src-entry-id="32895">
<add-attr attr-name="username">
<value naming="true" timestamp="1213087141#20" type="string">cblack</value>
<add-attr attr-name="first_name">
<value timestamp="1221631061#4" type="string">Cai</value>
<add-attr attr-name="email">
<value timestamp="1213087179#11" type="string">cai.black@idauto.net</value>
<add-attr attr-name="last_name">
<value timestamp="1213087141#3" type="string">Black</value>
<add-attr attr-name="password">
<add-attr attr-name="account_enabled">
<value type="int">1</value>


The key is the "account_enabled" attribute. Notice it is type "int".
I also tried as string.

The driver then does this:

idapp-mysql-fixx ST:INSERT INTO user(email, first_name, account_enabled, last_name, username, password) VALUES (?, ?, ?, ?, ?, ?)
idapp-mysql-fixx ST: IN @ index 1, field 'email', length: 20, value = 'cai.black@idauto.net'
idapp-mysql-fixx ST: IN @ index 2, field 'first_name', length: 3, value = 'Cai'
idapp-mysql-fixx ST: IN @ index 3, field 'account_enabled', value = true
idapp-mysql-fixx ST: IN @ index 4, field 'last_name', length: 5, value = 'Black'
idapp-mysql-fixx ST: IN @ index 5, field 'username', length: 6, value = 'cblack'
idapp-mysql-fixx ST: IN @ index 6, field 'password', length: 40, value = '6b2e94d8c3c0f6c055eaa40daf8d0bb23f57305a'
idapp-mysql-fixx ST: RS @ index 1, field 'id', value = 5


Notice that "account_enabled" is set to true. The column definition in
the database is TINYINT(1). The result is a null value in that column.
I need it to be the INT of 1.

Troy Moreland
tbmoreland's Profile: http://forums.novell.com/member.php?userid=14837
View this thread: http://forums.novell.com/showthread.php?t=344338