db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Does Embedded Driver Support Multiple Databases
Date Tue, 17 Jun 2008 19:31:15 GMT
Hi John,

You should be able to wrap a separate data source around each of your 
databases and access them both via the same EmbeddedDriver. There is not 
much information in this SQLException. Can you share more of the stack 
trace and/or the derby log file? That will help us puzzle through this.

Thanks,
-Rick

jp4 wrote:
> I am trying to mimic an standalone version of a test and production
> environment using Derby.  When I run my unit test cases, I would like to
> load two databases using the EmbeddedDriver.  Does the EmbeddedDriver
> support mulitple databases?  If so, how is this accomplished.  
>
> I am trying to startup the datasources using the Spring configuration Below
>
>         <bean id="dataSourcePerm"
> class="org.springframework.jdbc.datasource.DriverManagerDataSource"
>                 p:driverClassName="${jdbc.driverClassName}" 
>                 p:url="${jdbc.url.perm}" 
>                 p:username="${jdbc.username}"
>                 p:password="${jdbc.password}" />
>         
> 	<bean id="dataSourceTemp"
> class="org.springframework.jdbc.datasource.DriverManagerDataSource"
>                 p:driverClassName="${jdbc.driverClassName}" 
>                 p:url="${jdbc.url.temp}" 
>                 p:username="${jdbc.username}"
>                 p:password="${jdbc.password}" />
>
> With properties
>
> jdbc.driverClassName=org.apache.derby.jdbc.EmbeddedDriver
> jdbc.url.perm=jdbc:derby:../benefitrealization-dataaccess/target/brpermdb
> jdbc.url.temp=jdbc:derby:../benefitrealization-dataaccess/target/brtempdb
> jdbc.username=user
> jdbc.password=password
>
> When I try running my unit tests with this configuration, I get the
> following error:
>
> is java.sql.SQLException: Failed to start database
> '../benefitrealization-dataaccess/target/brpermdb', 
>
> Thanks,
>
> jp4
>   


Mime
View raw message