高分请教 weblogic下 jsp连接数据库oracle9i的问题

[delegent]

我编写的一段代码，
<% String url="jdbc:oracle:thin:@localhost:1521:workora";
String user="cheng";
String password="friend";
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection connection=DriverManager.getConnection(url,user,password);
Statement stmt=connection.createStatement();
ResultSet rs=stmt.executeQuery("select * from test;");
%>
<% while(rs.next()){%>
<%=rs.getString(1)%>
<br>
<%=rs.getString(2)%>
<%}%>
然后运行：
<2002-4-8 下午08时03分39秒> <Error> <HTTP> <101017> <[ServletContext(id=5761475,name=testdb,context-path=/testdb)] Root cause of ServletException

java.sql.SQLException: ORA-00911: 无效字符


at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)

at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)

at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)

at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)

at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:538)

at jsp_servlet.__testdb._jspService(__testdb.java:98)

at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)

at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:945)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:332)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:376)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:242)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5363)

at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:721)

at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3043)

at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2466)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152)

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)

>

各位，这是什么错误？？ 已在weblogic中建立 connection pool, datasource.
另外在jubilder 中，也已经包括class12.zip ,用database pliot测试成功
如果不用jsp，直接用应用程序，这可以成功。
各位高手，问题出在那里？？？

急

[Lutx]

ResultSet rs=stmt.executeQuery("select * from test;");

SQL语句中的分号不要。

[Duplicity]

对，在这里写SQL不要分号