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.
