Database Pool creation exception

[Mark Himsley]

Hi,

I've got Geronimo 2.1.4 installed in
/usr/local/geronimo-tomcat6-javaee5-2.1.4 on a Mac OS 10.5.8 with
java.version 1.5.0_19.

Going to the console at http://localhost:8080/console/ and logging in as
system/manager I am trying to add a Database Pool to a MySQL server.

I used the driver download function in the Database Pool wizard to
install the MySQL driver 3.1.2 which was installed into $GERONIMO_HOME
as
repository/mysql/mysql-connector-java/3.1.12/mysql-connector-java-3.1.12.jar

If I run Geronimo from the command line with ./start-server from
$GERONIMO_HOME/bin then there is not problem.

If I run Geronimo as a server within Eclipse then when I use the console
to deploy the Database Pool using that driver JAR I get the following
exception:


Deployer operation failed: org.apache.openejb.OpenEJBException: Unable
to extract jar. error in opening zip file: error in opening zip file
org.apache.geronimo.common.DeploymentException:
org.apache.openejb.OpenEJBException: Unable to extract jar. error in
opening zip file: error in opening zip file
        at
org.apache.geronimo.openejb.deployment.EjbModuleBuilder.createModule(EjbModuleBuilder.java:251)
        at
org.apache.geronimo.openejb.deployment.EjbModuleBuilder.createModule(EjbModuleBuilder.java:225)
        at
org.apache.geronimo.j2ee.deployment.EARConfigBuilder.getDeploymentPlan(EARConfigBuilder.java:310)
        at org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:227)
        at org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:134)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at
org.apache.geronimo.gbean.runtime.ReflectionMethodInvoker.invoke(ReflectionMethodInvoker.java:34)
        at
org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperation.java:124)
        at
org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.java:867)
        at
org.apache.geronimo.kernel.basic.BasicKernel.invoke(BasicKernel.java:239)
        at
org.apache.geronimo.deployment.plugin.local.AbstractDeployCommand.doDeploy(AbstractDeployCommand.java:116)
        at
org.apache.geronimo.deployment.plugin.local.DistributeCommand.run(DistributeCommand.java:61)
        at java.lang.Thread.run(Thread.java:613)
Caused by: org.apache.openejb.OpenEJBException: Unable to extract jar.
error in opening zip file: error in opening zip file
        at
org.apache.openejb.config.DeploymentLoader.unpack(DeploymentLoader.java:1006)
        at
org.apache.openejb.config.DeploymentLoader.createConnectorModule(DeploymentLoader.java:782)
        at
org.apache.openejb.config.DeploymentLoader.load(DeploymentLoader.java:142)
        at
org.apache.geronimo.openejb.deployment.EjbModuleBuilder.createModule(EjbModuleBuilder.java:241)
        ... 15 more
Caused by: java.util.zip.ZipException: error in opening zip file
        at java.util.zip.ZipFile.open(Native Method)
        at java.util.zip.ZipFile.<init>(ZipFile.java:203)
        at java.util.jar.JarFile.<init>(JarFile.java:132)
        at java.util.jar.JarFile.<init>(JarFile.java:97)
        at org.apache.openejb.util.JarExtractor.extract(JarExtractor.java:75)
        at org.apache.openejb.util.JarExtractor.extract(JarExtractor.java:48)
        at
org.apache.openejb.config.DeploymentLoader.unpack(DeploymentLoader.java:1004)
        ... 18 more



I'm running both from the command line and from within Eclipse as the
same user. And, yes I did shutdown the command-line run Geronimo before
I started the Eclipse Geronimo.

I'd like to know what I'm doing wrong in Eclipse - although I can't
think what!


Thanks

--
Mark

[Forrest_Xia]

You mean you boot geronimo from eclipse, then open a browser to login administrative console to deploy the same database pool?

 

can you share the data source deployment plan?

[Mark Himsley]

Forrest_Xia wrote:

open a browser to login administrative console to deploy the same database pool?

Yes. That's what I did.

If I start Geronimo from the command line and go to the administrative console in a browser then creating a database pool works.

If I start Geronimo from Eclipse and go to the administrative console in a browser then creating a database pool fails with the above exception.

Forrest_Xia wrote:

can you share the data source deployment plan?

I haven't got that far yet - I'm just trying to make a database pool in the admin console! Frankly, I tried to make the database pool for a couple of hours in the admin console of a Geronimo started as a service in Eclipse on my Mac, and it confused me that it was not working. It was only by chance that I ran Geronimo from the command line and found creating the pool worked. Perhaps its just me...

[Quintin Beukes-2]

Are you in Linux?

Have you tried to change the ownership of your Geronimo directory?
Perhaps some of it is owned by another user and your user (which you
run eclipse as) doesn't have write access to geronimo's temp
directories?

Q

On Mon, Sep 14, 2009 at 10:53 PM, Mark Himsley <mark@...> wrote:

>
>
> Forrest_Xia wrote:
>>
>> open a browser to login administrative console to deploy the same database
>> pool?
>>
>
> Yes. That's what I did.
>
> If I start Geronimo from the command line and go to the administrative
> console in a browser then creating a database pool works.
>
> If I start Geronimo from Eclipse and go to the administrative console in a
> browser then creating a database pool fails with the above exception.
>
>
> Forrest_Xia wrote:
>>
>> can you share the data source deployment plan?
>>
>
> I haven't got that far yet - I'm just trying to make a database pool in the
> admin console! Frankly, I tried to make the database pool for a couple of
> hours in the admin console of a Geronimo started as a service in Eclipse on
> my Mac, and it confused me that it was not working. It was only by chance
> that I ran Geronimo from the command line and found creating the pool
> worked. Perhaps its just me...
> --
> View this message in context: http://www.nabble.com/Database-Pool-creation-exception-tp25425055s134p25443458.html
> Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
>
>

--
Quintin Beukes

[Mark Himsley]

Quintin Beukes-2 wrote:

Are you in Linux?

No, Mac OS 10.5.8.

Also I am running Eclipse (and its server Geronimo) and the command line Geronimo as the same user, so I can't see how permissions could be the issue.

Can I turn up logging so see more accurately why Geronimo is unable to create the Database Pool?