jdbc在客户端连接oracle9i,在线等

jdbc驱动是ojdbc14.jar,路经设置应该没问题,用jsp连接连不上,jsp+tomcat5027+oracle9i,用户名,密码在服务器中以dba身份可以进入oracle9i,但在客户端用jsp连接时总是报错用户名和密码无效,郁闷,还请高手指教
<%@page contentType="text/html;charset=gb2312"
  import="java.sql.*"%>
<html>
<head>
</head>
<body>
<%String sDBDriver="oracle.jdbc.driver.OracleDriver";
String sConnStr="jdbc:oracle:thin:@192.168.0.54:1521:myora";
Class.forName(sDBDriver).newInstance();
Connection conn=DriverManager.getConnection(sConnStr,"system","sdrs");
Statement stmt=conn.createStatement();
String sql="SELECT * FROM  custom";
ResultSet rs=stmt.executeQuery(sql);
//rs为返回结果的ResultSet对象%>
<table bgcolor=lightyellow>
   <tr bgcolor=deepskyblue>
   <td>no.</td><td>name</td><td>address</td><td>phone</td>
   <td>mail</td><td>manager</td><td>career</td><td>email</td>
   <td>tel</td><td>birth</td>
   </tr>
   <%
   while(rs.next())
   {
   %>
   <tr>
   <td><%=rs.getString("uid")%></td>
   <td><%=rs.getString("nickname")%></td>
   <td><%=rs.getString("gender")%></td>
   <td><%=rs.getString("pwd")%></td>
   <td><%=rs.getString("realname")%></td>
   <td><%=rs.getString("career")%></td>
   <td><%=rs.getString("address")%></td>
   <td><%=rs.getString("email")%></td>
   <td><%=rs.getString("tel")%></td>
   <td><%=rs.getString("birth")%></td>
   </tr>
   <%
   }
   rs.close();
   stmt.close();
   conn.close();
   %>
   </table>
   </body>
   </html>
报错:
java.sql.SQLException: ORA-01017: invalid username/password; logon denied oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:496)
oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:278)
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.index_jsp._jspService(index_jsp.java:51)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)着急,请高手看一下

解决方案 »

  1.   

    错误在这行Connection conn=DriverManager.getConnection(sConnStr,"system","sdrs");，
      

  2.   

    要是你确定你用的用户名和密码是正确的，那看看192.168.0.54:1521:myora这个连接串对不对
    这段代码应该没有问题
      

  3.   

    服务器地址是对的，端口是１５２１，sid也是myora
      

  4.   

    应该没什么问题,你用class12.jar试试
      

  5.   

    没有啊,就一个,我还装了oracle的客户端
      

  6.   

    ORA-01017: invalid username/password; logon denied 
    Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password. 
    Action: Enter a valid username and password combination in the correct format.