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.
