Question : Coming from Oracle I have discovered that SSMS connects slightly different than Oracle’s SQL Developer. Oracle you click […]
Tag: connection-pooling
Connection pool Error
Question : I am getting the below error from my .net application. Source: xxx.Services.xxx.xxx.xxxx.xxxx.xxxxRequest — System.Data.Entity.Core.EntityException: The underlying provider failed […]
how to find a connection string value for a session in sql server?
Question : I know there was a similar question before at SO as shown here However, that answer really does […]
connection pooling, transactions, nested transaction and rollback
Question : I’ve got strange behavior on production. First user request thru application failed, I’ve got SQLServerException with “Lock request […]
Verifying connection pooling server side with CONTEXT_INFO on
Question : I’m working with a 3 tiered application, Microsoft Dynamics AX, where the middle tier maintains connections to a […]
How to reset session context/variables in JDBC pooled connections – MySQL / Oracle
Question : In my application I have multithreads that needs to access database and I am using apache.tomcat.jdbc.pool.DataSource as a […]
Is it possible to configure pgbouncer to distribute queries among master and slave?
Question : We have master (write-read) and slave (readonly) Postgres 10 databases. Slave is online replication from master. Now our […]
Shared connection pool in SQL Server and prevention of cross-database queries
Question : Microsoft recommends that a shared connection pool should be used when running e.g. a SaaS software with one […]
What is the sense to use server_lifetime with PgBouncer?
Question : I’ve found server_lifetime option in PgBouncer config, and I’m trying to undestand if it is really needed in […]
Debug Connection Pool Error
Question : I have been getting the below error. System.Data.Entity.Core.EntityException: The underlying provider failed on Open. —> System.InvalidOperationException: Timeout expired. […]