各位大虾菜鸟，有谁会hibernate帮我进来看看这个异常，可能在那里出了错，谢谢各位

[eclipsecainiao]

我在用eclipse学做一个简单的hibernate，就是要从库中将People表中的数据显示到页面（只显示人名）结果改来改去总是出现一下异常
-------------------------------------Exception---------------------------------------
java.lang.UnsupportedOperationException
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:116)
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:554)
net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:56)
net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:289)
net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3361)
net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3321)
net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2251)
cn.com.wyf.db.GetUserName.getUserName(GetUserName.java:36)
com.mytest.AskAction.execute(AskAction.java:25)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
-----------------------------------------------------------------------------------------


我的数据库连接池是在tomcat中配置的，以下是我的hibernate.properties

-----------------------------hibernate.properties------------------------------------
hibernate.dialect=net.sf.hibernate.dialect.SQLServerDialect
hibernate.connection.datasource=java:comp/env/jdbc/sqlserver
hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver
hibernate.connection.url=jdbc:microsoft:sqlserver://Localhost:1433;DatabaseName=Forum;SelectMethod=cursor
hibernate.connection.username=sa
hibernate.connection.password=wsnedy
hibernate.show_sql=true

-----------------------------------------------------------------------------------------
一下是我访问数据库的程序
-----------------------------------GetUserName.java-----------------------------------------------------
package cn.com.wyf.db;
import net.sf.hibernate.*;
import net.sf.hibernate.cfg.Configuration;
import java.util.*;
import cn.com.wyf.test.People;
public class GetUserName
{
private List list;

public static SessionFactory sessionFactory;

static
{
try
{
Configuration config=new Configuration();

config.addClass(People.class);

sessionFactory=config.buildSessionFactory();
}
catch(Exception e)
{
e.printStackTrace();
}
}

public List getUserName()throws Exception
{
Session session = sessionFactory.openSession();

Transaction tx = null;

try
{
tx=session.beginTransaction();

String sql="select people from People as people";

Query query=session.createQuery(sql);

list=query.list();

tx.commit();

}
catch(Exception e)
{
if (tx != null)
{
tx.rollback();
}
throw e;
}
finally
{
session.close();
}

return list;
}
}

各位好心人帮我看看到底是那里错了

[eclipsecainiao]

自己up

[soso119]

hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver改成
hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver
然后再找一个jtds-0.9.jar的msSqlServer的驱动jar试试吧。GetUserName.java看上去没什么大问题。

[eclipsecainiao]

我发现问题所在了但是不会改唉！错误在tx=session.beginTransaction();
这句话由于得到一个null，所以抛出了异常，请问大家这如何改，谢谢