You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@juddi.apache.org by SARA1232007 <cy...@foxmail.com> on 2009/06/24 09:51:15 UTC
Urgent:Unknown database 'juddi' exception when deploying juddi on
tomcat
Hi,
My juddi software's version is as following:
juddi-tomcat-2.0rc7 + apache-tomcat-5.5.23 + MySql
I have deployed juddi-2.0rc7 on tomcat accrording to the 《Getting Started
with jUDDI》 provided in juddi-distribution-2.0rc7-bin.zip.
Also, I have created juddi database in mySql according to the guidiance in
《Getting Started with jUDDI》. But after I startup Tomcat, juddi.log indicate
that there's No juddi datebase. The detailed information in juddi.log is as
following:
2009-06-24 11:25:07,468 INFO [org.apache.juddi.registry.RegistryServlet] -
Loading jUDDI configuration.
2009-06-24 11:25:07,468 INFO [org.apache.juddi.registry.RegistryServlet] -
Resources loaded from: /WEB-INF/juddi.properties
2009-06-24 11:25:07,468 INFO [org.apache.juddi.registry.RegistryServlet] -
Initializing jUDDI components.
2009-06-24 11:25:07,765 INFO [org.apache.juddi.util.jdbc.ConnectionManager]
- Using JNDI to aquire a JDBC DataSource with name:
java:comp/env/jdbc/juddiDB
2009-06-24 11:25:11,859 ERROR [org.apache.juddi.registry.RegistryEngine] -
Could not create jUDDI database Cannot create PoolableConnectionFactory
(Server connection failure during transaction. Due to underlying exception:
'com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database
'juddi''.
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
MESSAGE: Unknown database 'juddi'
STACKTRACE:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database
'juddi'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2772)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at
org.apache.juddi.util.jdbc.ConnectionManager.acquireConnection(ConnectionManager.java:56)
at
org.apache.juddi.registry.RegistryEngine.initializeDatabase(RegistryEngine.java:250)
at org.apache.juddi.registry.RegistryEngine.init(RegistryEngine.java:196)
at org.apache.juddi.registry.RegistryServlet.init(RegistryServlet.java:182)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
** END NESTED EXCEPTION **
Attempted reconnect 3 times. Giving up.)
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Server connection failure during transaction. Due
to underlying exception:
'com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database
'juddi''.
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
MESSAGE: Unknown database 'juddi'
STACKTRACE:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database
'juddi'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2772)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at
org.apache.juddi.util.jdbc.ConnectionManager.acquireConnection(ConnectionManager.java:56)
at
org.apache.juddi.registry.RegistryEngine.initializeDatabase(RegistryEngine.java:250)
at org.apache.juddi.registry.RegistryEngine.init(RegistryEngine.java:196)
at org.apache.juddi.registry.RegistryServlet.init(RegistryServlet.java:182)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
** END NESTED EXCEPTION **
Attempted reconnect 3 times. Giving up.)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at
org.apache.juddi.util.jdbc.ConnectionManager.acquireConnection(ConnectionManager.java:56)
at
org.apache.juddi.registry.RegistryEngine.initializeDatabase(RegistryEngine.java:250)
at org.apache.juddi.registry.RegistryEngine.init(RegistryEngine.java:196)
at org.apache.juddi.registry.RegistryServlet.init(RegistryServlet.java:182)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
... ...
Can anyone help with this?
Thanks.
Sara
--
View this message in context: http://www.nabble.com/Urgent%3AUnknown-database-%27juddi%27-exception-when-deploying-juddi-on-tomcat-tp24180236p24180236.html
Sent from the jUDDI - User mailing list archive at Nabble.com.
Re: Urgent:Unknown database 'juddi' exception when deploying juddi
on tomcat
Posted by Kurt T Stam <ku...@gmail.com>.
Hi Sara,
You just need to create a juddi database in MySQL, and a MySQL juddi
user that has access to this database.
--Kurt
SARA1232007 wrote:
> Hi,
>
> My juddi software's version is as following:
> juddi-tomcat-2.0rc7 + apache-tomcat-5.5.23 + MySql
>
> I have deployed juddi-2.0rc7 on tomcat accrording to the 《Getting Started
> with jUDDI》 provided in juddi-distribution-2.0rc7-bin.zip.
>
> Also, I have created juddi database in mySql according to the guidiance in
> 《Getting Started with jUDDI》. But after I startup Tomcat, juddi.log indicate
> that there's No juddi datebase. The detailed information in juddi.log is as
> following:
>
> 2009-06-24 11:25:07,468 INFO [org.apache.juddi.registry.RegistryServlet] -
> Loading jUDDI configuration.
> 2009-06-24 11:25:07,468 INFO [org.apache.juddi.registry.RegistryServlet] -
> Resources loaded from: /WEB-INF/juddi.properties
> 2009-06-24 11:25:07,468 INFO [org.apache.juddi.registry.RegistryServlet] -
> Initializing jUDDI components.
> 2009-06-24 11:25:07,765 INFO [org.apache.juddi.util.jdbc.ConnectionManager]
> - Using JNDI to aquire a JDBC DataSource with name:
> java:comp/env/jdbc/juddiDB
> 2009-06-24 11:25:11,859 ERROR [org.apache.juddi.registry.RegistryEngine] -
> Could not create jUDDI database Cannot create PoolableConnectionFactory
> (Server connection failure during transaction. Due to underlying exception:
> 'com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database
> 'juddi''.
>
> ** BEGIN NESTED EXCEPTION **
>
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
> MESSAGE: Unknown database 'juddi'
>
> STACKTRACE:
>
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database
> 'juddi'
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
> at com.mysql.jdbc.Connection.createNewIO(Connection.java:2772)
> at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
> at
> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
> at
> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
> at
> org.apache.juddi.util.jdbc.ConnectionManager.acquireConnection(ConnectionManager.java:56)
> at
> org.apache.juddi.registry.RegistryEngine.initializeDatabase(RegistryEngine.java:250)
> at org.apache.juddi.registry.RegistryEngine.init(RegistryEngine.java:196)
> at org.apache.juddi.registry.RegistryServlet.init(RegistryServlet.java:182)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(StandardService.java:448)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
> 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.catalina.startup.Bootstrap.start(Bootstrap.java:295)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
>
>
> ** END NESTED EXCEPTION **
>
>
> Attempted reconnect 3 times. Giving up.)
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Server connection failure during transaction. Due
> to underlying exception:
> 'com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database
> 'juddi''.
>
> ** BEGIN NESTED EXCEPTION **
>
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
> MESSAGE: Unknown database 'juddi'
>
> STACKTRACE:
>
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database
> 'juddi'
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
> at com.mysql.jdbc.Connection.createNewIO(Connection.java:2772)
> at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
> at
> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
> at
> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
> at
> org.apache.juddi.util.jdbc.ConnectionManager.acquireConnection(ConnectionManager.java:56)
> at
> org.apache.juddi.registry.RegistryEngine.initializeDatabase(RegistryEngine.java:250)
> at org.apache.juddi.registry.RegistryEngine.init(RegistryEngine.java:196)
> at org.apache.juddi.registry.RegistryServlet.init(RegistryServlet.java:182)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(StandardService.java:448)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
> 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.catalina.startup.Bootstrap.start(Bootstrap.java:295)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
>
>
> ** END NESTED EXCEPTION **
>
>
> Attempted reconnect 3 times. Giving up.)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
> at
> org.apache.juddi.util.jdbc.ConnectionManager.acquireConnection(ConnectionManager.java:56)
> at
> org.apache.juddi.registry.RegistryEngine.initializeDatabase(RegistryEngine.java:250)
> at org.apache.juddi.registry.RegistryEngine.init(RegistryEngine.java:196)
> at org.apache.juddi.registry.RegistryServlet.init(RegistryServlet.java:182)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(StandardService.java:448)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
> 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.catalina.startup.Bootstrap.start(Bootstrap.java:295)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
>
> ... ...
>
> Can anyone help with this?
>
> Thanks.
>
> Sara
>