java - Can't connect to MySQL server at 127.0.0.1 using c3p0 -


trying connect mysql server using following code in java c3p0:

combopooleddatasource = new combopooleddatasource();   combopooleddatasource.setjdbcurl("jdbc:mysql://127.0.0.1:3306/" + dbname);   combopooleddatasource.setuser(username);   combopooleddatasource.setpassword(password);   combopooleddatasource.setinitialpoolsize(15);   combopooleddatasource.setmaxpoolsize(20);   combopooleddatasource.setminpoolsize(10);   connection = combopooleddatasource.getconnection();

although have checked db , running , can connect using python keeps throwing me following error:

info: initializing c3p0 pool...com.mchange.v2.c3p0.combopooleddatasource@b4c966a[ acquireincrement -> 3, acquireretryattempts -> 30, acquireretrydelay -> 1000, autocommitonclose -> false, automatictesttable -> null, breakafteracquirefailure -> false, checkouttimeout -> 0, connectiontesterclassname -> com.mchange.v2.c3p0.impl.defaultconnectiontester, description -> null, driverclass -> null, factoryclasslocation -> null, forceignoreunresolvedtransactions -> false, identitytoken -> b4c966a, idleconnectiontestperiod -> -1, initialpoolsize -> 30, jdbcurl -> jdbc:jtds:mysql://127.0.0.1:3306/sip_base, logintimeout -> 0, maxidletime -> 0, maxpoolsize -> 20, maxstatements -> 0, maxstatementsperconnection -> 0, minpoolsize -> 10, numhelperthreads -> 3, preferredtestquery -> null, properties -> {user=******, password=******}, propertycycle -> 300, testconnectiononcheckin -> false, testconnectiononcheckout -> false, usestraditionalreflectiveproxies -> false ] Μαϊ 12, 2015 10:41:12 ΠΜ com.mchange.v2.resourcepool.basicresourcepool$acquiretask run warning: com.mchange.v2.resourcepool.basicresourcepool$acquiretask@7e2889c7 -- acquisition attempt failed!!! clearing pending acquires. while trying acquire needed new resource, failed succeed more maximum number of allowed acquisition attempts (30). Μαϊ 12, 2015 10:41:12 ΠΜ com.mchange.v2.resourcepool.basicresourcepool$acquiretask run warning: com.mchange.v2.resourcepool.basicresourcepool$acquiretask@372567de -- acquisition attempt failed!!! clearing pending acquires. while trying acquire needed new resource, failed succeed more maximum number of allowed acquisition attempts (30). exception in thread "main" java.sql.sqlexception: connections not acquired underlying database! @ com.mchange.v2.sql.sqlutils.tosqlexception(sqlutils.java:104) @ com.mchange.v2.c3p0.impl.c3p0pooledconnectionpool.checkoutpooledconnection(c3p0pooledconnectionpool.java:264) @ com.mchange.v2.c3p0.poolbackeddatasource.getconnection(poolbackeddatasource.java:94) @ com.mchange.v2.c3p0.combopooleddatasource.getconnection(combopooleddatasource.java:521) @ gov.nist.sip.proxy.extended.dbserver.<init>(dbserver.java:52) @ gov.nist.sip.proxy.extended.dbserver.getinstance(dbserver.java:64) @ gov.nist.sip.proxy.extended.dbserver.main(dbserver.java:161) caused by: com.mchange.v2.resourcepool.cannotacquireresourceexception: resourcepool not acquire resource primary factory or source. @ com.mchange.v2.resourcepool.basicresourcepool.awaitacquire(basicresourcepool.java:972) @ com.mchange.v2.resourcepool.basicresourcepool.checkoutresource(basicresourcepool.java:208) @ com.mchange.v2.c3p0.impl.c3p0pooledconnectionpool.checkoutpooledconnection(c3p0pooledconnectionpool.java:260) ... 5 more

you seem trying set initial pool size more max pool size - unlikely work.

combopooleddatasource.setinitialpoolsize(30);  // <<-- reduce  combopooleddatasource.setmaxpoolsize(20);  // <<-- less this.

Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l...
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more