SSH下重写sqlserver方言后无法创建载驱动

[lilongweichao]

SSH框架下，重写sqlserver方言解决分页效率问题。但加载重写后的方言后，启动报错Cannot create JDBC driver of class 不能创建JDBC驱动，求解释

[softroad]

错误信息贴出来。

[lilongweichao]

public class FannaDialect extends SQLServerDialect {  

	static int getLastIndexOfOrderBy(String sql){  

	return sql.toLowerCase().lastIndexOf("order by ");  

	 }  

	  
 public String getLimitString(String querySelect, int offset, int limit ){  

	int lastIndexOfOrderBy = getLastIndexOfOrderBy(querySelect);  

	 //　没有 order by 或第一页的情况下  

	if(lastIndexOfOrderBy<0 || querySelect.endsWith(")") || offset==0)  

	return super.getLimitString(querySelect, 0, limit);  

else {  

	//取出 order by 语句  

	 String orderby = querySelect.substring(lastIndexOfOrderBy, querySelect.length());  

	//取出 from 前的内容  

	int indexOfFrom = querySelect.toLowerCase().indexOf("from");  

	 String selectFld = querySelect.substring(0,indexOfFrom);  

	//取出 from 语句后的内容  

	 String selectFromTableAndWhere = querySelect.substring(indexOfFrom, lastIndexOfOrderBy);  

	 StringBuffer sql = new StringBuffer(querySelect.length()+100);  

	 sql.append("select * from (") .append(selectFld)  

	.append(",ROW_NUMBER() OVER(").append(orderby).append(") as _page_row_num_hb ")  

	.append(selectFromTableAndWhere).append(" ) temp ")  

	.append(" where _page_row_num_hb BETWEEN ")  

	.append(offset+1).append(" and ").append(limit);  

	return sql.toString();  

	 }  

	}  

	//使offset 参数生效  

	 public boolean supportsLimitOffset(){  

	 return true;  
   
	 }
	 }  

[ERROR] [org.hibernate.util.JDBCExceptionReporter] - <Cannot create JDBC driver of class 'com.manager.core.util.FannaDialect' for connect URL 'jdbc:sqlserver://127.0.0.1;databaseName=user_manager;selectMethod=cursor'>