You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@juddi.apache.org by Nitesh Khilwani <N....@lboro.ac.uk> on 2009/03/09 00:19:06 UTC
Error: Could not create jUDDI database Cannot create PoolableConnectionFactory
Hi,
I am trying to deploy jUDDI on TOMCAT 6.0 and Mysql 5.1. After going through the entire process given in Getting_Started.pdf document as well in Wiki-howto.
I am getting following error:
+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not acquired. (Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.))
- SELECT COUNT(*) FROM PUBLISHER failed (null)
Can you please help me for this. I will be really grateful of you.
The error is due to:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
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:1161)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4364)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 22 more
Caused by: java.sql.SQLException: Access denied for user 'juddi'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
... 35 more
Regards
Nitesh
..............................................................................................................
Nitesh Khilwani | PhD Student
email: N.Khilwani@lboro.ac.uk
tel: +44 (0) 1509 227 684 | fax: +44 (0) 1509 227 648
address: Wolfson School of Mechanical and Manufacturing Engineering, Loughborough University, Loughborough, LE11 3TU
Re: Error: Could not create jUDDI database Cannot create PoolableConnectionFactory
Posted by Kurt T Stam <ku...@gmail.com>.
The error you are having seems to have to do with a mysql user
permission problem. Try logging in with that user from the cmdline.
Nitesh Khilwani wrote:
> Hi,
>
> I am trying to deploy jUDDI on TOMCAT 6.0 and Mysql 5.1. After going
> through the entire process given in Getting_Started.pdf document as
> well in Wiki-howto.
> I am getting following error:
> + Got a JNDI Context!
> + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
> - DB connection was not acquired. (Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.))
> - SELECT COUNT(*) FROM PUBLISHER failed (null)
> Can you please help me for this. I will be really grateful of you.
>
> The error is due to:
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> 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:1161)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
> at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4364)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(StandardService.java:516)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at com.mysql.jdbc.Util.getInstance(Util.java:381)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253)
> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
> at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
> at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
> at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
> ... 22 more
> Caused by: java.sql.SQLException: Access denied for user 'juddi'@'localhost' <mailto:%27juddi%27@%27localhost%27> (using password: YES)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
> ... 35 more
> Regards
> Nitesh
>
> ..............................................................................................................
>
> *Nitesh Khilwani* | PhD Student
> email: N.Khilwani@lboro.ac.uk
> tel: +44 (0) 1509 227 684 | fax: +44 (0) 1509 227 648
> address: Wolfson School of Mechanical and Manufacturing Engineering,
> Loughborough University, Loughborough, LE11 3TU
>
>
>
Re: Error: Could not create jUDDI database Cannot create PoolableConnectionFactory
Posted by Kurt T Stam <ku...@gmail.com>.
Hi Nitesh,
The easiest way is probably to download the juddi-tomcat.zip bundle.
Then all you have to do is to change the datasource to mysql and add the
appropriate mysql driver.
There is a bundle for juddi-2.0rc6 at
http://www.apache.org/dist/ws/juddi/2_0RC6/
or for juddi-3.0-alpha at http://www.apache.org/dist/ws/juddi/3_0/
By the way, these bundles are ready to go using an embedded Derby
database. So you may want to
try that before switching databases.
Good luck!
--Kurt
Nitesh Khilwani wrote:
> Hi,
>
> I am trying to deploy jUDDI on TOMCAT 6.0 and Mysql 5.1. After going
> through the entire process given in Getting_Started.pdf document as
> well in Wiki-howto.
> I am getting following error:
> + Got a JNDI Context!
> + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
> - DB connection was not acquired. (Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.))
> - SELECT COUNT(*) FROM PUBLISHER failed (null)
> Can you please help me for this. I will be really grateful of you.
>
> The error is due to:
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
> 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:1161)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
> at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4364)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(StandardService.java:516)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at com.mysql.jdbc.Util.getInstance(Util.java:381)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253)
> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
> at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
> at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
> at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
> at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
> ... 22 more
> Caused by: java.sql.SQLException: Access denied for user 'juddi'@'localhost' <mailto:%27juddi%27@%27localhost%27> (using password: YES)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
> at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923)
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273)
> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)
> ... 35 more
> Regards
> Nitesh
>
> ..............................................................................................................
>
> *Nitesh Khilwani* | PhD Student
> email: N.Khilwani@lboro.ac.uk
> tel: +44 (0) 1509 227 684 | fax: +44 (0) 1509 227 648
> address: Wolfson School of Mechanical and Manufacturing Engineering,
> Loughborough University, Loughborough, LE11 3TU
>
>
>