为什么我的servlet程序在tomcat4.0下运行正常,而转到tomcat5.5.4下就报No database selected
NC 2005-02-20 09:19:43 如题,出错的代码段如下:
...
try {
System.out.println("select max(clear_date) from "+ tablename);
rs =stmt.executeQuery("select max(clear_date) from "+ tablename );//这一句在tomcat5.5.4下报错,而在tomcat4.0下正常
rs.next();
max_clear_date = rs.getInt(1);
//currtime = sdf.format(new Long (System.currentTimeMillis() ) );
starttime = sdf.format(new Long(System.currentTimeMillis()-refreshtimeinterval) );
currtime = sdf.format(new Long(System.currentTimeMillis()) );
//System.out.println("starttime="+starttime);
//System.out.println("currtime="+currtime);
rs = stmt.executeQuery( "select count(*) from "+tablename + " where clear_date="+max_clear_date+" and local_time>="+starttime+" and local_time<="+currtime);
rs.next();
total_rows = rs.getInt(1);
rs.close();
rs = stmt.executeQuery( "select * from "+tablename + " where clear_date="+max_clear_date+" and local_time>="+starttime+" and local_time<="+currtime );
}