📄 579776.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<TopicId>579776</TopicId>
<TopicName>请教！！ resin和tomcat的移植转换问题！！！</TopicName>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>18</ReplyNum>
<PostDateTime>2002-3-16 1:33:49</PostDateTime>
<Point>70</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>我的程序在resin服务器下已经全部实现的了，没有错误。
现在提供网站空间的服务器是用tomcat的，所以我务必 要转到tomcat下实现我的程序，所以请教各位有经验的大侠！！ 
tomcat服务器我已经配置好的了，可以运行“某些”jsp。说某些的意思是调用数据库的jsp则会出现错误，而用了javabean的页面同样也是。
特此请教各位有从resin中移植程序到tomcat下的高手！ 高分相送！</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>灯泡</PostUserNickName>
<rank>一星(中级)</rank>
<ranknum>star1</ranknum>
<credit>134</credit>
<ReplyID>3853680</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>98085</PostUserId>
<PostUserName>leonzhao</PostUserName>
<Point>0</Point>
<Content>说明一下出了什么错误。
</Content>
<PostDateTime>2002-3-16 6:00:51</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3868462</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>主要是以下两种提示错误吧：
javax.servlet.ServletException
	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:481)
还有：
java.lang.AbstractMethodError
	at yangchun.Linkdb.executeQuery(Linkdb.java:26)
</Content>
<PostDateTime>2002-3-17 21:07:45</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>灯泡</PostUserNickName>
<rank>一星(中级)</rank>
<ranknum>star1</ranknum>
<credit>134</credit>
<ReplyID>3870027</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>98085</PostUserId>
<PostUserName>leonzhao</PostUserName>
<Point>30</Point>
<Content>看的不明所以……
我猜想是不是classpath没有设置对？</Content>
<PostDateTime>2002-3-18 7:07:39</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>林材</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>3871077</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>102177</PostUserId>
<PostUserName>southline</PostUserName>
<Point>0</Point>
<Content>It is your DB driver error.
Assure you are already load the driver in your server,
or set driver in your classpath.</Content>
<PostDateTime>2002-3-18 9:48:06</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3873951</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>很抱歉，我想我的classpath已经设置好的了，因为在resin下面，系统是很好的在运作的，我的DB driver路径是这样，
 C:\mm.mysql.jdbc-1.2c\mm.mysql-2.0.2-src.jar;
 C:\mm.mysql.jdbc-1.2c\mm.mysql-2.0.4-bin.jar;
