我连ORACLE的时候,提示这个错误信息:java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-02248: invalid option for ALTER SESSION
请问是什么问题,应该如何解决?谢谢源码如下: <%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%!
String DBDRIVER="oracle.jdbc.driver.OracleDriver";
String DBURL="jdbc:oracle:thin:@10.101.0.100:1521:ORCL";
String DBUSER="xym";
String DBPASSWORD="xie93ym";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
%>
<%
try
{
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
String sql = "Select a,b from test";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
out.println("<table border=1 width=400");
while(rs.next()){
String col1 = rs.getString(1);
String col2 = rs.getString(2);
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td></tr>");
}
out.println("</table>");
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println(e);
}
%>
请问是什么问题,应该如何解决?谢谢源码如下: <%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%!
String DBDRIVER="oracle.jdbc.driver.OracleDriver";
String DBURL="jdbc:oracle:thin:@10.101.0.100:1521:ORCL";
String DBUSER="xym";
String DBPASSWORD="xie93ym";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
%>
<%
try
{
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
String sql = "Select a,b from test";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
out.println("<table border=1 width=400");
while(rs.next()){
String col1 = rs.getString(1);
String col2 = rs.getString(2);
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td></tr>");
}
out.println("</table>");
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println(e);
}
%>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货