db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francois Orsini <francois.ors...@gmail.com>
Subject Re: Unable to create derby datasource
Date Thu, 13 Aug 2009 19:19:48 GMT
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.
>
>

Mime
View raw message