<2003-7-30 上午09时11分07秒> <Error> <HTTP> <101017> <[ServletContext(id=7129651 ,name=upload,context-path=/upload)] Root cause of ServletException weblogic.jdbc.mssqlserver4.TdsException: Statement.executeQuery - No result sets were produced by 'INSERT INTO TFILES (FILENAME) VALUES ('3')' at weblogic.jdbc.mssqlserver4.TdsStatement.executeQuery(TdsStatement.jav a:79) at jsp_servlet._util.__conn._jspService(__conn.java:108) at weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run (ServletStubImpl.java:1058) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm pl.java:401) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm pl.java:445) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm pl.java:306) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio n.run(WebAppServletContext.java:5412) at weblogic.security.service.SecurityServiceManager.runAs(SecurityServic eManager.java:744) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe rvletContext.java:3086) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm pl.java:2544) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134) >
具体的错误如上所示,Rst和Stmt都定义过了
其实我在插入记录的时候,确实插入了记录。但是页面上报错。 Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected condition which prevented it from fulfilling the request. 也就是说执行成功了,但是weblogic服务器内部错误.我就不太理解了。可是我在oracle中使用同样的方法,就没有任何问题,我就是不知道怎么回事,可是我必须用sql server. 真的很急,请帮帮忙
select 可以,但是insert into TFILES (FILENAME)VALUES('AAA')就不行了。 但是数据库中确实已经插入了AAA。还是报相同的错误。这是为什么呢?Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected condition which prevented it from fulfilling the request.
,name=upload,context-path=/upload)] Root cause of ServletException
weblogic.jdbc.mssqlserver4.TdsException: Statement.executeQuery - No result sets
were produced by 'INSERT INTO TFILES (FILENAME) VALUES ('3')'
at weblogic.jdbc.mssqlserver4.TdsStatement.executeQuery(TdsStatement.jav
a:79)
at jsp_servlet._util.__conn._jspService(__conn.java:108)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:1058)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:401)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:445)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:306)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:5412)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServic
eManager.java:744)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3086)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2544)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)
>
Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.
也就是说执行成功了,但是weblogic服务器内部错误.我就不太理解了。可是我在oracle中使用同样的方法,就没有任何问题,我就是不知道怎么回事,可是我必须用sql server.
真的很急,请帮帮忙
Conn = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:upload@localhost","sa","sa");//此处根据你的SQLServer帐户而定。 Stmt = Conn.createStatement(); Rst = Stmt.executeQuery("select * from TFILES");
while(Rst.next){
String s=Rst.getString("FILENAME");
out.print(s);
}
Conn = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:upload@localhost","sa","sa");//此处根据你的SQLServer帐户而定。 Stmt = Conn.createStatement(); Rst = Stmt.executeQuery("select * from TFILES");
while(Rst.next()){
String s=Rst.getString("FILENAME");
out.print(s);
}不好意思忘记加()了
但是数据库中确实已经插入了AAA。还是报相同的错误。这是为什么呢?Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.
看weblogic的异常来猜测:
你的insert是用stmt.executeQuery来执行的
实际上要用stmt.executeUpdate或者是stmt.execute