db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jp4 <john.pfei...@hnpsolutions.com>
Subject Re: Does Embedded Driver Support Multiple Databases
Date Tue, 17 Jun 2008 20:24:58 GMT

Rick,

Thanks for the info.  I did a bit more digging and found that the error was
due to the fact that I didn't shutdown the database (using the
maven-sql-plugin) before executing my unit test cases.  Once I did that,
both datasources worked fine.

Thanks,

John 


Rick Hillegas-2 wrote:
> 
> 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
>>   
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Does-Embedded-Driver-Support-Multiple-Databases-tp17929196p17936500.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message