Hi everyone, I've run into a confusing issues that I'm hoping someone
else has a suggestion for.

I'm running IDM 3.0, with the JDBC driver 2.1, Microsoft SQL Server
2000 on a Windows 2000 server, and the Microsoft SQL Server 2000
Driver for JDBC ( Service Pack 3, Version 2.2.0040, May 2004).

I have a table of employees in MS SQL with a Float attribute value
that I'm trying to set to a default value during the record Add, but
when it performs the operation, I get the following error: "Unable to
add object. Unable to insert row into table/view 'eDirSync'.
Unsupported SQL type 'java.sql.Types.FLOAT'.". Here's the actual
DirXML trace of the Add operations:

************************************************** **************
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20051122_1255" instance="Deltekusersync"
version="2.1">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="CDS_ADMIN#20080101224533#3#2" level="error"
type="driver-general">
<description>Unable to add object. Unable to insert row into
table/view 'eDirSync'. Unsupported SQL type
'java.sql.Types.FLOAT'.</description>
<object-dn>O=CDS\OU=CDS_Cincy\CN=GSaintpauligirl</object-dn>
<jdbc:document>
<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="eDirSync" event-id="CDS_ADMIN#20080101224533#3#2"
qualified-src-dn="O=CDS\OU=CDS_Cincy\CN=GSaintpauligirl"
src-dn="\CDS_TREE\CDS\CDS_Cincy\GSaintpauligirl" src-entry-id="42675">
<add-attr attr-name="pk_emEmployee">
<value naming="true" timestamp="1199218536#25"
type="string">GSaintpauligirl</value>
</add-attr>
<add-attr attr-name="emLastName">
<value timestamp="1199218536#10" type="string">SaintPauliGirl</value>
</add-attr>
<add-attr attr-name="emFirstName">
<value timestamp="1199232708#2" type="string">Greta</value>
</add-attr>
<add-attr attr-name="emEMail">
<value timestamp="1199218536#2"
type="string">gsaintpauligirl@cds-assoc.com</value>
</add-attr>
<add-attr attr-name="pk_emEmployee">
19:11:49 947FE160 Drvrs: <value>GSAINTPAUL</value>
</add-attr>
<add-attr attr-name="emStatus">
<value>A</value>
</add-attr>
<add-attr attr-name="emHireDate">
<value type="time">1199232709</value>
</add-attr>
<add-attr attr-name="emJobCostRate">
<value type="int">1</value>
</add-attr>
</add>
</input>
</nds>
</jdbc:document>
</status>
</output>
</nds>
19:11:49 947FE160 Drvrs: Deltekusersync : Remote Interface Driver:
Received document for subscriber channel

************************************************** **************

The emJobCostRate attribute at the bottom is the problem for me. Right
now I've got it designated as an Int in my Creation Policy, since
there's not a Float value type in Designer. What's a developer to do?

Thanks for any suggestions!
Bill