用eclipse做hibernate+spring常见错误码

[code]
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[/code]

解决办法

将 <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>

缩成一行