ERROR: addon install bundle --bundleSymbolicName org.springframework.roo....

[rootalways]

Hello there, i just wanted to do reverse engineering on my existing database on MySQL. But i had no luck to install addon for this task. Any one experiencing the same problem and had the solution, kindly help me out.

I embed here the stacktrace from my machine.

roo> addon install bundle --bundleSymbolicName org.springframework.roo.wrapping.mysql-connector-java
Target resource(s):
-------------------
Spring Roo - Wrapping - mysql-connector-java (5.1.13.0001)

Deploying...done.

[Thread-2] [org.apache.felix.bundlerepository [2]] Resolver: Install error - org.springframework.roo.wrapping.mysql-connector-java
org.apache.felix.log.LogException: java.lang.IllegalStateException: java.lang.IllegalStateException: Public key ID '0x00B5050F' not available from key server
at org.springframework.roo.felix.pgp.PgpServiceImpl.i sResourceSignedBySignature(PgpServiceImpl.java:423 )
at org.springframework.roo.felix.HttpPgpUrlStreamHand lerServiceImpl.openConnection(HttpPgpUrlStreamHand lerServiceImpl.java:100)
at org.apache.felix.framework.URLHandlersStreamHandle rProxy.openConnection(URLHandlersStreamHandlerProx y.java:271)
at java.net.URL.openConnection(URL.java:945)
at java.net.URL.openStream(URL.java:1009)
at org.apache.felix.bundlerepository.ResolverImpl.dep loy(ResolverImpl.java:550)
at org.apache.felix.bundlerepository.ObrCommandImpl._ deploy(ObrCommandImpl.java:397)
at org.apache.felix.bundlerepository.ObrCommandImpl.d eploy(ObrCommandImpl.java:335)
at org.apache.felix.bundlerepository.ObrCommandImpl.e xecute(ObrCommandImpl.java:114)
at org.apache.felix.shell.impl.Activator$ShellService Impl.executeCommand(Activator.java:286)
at org.springframework.roo.felix.FelixDelegator.perfo rm(FelixDelegator.java:218)
at org.springframework.roo.felix.FelixDelegator.obrSt art(FelixDelegator.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.roo.support.util.ReflectionUti ls.invokeMethod(ReflectionUtils.java:191)
at org.springframework.roo.process.manager.ProcessMan agerHostedExecutionStrategy$1.callback(ProcessMana gerHostedExecutionStrategy.java:49)
at org.springframework.roo.process.manager.internal.D efaultProcessManager.doTransactionally(DefaultProc essManager.java:178)
at org.springframework.roo.process.manager.internal.D efaultProcessManager.execute(DefaultProcessManager .java:141)
at org.springframework.roo.process.manager.ProcessMan agerHostedExecutionStrategy.execute(ProcessManager HostedExecutionStrategy.java:47)
at org.springframework.roo.shell.AbstractShell.execut eCommand(AbstractShell.java:165)
at org.springframework.roo.addon.roobot.client.AddOnR ooBotOperationsImpl.installAddon(AddOnRooBotOperat ionsImpl.java:186)
at org.springframework.roo.addon.roobot.client.AddOnR ooBotOperationsImpl.installAddOn(AddOnRooBotOperat ionsImpl.java:157)
at org.springframework.roo.addon.roobot.client.AddOnC ommands.installBsn(AddOnCommands.java:74)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.roo.support.util.ReflectionUti ls.invokeMethod(ReflectionUtils.java:191)
at org.springframework.roo.process.manager.ProcessMan agerHostedExecutionStrategy$1.callback(ProcessMana gerHostedExecutionStrategy.java:49)
at org.springframework.roo.process.manager.internal.D efaultProcessManager.doTransactionally(DefaultProc essManager.java:178)
at org.springframework.roo.process.manager.internal.D efaultProcessManager.execute(DefaultProcessManager .java:141)
at org.springframework.roo.process.manager.ProcessMan agerHostedExecutionStrategy.execute(ProcessManager HostedExecutionStrategy.java:47)
at org.springframework.roo.shell.AbstractShell.execut eCommand(AbstractShell.java:165)
at org.springframework.roo.shell.jline.JLineShell.pro mptLoop(JLineShell.java:358)
at org.springframework.roo.shell.jline.JLineShell.run (JLineShell.java:132)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.felix.log.LogException: java.lang.IllegalStateException: Public key ID '0x00B5050F' not available from key server
at org.springframework.roo.felix.pgp.PgpServiceImpl.g etPublicKey(PgpServiceImpl.java:290)
at org.springframework.roo.felix.pgp.PgpServiceImpl.i sResourceSignedBySignature(PgpServiceImpl.java:402 )
... 37 more
Caused by: org.apache.felix.log.LogException: java.net.SocketException: Connection timed out
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:513)
at sun.net.www.protocol.http.HttpURLConnection$6.run( HttpURLConnection.java:1360)
at java.security.AccessController.doPrivileged(Native Method)
at sun.net.http://www.protocol.http.HttpURLConn...tion.java:1354)
at sun.net.http://www.protocol.http.HttpURLConn...tion.java:1008)
at org.springframework.roo.url.stream.jdk.JdkUrlInput StreamService$ProgressIndicatingInputStream.<init> (JdkUrlInputStreamService.java:73)
at org.springframework.roo.url.stream.jdk.JdkUrlInput StreamService.openConnection(JdkUrlInputStreamServ ice.java:49)
at org.springframework.roo.felix.pgp.PgpServiceImpl.g etPublicKey(PgpServiceImpl.java:287)
... 38 more
Caused by: java.net.SocketException: Connection timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream. java:129)
at java.io.BufferedInputStream.fill(BufferedInputStre am.java:218)
at java.io.BufferedInputStream.read1(BufferedInputStr eam.java:258)
at java.io.BufferedInputStream.read(BufferedInputStre am.java:317)
at sun.net.http://www.http.HttpClient.parseHTTP...ent.jav a:687)
at sun.net.http://www.http.HttpClient.parseHTTP...lient.java:632)
at sun.net.http://www.http.HttpClient.parseHTTP...lient.java:652)
at sun.net.http://www.protocol.http.HttpURLConn...tion.java:1064)
at sun.net.http://www.protocol.http.HttpURLConn...tion.java:2165)
at java.net.URLConnection.getHeaderFieldInt(URLConnec tion.java:579)
at java.net.URLConnection.getContentLength(URLConnect ion.java:474)
at org.springframework.roo.url.stream.jdk.JdkUrlInput StreamService$ProgressIndicatingInputStream.<init> (JdkUrlInputStreamService.java:72)
... 40 more


Thank alot,
Tuyen

[Stefan Schmidt]

This is a known problem with Roo 1.1.1. Unfortunately the keyserver contacted by Roo has been taken down. We have addressed this problem for the 1.1.2 release. Until it is officially released, please use a CI build snapshot from here: http://static.springsource.org/downl...hp?project=ROO

-Stefan

[shmoo83]

Hi!
You can also try downloading the jar from:
http://s3browse.springsource.com/bro...a/5.1.13.0001/

and then install it using roo via the command:
osgi start --url <path to your mysql-connector-java-5.1.13.0001.jar>
i.e.: file:org.springframework.roo.wrapping.mysql-connector-java-5.1.13.0001.jar

Info was taken from this thread: http://forum.springsource.org/showthread.php?t=97129

It worked for me so I hope it will work for you as well.