Stack Overflow
Stack Overflow

Questions tagged [dbconnection]

230 questions
5
votes
1 answer

How to get EFProf and EFProviderWrapper working together in on Entity Framework Connection

Has anyone found a way to get Kowalski's EFProviderWrapper framework to run alongside Rhino's EFProf (Entity Framework Profiler) within the same Entity Framework context/connection? Currently if i try to register the EFProf Profiler while using an…
Rob
  • 1,663
  • 1
  • 19
  • 16
5
votes
1 answer

Error : "in `require': cannot load such file -- win32ole (LoadError)" while trying to connect from ruby program to ms access database

From my Ruby program running under Ubuntu I am trying to connect to an Access database residing on another computer running Windows. I am getting the error 'require': cannot load such file -- win32ole (LoadError) Another problem I am facing is…
John
  • 1,273
  • 3
  • 27
  • 61
5
votes
2 answers

Elastic Search Transport Client. Singleton vs One new instance for each call vs Connection Pool (if any)

I am connecting to elastic search using Elastic Search Transport Client. There are two approaches that I've tried 1) Singleton client shared across my entire application. Time to response is between 1-2s 2) New client instance for every call to…
Ravi Naik
  • 739
  • 7
  • 6
5
votes
1 answer

Correct Implementation of Transient Fault Handling (Azure)

For the past day or so I've been trying to implement Transient Fault Handling on an Azure SQL database. Although I have a working connection to the DB, I'm not convinced that it's handling the transient faults as expected. So far my approach has…
awj
  • 7,482
  • 10
  • 66
  • 120
4
votes
0 answers

How to let psql write connections work gracefully with AWS Aurora read replica scaling

Background We have a worker application server that does long running reporting export jobs. Since they are export jobs we connected it to a (managed, not serverless) Aurora database cluster with a write master and read replicas that auto-scale with…
abbood
  • 23,101
  • 16
  • 132
  • 246
4
votes
9 answers

Can a return statement prevent a using statement from closing a connection to a database?

When I'm creating temp tables I get an error message telling me that the temp table already exists. The temp table is unique to the session so it seems my connection isn't closing properly and I think it may have something to do with a return…
mezoid
  • 28,090
  • 37
  • 107
  • 148
4
votes
3 answers

Executing a stored procedure using a DbConnection

I need to execute a stored procedure on a database. This is what I got so far that works: protected DbProviderFactory dbProviderFactory; this.dbProviderFactory = DalFactory.GetFactory(this.adapterConfiguration); DbConnection dbConnection =…
Kasper Hansen
  • 6,307
  • 21
  • 70
  • 106
4
votes
1 answer

Is there a way to read UNCOMMITTED rows only in dapper?

I have already set the isolation level to IsolationLevel.ReadUncommitted is there an option to fetch uncommitted data only? Without manually altering Stored Procs to be called? Below is the script for fetching uncommitted data only: SELECT * FROM…
Barak
  • 535
  • 6
  • 18
4
votes
1 answer

How to use multiple versions at the same time in an Apigility app with Doctrine?

Context first: Apigility driven application based on Zend Framework 2. In the first version (V1) I was using the ZfcBase DbMapper for the model layer. Now I'm implementing the V2 with Doctrine 2 as ORM. Apigility provides an easy switching between…
automatix
  • 14,018
  • 26
  • 105
  • 230
4
votes
1 answer

Does DbConnection.Open always open a new database connection or can it reuse one of the connection pool?

I'm unsure at which level the connection pool is implemented in .NET. When I call using(var connection = new SqlConnection(connectionString)) { connection.Open(); Am I surely opening a new connection? Or could I possibly be reusing an active…
Jader Dias
  • 88,211
  • 155
  • 421
  • 625
3
votes
0 answers

MongoDB - Connections vs. sessions

I tried to understand what is the difference between connection and session upon mongoDB connection. I do understand that sessions are stored in cache on the db side, and cleaned up per 5 minutes (configurable). What the purpose of sessions? What…
Rotem ben
  • 156
  • 2
  • 13
3
votes
2 answers

DB Connection Timeout simulation

Is there an way to simulate a db connection timeout? I'm encountering problems with a timeouted db connection on a productive system and need to simulate a similar situation.
paweloque
  • 18,466
  • 26
  • 80
  • 136
3
votes
1 answer

Elixir: DBConnection queue_target and queue_interval explained

I am reading DBConnection documentation. And I don't quite understand following quote: Our goal is to wait at most :queue_target for a connection. If all connections checked out during a :queue_interval takes more than :queue_target, then we double…
Rudziankoŭ
  • 10,681
  • 20
  • 92
  • 192
3
votes
1 answer

.NET data provider for iSeries on V5R4

We have an iSeries on V5R4. Currently we use the .NET Framework IBM.Data.DB2.iSeries iDB2Connection extensively and successfully. For a long time now I have been trying to find a way to use the same IBM.Data.DB2.iSeries .NET data provider on either…
tibba69
  • 83
  • 4
3
votes
0 answers

What makes database connection expensive?

We all seem to know that database connections are expensive and we try to reduce the number of database trips as much as possible. But Why should one care about it ?? This may sound like a stupid question: What makes a database connection…
Malik Khalil
  • 6,454
  • 2
  • 39
  • 33
1
2
3
…
15 16