A database connection is a facility that allows client software to communicate with database server software, whether on the same machine or not. A connection is required to send commands and receive answers.
0
votes
1answer
9 views
Determining the right database connection pool size for an application hosted on Cloudfoundry
I am in reference to this excellent article regarding sizing a database connection pool by brettwooldridge author of HikariCP.
Amongst other, the article provide a formula for determining the size of ...
4
votes
1answer
6k views
How to connect to SQL Server through proxy server
Is it possible to connect to SQL Server server through proxy (http) using SQLSERVER oledb provider?
How can I specify proxy address and port in connection string if it's possible?
What nonstandard ...
0
votes
0answers
17 views
Connection pool management
I am writing a client pool implementation,
The client is my class that contains stub to axis 1.4 webService
Is there an open source Client Pool library that can help me manage my clients instead of me ...
1
vote
0answers
8 views
How to establish DB connection only once using zend frame work
I am newbie to the zend framework. I am using zend_db_table_abstract for doing database operations. Now, i want to know that zend_db_table_abstract will make single db connection for through out the ...
1
vote
1answer
26 views
How to define a connection string to create local database in the current folder?
My current connection string is:
<connectionStrings>
<add name="myConnectionString"
connectionString="Data Source=(LocalDB)\v11.0;Initial ...
0
votes
0answers
21 views
Unable to connect password protected MySQL Database using PHP
I have a website hosted at godaddy (say "abc.co.in"). After having logged into cpanel through my cpanel id and password (say "siteid" and "sitepw" respectively), i went ahead and created a MySQL ...
0
votes
0answers
6 views
What do “Connection Cycle ops/ms” and “Statement Cycle ops/ms” mean in the context of a microbenchmark of a connection pool?
I am in reference to HikariCP microbenchmark.
I saw two metrics that I don't really understand i.e.
Connection Cycle ops/ms
Statement Cycle ops/ms
Can someone please explain to me what the ...
0
votes
1answer
8 views
Why and when should an idle database connection be retired from a connection pool?
I understand from reading HikariCP's documentation (see below) that idle connections should be retired from a connection pool.
My question is: why and when should an idle database connection be ...
0
votes
1answer
43 views
Max User Connection issue with Hibernate and Java
I am using following code for database connection with Hibernate and Java specified in my applicationcontext file,
<bean id="DataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" ...
0
votes
1answer
5k views
Another 1045 : Access denied for user 'someone'@'localhost' (using password: YES)
As lot of dummies, I cannot connect to MySQL server with user.
This is settings of my USER in DB mysql table user
Host: %
User: someone
Password: mypassword
Select_priv, Insert_priv, ...
1
vote
3answers
1k views
Java SQL error, no suitable driver found
I'm trying to compile this small piece of code, to help me connect to my db and retrieve some information to test it. I am using Netbeans on a Windows 7 x64 machine. This is the code:
package ...
3
votes
1answer
7k views
Error:The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
I am using
Windows 7
Netbeans IDE 7.1.2
SQL Server Management Studio Express 2005
JDK1.6
I am getting the below error while connecting to the database:
...
0
votes
0answers
16 views
mysqli::query(): MySQL server has gone away - php and mysql
Fatal error: Uncaught exception 'ErrorException' with message 'mysqli::query(): MySQL server has gone away in functions.php on line 2108'
ErrorException: mysqli::query(): MySQL server has gone away ...
0
votes
2answers
370 views
PHP Login script receive blank screen in Hostinger
I have a confusing problem in login form, it seems work well when i try it in localhost but it gives a blank white screen when i upload it to hostinger. I think its not about the database connection. ...
0
votes
1answer
10 views
jar file not connecting to the database
i created a java project long back which requires connection to derby which is an inbuilt netbeans database. i always used to open netbeans, compile the files and run and it used to work just fine. ...
0
votes
0answers
16 views
MySQL remote SSH Connection using .NET C#
Below is a screenshot from MySQL workbench. The parameters are not real, but the structure shown here is exactly as per my real connection which is working nicely.
I am trying to connect to this ...
1
vote
1answer
34 views
Not able to get data from local DB in diff Web Role
I've created very simple MVC5 project with two Web roles . webRole1 with local DB which was created by code first (and generate the view by scaffold) this is working fine ,I was able to run it get ...
0
votes
0answers
25 views
Websphere application server connection pooling
In my WAS 7, I have installed 3 applications which are connected to different datasources configured in same server (eg. jdbc/Datasource1, jdbc/Datasource2, jdbc/Datasource3).
While working with one ...
-1
votes
0answers
27 views
ExecuteReader requires an open and available Connection. The connection's current state is open
I'm having this problem in my code that I have yet figured out how to resolve
Public Sub SqlFillDropDown(ByVal DropDown As DropDownList, ByVal Qry As String, ByVal Display As String, ByVal Value As ...
-3
votes
1answer
15 views
using mysqli_connect_errno not producing and output when writing wrong connection to db
<?php
// 1. Create a database connection
$dbhost = "???";
$dbuser = "???";
$dbpass = "???";
$dbname = "???";
$connection = mysqli_connect($dbhost, $dbuser, $dbpass,
$dbname);
// Test ...
0
votes
0answers
292 views
Retrying database connection on failure
Our django based application connects to an oracle 11 database. Connection creation sometimes fails because the database server might get large spikes of activity, and these cause oracle to return an ...
0
votes
0answers
13 views
how to connect sql server 2008 from my android app
I'm developing android app to connect SQL Server 2008, and this is my source code
DBConn.java
public class DBConn {
private static Connection conn = null ;
private static String DRIVER = ...
1
vote
2answers
12k views
App.Config Connection String
In my windows form i have connection string in app.config as
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add ...
0
votes
2answers
1k views
can't get database to connect during magento installation - using wizard
I’m trying to install magento on my live web server , I’ve checked the server with magento-check.php and thats fine.
I’ve set up a mysql db with the user name and password the of the mysql server
...
0
votes
1answer
18 views
Connection leaks causing TimeoutException when using C3P0
I'm using Carbonado, which is Amazon's open source object relational mapper. Carbonado is like Hibernate. My service contains a public API method for accessing the database using Carbonado. This ...
1
vote
3answers
4k views
1049, “Unknown database 'database' ” django mysql can't connect
Exception Type: OperationalError at /
Exception Value: (1049, "Unknown database 'database'")
At the moment i tried this:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql', ...
0
votes
1answer
9 views
WebSphere Shared Connections in Multiple Threads
When a data source is configured for Shared Connections, will WebSphere give out Connections to the same physical database connection handle to two different threads simultaneously? In other words, ...
0
votes
1answer
13 views
Determining the connections to Mongo
In Oracle, I can use V$SESSION to determine all the connections which are coming to an Oracle server. Is there any similar command for Mongo as well ?
Is there any way to determine the number of ...
0
votes
3answers
49 views
Asp.net Unable to Connect to MSSQL
When I try to launch the web project in asp.net with MSSQL, it seems like I cannot connect to my database. The error message is:
A network related or instance specific error occurred while ...
-1
votes
1answer
19 views
Windows authentication in app.config?
In web.config, to use windows domain authentication, I am aware to do the following:
<add name="MSSQL" connectionString="server=devserver;database=DBNAME;Integrated Security=SSPI;" ...
0
votes
0answers
21 views
creating a list in windows 8 phone app which fetches data for each list item from the server
I am using expression blend for designing my windows 8 phone app....I want to display 175 elements as a list and each element should be a button which can navigate to the next page for more info. ...
-3
votes
0answers
13 views
Error 28000 Access Denied for user @ pool 173.60.127.2
Where do I fix this error 28000 Access Denied for user @ pool 173.60.127.2
0
votes
1answer
148 views
Why can't my Django application reach my Postgres server?
Both servers are VirtualBox servers on my host machine, and I'm able to network between them just fine (ssh from one to the other, etc.), other than this issue (which I don't know enough about to rule ...
1
vote
1answer
19 views
IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer
I have installed Oracle 11g ON a RedHat6 linux instance, by following all the steps mentioned in "http://technologylair.net/2013/08/oracle-11g-installation-linux/#comment-50" I am trying to connect to ...
1
vote
1answer
8 views
Rails SQLite Delete Cascade Not Working
Where should I put "PRAGMA FOREIGNS KEYS = ON;" in rails 4.0?
I know it's connection setting so I have to make rails put it anytime it deletes something, but I don't know where to put it. I tried in ...
0
votes
0answers
5 views
DBCP connection hung
I am seeing following in the thread dump from load environment. I can see lot of connection available on the database side but still the queries are hung because of below wait. Any Idea if this is an ...
0
votes
2answers
2k views
“Can't connect to MySQL server on 'localhost' (10061)” error in python
Just today I have decided that I wanted to learn python because I personally like the syntax and its feel. I am a pretty young developer and I really wanted to learn a new programming language since I ...
15
votes
5answers
21k views
SQL Express Connection string - Relative to application location
I am using a SQL express databases as part of a unit test project in c#.
My databases is located in ./Databases/MyUnitTestDB.mdf
I would like to use a relative path or variable in the app.config ...
0
votes
1answer
20 views
Will JDBC database connections get released if they're used in a thread when Tomcat server shuts down?
We have a Tomcat stack for our web app, and use javax.sql.DataSource for our database connections. We have some methods that do a lot of database work that users don't really need to wait for that we ...
0
votes
1answer
65 views
Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?
Problem
Please note that I changed details for security purposes. However, the problem remains intact.
I installed an Oracle 11g database on a server at location, say, herp-devDV.derp.edu.
Now I ...
0
votes
0answers
17 views
What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?
Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
0
votes
0answers
11 views
SQL Server Express not connects from different IP range
I have developed c#.net application which communicates with remote SQL Server. Actually the machine on which SQL Server resides has IP 10.62.76.5 and client machine IP is 100.23.34.4, in this case ...
0
votes
1answer
39 views
Can not open android database using SQLiteDatabase.openDatabase()
In my app, I tried to open existing android database for modifying its content by following code:
String DB_PATH = "/data/data/com.sec.android.provider.logsprovider/databases/";
String ...
0
votes
2answers
47 views
Java database applicaion Freezing when loading lots of records
I need some advice from you more experienced coders with an issue I am having.
I created a Java SE application which deals with data stored locally on a MySQL server.
It works fine where there are ...
0
votes
0answers
12 views
SSMS status bar color bug
I tried to change the color of my status bar in ssms 2012 depending on the connection to registered servers. I registered the servers, checked "Use custom color:" in the connection properties and ...
2
votes
3answers
930 views
PostgreSQL: Warning: Console code page (437) differs from Windows code page (1252)
Using PostgreSQL when I connect to a db using \c testdb inside PostgreSQL Database SQL Prompt. I successfully connect to the db but getting the following warning:
postgres-# \c testdb
WARNING: ...
0
votes
1answer
17 views
Use MAMP to open website on another pc - only see db content
I’m trying to make access to my MAMP localhost from my mobile phone and other Windows PC. I’m currently using a Mac.
While I can see the database content but the website doesn’t render as usual (no ...
0
votes
2answers
22 views
Keyword not supported: 'data source' web.config
I cant seem to see where the problem is in my connection string, where you have the " in the string I've even tried adding single quotes as advised on stackoverflow but it still doesn't seem to ...
0
votes
2answers
15 views
difference between creating data base in microsoft access using netbeans and creating database in mysql
what is the difference between creating data base in microsoft access using netbeans and creating database in mysql. is it the same ? Please help me.. i dun understand.
-1
votes
4answers
24 views
Connection to database in NetBeans unsuccessful (error ora-00933)
For school project I'm doing Music player using a simple database (for name, artist, length, album...) and I've done it 1/2 already but now when I'm trying to connect to school database it gives me an ...
Related Tags
mysql × 653
database × 474
c# × 470
java × 418
php × 417
sql-server × 295
sql × 210
connection-string × 192
asp.net × 182
jdbc × 164
oracle × 142
.net × 124
sql-server-2008 × 119
connection-pooling × 119
android × 102
vb.net × 84
ms-access × 74
sqlite × 72
postgresql × 68
python × 67
connection × 65
visual-studio-2010 × 62
ruby-on-rails × 61
odbc × 61
sql-server-2005 × 51
more related tags
Hot Network Questions
- What is the significance of the slope of the tangent line of a function? Why is the derivative soo important?
- "When I was in college..." Do you really mean college? Or university?
- Is 'Bring your own Identity' as the only authentication option a valid practice?
- Dual-boot or virtual machine for Linux programmer that does some Visual Studio development?
- Why don't people just use rsync to back up vmware guests?
- What is the core in the elder wand?
- How can I output the Field Name in my template
- Jumping between points in time in narrative
- How do I submit a NOTAM?
- Why is it that the maiden name is traditionally dropped when a woman is getting married?
- How do you make an Android loading icon in Illustrator?
- Circumnavigating a curve or going through it to show different behavior
- Jet aviation on 'rough' airfields
- When uploading assets what determines the maximum file size?
- Why Vim can't open a 100Mb text file when I have 16G RAM
- Fitting points to tilted, off-center ellipse
- Search results for my website show content that isn't mine including pharmacy (Viagra and Cialis)
- What colour is this?
- Goring Charge Monk Optimization
- Are concepts necessarily false even if useful?
- Should I assign a unique ID to individual units of game currency?
- Why is the finalize method included in Java?
- What would have happened if Saruman had gotten the One Ring?
- Why didn't humans try to settle other galaxies?
