Questions tagged [multi-database]
120 questions
30
votes
6 answers
Multiple database with Spring+Hibernate+JPA
I'm trying to configure Spring+Hibernate+JPA for work with two databases (MySQL and MSSQL).
My datasource-context.xml:

ziftech
- 747
- 1
- 10
- 22
5
votes
1 answer
CodeIgniter MultiDatabse connect error
I see a lot of method/tutorial to connect multi database in CodeIgniter? Still far far away with me. Some one provide me to connect multi database in CI. This is my using way i was found it in a blog. pardon me, i don't recognize the blog address.
…

pico
- 247
- 3
- 9
- 20
4
votes
3 answers
Spring or Hibernate multi-tenancy for multi-database Grails app
Grails has a multi-tenancy plugin for a single database and a multi-tenancy plugin for multi-databases, but the one for multi-databases is no longer supported/maintained. Is there some way I can instead use Spring or Hibernate themselves for a…

Daniel
- 1,774
- 2
- 22
- 38
4
votes
3 answers
Django fails to create superuser in other db than 'default'
Is it a bug or am I wrong ?
I am at the step to create a superuser, but django want a table in wrong db despite my router seems to work :
settings.py
DATABASES = {
'intern_db': {
'ENGINE': 'mysql.connector.django',
'NAME':…

hl037_
- 3,520
- 1
- 27
- 58
3
votes
2 answers
Include the role of Active Record queries in logs
Rails now includes support for multiple database roles (by default, writing for the primary and reading for the replica):
ActiveRecord::Base.connected_to(role: :reading) do
# all code in this block will be connected to the reading role
end
In…

Patrick Brinich-Langlois
- 1,381
- 1
- 15
- 29
3
votes
1 answer
change database connection just for 1 user
I need to use another db connection just for 1 user.
First of all I created another connection in the config/database.php file:
'mysqltest' => [
'driver' => 'mysql',
//...
],
It works. I tried it with something like this…

Giacomo M
- 4,450
- 7
- 28
- 57
3
votes
0 answers
error during Django 1.8 test with multiple databases
I'm moving a Django 1.8 project from a single database setup to a writer/reader setup. I ran into the issue described in Django bug 23718 but the work arounds described didn't seem to help.
Has anyone run into similar issues? Relevant code segments…

Jon
- 79
- 5
3
votes
4 answers
How to create an application supporting multiple databases
I have a situation where I need to create an application which supports multiple databases. Multiple databases means the client can use any of the database like Oracle, SQL Server, MySQL, PostgreSQL at first.
I was trying to use ORM like NHibernate…

शेखर
- 17,412
- 13
- 61
- 117
3
votes
3 answers
save() got an unexpected keyword argument 'using'
I'm using a multi database system for my django project.
But when I'm trying to save my form, I get this error : save() got an unexpected keyword argument 'using'
Here is my simple code :
My View :
def addCompany2(request):
"""Add a company"""
…

yann
- 87
- 2
- 10
2
votes
0 answers
Heroku Rails 6 multiple connection not working
I have a project running on Rails 6 with multiple database configuration.
This is my database.yml configuration
default: &default
adapter: postgresql
encoding: unicode
# # For details on connection pooling, see Rails configuration guide
# #…

Lomefin
- 1,173
- 12
- 43
2
votes
1 answer
How Do I Migrate Tenant Databases and Host Database in Asp.NET ZERO / Boilerplate?
I am using the ASP.NET ZERO framework with ASP.NET Core and Angular for my current project.
I am also using the 'MultiTenancy - MultiDatabase' feature of ASP.Net ZERO.
In application I have added a 'Tenant1-Database' connection string in create new…

Hardik Leuwa
- 3,282
- 3
- 14
- 28
2
votes
1 answer
Differences between @MapperScan and @Bean MapperScannerConfigurer
I have a multi-datasource web application with following technique:
Spring boot 1.5.12
Mybats-Spring-boot-starter 1.3.2
And I prefered Java based configuration. Therefore, I have Datasource1Config.java and Datasource2Config.java.
I defined…

Rifu
- 21
- 2
2
votes
1 answer
Laravel How to create database on real time and like same as old database and how to access that databse
I need multi database concept for my project. I create user on real time automatically create new database for that new user .that new user login switched to master database to user database.. how to do this .. I am trying larval 5.4 version .
1.How…

john henry
- 25
- 1
- 5
2
votes
1 answer
SQLite view across multiple databases. Is this okay? Is there a better way?
Using SQlite I have a large database split into years:
DB_2006_thru_2007.sq3
DB_2008_thru_2009.sq3
DB_current.sq3
They all have a single table call hist_tbl with two columns (key, data).
The requirements are:
1. to be able to access all the…

Pete
- 409
- 4
- 8
2
votes
2 answers
zf2 + Doctrine a different database for each member
Each connected member of my site has its database.
Here is the doctrine config for "user_1":
return array(
'doctrine' => array(
'connection' => array(
'orm_default' => array(
'driverClass' =>…

user2670354
- 43
- 6