Hi Robert I got the root cause of this problem. After getting the connection we are not releasing the same. So connection pool is releasing the connection by logging it as abandoned by checking the abandoned timeout and finally this connection object will be nullified. Thank you for catching this. I will solve it and update the release branch.
Thanks, Nazeer -----Original Message----- From: Ippez Robert [mailto:[email protected]] Sent: 18 May 2017 13:39 To: [email protected] Subject: Re: New release branch 1.0.0 Please follow the below:- 1. In Global search, type initials of any client in database 2. on one of the click's display 3. click on the + button to expand additional information. Accounts are shown correctly but when you check your tomcat console, you will see the above warnings as pasted in the above thread. On Thu, May 18, 2017 at 10:55 AM, Shaik Nazeer < [email protected]> wrote: > Can you give some prerequisites to reproduce this issue please as I am > unable to reprocude the same. > > -----Original Message----- > From: Ippez Robert [mailto:[email protected]] > Sent: 18 May 2017 13:19 > To: [email protected] > Subject: Re: New release branch 1.0.0 > > Hi Nazeer, > Please check tomcat log when you search a client or group from global > search and then click on + sign to expand to show additional > information on the client. I think its due to column validation a feature > added recently. > > Here is a snapshot of the error log:- > > *May 18, 2017 10:51:30 AM org.apache.tomcat.jdbc.pool.ConnectionPool > abandon* > *WARNING: Connection has been abandoned > PooledConnection[com.mysql.jdbc.JDBC4Connection@1aef596f] > :java.lang.Exception* > * at > org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump( > ConnectionPool.java:1063)* > * at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection( > ConnectionPool.java:780)* > * at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection( > ConnectionPool.java:619)* > * at > org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection( > ConnectionPool.java:188)* > * at > org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection( > DataSourceProxy.java:128)* > * at > org.apache.fineract.infrastructure.core.service.RoutingDataSource. > getConnection(RoutingDataSource.java:49)* > * at > org.apache.fineract.infrastructure.security.utils.ColumnValidator. > validateColumn(ColumnValidator.java:50)* > * at > org.apache.fineract.infrastructure.security.utils.ColumnValidator. > validateSqlInjection(ColumnValidator.java:98)* > * at > org.apache.fineract.portfolio.accountdetails.service. > AccountDetailsReadPlatformServiceJpaRepositoryImpl.retrieveAccountDeta > ils( > AccountDetailsReadPlatformServiceJpaRepositoryImpl.java:137)* > * at > org.apache.fineract.portfolio.accountdetails.service. > AccountDetailsReadPlatformServiceJpaRepositoryImpl. > retrieveClientAccountDetails(AccountDetailsReadPlatformServ > iceJpaRepositoryImpl.java:79)* > * at > org.apache.fineract.portfolio.client.api.ClientsApiResource. > retrieveAssociatedAccounts(ClientsApiResource.java:306)* > * at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)* > * at > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43)* > * at java.lang.reflect.Method.invoke(Method.java:498)* > * at > com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke( > JavaMethodInvokerFactory.java:60)* > * at > com.sun.jersey.server.impl.model.method.dispatch. > AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch( > AbstractResourceMethodDispatchProvider.java:185)* > > Thanks > Regards > Ippez Robert > > On Thu, May 18, 2017 at 10:35 AM, Shaik Nazeer < nazeer.shaik@ > confluxtechnologies.com> wrote: > > > Hi all, > > > > > > > > I have created new release branch & tagged for upcoming Apache > > Fineract > > 1.0.0 release. > > > > > > > > Thanks, > > > > Nazeer > > > > > > > -- > Ippez Roberts > Director & Founder - Skyline Technologies Uganda "IT Consultants & > Engineers" > P.O.Box 155, Moyo > UGANDA. > Tel: +256788725408/789643284 > Skype ID: ippez.robert1 > Email: [email protected] > > -- Ippez Roberts Director & Founder - Skyline Technologies Uganda "IT Consultants & Engineers" P.O.Box 155, Moyo UGANDA. Tel: +256788725408/789643284 Skype ID: ippez.robert1 Email: [email protected]
