URL问题,请帮忙,多谢了!
在WebSphere5.0的测试环境运行下以test.jsp文件时提示:
java.sql.SQLException:指定了无效的Oracle URL
难道URL没有写对吗?怎么写才是对的呢?
<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin@10.3.0.125:1521:tesdb";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try
{
Class.forName(sDBDriver);
out.print("11");
conn = DriverManager.getConnection(sConnStr,"new3m","command");
out.print("22");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from tt");
out.print("22");
while (rs.next()){
out.println("" + rs.getInt(2) + "");
out.println(":"+"<br>");
}
rs.close();
}
catch(Exception e)
{
out.println(e);
}
%>