已经作了双重保险了，哈哈，所以应该是没问题的，而且在一些简单的连接数据库页面是可以的，只是一有javabean的还有一些处理得教复杂的数据库操作时才会这样，实在是头疼！ 请各位多多帮忙！</Content>
<PostDateTime>2002-3-18 12:45:33</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3897778</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>请教！</Content>
<PostDateTime>2002-3-19 21:26:40</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3914748</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>急！  请教</Content>
<PostDateTime>2002-3-21 1:03:10</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>距离</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>98</credit>
<ReplyID>3923591</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>214226</PostUserId>
<PostUserName>hiphen1</PostUserName>
<Point>0</Point>
<Content>我也关注</Content>
<PostDateTime>2002-3-21 17:56:41</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3932363</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>哦，why～</Content>
<PostDateTime>2002-3-22 12:50:00</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>宝宝猫</PostUserNickName>
<rank>一星(中级)</rank>
<ranknum>star1</ranknum>
<credit>100</credit>
<ReplyID>3932654</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>193243</PostUserId>
<PostUserName>jimjxr</PostUserName>
<Point>30</Point>
<Content>Linkdb.java的26行是什么啊，还有那个javax.servlet.ServletException是单独出现的吗？</Content>
<PostDateTime>2002-3-22 13:04:40</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>balance</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>3935896</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>50835</PostUserId>
<PostUserName>wujj</PostUserName>
<Point>5</Point>
<Content>我也遇到从resin到tomcat上的问题
很多页面出错
还有数据库出现乱码问题
在resin无需转码，可在tomcat中只有转一下码才能正常显示呀</Content>
<PostDateTime>2002-3-22 15:57:21</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3940047</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>那是一个连接数据库的bean
package test;
import java.sql.*;
public class Linkdb {
  String strDriver="org.gjt.mm.mysql.Driver";
  String strConn="jdbc:mysql://localhost/test?user=test&password=123456";
  private Connection con = null;
  private Statement stm = null;
  ResultSet rs = null;
  public Linkdb() 
  {
	try { 
         Class.forName(strDriver).newInstance(); 
        } catch (Exception E) { 
            System.err.println("不能连接MySql数据库！"); 
          } 
  }
  public ResultSet executeQuery(String sql) {
    rs = null;
    try {
      con = DriverManager.getConnection(strConn); 
//以下便是第26行，在resin中执行没有出现错误
      stm = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
      rs = stm.executeQuery(sql);
       }catch(SQLException ex) { 
          System.err.println("执行SQL语句出错：" + ex.getMessage());
       }
    return rs;
  }
 //执行Insert,Update语句 
  public void executeUpdate(String sql) {
    stm = null;
    rs=null;
    try {
    con = DriverManager.getConnection(strConn); 
    stm = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
    stm.executeUpdate(sql);
    stm.close();
    con.close();
    } 
    catch(SQLException ex) { 
      System.err.println("执行SQL语句出错: " + ex.getMessage());
    }
  }
  public void stmClose(){
    try{
      stm.close();
     }
    catch(SQLException e){
      e.printStackTrace();
     }
  }
  public void conClose(){
    try{
      con.close();
     }
    catch(SQLException e){
      e.printStackTrace();
     }
  }
}
</Content>
<PostDateTime>2002-3-22 20:46:40</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>中原</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>97</credit>
<ReplyID>3945086</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>39114</PostUserId>
<PostUserName>CAYU</PostUserName>
<Point>5</Point>
<Content>是你的 servlet.jar  没有加到 classpath 中,到Tomact网上下一个就ok了</Content>
<PostDateTime>2002-3-23 13:51:50</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3949753</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>好，我要回去试试，要是可以的话就真的谢谢谢谢你了！</Content>
<PostDateTime>2002-3-23 22:49:48</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>距离</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>98</credit>
<ReplyID>3950193</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>214226</PostUserId>
<PostUserName>hiphen1</PostUserName>
<Point>0</Point>
<Content>我不同意CAYU(中原)的说法，因为我设置了也是不行</Content>
<PostDateTime>2002-3-24 0:10:15</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3962845</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>哇！  终于实现移植了，现在有事，晚上回来总结和送分！</Content>
<PostDateTime>2002-3-25 13:11:56</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3970624</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>我上面的javabean，在resin中是可以编译的，但到了tomcat，却不行，就是这一行折腾的：
stm = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
要改为stm = con.createStatement();
才行，反正我还不知道原因！  :(
另一个出错的地方是我在原来没移植的程序中，多处用了rs.first();这个方法，这是ResultSet结果操纵中的方法，不用这个，resin会报告出错，但tomcat却不需要，用了反而报告java.lang.AbstractMethodError出错！
方正我也还不知道原因！   :(
最后一个就是数据库中文问题，tomcat中向mysql加入中文数据是不需要转码的，直接加入就行，但resin中是需要把GBK换成unicode才能插入数据库！这要注意！</Content>
<PostDateTime>2002-3-25 21:58:58</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>东南西北</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>110</credit>
<ReplyID>3970693</ReplyID>
<TopicID>579776</TopicID>
<PostUserId>129031</PostUserId>
<PostUserName>jacob1</PostUserName>
<Point>0</Point>
<Content>以上问题要是leonzhao(灯泡)或是 jimjxr(宝宝猫) 看到，能再解答解答吗？</Content>
<PostDateTime>2002-3-25 22:03:59</PostDateTime>
</Reply>
</Replys>
</Topic>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -