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…
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:…
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…
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…
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…
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
1 2
3
41 42