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