Re: Error deploying EAR because of DataSource

Fri, 27 Oct 2006 04:45:59 -0700

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.

Reply via email to