Re: JDBC Realm & exceptions

2015-02-20 Thread Leonid Rozenblyum
Thanks for the idea with the view! On Thu, Feb 19, 2015 at 9:03 PM, Felix Schumacher wrote: > Am 19.02.2015 um 13:58 schrieb Leonid Rozenblyum: >> >> I'm sorry for the late response. >> >> 1. After deeper check I see our structure is NOT much more complex >> than standard Tomcat structure. >> Act

Re: JDBC Realm & exceptions

2015-02-19 Thread Felix Schumacher
Am 19.02.2015 um 13:58 schrieb Leonid Rozenblyum: I'm sorry for the late response. 1. After deeper check I see our structure is NOT much more complex than standard Tomcat structure. Actually the significant difference is : user roles table has foreign key to id in users table (so we join by id n

Re: JDBC Realm & exceptions

2015-02-19 Thread Leonid Rozenblyum
I'm sorry for the late response. 1. After deeper check I see our structure is NOT much more complex than standard Tomcat structure. Actually the significant difference is : user roles table has foreign key to id in users table (so we join by id not by username) 2. Great news about fix in 8.0.19!

Re: JDBC Realm & exceptions

2015-02-05 Thread Felix Schumacher
Am 5. Februar 2015 22:21:38 MEZ, schrieb Leonid Rozenblyum : >Hello Felix! >Thanks for the detail answer! Good suggestion about DataSourceRealm! >(I thought about this possibility but then I discovered that we have >extended JDBCRealm to support some complex DB structure so maybe this >switch t

Re: JDBC Realm & exceptions

2015-02-05 Thread Leonid Rozenblyum
Hello Felix! Thanks for the detail answer! Good suggestion about DataSourceRealm! (I thought about this possibility but then I discovered that we have extended JDBCRealm to support some complex DB structure so maybe this switch to another Realm is not SO easy as it should be). Is it a good idea t

Re: JDBC Realm & exceptions

2015-02-05 Thread Felix Schumacher
Hi Leonid, Am 05.02.2015 um 16:28 schrieb Leonid Rozenblyum: Hello! After upgrading from Tomcat7 to Tomcat8 we started facing exceptions: rg.apache.catalina.realm.JDBCRealm getPassword SEVERE: Exception performing authentication org.postgresql.util.PSQLException: This statement has been closed

JDBC Realm & exceptions

2015-02-05 Thread Leonid Rozenblyum
Hello! After upgrading from Tomcat7 to Tomcat8 we started facing exceptions: rg.apache.catalina.realm.JDBCRealm getPassword SEVERE: Exception performing authentication org.postgresql.util.PSQLException: This statement has been closed. They look like not giving any harm (?). Could we do anything