B4J Question < SOLVED> ConnectionPool Issue

Harris

Expert
Licensed User
Longtime User
Had an issue with ConnectionPool...

pool.Initialize(driverClass, JdbcUrl, dbuser, dbpassword) <---- This worked!!!
Dim sql1 As SQL = pool.GetConnection <---- This didn't. Timeout with access denied for user...

The issue was, I had a copy of Bitnami Joomla installed on my machine which had a MySql service running! I was testing this as a web dev platform - along with many others...

I ran USBwebserver - expecting it to be my MySql database connection. It seemed to initialize but then GetConnection would use the "windows service".

Uninstalled Joomla and connection now works fine (as shown below).

NOW, onward and upward with B4J and ABMaterial for web app development!

Thanks

B4X:
Program started.
Credts : jdbc:mysql://localhost/harris?characterEncoding=utf8  com.mysql.jdbc.Driver
Credts :root  usbw
Dec 03, 2015 1:08:22 PM com.mchange.v2.log.MLog <clinit>
INFO: MLog clients using java 1.4+ standard logging.
Dec 03, 2015 1:08:22 PM com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.2.1 [built 20-March-2013 11:16:28 +0000; debug? true; trace: 10]
pool is inited
attempting to get connection before dimming sql obj
Dec 03, 2015 1:08:22 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgeby99dtbjwihw5xza9|484b61fc, debugUnreturnedConnectionStackTraces -> false, description ->...
attempting to create table after dimming sql obj
attempting to create table
2015-12-03 13:08:24.553:INFO::main: Logging initialized @3950ms
2015-12-03 13:08:24.742:INFO:oejs.Server:main: jetty-9.1.z-SNAPSHOT
2015-12-03 13:08:24.792:WARN:oejh.MimeTypes:main: java.util.MissingResourceException: Can't find bundle for base name org/eclipse/jetty/http/encoding, locale en_CA
2015-12-03 13:08:24.844:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@1b68ddbd{/,file:/C:/Anywhere%20Software/B4J/ABM1/SisMAC/Objects/www/,AVAILABLE}
2015-12-03 13:08:24.850:INFO:oejs.AbstractNCSARequestLog:main: Opened C:\Anywhere Software\B4J\ABM1\SisMAC\Objects\logs\b4j-2015_12_03.request.log
2015-12-03 13:08:25.018:INFO:oejs.ServerConnector:main: Started ServerConnector@6c73ddeb{HTTP/1.1}{0.0.0.0:51043}
2015-12-03 13:08:25.019:INFO:oejs.Server:main: Started @4424ms
Emulated network latency: 100ms
Connected
ready!
 
Top