<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>
jdbc:oracle:thin:@localhost:1521:bsqam
</value>
</property>
<property name="username">
<value>a</value>
</property>
<property name="password">
<value>1</value>
</property>
</bean>
上面是在applicatoncontext中配置的datasource(myeclipse生成的),可是用junit做测试却出现下面的错误:
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
org.hibernate.exception.GenericJDBCException: Cannot open connectionCaused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL '
jdbc:oracle:thin:@localhost:1521:bsqam
'
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:80)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
... 21 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
... 24 more
看提示是数据库连接驱动有问题,可是驱动肯定有,数据库也正常,我写了一个main测试数据库的程序执行结果正确.请问是哪有问题啊?怎么解决呢?谢谢