Questions tagged [multiple-databases]
631 questions
8
votes
2 answers
Django TestCase not using transactions on secondary database
I am using Django 1.3.1. I have two databases, some of my models live in one database, some in the other. Both databases are contrib.gis.db.backends.postgis databases.
To my surprise, Django's TestCase isn't rolling back changes I made in the…

RemcoGerlich
- 30,470
- 6
- 61
- 79
7
votes
2 answers
Dynamically connecting a model to databases in a running app?
I've read many of the existing questions/threads on this subject, but keep in mind that none of them have directly addressed my issue. Also keep in mind that this is NOT a situation for database.yml as I won't know the DB info in advance.
That…

humble_coder
- 2,777
- 7
- 34
- 46
7
votes
2 answers
MS Access databases on slow network: Is it faster to separate back ends?
I have an Access database containing information about people (employee profiles and related information). The front end has a single console-like interface that modifies one type of data at a time (such as academic degrees from one form, contact…

Code Jockey
- 6,611
- 6
- 33
- 45
7
votes
2 answers
CodeIgniter Multiple Databases Persistent Connection?
I'm using multiple database in my CodeIgniter application and have been reading a lot that persistent connections should be turned off.
Why is this measure recommended and is this still necessary in the newest version, 2.0.2?
I'm doing things like…

user599146
- 344
- 5
- 17
7
votes
0 answers
'Couldn't find PersistentEntity for type class' exception in Spring boot MongoRepository
In here I have configured two databases in mongodb. As described in this tutorial (link). So basically I override the MongoDataAutoConfiguration and MongoProperties implementations.
The property yml file :
spring:
autoconfigure:
exclude:…

GeekySelene
- 847
- 3
- 13
- 31
7
votes
2 answers
Connect multiple databases dynamically in laravel
I'm building an application which requires connecting 2 database. first one is static and another one is dynamic.
config/database.php is like
'mysql' =>
array (
'driver' => 'mysql',
'host' => '127.0.0.1',
'port' => '3306',
'database' =>…

Kanth
- 73
- 1
- 1
- 8
7
votes
5 answers
django unit testing on multiple databases
I'm working on a django project where all my unit test cases were working perfectly.
Ass soon as I introduced a second database all my test cases that inherit from TestCase are broken. At this stage I haven't build any test case for that second…

user298404
- 203
- 2
- 9
7
votes
2 answers
nHibernate, ASP.NET MVC, s#arp architecture and multiple identical databases
We are currently developing an application based on NHibernate and ASP.NET MVC and a SQL Server backend. Since I'm fairly new to NHibernate, I'm tryig to understand best practices.
Our application requires every user to have it's own SQL Server…

Rik
- 483
- 3
- 12
7
votes
3 answers
Why is django_migrations table in all databases
I'm building a website under Django Framework, this website needs to have different SQL schemes, for now I succeeded creating all schemes and all stuff, but I don't understand why the table django_migrations is in each schema after migration of…

Nadir Albajari
- 93
- 2
- 6
7
votes
1 answer
How to identify a particular entity's Session Factory with Fluent NHibernate and Multiple Databases
Question follows on from Fluent NHibernate + multiple databases (no need to follow this link,there should be enough background here).
My problem is this:
I'm using Fluent NHibernate. My application uses multiple databases. Each database has its own…

Trevor
- 559
- 5
- 12
7
votes
1 answer
Grails - Multiple Datasources
First, let me start that I have looked so many sites about the "correct" way to configure multiple datasource on Grails, every one of them (with Grails 2.0 and later) pointing to the docs , however after doing what the docs says I get this error:…

Alex Vargas
- 406
- 4
- 15
7
votes
2 answers
Connecting to two databases Mongoid
I have two databases that I have to use in my application. I have the following in my mongoid.yml:
development:
# Configure available database sessions. (required)
sessions:
# Defines the default session. (required)
default:
#…

senthil
- 1,307
- 1
- 11
- 23
7
votes
2 answers
Join query of two databases in codeigniter
I need to write a join query of two tables from two databases and fetch the joined data.
For eg, consider I have a database db1 which has some tables named companies, plans, customers. Suppose I need to join the two tables companies and plans with…

Anu
- 131
- 1
- 1
- 7
6
votes
1 answer
liquibase using maven with two databases does not work
This post describes how to update two databases from maven using liquibase:
liquibase using maven with two databases
However, when I try the exact same configuration in my pom.xml (included below) it does not work. I get this error when running 'mvn…

Thiagarajan Hariharan
- 426
- 1
- 4
- 15
6
votes
2 answers
Rails fixtures with multiple databases
I'm trying to add test fixtures to a rails (v 3.1.3) app that uses multiple databases.
The fixture should be applied only to the applications own test sqlite database:
test:
adapter: sqlite3
database: db/test.sqlite3
pool: 5
timeout:…

Abraxas
- 73
- 6