Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Message-ID: <14393647.1178876715505.JavaMail.jira@brutus>
Date: Fri, 11 May 2007 02:45:15 -0700 (PDT)
From: "Rajiv M (JIRA)" <jira@apache.org>
To: dev@geronimo.apache.org
Subject: [jira] Created: (GERONIMO-3150) Cannot open mutliple connections to
 Derby from Geronimo
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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.