AW: crashing IdP db connection

[John Morrison]

On Tue, 2017-04-04 at 14:00 +0000, Cantor, Scott wrote:
> > The database connection is fine, something goes wrong with the
> > IdP/tomcat pool connection towards the localhost connection to mariadb
> > when the users/app URL changes its already recorded CAS Session
> > corresponding to the initial CAS URL.
> 
> That change is in fact a change. URLs are case sensitive. And keys in storage are also. So I would say this database is not set up appropriately perhaps. I'm assuming Hibernate understands that keys are not inherently case insensitive.
> 
Terrible that IIS isn't case sensitive when using ASP.net Default.aspx
and default.aspx are both accepted thus confusing the database. Paths
are case sensitive in IIS, but not ASP.net scripts, so it seems.

So your saying, hibernate can be set to accept case insensitive? Is this
a good idea?

> Also, you shouldn't use a Tomcat data source here, use a Spring bean inside the application declared in global.xml or a similar location. That may help a bit with overall stability (or not).
> 

Thanks! I will change that. This might be more stable if changed and not
drop the pool connection to the db, hopefully.... I'll try this first.

> -- Scott
> 
>