Hi,

Is 'derby.jar' referenced as part of the CLASSPATH for Spring?

If not, then it cannot find the embedded Derby driver ('org.apache.derby.jdbc.EmbeddedDriver') required to connect to an embedded Derby instance.

Cheers

--francois

On Thu, Aug 13, 2009 at 7:23 AM, nagl <neeravagl@gmail.com> wrote:

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:

[code]<bean id="innerorgDataSource"
               class="org.enhydra.jdbc.standard.StandardXADataSource"
               destroy-method="shutdown">
               <property name="transactionManager">
                       <ref local="jotm" />
               </property>
               <property name="driverName">
                       <value>${jdbc.ClassName}</value>
               </property>
               <property name="url">
                       <value>
                               ${jdbc.org.URL}
                       </value>
               </property>
</bean>
<bean id="orgDataSource"
               class="org.enhydra.jdbc.pool.StandardXAPoolDataSource"
               destroy-method="shutdown">
               <property name="dataSource">
                       <ref local="innerorgDataSource" />
               </property>
               <property name="user">
                       <value>${jdbc.org.user}</value>
               </property>
               <property name="password">
                       <value>${jdbc.org.password}</value>
               </property>
               <property name="maxSize">
                       <value>30</value>
               </property>
       </bean>[/code]

Following are the properties I am using for derby datasource:

[code]  org.apache.derby.jdbc.EmbeddedDriver
       jdbc:derby:target/derby/orgDB;create=true
       org
       org[/code]

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.






--
View this message in context: http://www.nabble.com/Unable-to-create-derby-datasource-tp24954784p24954784.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.