English 中文(简体)
java.sql.SQLException: 在通过春 进行测试时没有合适的司机
原标题:java.sql.SQLException: No suitable driver when running tests through spring roo

I m试图通过实体班轮自动产生的测试。 当我对 h子进行测试时,他们都通过。 但是,在对Oracle进行测试时,我得到以下信息:

源于:org.apache.commons.dbcp.SQLNestedException: Cannot Creating JDBC power of category oracle.jdbc.driver.Oraclejianr for connection URL jdbc: localhost:1521:xe

我有一个当地分母,我知道连接工作。

ojdbc14.jar档案存放在JBos 4.2.3/server/all目录(我们在那里重新部署)的校正目录中。

这是数据源星和实体经理工厂的定义。

<bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="dataSource">
    <property name="driverClassName" value="${database.driverClassName}"/>
    <property name="url" value="${database.url}"/>
    <property name="username" value="${database.username}"/>
    <property name="password" value="${database.password}"/>
    <property name="testOnBorrow" value="true"/>
    <property name="testOnReturn" value="true"/>
    <property name="testWhileIdle" value="true"/>
    <property name="timeBetweenEvictionRunsMillis" value="1800000"/>
    <property name="numTestsPerEvictionRun" value="3"/>
    <property name="minEvictableIdleTimeMillis" value="1800000"/>
</bean><!--  Development specific configuration comes here.  -->

<bean class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" id="entityManagerFactory">
    <property name="persistenceUnitName" value="${hibernate.persistenceunit}"/>
    <property name="dataSource" ref="dataSource"/>
</bean>

这是一种om依赖定义:

    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc14</artifactId>
        <version>10.2.0.3.0</version>
        <classifier/>
    </dependency>

2. 持久性变量决心 UnitDev

this is the hibernate definition of that persistence unit org.hibernate.ejb.HibernatePersistence

最后,我的财产档案界定了数据链接:

database.password=password
database.url=jdbc:localhost:1521:xe
database.username=username
database.driverClassName=oracle.jdbc.driver.OracleDriver

我可以指出,为什么它告诉我,它能够找到合适的司机。

预先感谢

最佳回答

URL没有适当的模式。 Try jdbc:oracle:thin:@ localhost:1521:xe.

问题回答

暂无回答




相关问题
Export tables from SQL Server to be imported to Oracle 10g

I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

How to make a one to one left outer join?

I was wondering, is there a way to make a kind of one to one left outer join: I need a join that matches say table A with table B, for each record on table A it must search for its pair on table B, ...

Insert if not exists Oracle

I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see if a primary key exists and if it does, then it skips that insert. Something like: INSERT ALL ...

How can I store NULLs in NOT NULL field?

I just came across NULL values in NOT-NULL fields in our test database. How could they get there? I know that NOT-NULL constraints can be altered with NOVALIDATE clause, but that would change table s ...

Type reference scope

I m studying databases and am currently working on a object-relational DB project and I ve encountered a small problem with the number of possible constraints in an object table. I m using "Database ...

OracleParameter and DBNull.Value

we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...

热门标签