Hi folks, I've been dinking around with this this morning trying to
generate a java.sql.timestamp value for today to add to a MSSQL table.
I've tried a few variations on this, but to no avail. Here's the
error I keep receiving:

**************************************************
DirXML Log Event -------------------
Driver: \CDS_TREE\CDS\IdentityMgr\Deltekusersync
Channel: Subscriber
Object: \CDS_TREE\CDS\CDS_Cincy\KBaldwin
Status: Warning
Message: Code(-8003) Unable to synchronize reference to
\CDS_TREE\CDS\eGuideUsers from attribute Group Membership.
11:31:57 8968A5E0 Drvrs: Deltekusersync ST: Processing returned
document.
11:31:57 8968A5E0 Drvrs: Deltekusersync ST: Processing operation
<status> for .
11:31:57 8968A5E0 Drvrs: Deltekusersync ST:
DirXML Log Event -------------------
Driver: \CDS_TREE\CDS\IdentityMgr\Deltekusersync
Channel: Subscriber
Object: \CDS_TREE\CDS\CDS_Cincy\KBaldwin
Status: Warning
Message: Column 'Group Membership' is undefined on table/view
'eDirSync' or is unsyncable.
11:31:57 8968A5E0 Drvrs: Deltekusersync ST: Processing operation
<status> for .
11:31:57 8968A5E0 Drvrs: Deltekusersync ST:
DirXML Log Event -------------------
Driver: \CDS_TREE\CDS\IdentityMgr\Deltekusersync
Channel: Subscriber
Object: \CDS_TREE\CDS\CDS_Cincy\KBaldwin
Status: Error
Message: <description>Unable to add object. Unable to insert row into
table/view 'eDirSync'. Unable to convert directory time value
'XPATH("jtimestamp:getTime(jdate:new())")' to type
'java.sql.Timestamp'.</description>
<object-dn>O=CDS\OU=CDS_Cincy\CN=KBaldwin</object-dn>
<jdbc:document 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="User"
event-id="CDS_ADMIN#20071210155738#2#2"
qualified-src-dn="O=CDS\OU=CDS_Cincy\CN=KBaldwin"
src-dn="\CDS_TREE\CDS\CDS_Cincy\KBaldwin" src-entry-id="42648">
<add-attr attr-name="CN">
<value naming="true" timestamp="1196968148#46"
type="string">KBaldwin</value>
</add-attr>
<add-attr attr-name="Surname">
<value timestamp="1197304311#2"
type="string">Baldwinn</value>
</add-attr>
<add-attr attr-name="Given Name">
<value timestamp="1196968148#15"
type="string">Katrina</value>
</add-attr>
<add-attr attr-name="Internet EMail Address">
<value timestamp="1196968148#9"
type="string">KBaldwin@cds-assoc.com</value>
</add-attr>
<add-attr attr-name="employeeStatus">
<value>A</value>
</add-attr>
<add-attr attr-name="emHireDate">
<value
type="time">XPATH("jtimestamp:getTime(jdate:new()) ")</value>
</add-attr>
<add-attr attr-name="emJobCostRate">
<value type="int">1</value>
</add-attr>
</add>
</input>
</nds>
11:31:57 8968A5E0 Drvrs: </jdbc:document>
11:31:57 8968A5E0 Drvrs: Deltekusersync ST: End transaction.
**************************************************

I've added the following namespace definitions into my policy:

jdate : java.util.Date (java extension checkbox checked)
jtimestamp : java.sql.timestamp (java extension checkbox checked)

but to no avail. I think that java.util.Date is pre-loaded with other
JAVA modules on my NetWare server, but what about java.sql.timestamp?
Is there an easier method to convert to a java.sql.timestamp value?
Thanks!

Bill