Hi Robert,

I have fixed the below issue and pushed into release branch. Can you verify it 
please.

Thanks,
Nazeer
-----Original Message-----
From: Ippez Robert [mailto:[email protected]] 
Sent: 18 May 2017 14:07
To: [email protected]
Subject: Re: New release branch 1.0.0

Thanks too @Nazeer!!!

Regards

On Thu, May 18, 2017 at 11:29 AM, Shaik Nazeer < 
[email protected]> wrote:

> 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 < nazeer.shaik@ 
> confluxtechnologies.com> 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.retrieveAccountDe
> > ta
> > 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]
>
>


--
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]

Reply via email to