Hi Lasantha, I've already answered Guillaume's answer, it is deployed now. But i want to ask a question about the structure.
First i created database pools from the console then I deployed a war project with geronimo-web.xml in it geronimo-web.xml ------------------------------ <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.1";> <environment> <moduleId> <artifactId>test-war</artifactId> </moduleId> <dependencies> <dependency> <groupId>console.dbpool</groupId> <artifactId>TEST1</artifactId> </dependency> <dependency> <groupId>console.dbpool</groupId> <artifactId>TEST2</artifactId> </dependency> </dependencies> </environment> <context-root>/test-war</context-root> <!-- define a reference name to the db pool--> <resource-ref> <ref-name>jdbc/TEST1</ref-name> <resource-link>TEST1</resource-link> </resource-ref> <resource-ref> <ref-name>jdbc/TEST2</ref-name> <resource-link>TEST2</resource-link> </resource-ref> </web-app> Later I want to put this war project into an ear and deploy to geronimo. This time i had to prepare geronimo-application.xml but I didn't realize that i have to put dependencies again to geronimo-application.xml I was expecting it to find from geronimo-web.xml (I put it also under a folder named 'deployment' in ear and referenced it with alt-dd under module) <application xmlns="http://geronimo.apache.org/xml/ns/j2ee/application-1.1"; xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"; xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1"; application-name="test-ear"> <sys:environment> <sys:moduleId> <sys:groupId>default</sys:groupId> <sys:artifactId>test-ear</sys:artifactId> <sys:version>1.0</sys:version> <sys:type>car</sys:type> </sys:moduleId> <sys:dependencies/> </sys:environment> <module> <web>test-war.war</web> <alt-dd>deployment/geronimo-web.xml</alt-dd> </module> </application> this was giving unable to resolve resource reference jdbc/TEST1 then i changed geronimo-application.xml like below and it is deployed <application xmlns="http://geronimo.apache.org/xml/ns/j2ee/application-1.1"; xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"; xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1"; application-name="test-ear"> <sys:environment> <sys:moduleId> <sys:groupId>default</sys:groupId> <sys:artifactId>test-ear</sys:artifactId> <sys:version>1.0</sys:version> <sys:type>car</sys:type> </sys:moduleId> <sys:dependencies> <sys:dependency> <sys:groupId>console.dbpool</sys:groupId> <sys:artifactId>TEST1</sys:artifactId> <sys:version>1.0</sys:version> <sys:type>rar</sys:type> </sys:dependency> <sys:dependency> <sys:groupId>console.dbpool</sys:groupId> <sys:artifactId>TEST2</sys:artifactId> <sys:version>1.0</sys:version> <sys:type>rar</sys:type> </sys:dependency> </sys:dependencies> </sys:environment> <module> <web>test-war.war</web> <alt-dd>deployment/geronimo-web.xml</alt-dd> </module> </application> But my question is how can i make these dependencies for only a project in ear. I mean only the web project have dependency to these datasources in ear and i've already put these dependency in geronimo-web.xml and if it gives this error that means it checks web.xml of war project so it might also check geronimo-web.xml because if i want only deploy war project (not in ear), it exactly does this right? it finds the dependencies from geronimo-web.xml so it successfully deploys war project. if this is the only way for ear should i remove the dependencies in geronimo-web.xml ? Thanks Lasantha Ranaweera wrote: > > Hi, > > Could you be bit more specific on your situation? I might be able to > help you as the author of this sample application. :) > > Thanks, > Lasantha Ranaweera > niteryder wrote: >> Hi Guillaume, >> >> Have you succeeded on this issue? I have similar problem, I can deploy >> war >> individually and I can use the database pools that I created with >> Geronimo's >> with this deployed war. But when i want to add this war to an ear and >> deploy >> it. I also take similar messages for my datasources. >> >> Thanks >> >> >> Guillaume Bilodeau wrote: >> >>> 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#a7599290 Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
