Top "Database-connection" questions

A database connection is a facility that allows client software to communicate with database server software, whether on the same machine or not.

Difference between ResultSet TYPE_SCROLL_SENSITIVE and TYPE_SCROLL_INSENSITIVE

I am trying to understand the difference between these two methods of creating a statement: 1: Statement statement = connection.createStatement(ResultSet.…

java jdbc database-connection resultset
MySQL connection validity test in datasource : SELECT 1 or something better?

I'm setting up a failover cluster on MySQL, in a master/slave architecture. I'm also configuring my JBoss Datasource, and …

mysql jdbc orm database-connection datasource
Message: Configured database connection is persistent. Aborting

Codeigniter 2 to 3 version after upgrading, I get this error.. Why would that be? An uncaught Exception was encountered Type: Exception …

php codeigniter database-connection codeigniter-3
Design Patterns: How to create database object/connection only when needed?

I've a simple application, say it has some classes and an "extra" one that handles database requests. Currently i'm creating …

php oop design-patterns database-connection
postgresql "keepalives" parameter

According to https://www.postgresql.org/docs/current/static/libpq-connect.html there is parameter keepalives and further parameters keepalives_idle, …

postgresql connection database-connection libpq
Asterisk unable to connect to database using odbc connector

I am pretty new to Asterisk and this is my first attempt to connect to database (MySQL). But I keep …

mysql odbc database-connection asterisk unixodbc
Limit number of results in Meteor on the server side?

I have some code as shown below. There are about 60K entries in my keywords collection in Mongo. I really …

performance meteor database-connection subscriptions
How do I close the cursor created in a database link(ORA-02080)?

I perform the following sequence of steps(step-wise using F-9) in Oracle SQL Developer: create database link mydb connect to …

sql oracle database-connection database-link database-cursor
Concurrent use of same JDBC connection by multiple threads

I'm trying to better understand what will happen if multiple threads try to execute different sql queries, using the same …

java jdbc database-connection connection-pooling apache-commons-dbcp
Windows authentication trusted connection not working

MSSQL Server is in the "abc" domain and have mixed mode authentication. I am connecting from the machine which is …

sql-server database-connection windows-authentication sqlconnection trustedconnection