用eclipse做hibernate+spring常见错误码

log4j:WARN No appenders could be found for logger 

(org.springframework.core.CollectionFactory).
log4j:WARN Please initialize the log4j system properly.
com.huaying.dao.LoginDAO@3a1ec6
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: Hibernate 

operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state 

[null]; error code [0]; Cannot create JDBC driver of class 

'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL '
				jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs
			'; nested exception is org.apache.commons.dbcp.SQLNestedException: 

Cannot create JDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for 

connect URL '
				jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs
			'
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 

'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL '
				jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs
			'
	at org.apache.commons.dbcp.BasicDataSource.createDataSource

(BasicDataSource.java:780)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at 

org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection

(LocalDataSourceConnectionProvider.java:81)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
	at org.hibernate.loader.Loader.doQuery(Loader.java:390)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections

(Loader.java:218)
	at org.hibernate.loader.Loader.loadEntity(Loader.java:1345)
	at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
	at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101)
	at org.hibernate.persister.entity.BasicEntityPersister.load

(BasicEntityPersister.java:2471)
	at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource

(DefaultLoadEventListener.java:351)
	at org.hibernate.event.def.DefaultLoadEventListener.doLoad

(DefaultLoadEventListener.java:332)
	at org.hibernate.event.def.DefaultLoadEventListener.load

(DefaultLoadEventListener.java:113)
	at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad

(DefaultLoadEventListener.java:167)
	at org.hibernate.event.def.DefaultLoadEventListener.onLoad

(DefaultLoadEventListener.java:79)
	at org.hibernate.impl.SessionImpl.get(SessionImpl.java:621)
	at org.hibernate.impl.SessionImpl.get(SessionImpl.java:614)
	at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate

(HibernateTemplate.java:452)
	at org.springframework.orm.hibernate3.HibernateTemplate.execute

(HibernateTemplate.java:366)
	at org.springframework.orm.hibernate3.HibernateTemplate.get

(HibernateTemplate.java:446)
	at org.springframework.orm.hibernate3.HibernateTemplate.get

(HibernateTemplate.java:440)
	at com.huaying.dao.LoginDAO.findById(LoginDAO.java:27)
	at com.huaying.dao.SpringDemo.main(SpringDemo.java:21)
Caused by: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:243)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource

(BasicDataSource.java:773)
	... 25 more

解决办法

将 <bean id="testsql" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
<property name="url">
<value>
jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs
</value>
</property>
<property name="username">
<value>sa</value>
</property>
</bean>

缩成一行