在JSP中用JDBC连接ORACLE的问题? 数据库类型和JDBC类型或版本不匹配? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 谢谢我的JDBC完全是JB7的,ORACLE为第9版,哪应该怎么做? 刚才哪一位已经搞定了,把classes12.jar复制到tomcat的lib中就可以了;但在这一步又出错了: try { conn=DriverManager.getConnection(URL_ONE,this.USERNAME_ONE,PASSWORD_ONE); } catch(SQLException e) { System.err.print(e.toString()); }提示什么:java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))There is not JDBC driver!StandardWrapperValve[debugjsp]: Servlet.service() for servlet debugjsp threw exceptionjava.lang.NullPointerException应该怎么做? 谢谢 试试在环境变量classpath加上classes12.jar,最好放在第一个位置。 *执行一条insert语句并传参数*/create or replace procedure p_test2(i in number) asbegininsert into t values (i,'x'||to_char(i));commit;end;/<%@ page language="java" contentType="text/html;charset=gb2312"%><%@page import="java.sql.*"%><html><body><table><tr><td>aaa</td><td>bbb</td></tr><%String driver = "oracle.jdbc.driver.OracleDriver";String strUrl = "jdbc:oracle:thin:@192.168.1.6:1521:db"; Class.forName(driver); Connection conn = DriverManager.getConnection(strUrl, "scott", "tiger"); String procedure = "{call p_test2 (?) }"; CallableStatement cstmt = conn.prepareCall(procedure); cstmt.setInt(1,33); cstmt.executeUpdate(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from t"); while(rs.next()) { out.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td></tr>"); } rs.close(); stmt.close(); conn.close();%></table><p><%out.print(conn.isClosed());%></body></html></body> </html> 先把oracle 9i的 jdbc驱动加到classpaht中去,然后再try { conn=DriverManager.getConnection(URL_ONE,this.USERNAME_ONE,PASSWORD_ONE); } catch(SQLException e) { System.err.print(e.toString()); }我一直这样做,百发百中 谢谢上面,我已经先把oracle 9i的 jdbc驱动加到classpath中去了,还是不行 求指点 .do的疑惑,求解答 各位给个意见,(JSP)如何架构B/S系统(CRM系统)比较好(或者说比较流行) 怎么解决JPA Enitity的LAZY问题 struts2.1.6 和 spring 3.01 下拉框怎么写,我忘了! file javax\servlet\jsp\PageContext.class not found java数组问题,解决问题已经给分50 jsp中如何实现在一个表单中用不同的按钮将内容提交到不同的页面上去? javabean的疑难 循环显示的记录在不同的行显示出来,怎么实现??请帮我看看!!!!在线等待!! 请问大家写jsp,都用什么工具的,谢谢!
try {
conn=DriverManager.getConnection(URL_ONE,this.USERNAME_ONE,PASSWORD_ONE);
}
catch(SQLException e)
{
System.err.print(e.toString());
}提示什么:
java.sql.SQLException: Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))There is not JDBC driver!StandardWrapperValve[debugjsp]: Servlet.service() for servlet debugjsp threw exceptionjava.lang.NullPointerException
应该怎么做? 谢谢
create or replace procedure p_test2(i in number) as
begin
insert into t values (i,'x'||to_char(i));
commit;
end;
/<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<body>
<table>
<tr><td>aaa</td><td>bbb</td></tr>
<%
String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin:@192.168.1.6:1521:db";
Class.forName(driver);
Connection conn = DriverManager.getConnection(strUrl, "scott", "tiger"); String procedure = "{call p_test2 (?) }";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.setInt(1,33);
cstmt.executeUpdate(); Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from t"); while(rs.next())
{
out.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td></tr>");
} rs.close();
stmt.close();
conn.close();
%>
</table>
<p>
<%
out.print(conn.isClosed());
%></body>
</html>
</body>
</html>
然后再try {
conn=DriverManager.getConnection(URL_ONE,this.USERNAME_ONE,PASSWORD_ONE);
}
catch(SQLException e)
{
System.err.print(e.toString());
}我一直这样做,百发百中
还是不行