633 questions
1
vote
2
answers
3k
views
Spring Data JPA map the stored procedure result to Non-Entity POJO from multiple data source
I have tried to research on a better way of calling two stored procedures on two different data sources with no luck. Here is my scenario, I have connection to two data sources, each data source with ...
- 510
0
votes
0
answers
442
views
Getting no transaction in progress with multiple datasources with Spring Boot
Running Spring Boot version 2.3.0 with two datasources configured. Am getting the below exception when trying to save an entity to the DB. This same code was working with single datasource. We have ...
- 1
3
votes
0
answers
133
views
PostgreSQL JOIN query much slower via Django than on simple Python interpretor
here is a topic I have been struggling on for a small while now.
For now, I decided to just limit the requests sizes, but I'd like to know why this happened.
If you can take some time solving this ...
1
vote
0
answers
30
views
Spring JPA - create N repositories for N databases [duplicate]
A have a User @Entity. I have all the necessary credentials for N databases in application.properties,
say, in the following format:
#First Database Connection
db0.driver=org.postgresql.Driver
db0.url=...
0
votes
1
answer
480
views
How to get mapped entities from different databases?
I have two different (entity1 and entity2) mapped (@OneToOne or @OneToMany) entities from two different database schemas (db1 and db2).
If I try traditional ways, I got errors that are about "db1....
- 531
1
vote
1
answer
338
views
How can I call a custom Django manage.py command directly from code with specific database connection
I followed this solution to run customer Django command programmatically, but it is limited for just one database connection.
I have Django app configured with multiple database , is it possible to ...
0
votes
1
answer
175
views
Should i use another database for my web application?
I'm developing a web application using Node.js for backend(express) and React.js for frontend. I'm using PostgreSQL as database for almost every data storage. But now, i will add a real time chatting ...
- 31
0
votes
1
answer
1k
views
Django Accessing external Database to get data into project database
i'm looking for a "best-practice" guide/solution to the following situation.
I have a Django project with a MySql DB which i created and manage. I have to import data, every 5 minutes, from ...
- 107
0
votes
1
answer
331
views
Django rest api: user authentication with multyple databses
I need to developed Django rest API with access to multiple databases and also need to authenticate from multiple databases
ex -
user1 - authenticate from database1 user table
user2 - authenticate ...
2
votes
0
answers
303
views
Spring Data: fetching full entity from multiple data source with spring jpa
I have 2 entities from 2 different data sources.
Purchase - data source A
Merchant - data source B
And they have one to one relationship.
I defined the Purchase entity as below.
I want when fetching ...
- 2,776
1
vote
1
answer
1k
views
How I can connect and fetch the data from multiple mysql databases on multiple severs?
I want to fetch data from multiple mysql databases which are on multiple servers.
I'm using phpmyadmin (mysql). All the databases will be mysql database (same vendor) which are on multiple servers. ...
- 11
2
votes
1
answer
934
views
Django multiple databases — read from "readonly" connection; Commit transaction and have all following queries use "default" connection
I have 2 databases:
# Config
DATABASES = {
'default': {},
'readonly': {},
}
In a background task, I would like to pull data from the "readonly" database, then save using the "...
- 765
0
votes
1
answer
24
views
How can I save query data from another mongoDB to the collection of DB I am currently connected to?
I've got two databases and I want to write data from another DB in the collection.
I am connected to a mongoDB with
mongoose.connect("mongodb://XXX:YYY@localhost:27017/realtime?authSource=admin&...
- 1
1
vote
1
answer
2k
views
Running manage.py makemigrations for multiple databases in django
I'm trying to use multiple databases in my Django project i.e. MongoDB and MySQL.
# settings.py
DATABASES = {
'default': {
'NAME': 'sql_db',
'ENGINE': 'django.db.backends.mysql',
...
- 269
1
vote
0
answers
224
views
Django: Specifying Dynamic Database at Runtime
I'm attempting to trial setting up a system in Django whereby I specify the database connection to use at runtime. I feel I may need to go as low level as possible, but want to try and work within the ...
- 4,260
0
votes
1
answer
2k
views
Using Multiple DataSource in Spring Batch Tasklet
I am new to spring batch, and I'm encountering an issue when using multiple data source in my batch.
Let me explain.
I am using 2 databases in my server with Spring Boot.
So far everything worked fine ...
0
votes
1
answer
5k
views
Data Migration from One Db to another using Spring batch and Spring boot
Im new to spring framework and I Want to migrate data from One DB to another using Spring boot n Batch
Im trying to read from an Mysql db with an item reader and write it to an Oracle db using an item ...
- 11
0
votes
1
answer
1k
views
How to implement spring data mongo multidatabase transactions
I created an application that copies data from one database to another one based on this tutorial.
In fact, I need to make a method that inserts in two different databases transactional.
Is this ...
- 526
3
votes
0
answers
317
views
Multiple databases in RoR: Issue with migration applied to the wrong database
I want to add a secondary database to my RoR project, so I followed this: https://guides.rubyonrails.org/active_record_multiple_databases.html
So now I have two databases: jobtitleio & profiles
...
- 31
2
votes
1
answer
828
views
Adding multiple database in Django project
I tried maybe 100 samples but multiple database never worked in my projects. Please help me. I have tired more codes from various sites, but there is last codes in my project which I got from official ...
- 83
1
vote
1
answer
987
views
Mysql connector - How to use connection pool with multiple databases?
I have more than 30 databases and I want to use connection pool in my python code.
conn = mysql.connector.connect(
host=MYSQL_HOST,
user=MYSQL_USERNAME,
passwd=MYSQL_PASSWORD,
...
- 104
2
votes
1
answer
2k
views
Spring Boot JPA AttributeConverter with multiple Datasources
I have encrypted spring JPA Entity data using custom Attribute converter. I was working nice with single(default) postgres datasource in spring boot. Now when I implemented multiple datasources ...
- 21
0
votes
1
answer
153
views
Multiple Spring Datasource : Consider defining bean of type ExternalJarRepository
@SpringBootApplication
@EnableJpaRepositories(basePackages=..,entityManagerRef=..)
@ComponentScan("com.main", "com.external.jar")
public class Application{
...
//methods defining primary datasource, ...
- 647
0
votes
0
answers
54
views
Indexing data from multiple data sources (CSV, RDBMS)
we are working on indexing data from multiple data sources using a single collection, for that specified data sources information in the data-config file and also updated managed-schema.xml by adding ...
1
vote
1
answer
470
views
Rails 6 Migration giving strange error after using multiple databases
I'm using Two databases in my project using default rails 6 support.
database.yml:-
default: &default
adapter: postgresql
migrations_paths: "db/migrate/primary"
encoding: unicode
...
- 1,007
0
votes
2
answers
8k
views
Join Two Databases in Oracle SQL
I need your help. I have two databases (ex. PEN and PAPER) the tables of which need to be joined. Table name in db PEN is PEN.ORDER. Table name in db PAPER is PAPER.ORDER.
Being on PAPER db I am ...
0
votes
1
answer
526
views
Laravel 6 - 2nd Database configured in database.php but still received Database connection [] not configured
I want to create a second database to act as a backup. I've been following another SO question solution and other websites which leads to the same thing. I've added a new DB connection in .env and ...
- 397
0
votes
0
answers
179
views
Multiple databases using routers
I created an application with three apps account,Product and Post, i want to connect each app to different database but it is just not happening.Please tell me what i am doing wrong.This is the first ...
2
votes
0
answers
121
views
Semi-synchronous master master replication
I am building a "Semi-synchronous master master replication". There are two databases in two different servers. People on both sides can read/write from/into these two databases.
Servers (A & B), ...
- 21
2
votes
0
answers
101
views
import data from source db to target db using flask sqlalchemy
I want to fetch data from one source database and insert it into my targeted database using flask SQL alchemy
Database_connection
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:root@...
0
votes
0
answers
85
views
Multiple database implementation in django
I have two databases, which I need to use in the same app of django asynchronously.
I have referred following document :
https://docs.djangoproject.com/en/3.0/topics/db/multi-db/
which basically ...
1
vote
0
answers
23
views
CustomUser on separate database issues
I want to use the users from a legacy database but keep everything else on the 'default' database.
The main issue I have atm is that I can't get the database router to properly forward queries to the ...
- 20.6k
2
votes
1
answer
1k
views
common configuration for multiple databases with spring boot
My Project has multiple databases having one master database and 35 other databases (having same schema and same configuration)
Now currently we are using c3p0 connection pool and using jdbc for ...
- 2,276
0
votes
2
answers
5k
views
How to use multiple databases with spring?
i need to create web-app (with spring+mysql) which should be a little like "MySQL Workbench online".
In my application, Users will be able to create their own databases. I did it as follows:
User ...
- 59
0
votes
1
answer
546
views
Multiple databases with same login (.net core 3 API)
As I am working on a new platform (.net core 3 API) where every company has a separate database. I'm finding myself with an issue I can't find a solution to on the internet.
Companies have different ...
- 562
4
votes
3
answers
15k
views
NestJS - Use multiple MongoDB connections per module
Is there a way to connect multiple MongoDB connections per module?
app.module.ts
@Module({
imports: [
MongooseModule.forRoot('mongodb://localhost/masterDB'),
UserModule,
],
controllers:...
- 188
1
vote
1
answer
3k
views
Multi-tenancy and custom features per tenant
I am building a web app (using Laravel but it's irrelevant), that will have multiple tenants with each tenant having its own database. The backend and frontend code end will be common.
We all know ...
- 1,851
0
votes
1
answer
4k
views
Spring Boot switch between multiple databases (data-sources)
I have a spring boot REST API application for a project with 2 different setups ( =2 different jars). Both need to be realized, but I have no idea on how to do it or what the best way would be.
Both ...
- 1,210
0
votes
1
answer
56
views
Ability to connect to SQL server and SQL server compact without modifying the code
I have built a vb.net application to work on one computer, so I used SQL server compact database.
Now I want the application to work over network with SQL server database without making anther copy ...
1
vote
0
answers
267
views
Cannot use sessions when working with multiple databases
It seems impossible to use sessions in my configuration of multiple databases. For example, I always need to type username and password when I enter the admin site. How do I make sessions work?
I ...
- 165
1
vote
1
answer
614
views
IntegrityError in Django testcase
I am suspecting that transaction.atomic() does not commit my instance to the database during testing. The problem might comes from multiple databases
from django.db import models
from model_utils....
- 9,653
3
votes
0
answers
195
views
Rails 6 Multiple Databases for 'Sandbox' mode
We are developing a Rails app that will include an API for our customers. Let's say that with this API, they can create Puppies. Many services that provide an API, include a 'sandbox' mode, in which ...
- 554
0
votes
1
answer
494
views
Django multiple database foreign keys
I am trying to implement multiple database support for my django (version 1.11) app. For that purpose I have included in my settings.py:
DATABASES = {
'default': {
'ENGINE': 'django.db....
- 2,074
1
vote
0
answers
51
views
Will multiple databases be the best way?
I have a CouchDB scenario which involves:
A business has multiple (10000's) discrete clients. I.e data is not shared between clients.
Each client has a set of <10K documents.
Clients have a 'life' ...
- 395
1
vote
1
answer
2k
views
Using Two Databases in Django (one read-only)
I am using two databases, one to read data from and then write data to another. Below is my Router class and my changes to settings but am very new to this concept, can someone with more experience in ...
- 59
1
vote
1
answer
734
views
Flask View from table of a sqlalchemy-bind doesn't work
I'm using python 3.6.5, flask 1.0.2, flask-admin, flask-sqlalchemy
I have problems showing a View of a table from a second database, sqlalchemy bind configuration, model database, model view all seem ...
- 53
2
votes
0
answers
764
views
Testing a multiple databases connections node.js app with Jest
I have a node app that uses multiple databases. I created a separate connection and model for each database per the solution suggested here.
However, when I run my Jest unit tests for testing the ...
- 1,476
0
votes
2
answers
2k
views
C# WPF MVVM change between multiple database connection types
I'm prepering for my final exam with C# WPF using MVVM creating an query editor which needs to support multiple database motors, and wondering what's the best practice of having multiple database ...
- 35
0
votes
2
answers
6k
views
python sqlite3 multiple-databases
I have the same data data spread out over many identical databases. I want to combine all this data into one database ( well over a million records)
I have connection objects and cursor objects from ...
- 19
7
votes
0
answers
6k
views
'Couldn't find PersistentEntity for type class' exception in Spring boot MongoRepository
In here I have configured two databases in mongodb. As described in this tutorial (link). So basically I override the MongoDataAutoConfiguration and MongoProperties implementations.
The property yml ...
- 937