Foros de discusión
Java.sql.SQLException
Praveen P, modificado hace 11 años.
Java.sql.SQLException
Regular Member Mensajes: 100 Fecha de incorporación: 21/02/12 Mensajes recientes
How to resolve this exception?
Thanks in advance
11:10:56,062 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@853266 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
java.sql.SQLException: Access denied for user 'lportal'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thanks in advance
Hitoshi Ozawa, modificado hace 11 años.
RE: Java.sql.SQLException
Liferay Legend Mensajes: 7942 Fecha de incorporación: 24/03/10 Mensajes recientes
Check if you can login to the database using user/password you provided and create a table in the liferay database.
Praveen P, modificado hace 11 años.
RE: Java.sql.SQLException
Regular Member Mensajes: 100 Fecha de incorporación: 21/02/12 Mensajes recientes
ya it is working fine for some portlet but not responding for some other portlets
i created users and details of user information is getting stored perfectly in user_ table
i created users and details of user information is getting stored perfectly in user_ table
Hitoshi Ozawa, modificado hace 11 años.
RE: Java.sql.SQLException
Liferay Legend Mensajes: 7942 Fecha de incorporación: 24/03/10 Mensajes recientes
In which portlets are it working and for which is it not working?
This implies the user you're using to access mysql database does not have proper privilege.
java.sql.SQLException: Access denied for user 'lportal'@'localhost' (using password: YES)
This implies the user you're using to access mysql database does not have proper privilege.
Jitendra Rajput, modificado hace 11 años.
RE: Java.sql.SQLException
Liferay Master Mensajes: 875 Fecha de incorporación: 7/01/11 Mensajes recientes
As per the log issue is with your credentials only
Danial Mustofa Habibi, modificado hace 11 años.
RE: Java.sql.SQLException
Regular Member Mensajes: 141 Fecha de incorporación: 1/11/11 Mensajes recientesPraveen P:
How to resolve this exception?11:10:56,062 WARN [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@853266 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception:
java.sql.SQLException: Access denied for user 'lportal'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thanks in advance
problem occur because your credential..check again the user name and password, or if using custom portlet maybe your ext-spring?
Chennamma Rathode, modificado hace 8 años.
RE: Java.sql.SQLException
Junior Member Mensajes: 45 Fecha de incorporación: 5/08/15 Mensajes recientes
Hi I'm also getting the same error. plz help me regarding this.
David H Nebinger, modificado hace 8 años.
RE: Java.sql.SQLException
Liferay Legend Mensajes: 14919 Fecha de incorporación: 2/09/06 Mensajes recientes
This is a 3 year old zombie thread that you've just brought back to life.
I doubt that you are having the same problem that folks 3 years ago were having anyway. Different versions and all. Maybe your problem resembles this, but that doesn't mean it's the same.
I doubt that you are having the same problem that folks 3 years ago were having anyway. Different versions and all. Maybe your problem resembles this, but that doesn't mean it's the same.
Chennamma Rathode, modificado hace 8 años.
RE: Java.sql.SQLException
Junior Member Mensajes: 45 Fecha de incorporación: 5/08/15 Mensajes recientes
I'm new to liferay now i'm using liferay 6.2 version...Facing same exception unable to start the server.