Stack Overflow
Stack Overflow

Questions tagged [multiple-databases]

631 questions
0
votes
2 answers

YII2 creating relations in models between tables from 2 databases

I have defined 2 databases , for example return [ 'components' => [ 'db1' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=localhost;dbname=db1name', 'username' => 'db1username', 'password' =>…
nshah143
  • 549
  • 4
  • 22
0
votes
0 answers

Grails multiple databases for a single deployed application

We have a current application written in grails 3, which we want to deploy for multiple different clients. The application and the database schema is the same for every client, only the data changes. We don't want to have a single database because…
user666
  • 834
  • 2
  • 10
  • 20
0
votes
0 answers

Connect 1 form to 2 Mysql Databases with PDO

its my first time here i have a question im making a register form but i need to insert to 2 databases here is my code. when i run its only register in one database sometimes db1 other times db2 -Sorry for my bad english -Here's…
FenixTM
  • 9
  • 2
0
votes
0 answers

How to set two data sources in java LocalContainerEntityManagerFactoryBean?

In xml format, you can define some code as below to set two data sources without problems:
mikezang
  • 2,291
  • 7
  • 32
  • 56
0
votes
1 answer

Multiple Data Sources in Microsoft Excel SQL Query

I have a lot of spreadsheets that pull transactional information from our ERP software into Excel using the Microsoft Query that we then perform other calculations on automatically. Recently we upgraded our ERP system, but management made the…
Error
  • 25
  • 1
  • 6
0
votes
1 answer

Spring.NET + NHibernate - Multiple (Distinct) Databases with OpenSessionInView

In my web application, I have 2 totally different databases - one that's being used mostly by a CMS from which we'd like to get page information on non CMS pages on the same website, & one that contains totally different data. Is it possible to use…
Simon Rice
  • 1,119
  • 1
  • 13
  • 22
0
votes
0 answers

Spring batch-query two databases with one's result as parameter for other

Spring batch: I want to query two databases, with the result of query from 1st database as parameter in IN clause of second database query. I tried with CustomItemReader, but failed. Any one can help!!!
Harpreet
  • 1
  • 3
0
votes
1 answer

Django Haystack with multiple databases

Django recently added support for using multiple databases and "database routing". Does Haystack deal intelligently (or at all) with multiple databases?
Danny Roberts
  • 3,442
  • 23
  • 28
0
votes
1 answer

AmCharts Multipledatasets

I am stuck with http://www.amcharts.com/demos/multiple-data-sets/#theme-none, the creators of the graphic just put a random numbers to fill it, but I would like to load a CSV file which they have a plugin…
Eduardo Bernabe Sacahui Diaz
  • 3
  • 1
  • 5
0
votes
1 answer

SQL Run query across multiple Databases

I am looking to run a query over multiple databases. I've seen this function; sp_MsForEachDb Which is ok, but it runs through all the databases and I only want to use some of them. Is there a way to select which databases are run? Also within…
Becky
  • 115
  • 2
  • 18
0
votes
1 answer

Working on django projects, where I have multiple projects and multiple databases, I want to access all databases in everyapp

I have 3 projects (A, B, C) and 3 databases (DB1, DB2, DB3). I have defined Model common in project A and want to access same model in Project B. I want to access every database with each application. I don't know how to configure settings files so…
Harshil jain
  • 318
  • 1
  • 9
0
votes
1 answer

Django print query

I'm trying to print the query generated by my queryset by I'm getting this error: print owa_reqs.query *** OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)") The strange thing is that root@localhost are my…
Pablo K
  • 125
  • 1
  • 10
0
votes
1 answer

Switch Databases based on runtime based on some value selected

I have home page where i have overlay with list of cities as an hyperlink. I have different databases for each city. So when user clicks a city on runtime the database should be selected. Again if users change the city the database should be…
chandramohan
  • 31
  • 6
0
votes
1 answer

Switching between several databases in rails 4 application

I am currently creating a rails app where I have to switch between several databases. These databases have the same tables but each one represents a different hotel(i.e: hotel1 has database1, hotel2 has database2 and so on) .This happens because…
Esparratacus
  • 13
  • 3
0
votes
1 answer

Application with multiple databases

I want to separate my model in two databases because there is a part that's used by another databases as well. I'm wondering how to deal with: Joins among tables of both databases. If any other problems can show up. Are there any other solutions…
Serginho
  • 7,291
  • 2
  • 27
  • 52
1 2 3
…
41 42