at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Dec 02, 2015 6:25:44 PM com.mchange.v2.resourcepool.BasicResourcePool forceKillAcquires
WARNING: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@23223dd8 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Dec 02, 2015 6:25:44 PM com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask run
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@78a1be2e -- 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 (30). Last acquisition attempt exception:
java.sql.SQLException: Access denied for user 'mhw'@'localhost' (using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)
Having a heck of a time connecting to my local MySql db. With or without password.
Tried different users, disabled firewall, etc.
Strange, phpmyadmin accesses it just fine...
Code:
Public Sub init
Dim JdbcUrl As String = Main.settings.Get("JdbcUrl")
Dim driverClass As String = Main.settings.Get("DriverClass")
Dim dbuser As String = Main.settings.Get("DBUser")
Dim dbpassword As String = Main.settings.Get("DBPassword")
Log(" Credts : "&JdbcUrl&" "&driverClass)
Log(" Credts :"&dbuser&" "&dbpassword)
Try
pool.Initialize(driverClass, JdbcUrl, dbuser, dbpassword)
Catch
Log("last Except: "&LastException.Message)
End Try
End Sub
EDIT: App dies here: ---> Dim sql1 As SQL = pool.GetConnection
Public Sub CreateUserTableIfNeeded
Dim sql1 As SQL = pool.GetConnection
End Sub..
settings.txt
Code:
JdbcUrl=jdbc:mysql://localhost/harris?characterEncoding=utf8
DriverClass=com.mysql.jdbc.Driver
DBUser=mhw
DBPassword=
RecaptchaPrivateKey=6LcslRATAAAAAMfi-QOBebkJfIcJTZBPWuOZlfQu
Port=51043
