在学习一个留言板系统,用的是孙鑫的JAVA+WEB+开发详解:XML+XSLT+SERVLET+JSP+深入剖析与实例应用中的例子,然后在运行时出现下面的错误:
exception org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 9996:  out.println("用户名:"+rs.getString(2));
97:  out.println("  ");
98: 
99:  System.out.println(rs.getTimestamp("gst_time"));
100:  Timestamp ts=rs.getTimestamp("gst_time");
101:  long lms=ts.getTime();
102:  Date date=new Date(lms);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: 不支持从 timestamp 到 TIMESTAMP 的转换。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:841)
org.apache.jsp.index_jsp._jspService(index_jsp.java:208)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause com.microsoft.sqlserver.jdbc.SQLServerException: 不支持从 timestamp 到 TIMESTAMP 的转换。
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:946)
com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:1952)
com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:175)
com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:113)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1982)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1967)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.getTimestamp(SQLServerResultSet.java:2377)
org.apache.jsp.index_jsp._jspService(index_jsp.java:181)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)然后我看了一下,相关的语句是有
ResultSet rs=stmt.executeQuery("select * from guestbook order by gst_time desc");
还有
Timestamp ts=rs.getTimestamp("gst_time");
long lms=ts.getTime();
Date date=new Date(lms);
Time time=new Time(lms);
相应的的数据库表是这么建立的
[gst_id] [int] IDENTITY(1,1) NOT NULL primary key,
[gst_user] [varchar](10) NOT NULL,
[gst_title] [varchar](100) NOT NULL,
[gst_content] [text] NULL,
[gst_time] [timestamp] NOT NULL,
[gst_ip] [varchar](15) NOT NULL,
原书作者孙鑫使用的是mySql数据库,我使用的是sql2008的,难道是数据库不支持?
这个问题改怎么处理呢?新人第一次发帖,请专家帮助啊