I agree it's a good sign that the data source is actually usable from the sample application. However from what I understand this application does not have a strict dependency to a specific data source like our application - it instead discovers them programmatically.
The problem I'm describing is actually happening during the deployment phase: I open the "Deploy new" screen, select the application EAR, I even uncheck the "Start after install" option and finally click on Deploy. A few instants later, Geronimo gives the following message: Deployment failed: Unable to resolve resource reference 'jdbc/AuchanPromoDS' (Could not find resource 'AuchanPromoDS'. Perhaps it has not yet been configured, or your application does not have a dependency declared for that resource module?) AFAICT, the application wasn't started yet, so I presume it's more a configuration issue than an application issue. The problem is, everything seems to be configured according to the Geronimo usage page :) The applicationContext.xml file is a configuration file for the Spring framework. In our application, this file isn't loaded right on startup so I doubt it's interfering with anything. I didn't mention yet but the application runs fine on Glassfish and Tomcat, so I suppose I'm not configuring Geronimo or access to it correctly. I'll have a look at the simple-database-access-sample-application and let you know if it's not too late - it's Friday after all :) Thanks! GB Lasantha Ranaweera wrote: > > Ok.. Then we can suspect problem is in your application. :-) > > I saw file called in "applicationConext.xml" one of your previous mails. > What exactly that means? > > To link a DBPool with your web application you need to add reference in > your geronimo-web.xml file too. Then it should be linked with web.xml. > Have a look at > > http://cwiki.apache.org/GMOxDOC11/simple-database-access-sample-application.html > > Let us know your status too. > > Thanks, > Lasantha Ranaweera > > > Guillaume Bilodeau wrote: >> I've tested the pool before deploying it and it worked fine. I have now >> downloaded, built and deployed the dbtester sample application with >> correct >> results: my AuchanPromoDS pool is there, and I can list its tables and >> their >> content with no error whatsoever. >> >> Everything looks fine, how come my application will not even deploy? I'm >> at >> a loss here :S >> >> Thanks again, >> GB >> >> >> Lasantha Ranaweera wrote: >> >>> Since you have deployed DB pool using G console, have you tested it >>> before deploying? >>> >>> Otherwise have a look at this sample application which help to find out >>> your DB connection pools is working or not. >>> >>> http://cwiki.apache.org/GMOxDOC11/db-pool-testing-sample-application.html >>> >>> Thanks, >>> Lasantha Ranaweera >>> >>> Guillaume Bilodeau wrote: >>> >>>> No it's a remote Oracle database. >>>> >>>> >>>> Lasantha Ranaweera wrote: >>>> >>>> >>>>> What is the DB you are using? Is it Derby Embedded? >>>>> >>>>> Thanks, >>>>> Lasantha Ranaweera >>>>> >>>>> Guillaume Bilodeau wrote: >>>>> >>>>> >>>>>> Hi David, >>>>>> >>>>>> Not sure if that's what you mean, but I deployed the datasource >>>>>> myself >>>>>> using >>>>>> the "Geronimo database pool wizard", not through a separate >>>>>> deployment >>>>>> plan. >>>>>> Is that it? >>>>>> >>>>>> Thanks, >>>>>> GB >>>>>> >>>>>> >>>>>> David Jencks wrote: >>>>>> >>>>>> >>>>>> >>>>>>> Everything you show looks ok to me, which makes me wonder if the >>>>>>> console-generated rar plan really has the connection factory named >>>>>>> AuchanPromoDS. Could you show the plan for deploying the >>>>>>> datasource? >>>>>>> >>>>>>> thanks >>>>>>> david jencks >>>>>>> >>>>>>> On Oct 26, 2006, at 11:03 PM, Guillaume Bilodeau wrote: >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>>> Ok let's try this again, without altering any names :) I'm using >>>>>>>> Geronimo+Tomcat 1.1.1 on Java 5. >>>>>>>> >>>>>>>> Error: >>>>>>>> >>>>>>>> Deployment failed: >>>>>>>> Unable to resolve resource reference 'jdbc/AuchanPromoDS' (Could >>>>>>>> not find >>>>>>>> resource 'AuchanPromoDS'. Perhaps it has not yet been configured, >>>>>>>> or your >>>>>>>> application does not have a dependency declared for that resource >>>>>>>> module?) >>>>>>>> >>>>>>>> "Installed J2EE connectors" screen: >>>>>>>> console.dbpool/AuchanPromoDS/1.0/rar running Stop >>>>>>>> >>>>>>>> Restart >>>>>>>> Uninstall >>>>>>>> >>>>>>>> web.xml: >>>>>>>> >>>>>>>> <?xml version="1.0" encoding="UTF-8" ?> >>>>>>>> >>>>>>>> <web-app xmlns="http://java.sun.com/xml/ns/j2ee"; >>>>>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; >>>>>>>> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee >>>>>>>> http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"; >>>>>>>> version="2.4"> >>>>>>>> ... >>>>>>>> <resource-ref> >>>>>>>> <res-ref-name>jdbc/AuchanPromoDS</res-ref-name> >>>>>>>> <res-type>javax.sql.DataSource</res-type> >>>>>>>> <res-auth>Container</res-auth> >>>>>>>> <res-sharing-scope>Shareable</res-sharing-scope> >>>>>>>> </resource-ref> >>>>>>>> ... >>>>>>>> </web-app> >>>>>>>> >>>>>>>> geronimo-web.xml: >>>>>>>> >>>>>>>> <?xml version="1.0" encoding="UTF-8"?> >>>>>>>> >>>>>>>> <web-app xmlns="http://geronimo.apache.org/xml/ns/web";> >>>>>>>> <environment> >>>>>>>> <moduleId> >>>>>>>> <artifactId>promo-war</artifactId> >>>>>>>> </moduleId> >>>>>>>> <dependencies> >>>>>>>> <dependency> >>>>>>>> <groupId>console.dbpool</groupId> >>>>>>>> <artifactId>AuchanPromoDS</artifactId> >>>>>>>> </dependency> >>>>>>>> </dependencies> >>>>>>>> </environment> >>>>>>>> >>>>>>>> <context-root>/auchan-promo</context-root> >>>>>>>> >>>>>>>> <resource-ref> >>>>>>>> <ref-name>jdbc/AuchanPromoDS</ref-name> >>>>>>>> <resource-link>AuchanPromoDS</resource-link> >>>>>>>> </resource-ref> >>>>>>>> </web-app> >>>>>>>> >>>>>>>> applicationContext.xml: >>>>>>>> >>>>>>>> <jee:jndi-lookup id="mainDataSource" >>>>>>>> jndi-name="java:comp/env/jdbc/AuchanPromoDS" >>>>>>>> proxy-interface="javax.sql.DataSource" >>>>>>>> lookup-on-startup="false" /> >>>>>>>> >>>>>>>> application.xml: >>>>>>>> >>>>>>>> <?xml version="1.0" encoding="UTF-8"?> >>>>>>>> <!DOCTYPE application PUBLIC >>>>>>>> "-//Sun Microsystems, Inc.//DTD J2EE Application 1.3//EN" >>>>>>>> "http://java.sun.com/dtd/application_1_3.dtd";> >>>>>>>> <application> >>>>>>>> <display-name>promo-ear</display-name> >>>>>>>> <description>Promo Action Management System EAR</description> >>>>>>>> <module> >>>>>>>> <web> >>>>>>>> <web-uri>promo-web-2.0.0-SNAPSHOT.war</web-uri> >>>>>>>> <context-root>/auchan-promo</context-root> >>>>>>>> </web> >>>>>>>> </module> >>>>>>>> <module> >>>>>>>> <ejb>promo-server-2.0.0-SNAPSHOT.jar</ejb> >>>>>>>> </module> >>>>>>>> </application> >>>>>>>> >>>>>>>> It seems to me that I followed what the usage screen suggests. Is >>>>>>>> this a >>>>>>>> problem with dealing with EARs? >>>>>>>> >>>>>>>> Thanks, >>>>>>>> GB >>>>>>>> >>>>>>>> >>>>>>>> On 10/26/06, Guillaume Bilodeau <[EMAIL PROTECTED]> wrote: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>> Yes actually that was a mistake in my post, I forgot to remove all >>>>>>>>> references >>>>>>>>> to my current client :) All names are correct in my code, all of >>>>>>>>> them >>>>>>>>> being >>>>>>>>> jdbc/<insertClientNameHere>PromoDS. >>>>>>>>> >>>>>>>>> Any other idea? >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> Can you look in the database pool screen in the console, and select >>>>>>>> the usage link next to your database pool, and make sure that all >>>>>>>> the >>>>>>>> names in the example there match the ones in your geronimo-web.xml >>>>>>>> file? It's hard to troubleshoot from the config files if you're >>>>>>>> changing the important entries as you post them. :) >>>>>>>> >>>>>>>> Also, are you using Geronimo 1.0 or Geronimo 1.1? The XML >>>>>>>> namespaces >>>>>>>> in the geronimo-web.xml file aren't really correct for Geronimo >>>>>>>> 1.1, >>>>>>>> though it may auto-convert them. I'd try putting in the proper >>>>>>>> values >>>>>>>> (which you can get from here >>>>>>>> http://geronimo.apache.org/schemas.html). >>>>>>>> >>>>>>>> Thanks, >>>>>>>> Aaron >>>>>>>> >>>>>>>> -- >>>>>>>> View this message in context: >>>>>>>> http://www.nabble.com/Error-deploying- >>>>>>>> EAR-because-of-DataSource-tf2513035.html#a7024975 >>>>>>>> Sent from the Apache Geronimo - Users mailing list archive at >>>>>>>> Nabble.com. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > > -- View this message in context: http://www.nabble.com/Error-deploying-EAR-because-of-DataSource-tf2513035.html#a7029656 Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
