Stack Overflow
Stack Overflow

Questions tagged [multi-database]

120 questions
0
votes
1 answer

Configuring MyBatis with Spring MVC for multiple datasources

I have been trying to configure MyBatis with Spring MVC to work with multiple databases. I have a page which is trying to connect to one of the DB's to fetch data, so that it can be populated into the drop-down boxes. Now I am not sure what is…
Shiva1281969
  • 37
  • 1
  • 7
0
votes
2 answers

How to get Crystal Report all queries

There were 24 database in my project. One database has been seperated to 3 another databases. And now, I have to change all queries of Crystal Report. How can I batch update all queries via C#? Is it possible? or How can I find out the questions…
sinot
  • 1
  • 2
0
votes
2 answers

Unable to run Spring boot test runner with JPA without HSQL

We are trying to write test case for an application which works with both MyBatis and JPA in Spring boot using AbstractRoutingDataSource, Mockito; we are able to mock the mybatis code. When we integrate the JPA the @SpringBootTest trying to access…
N. Pradeep
  • 193
  • 2
  • 7
0
votes
2 answers

Retrieve data from same table in all server databases

I have SQL Server 2012 with DB1 , DB2 , Db3 ...> DB50 If I need to view databases in server I use SELECT * FROM sys.databases All databases have same table Saves except for five databases that do not have this table. I need to know which…
محمد عبدالغفار الفقى
  • 11
  • 5
0
votes
2 answers

SaaS ways to access multiple databases and user authentication mechanisms with master database

I'm in the process of building a saas application with a master database for all transactions and the user base and seperate databases for each tenant. Each tenant is given an unique sub domain and based on that, the correct database is pointed to…
Pavan Welihinda
  • 605
  • 3
  • 11
  • 26
0
votes
0 answers

Laravel multi-tentant application approach

I'm trying to build a multi-tenant application with Laravel 5. I'm aware of already existing packages like Hyn and AuraEQ, but I still find these hard to understand and I want to make my own (simplified) version. This way I exactly know what is…
JasonK
  • 5,214
  • 9
  • 33
  • 61
0
votes
1 answer

Difficulty modeling Star schema

First of all, I'm sorry about the title... As soon as someone answer it and I understand what was my actual problem, I'll put a better one. I am creating a fact table which will measure the amount of reasources related to schools: Amount of…
Leonardo Sibela
  • 1,613
  • 1
  • 18
  • 39
0
votes
1 answer

I am facing "Your login attempt was not successful" Please try again. error while implementing custom membership

My requirement of application is single application & multiple databases for each client. So I implemented custom membership to achieve this. First I check user belongs to which Client the according to connection string of that client's db I…
Tukaram
  • 66
  • 6
0
votes
4 answers

Multi-database connection string: where store it in my application

I have different database with same schema. I need to connect to one of them according to the client that has been connected. For example if ClientA is connected i must connect to DatabaseA; If ClientB is connected i must connect to DatabaseB; Now…
Simone
  • 2,304
  • 6
  • 30
  • 79
0
votes
1 answer

Does 'objects.using(...)' mean I don't need a data router?

I've been trying to figure out how to automatically handle migration and queries from dynamically created databases (MySql). I have a dynamic router to which I can prefix the route to a database by name to perform a query. But then I found…
IAbstract
  • 19,551
  • 15
  • 98
  • 146
0
votes
1 answer

How can I use NLog to log to a specific database in an API?

In our organization, each customer has their own database, with a respective logging table. How can I configure NLog programmatically so that I can point it at the correct database per customer? Something like: var loggerA =…
Paul Coghill
  • 667
  • 6
  • 27
0
votes
2 answers

SQLAlchemy - Multiple Database Issues

We are making a game server using SQLAlchemy. because game servers must be very fast, we have decided to separate databases depending on user ID(integer). so for example I did it successfully like the following. from threading import Thread from…
Anderson
  • 3,139
  • 3
  • 33
  • 45
0
votes
2 answers

Cannot build Relationship between two tables from different databases

I have the following use case: [User.groovy]: is mapped to user table in auth mysql Database . [Project.groovy] : is mapped to project table in pm mysql database When i add this relationship between the 2 classes class Project { User…
Abdennour TOUMI
  • 87,526
  • 38
  • 249
  • 254
0
votes
1 answer

Use 2(or more) Database in one asp application and switch connection string

i have one ASP application and i want to use that for 2(or more) place and each of them has their Database , now is there a way to change connection string when user log in? or anyway to change database for each user? i saw this question before…
mosyflasher
  • 489
  • 1
  • 6
  • 16
0
votes
1 answer

Django, Tests and multidatabases

I have started to write tests to my django project. However I have question how to solve one problem. As my project has many databases and in my functions I have lines like dbs = DataBaseSettings.objects.using("companies_db").all() thanks to that I…
Arturo
  • 71
  • 6
1 2 3 4 5 6
7
8