我是刚学jsp,没学多久就遇到了问题,之前在网上查了好多办法,都没有弄好,求求哪位好心人帮帮我
exceptionorg.apache.jasper.JasperException: An exception occurred processing JSP page /sql_1.jsp at line 1512: String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
13: String user="sa";
14: String password="sa";
15: Connection con=DriverManager.getConnection(url,user,password);
16: Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
17: String sql="select * from t_sno";
18: ResultSet rs=stmt.executeQuery(sql);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:408)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)root causejavax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.sql_005f1_jsp._jspService(sql_005f1_jsp.java:98)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)root causejava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.sql_005f1_jsp._jspService(sql_005f1_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs.
解决方案 »
- 请教一下,有没有高手指点一下,做个小小的CHECKBOX的应用
- 请教hibernate问题。。。。。。急!!!!
- jsp 动态传递参数
- 怎么用java写一个正则表达式,把字符中的<,> ,(,[,},*,%类似的字符替换为空格?
- 关于使用<iframe>标记出现乱码的问题?(怀疑是tomcat的问题,请高手指点,快急死了!)
- 请教jsp
- 怎样才能把这个id送过去?
- 初学:简单的JSP显示问题!写了一个简单的JSP,调用了hello.class,但在IE上确提示找不到hello.class
- struts2 action跳转
- 大神们下午好,求解一个bug 。
- 使用了dojo的a标签后struts2的div标签不自动加载资源
- 求大牛解答关于Struts2的<s:debug>标签的问题
这里会出现异常,你没有处理。
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try{con=DriverManager.getConnection(url,user,password);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from t_sno";
ResultSet rs=stmt.executeQuery(sql);}
catch(Exception e){
}
这句话出错了,改写成
String url="jdbc:microsoft:sqlserver://localhost:1433/student";就ok了1433是不是你的端口号呀。很多人都是3306
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");Connection con = DriverManager.getConnection(url,user,password);
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection(url,user,password);
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
也说了驱动引起的,
先加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
然后再做下一步操作啊……
Connection con = DriverManager.getConnection(url,user,password);
sqlserver的url就是这么写的,默认端口号是1433。3306是mysql的默认端口号。楼主忘了加载jar包了,应该是!sqlserver共有3个jar包:msbase.jar、mssqlserver.jar、msutil.jar并且以这种方式实现的话,xp用户需要打SP3的补丁
另附,以前整理的SqlServer的jdbc实现方式。第一种:JDBC-ODBC数据库连接桥(需要配置ODBC数据源,不需下载驱动)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:数据源名称","用户名","密码"); 第二种:利用Microsoft提供的驱动程序(XP用户需要打SP3的补丁,需要下载驱动)
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=数据库名","用户名","密码"); 第三种:利用第三方提供的驱动程序(需要下载驱动)
Class.forName("net.sourceforge.jtds.jdbc.Driver");
con=DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/数据库名;user=用户名;password=密码"); 第四种:在Struts下配置数据源(其实这种方式跟上边的不属于一种类型)
<data-sources>
<data-source key="在Struts中数据源的名称" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="sun.jdbc.odbc.JdbcOdbcDriver" />
<set-property property="url" value="jdbc:odbc:数据源" />
<set-property property="username" value="用户名" />
<set-property property="password" value="密码" />
</data-source>
</data-sources> 额,我没仔细看报的什么错,总之就先贴上来了,我学校马上要断网了,~~~~(>_<)~~~~
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.异常已经说的很清楚了,,不能启用端口号,你用命令查看一下1433端口开了没有!!