Problems with SQL server driver & XML retrievel

[Ashwin]

Hi,

I am getting a sql exception when i am trying to use the "FOR XML
AUTO" feature of SQL Server 2000 DB. The problems comes only when i
use the SQL Server 2000 Driver for JDBC which is a Type 4 driver. When
i used a JDBC-ODBC bridge driver it worked fine.
Thanks,
Ashwin
The exception is as follows:
10:29:39,263 INFO [STDOUT] java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The FOR XML
clause is not allowed in a
10:29:39,294 ERROR [Engine] Error Occured while logging into the
system.
java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC][SQLServer]The FOR XML clause is not allowed in a
CURSOR
at com.ehars.beans.admin.dataadmin.sb.CreateDataSetSB.executeXmlSelect(CreateDataSetSB.java:261)
at com.ehars.beans.admin.dataadmin.sb.CreateDataSetSB.createEvalDS(CreateDataSetSB.java:41)
at com.ehars.application.action.admin.dataadmin.SendDataToCdcAction.perform(SendDataToCdcAction.java:110)
at org.apache.struts.action.Action.execute(Action.java:415)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:480)
at com.ehars.application.action.RequestProcessor.process(RequestProcessor.java:185)
at com.ehars.application.action.ActionServlet.process(ActionServlet.java:281)
at com.ehars.application.action.ActionServlet.doPost(ActionServlet.java:122)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:469)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1040)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1151)
at java.lang.Thread.run(Thread.java:536)