geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shiva Kumar H R (JIRA)" <j...@apache.org>
Subject [jira] Created: (GERONIMO-3380) Derby embedded database pool created from console doesn't work
Date Mon, 06 Aug 2007 13:44:01 GMT
Derby embedded database pool created from console doesn't work
--------------------------------------------------------------

                 Key: GERONIMO-3380
                 URL: https://issues.apache.org/jira/browse/GERONIMO-3380
             Project: Geronimo
          Issue Type: Bug
      Security Level: public (Regular issues)
          Components: console
    Affects Versions: 2.1
            Reporter: Shiva Kumar H R
            Priority: Critical


Steps to reproduce:
1) From Admin Console's "DB Manager" portlet create a database by name "BankDB" and populate
it with the contents of "BankDB.sql". 

2) From "Database Pools" portlet, create a new database pool using the Geronimo database pool
wizard, with the below information:
Name of Database Pool: BankDBPool
Database Type: Derby embedded
Driver JAR: org.apache.derby/derby/10.2.2.0/jar
Database: BankDB

3) From "Deploy New" portlet, deploy "WebAppJDBCAccess.war" using "geronimo-web.xml".

4) Open http://localhost:8080/WebAppJDBCAccess/ and click on "Click here to list Customers".
Server will fail to show database contents by throwing following errors at command prompt:

19:10:59,555 ERROR [MCFConnectionInterceptor] Error occurred creating ManagedCon
nection for org.apache.geronimo.connector.outbound.ConnectionInfo@cd7887
javax.resource.spi.ResourceAllocationException: Unable to obtain physical connec
tion to jdbc:derby:BankDB
        at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDri
verMCF.java:98)
        at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCD
riverMCF.java:73)
        at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getCo
nnection(MCFConnectionInterceptor.java:48)
        at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterc
eptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
        at org.apache.geronimo.connector.outbound.SinglePoolConnectionIntercepto
r.internalGetConnection(SinglePoolConnectionInterceptor.java:67)
        at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionIn
terceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:78)
        at org.apache.geronimo.connector.outbound.TransactionEnlistingIntercepto
r.getConnection(TransactionEnlistingInterceptor.java:46)
        at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.
getConnection(TransactionCachingInterceptor.java:96)
        at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.ge
tConnection(ConnectionHandleInterceptor.java:43)
        at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(
TCCLInterceptor.java:39)
        at org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.
getConnection(ConnectionTrackingInterceptor.java:66)
        at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allo
cateConnection(AbstractConnectionManager.java:87)
        at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56
)
        at myPackage.ListCustomers.doGet(ListCustomers.java:41)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:693)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
bjectValve.java:56)
        at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.
invoke(GeronimoStandardContext.java:351)
        at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(Gero
nimoBeforeAfterValve.java:47)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:104)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
563)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:261)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:581)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Database 'BankDB' not found.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow
n Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source
)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown So
urce)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
        at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
        at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDri
verMCF.java:96)
        ... 31 more
java.sql.SQLException: Database 'BankDB' not found.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow
n Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source
)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown So
urce)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
        at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
        at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDri
verMCF.java:96)
        at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCD
riverMCF.java:73)
        at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getCo
nnection(MCFConnectionInterceptor.java:48)
        at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterc
eptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
        at org.apache.geronimo.connector.outbound.SinglePoolConnectionIntercepto
r.internalGetConnection(SinglePoolConnectionInterceptor.java:67)
        at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionIn
terceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:78)
        at org.apache.geronimo.connector.outbound.TransactionEnlistingIntercepto
r.getConnection(TransactionEnlistingInterceptor.java:46)
        at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.
getConnection(TransactionCachingInterceptor.java:96)
        at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.ge
tConnection(ConnectionHandleInterceptor.java:43)
        at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(
TCCLInterceptor.java:39)
        at org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.
getConnection(ConnectionTrackingInterceptor.java:66)
        at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allo
cateConnection(AbstractConnectionManager.java:87)
        at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56
)
        at myPackage.ListCustomers.doGet(ListCustomers.java:41)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:693)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
bjectValve.java:56)
        at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.
invoke(GeronimoStandardContext.java:351)
        at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(Gero
nimoBeforeAfterValve.java:47)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:104)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
563)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:261)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:581)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44
7)
        at java.lang.Thread.run(Thread.java:595)

-- 
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