Stack Overflow
Stack Overflow

Questions tagged [dbconnection]

230 questions
3
votes
1 answer

Whats is DB Connections(Count) in AWS?

What is meaning of DB Connections(Count) report on AWS RDS? I have gone through their documentation but didn't find my answer there. I am quite confused with DB Connection report on my AWS. I can see their only 1 connection available but I am sure…
Bhushankumar Lilapara
  • 780
  • 1
  • 13
  • 26
3
votes
1 answer

Connecting to DB2 via .NET DbConnection

Our current DB Connection provider model relies on database connectivity to use DbConnection (System.Data) based objects. We can connect to DB2 (*Nix * Windows) via OdbcConnection, but we would like to allow the use of native DB2 Drivers. Is there…
johnc
  • 39,385
  • 37
  • 101
  • 139
3
votes
1 answer

Couchbase Connection - External ip instead of internal

In the same data center I have an application server (the client) connecting to a couchbase cluster containing 3 nodes. I would like the client to connect via the internal IP and not the external for optimized performance. Let's assume these are my…
forhas
  • 11,551
  • 21
  • 77
  • 111
3
votes
3 answers

C# + Disposing DbConnection and DbCommand and catching error

I am trying to understand DbConnection and DbCommand, and the proper way to dispose those objects after use. Following is the code snippet I have. By using "using statement" on DbConnection and DbCommand, would it be sufficient? I am trying to…
Eatdoku
  • 6,569
  • 13
  • 63
  • 98
3
votes
1 answer

Lost connection to MySQL server at 'reading initial communication packet' for remote mysql server

I am trying to access remote mysql database using rake task. Here i am posting my active record connection logic client = ActiveRecord::Base.establish_connection( :host => "server_ip", :port => 22, :adapter => "mysql2", :pool => 5, :database =>…
Jeet
  • 1,350
  • 1
  • 15
  • 32
3
votes
1 answer

Error in creating active RAR + ResourceAdapterImpl class not found in JAVA

I have created a EJB package with Glassfish V 4.0 and postgre sql as server and DB respectively. Glassfish and postgre are installed remotely. I have created a connection pool and JNDI Let me know if any more details is required When i run my class…
Neil
  • 1,715
  • 6
  • 30
  • 45
3
votes
1 answer

Query on multiple tables using dbGetQuery of RMySQL package

With the help of dbConnect, multiple connections were established with SQL DBs (say, DB1 and DB2). How can I write a query that involves tables from DB1 and DB2? Does dbGetQuery allow querying one only one DB? Can sqldf package be leveraged after…
Anindita
  • 31
  • 3
3
votes
2 answers

SQLite connection:application stops working

I am making a diary application in android which is supposed to get some data from text fields. When I run my app on the emulator, it gets successfully installed but as soon as I give input in the fields and I tap save option in the menu, emulator…
titan
  • 664
  • 6
  • 18
3
votes
0 answers

After session.close() connection is still active with Database

I am working with swing and hibernate. Now for retrive connection, I am using sessionFactory.openSession(). Once I done with DB activity, I am closing same session by session.close(). Now the problem is, when I go on use my application, after some…
Navnath
  • 1,064
  • 4
  • 18
  • 34
3
votes
2 answers

PDO prepared statement stops redirecting if db connection is in config file

PDO prepared statements stop redirecting when the database connection is in a separate file (config.php). The query works correctly (i.e. inserts properly, etc.), and the redirect works just fine when the database connection is in the document…
Chaya Cooper
  • 2,566
  • 2
  • 38
  • 67
3
votes
0 answers

Monitoring the Entity Framework DB connection (Code first 4.3)

I am wondering what the best approach is to managing/ monitoring a connection to a server database using the Entity Framework. I know that the EF DB context or Object context does the main bits for you. However, in our scenario a user may unplug a…
timmit
  • 181
  • 1
  • 6
2
votes
1 answer

How to use different connections according to query type in Yii

All my reads should go to one DB connection All my writes should go to another connection How do I accomplish this in Yii, with minimal changing the code of the core library? And on occasions (as stated in the comments) I will need the ability to…
Itay Moav -Malimovka
  • 52,579
  • 61
  • 190
  • 278
2
votes
1 answer

Accessing google cloud secret manager data in node js for DB connection

We have a nodejs application in which our basic requirement is to not use hard coded DB password from config.json file instead read it from Google Cloud Secret Manager and i am able to fetch that secret value from there. But when i try to use it in…
Ravindra
  • 1,039
  • 2
  • 12
  • 26
2
votes
1 answer

How to connect to Snowflake database through R if MFA (multi factor authentication) is required through Duo app?

I am working on a project which requires me to connect through R to a Snowflake database to pull data from it. However, since we use multifactor authentication to access the DB. I couldnt establish a connection and end up getting timed out. I use…
kgr
  • 23
  • 4
2
votes
1 answer

Differences between DbConnectionStringBuilder and OdbcConnectionStringBuilder Connection Strings

I am trying to make my application database agnostic and in doing so I have elected to use the DBConnection Class instead of the SqlConnection, OracleConnection, etc that currently litter my application. So I am having an issue with the…
Mark Kram
  • 5,672
  • 7
  • 51
  • 70
1 2
3
…
15 16