You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by "David Jencks (JIRA)" <ji...@apache.org> on 2007/08/17 02:39:30 UTC
[jira] Closed: (GERONIMO-3380) Derby embedded database pool created
from console doesn't work
[ https://issues.apache.org/jira/browse/GERONIMO-3380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Jencks closed GERONIMO-3380.
----------------------------------
Resolution: Fixed
Fix Version/s: 2.1
This requires Sun Li's changes from GERONIMO-3374 to work. Fixed in rev 566889 in trunk.
- changed the db info gbean "isXA" flag to "isSpecific" and if it is, show the rar-specific properties.
- changed the include/exclude logic for what to show in the jar list so system-database car shows up.
- generified some of the classes.
If you want derby, you have to select system-database car as a "jar" instead of derby. The embed-local tranql ra.xml claims that it is xa, which is a bit confusing.
I think it would be better to have a filter in the db info gbean that was used to specify what jars to show. Generally we can figure out the likely jars that contain drivers.
This could use some additional checking.
> 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
> Assignee: David Jencks
> Priority: Critical
> Fix For: 2.1
>
> Attachments: BankDB.sql, BankDBPool2.xml, geronimo-web.xml, geronimo-web2.xml, WebAppJDBCAccess.war
>
>
> 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.