aspose file tools
The moose likes JDBC and the fly likes Unable to create a derby datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Unable to create a derby datasource" Watch "Unable to create a derby datasource" New topic
Author

Unable to create a derby datasource

neeravagl agl
Greenhorn

Joined: Jul 27, 2009
Posts: 2
Hi,

I am using spring framework to create datasource using xapool and jotm.
I want a configurable datasource for oracle and derby.
The following are the bean definitions I am using:



Following are the properties I am using for derby datasource:



Now when i am passing oracle properties for the placeholders the datasource is successfully created.
But when i switch to derby i get the following error.

java.sql.SQLException: Cannot get connection for URL
jdbc:derby:target/derby/luDB;create=true
: No suitable driver found for
jdbc:derby:target/derby/luDB;create=true

Now I am using Maven for dependencies and have made sure that derby is included in the dependency and its also clearly visible in the dependency graph in eclipse.
What else can be the issue. Please put in your suggestions.





Balu Sadhasivam
Ranch Hand

Joined: Jan 01, 2009
Posts: 874


What are the derby jars added to classpath ?
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Unable to create a derby datasource
 
Similar Threads
com.sybase.jdbc2.SybConnection: SET CHAINED command not allowed within multi-statement transaction
exceptions in spring configuration file.
Spring 2.5 with Hibernate 3.0 error when creating dataSource for Hibernate SessionFactory
Spring MVC - Url Handling Problem
Hiberante transaction in Spring