Questions tagged [connection]

Refers to a connection used to transfer data between two endpoints, such as between a client and a web, database, web service or other server.

A connection is a session established between two communications endpoint applications.

10252 questions
22
votes
4 answers

Relation between Oracle session and connection pool

Let me explain the set up first. We have an oracle server running on a 2GB RAM machine. The Db instance has the init parameter "sessions" set to 160. We have the application deployed on Websphere 6.1. The connection pool settings is Min 50 and Max…
Sathya
  • 2,371
  • 5
  • 19
  • 27
21
votes
9 answers

What is Sqlite used for?

I don't know how authoritative this is but I found this: http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations and it doesn't seem good to have a lot of connections to sqlite. This seems to be bad for the web and most applications that…
johnny
  • 19,272
  • 52
  • 157
  • 259
21
votes
6 answers

PHP's PDO is ignoring the ATTR_TIMEOUT option for MySQL when server cannot be reached

I'm testing scenarios where the mysql server cannot be reached by putting in a random IP to try to connect to. I set PDO's options to time out after one second using PDO::ATTR_TIMEOUT => 1. However, it still takes 30 seconds to throw an exception.…
timetofly
  • 2,957
  • 6
  • 36
  • 76
21
votes
2 answers

upstream timed out (110: Connection timed out) for static content?

I've a situation where two webservers are setup with nginx as loadbalancer and are backends themselves. Distribution is Debian Wheezy. Config is the same on both servers (Quad-Core with 32GB…
rabudde
  • 7,498
  • 6
  • 53
  • 91
21
votes
5 answers

RabbitMQ new connection refused due to SocketException

while trying to create a new connection to rabbitmq running on a different server, I got the following error: java.io.IOException at com.rabbitmq.client.impl.AMQChannel.wrap(AMQChannel.java:106) at…
Rasika Vijay
  • 395
  • 1
  • 7
  • 17
21
votes
2 answers

Moving from mysql connection to mysqli

I have a function I used to use with my scripts. openDBConn() and closeDBConn() These both called the mysql_connect() function. Used as seen below openDBConn(); $car_model = getCarModel($car_id); $car_color =…
Jms Bnd
  • 1,213
  • 3
  • 13
  • 18
20
votes
4 answers

Implementing Connection Pooling : Java

In one of the interviews that I faced,I was asked to implement connection pooling. So approach was this: Create a List or HashMap Create predefined number of connections Add them to the collection. Now when the ConnectionImpl getConnection() method…
crackerplace
  • 5,305
  • 8
  • 34
  • 42
20
votes
5 answers

Where to store database login credentials for a PHP application

We have a development server and a live server with different database connection details (username, password, etc). Currently we're storing BOTH the database connection details in a initial.php and one is selected if a DEFINE statement is present.…
siliconpi
  • 8,105
  • 18
  • 69
  • 107
20
votes
1 answer

How do you connect your terminal with the Android emulator

I have tried the navigate to the android tool folder and entering the "adb shell" command but it doesn't seem to work. My terminal seems only to recognize the adb part of the command and gives me an error message. What am I doing wrong???
codenamejupiterx
  • 1,589
  • 9
  • 23
  • 34
20
votes
2 answers

How to solve the 10054 error

I'm using an app provided by some website to collect some data from the website periodly, say, 30s a time. The returned response is then recorded in database. I use the requests modular by import requests and write codes to catch Exception. The…
Deep_fox
  • 405
  • 2
  • 6
  • 14
20
votes
7 answers

psql: FATAL: too many connections for role

I tried connecting to the database server using the command: psql -h host_ip -d db_name -U user_name --password It displays the following line and refuses to connect. psql: FATAL: too many connections for role "user_name". How to close the active…
nishantsingh
  • 4,537
  • 5
  • 25
  • 51
20
votes
2 answers

Why do we need to set Min pool size in ConnectionString

For SQL connection pool, why do we need to set up a min pool size? As connections will be saved in the connection pool and reused, why do we need to keep live connections specified by the min pool size? Thanks.
Helic
  • 907
  • 1
  • 10
  • 25
20
votes
10 answers

Where to close a JDBC Connection while I want to return the ResultSet

It seems that the ResultSet will be automatically closed when I close the Connection. But I want to return the ResultSet and use it in another method, then I don't know where to close Connection and PreparedStatement. public ResultSet…
Aloong
  • 1,715
  • 6
  • 23
  • 40
20
votes
2 answers

Rabbitmq server connection closing abruptly

I have tried to use Rabbitmq server for some reason the connection closes abruptly even though I passed the correct username and password. Rabbitmq server is running on port 5672 and telneting to my server at port 5672 says its running fine. I have…
Gagan
  • 4,278
  • 7
  • 46
  • 71
19
votes
4 answers

Internet Connection Error

I have an Android application which connects to the Internet. I am trapping all the possible scenarios for the connection and notice that when I don't have an Internet connection, an UnknownHostException is thrown. I am a bit confused here since…
Arci
  • 6,647
  • 20
  • 70
  • 98