请教一个sql server的问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

请教一个sql server的问题

请教一个sql server的问题# Database - 数据库

c*x2002-04-08 07:04

1 楼

我通过jdbc执行一条语句：
INSERT INTO OBJECT VALUES ( 'login' , 'pass' , 1)
结果每次都产生下面的exception:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]No ResultSet set was
pr
oduced.
不过察看数据库，发现我的insert操作是成功的！！但是我的executeQuery是最后一条语
句啊!
请大侠给个提示是怎么回事，还有为什么会有这个exception, 谢谢先。

c*x2002-04-08 07:04

2 楼

I have already known the answer, don't bother to reply please.
Thanks.

was
语

【在 c********x 的大作中提到】

: 我通过jdbc执行一条语句：
: INSERT INTO OBJECT VALUES ( 'login' , 'pass' , 1)
: 结果每次都产生下面的exception:
: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]No ResultSet set was
: pr
: oduced.
: 不过察看数据库，发现我的insert操作是成功的！！但是我的executeQuery是最后一条语
: 句啊!
: 请大侠给个提示是怎么回事，还有为什么会有这个exception, 谢谢先。

m*g2002-04-08 07:04

3 楼

Would you please post your answer here? I, and other folks I believe, will be
interested and really appreciated.

条

【在 c********x 的大作中提到】

: I have already known the answer, don't bother to reply please.
: Thanks.
:
: was
: 语

c*x2002-04-08 07:04

4 楼

The answer is that I misused the executeQUERY(), in fact, we should use
executeUPDATE() instead.
I ever used mysql, which is fine to use executeQuery() for all queries and
updates, but for sql server,the two things are different.
SELECT uses executeQUERY(), INSERT, DELETE, UPDATE use executeUPDATE().

be
set
一

【在 m*g 的大作中提到】

: Would you please post your answer here? I, and other folks I believe, will be
: interested and really appreciated.
:
: 条