geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajiv M (JIRA)" <j...@apache.org>
Subject [jira] Created: (GERONIMO-3150) Cannot open mutliple connections to Derby from Geronimo
Date Fri, 11 May 2007 09:45:15 GMT
Cannot open mutliple connections to Derby from Geronimo
-------------------------------------------------------

                 Key: GERONIMO-3150
                 URL: https://issues.apache.org/jira/browse/GERONIMO-3150
             Project: Geronimo
          Issue Type: Bug
      Security Level: public (Regular issues)
          Components: databases
    Affects Versions: 1.1.1
         Environment: Windows XP. 32-bit.
            Reporter: Rajiv M


The below is a testcase to simulate the problem: 
Steps: 
Create a Derby database from DBManager 
Create a Derby database pool in Geronimo console 
Create a web app that uses DataSource/JNDI to connect to Derby 

I am able to reproduce the problem in 2 ways: 
1. 
* Deploy the application and launch the web component that access the database 
* Run DBManager to do SQL operation on the same database 
* DBManager will report error - database booted by another instance 

2. 
* Deploy the application and launch the web component that access the database without starting
it 
* Run DBManager to do SQL operation on the same database 
* Launch the web app 
* Web app will report error - database booted by another instance 

Derby embedded should allow mutliple connections to a database from same JVM as documented
in the Apache Derby website. But, appears that DBManager and webapplication cannot open connections
at the same time. It is always first attempt wins.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message