Hi,
I am using the jtds1.2.5 jar to connect to MS SQL 2008 server. I am
using the driver in schema unaware mode(all tables/views excluded) and
inserting data using direct sql commands executed by command processor.
(shown below
<DO-SET-LOCAL-VARIABLE NAME=\"VARINSERTSTATEMENT\">
<ARG-NODE-SET>
<TOKEN-XML-PARSE>
<TOKEN-TEXT
XML:SPACE=\"PRESERVE\">&LT;INPUT>&LT;JDBC:STATEMEN T
JDBC:TRANSACTION-ID=\"3\" JDBC:TRANSACTION-TYPE=\"MANUAL\"
JDBC:TYPE=\"\" XMLNS:JDBC=\"URNIRXML:JDBC\">&LT;JDBC:SQL>INSERT INTO
DBO.IDM_USERROLE(USERID,ROLEID) VALUES
('$VAR_UID$','$CURRENT-NODE$')&LT;/JDBC:SQL>&LT;/JDBC:STATEMENT>&LT;/INPUT></TOKEN-TEXT>
</TOKEN-XML-PARSE>
</ARG-NODE-SET>
</DO-SET-LOCAL-VARIABLE>
<DO-SET-LOCAL-VARIABLE NAME=\"VARINSERTOUTPUT\">
<ARG-NODE-SET>
<TOKEN-XPATH
EXPRESSION=\"CMD:EXECUTE($DESTCOMMANDPROCESSOR,$VA RINSERTSTATEMENT)\"/>
</ARG-NODE-SET>
</DO-SET-LOCAL-VARIABLE>

The problem is: even though the trace level is 7, and the sqls, dirxml
commands are executed properly, a zero size trace file is formed. I do
not see *any* dirxml log in the trace..

I have used the jdbc driver in a similar manner before using sqljdbc
jar on MS SQL 2005 but I never had any issues. I am not sure what am
missing here!!

Please HELP!


--
varunece
------------------------------------------------------------------------
varunece's Profile: http://forums.novell.com/member.php?userid=42999
View this thread: http://forums.novell.com/showthread.php?t=440858