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…
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…
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' =>…
1
2 3 4 5 6 7 8