Redian新闻
>
MS SQL Server JDBC Driver Problem
avatar
MS SQL Server JDBC Driver Problem# Java - 爪哇娇娃
p*n
1
I am using MS SQL SERVER JDBC DRIVER under Weblogic 7 to call an MS SQL Server
stored procedure. The stored procedure returns a xml string like this:

...
...
...

so far so good.
the problem comes up when there is some characters like "'" is contained in
the string, e.g.,
Let's go and have fun
Then the SP call returns some funky character which XALAN is not able to
parse.
Tried to execute the SP from SQL Server client and the result returned is
fine.
A
avatar
st
2
wrap it with CDATA block or encode it with XML encoding(I prefer first way)

【在 p***n 的大作中提到】
: I am using MS SQL SERVER JDBC DRIVER under Weblogic 7 to call an MS SQL Server
: stored procedure. The stored procedure returns a xml string like this:
:
: ...
: ...
: ...
:

: so far so good.
: the problem comes up when there is some characters like "'" is contained in
: the string, e.g.,

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。