oracle hibernate + maven dependenciesm dbcp.basicdatasource exception

Question

I'm trying to create a web application using maven, tomcat and hibernate. Now I'm getting a cannot find class for org.appache.commons.dbcp.basicdatasource for bean with name datasource... exception.

Without the hibernate aspects it works fine, but if I add

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"/>
    <property name="username" value="temp"/>
    <property name="password" value="temp"/>
</bean> 

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
            <prop key="hibernate.hbm2ddl.auto">create</prop>
            <prop key="hibernate.show_sql">true</prop>
        </props>
    </property>
    <property name="mappingResources">
        <list>
        </list>
    </property>
</bean>

to my applicationContext then I get the error.

What I did was:

add org.hibernate to my pom
put ojdbc16.jar in my tomcat bin folder
add the above snippet to my applicationContext.xml

I use a bat file to compile my project (using maven), copy it to my tomcat webapp folder and to start the server.

Any input on what I'm doing wrong is welcome.

Pascal Thivent · Accepted Answer · 2010-04-19 19:44:42Z

17

You're very likely missing the dependency for Commons DBCP:

<dependency>
  <groupId>commons-dbcp</groupId>
  <artifactId>commons-dbcp</artifactId>
  <version>1.4</version>
</dependency>

answered Apr 19, 2010 at 19:44

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mike Over a year ago

Thank you for the response. I added that to my pom but I get: Missing artifact commons-dbcp:commons-dbcp:jar:1.4:compile I'm not that familiar yet with maven. I tried putting the commons-dbcp on scope: compile but that didn't help.

Pascal Thivent Over a year ago

@Joe That's strange. I double checked and this artifact is definitely in the central repository. Do you run maven "online"? Who is complaining about the missing artifact exactly?

Mike Over a year ago

My compiler.I added: <repository> <id>repo1</id> <name>repo1</name> <url>repo1.maven.org/maven2/</url> </repository> And it doesn't complain anymore, so I guess the repository lacked that jar.

Bozho Over a year ago

very odd. This repository is added by default

Collectives™ on Stack Overflow

oracle hibernate + maven dependenciesm dbcp.basicdatasource exception

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related