633 questions
0
votes
0
answers
129
views
Laravel PHPUnit test: Multiple databases issue
In my Laravel application, I have set up two databases in a single server. All specific migrations and model classes have $connection property set up to use blog instance. The app works fine, no ...
- 64
3
votes
2
answers
195
views
java.lang.IllegalStateException: java.lang.NoSuchMethodError: error while configuring multiple database in springboot microservice project
I am trying to do a sample microservice which involves pulling data from multiple databases. And while configuring I am getting the Exception in thread "main" java.lang.IllegalStateException:...
- 1,688
0
votes
2
answers
83
views
sum values for rows with a specific value in another column in SQL with left join of multiple tables
I need to report the sum total amount value of a sold particular brand on completed sales only, on a per month basis report. I have the data spread across three tables but one of them is on a ...
- 13
0
votes
1
answer
55
views
Multiple data type column in Power Query
I have a column with multiple data type in Power BI as the following below. How I can convert/modify to Currency ( Fixed decimal number)
old_price
null
990
SR 4,040
SR 50/4 pack
SR 445/2 pack
null
895
...
0
votes
1
answer
210
views
Spring Batch Service: UnsatisfiedDependencyException when extends DefaultBatchConfiguration
I appreciate your help to find the cause of the exception listed below thrown when attempted to extend the DefaultBatchConfiguration. The Spring Batch Service show below works fine when doesn't extend ...
- 1
2
votes
0
answers
164
views
Spring Boot @Async Method Prevents JPA INSERT Queries from Executing with Multiple Database Connections
I'm working on a Spring Boot application that connects to multiple databases using Spring Data JPA. I have a method that saves an entity to one of the databases. The method functions correctly when it ...
1
vote
2
answers
76
views
Get model relationship collection from another database in Laravel
I have set the connection to two databases properly. I also have created eloquent table models and I can query a single table relationship from another database easily e.g.
$user->customer
User ...
- 2,794
0
votes
1
answer
55
views
Same table union from different databases
I have 03 MySQL databases as 2022_db, 2023_db and 2024_db. All the tables and table structures in the 03 databases are same & included different values.I want to get the sum of values in two ...
- 281
0
votes
0
answers
80
views
Updating several data sources in a single transaction
Using Spring Boot, I need to read and update data from 2 different data sources. For this I have configured my application based on https://www.baeldung.com/spring-boot-configure-multiple-datasources ...
- 385
1
vote
1
answer
93
views
Prefix on FastAPI url to switch databases?
FastAPI Routing Question:
Hi, I've got 3 databases set up (master databases that is, postgres instances) as such:
master1:
- db1:
- tables...
- db2:
- and so on...
-...
- 11
1
vote
1
answer
118
views
Need to monitor invalid objects from different DBLinks
I have to make a monitor that detects invalid objects for different DBlinks.
I've tried with a code in different files for each DBLink
-- Enable logging of results to a specific file
SPOOL C:\route
...
- 27
0
votes
1
answer
228
views
Finbuckel per tenant authenication using JWT
While using the WithPerTenantOptions authenication method of Finbuckel package I am getting the issue 'TenantInfo' does not contain a definition for 'JwtAuthority' and no accessible extension method '...
0
votes
1
answer
94
views
crystal report - uses subreport, has to get data from 2 different database in one command
I have installed crystal reports 2011 for .net 4.0. I create crystal report using visual studio. I use command to get data. the command gets data from 2 database. the 2nd database has same user and ...
1
vote
1
answer
99
views
Create from multiple data frames complex customized figure on ggplot2
I am working on a project where I need to combine data from two different data frames into a single plot using ggplot2 in R. I was wondering how I can efficiently achieve this, assigning specific ...
0
votes
1
answer
98
views
Relationships from multiple non-unique data sources in Power BI
I have an interesting problem. I am trying to create a relationship from an Excel File containing 'Business Days' with only Dates/Month Name/Days/Year and connecting that to a SQL Database source in ...
- 21
1
vote
0
answers
239
views
Connecting Multiple Databases in Dbt Cloud
I’m new to dbt and currently have a project connected with PostgreSQL in my development database.
My question is whether it’s possible to connect multiple databases in dbt Cloud to accommodate ...
- 11
1
vote
0
answers
208
views
Rails App: using multiple versions table in paper_trail
I am using Rails 7.0.4 with Ruby 3.0.4 for my app.
The app used multiple databases with Active Record (primary and secondary), each on a specific server.
In the app, I have different models, all of ...
- 147
0
votes
1
answer
102
views
Changing the database name dynamically over the same connection does not work
In the login section of the application, the user selects the database to be connected from the list of companies and the main page of the program opens according to the selected database.
The ...
- 1
1
vote
0
answers
737
views
Could not autowire. Qualified bean must be of 'EntityManagerFactory' type
I upgraded Java from 1.8 to 17 ,
Spring Boot from 2.1.18.RELEASE to 3.1.1
and Postgresql from 42.2.16.jre7 to 42.6.0
I was using this in my app prop:
spring.jpa.database-platform = org.hibernate....
- 11
0
votes
1
answer
82
views
Nested loop with using multiple data sets
I am having trouble setting up a nested loop for data cleaning. Each semester (Fall, Spring, Summer) has three data sets that need to be combined over multiple years (2018, 2019, 2020, 2021, 2022). ...
- 131
0
votes
1
answer
804
views
how to connect 2 mongodb databases in springboot
I am currently using 1 mongodb. This is how I set it up in application
spring.data.mongodb.database=Active
spring.data.mongodb.uri=mongodb+srv://<my_uri>
Now I need to introduce a secondary ...
0
votes
1
answer
85
views
Run a SQL query on multiple databases on a single server, single instance
I know there are a number of posts regarding the topic but I would like you to provide a solution to run the following (rebuild indexes) query on multiple databases, each with the same structure and ...
- 3
-1
votes
1
answer
52
views
Multiple SQL joins on 2 different databases with multiple tables
I'm attempting to create the correct set of joins on multiple tables across two different databases but i keep running into syntax errors ("Incorrect syntax near the keyword 'join') whenever i ...
1
vote
1
answer
266
views
How to configure second database (For only Select queries) in Spring Boot
I have a spring boot project with a MySql DB already configured along with the migration scripts.
I have a new requirement where I have to configure an Oracle database(part of another application) to ...
- 13
0
votes
0
answers
26
views
Can I use in the same project a Database made by myself and a Firebase Database?
I am planning a project and I have the authentication with firebase but I want to have the other tables in another database. Could this option be viable?
A detected problem that could happen would be ...
1
vote
0
answers
490
views
How to Handle Dynamic Database Connections in Go?
I am currently building a Go application that needs to connect to multiple databases dynamically.
For context I have 22 Databases (db1, db2, db3...) and the dbUser, dbPass and dbPort remains the same. ...
- 31
0
votes
1
answer
68
views
Insert data into a list of databases in MySQL
I have basic knowledge of MS SQL which actually sabotages me as the syntax differs from MySQL in which I need the code written.
I have X databases named "project_%". It's 1 database per ...
- 19
0
votes
1
answer
144
views
ActiveRecord 6 without Rails: Connecting to multiple databases
I have a legacy codebase which I need to upgrade to ActiveRecord 6. It does not use Rails.
I need to be able to connect to multiple databases.
In my code, I have:
conf = ActiveRecord::...
- 477
1
vote
0
answers
511
views
How can I configure multiple databases with springboot one being JPA and the other 5 plain jdbc?
For a project with a springboot backend, I have to use 1 database in Postgresql to save information and to add a history feature to the application and 5 other databases in Oracle on which I only have ...
- 11
1
vote
1
answer
787
views
Atomikos transaction timeout when insert into huge table
I'm using atomikos to handle global transaction between 2 different databases. I ran before with more than 1 billion records and this problem just appeared couple days ago. I guess the reason is my ...
- 33
2
votes
0
answers
488
views
Configured two data source in spring data JPA but second data source still considering first DB URL
In this official example of configuring 2 data sources, they have used embedded DB.
So, with the help of Spring boot's How to documentations, Configure Two DataSources and Using Multiple ...
- 324
0
votes
0
answers
230
views
Mapping problem with Symfony 4 and Doctrine 2 on multiple schemas
I'm working on rewriting an old plain PHP bad written app with Symfony 4.4 and Doctrine 2.12. Due to the number of databases (5) and the XXL size of them (at least 50 tables per database with often ...
- 75
0
votes
0
answers
2k
views
Multiple Database connections using fastapi in python
I wanted to connect multiple databases. I tried to go through the https://github.com/tiangolo/fastapi/issues/2592 but was unable to understand the approach.
How can I get data using this function
`@...
- 179
-1
votes
1
answer
359
views
How to use multiple datasets from different measurements for one prediction with machine learning models? How to split data into Train Test sets?
I'm working on Capacity prediction models for Lithium-Ion batteries.
I have 10 datasets from 10 different batteries including the capacity and multiple features. Each dataset is time dependent. In the ...
- 1
0
votes
1
answer
3k
views
Spring-boot mysql multiple datasources: Getting "this.embeddedDatabaseConnection" is null Exception
You can clone the complete updated code from GitHub.
Erroneous code which I had while posting this question is in the branch "issue_null_db_details_on_second_time_initialization"
I merged ...
- 324
0
votes
1
answer
101
views
Custom manager in Django MultiDB
I'am using MySQL and PostgreSQL in my Django project. Below are the settings:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'mysql_db',
'USER': '...
- 269
3
votes
0
answers
377
views
Problem with multiple databse when used spring-boot-autoconfigure 2.7.+
I try to change spring-boot-starter-parent from 2.6.9 to 2.7.2.
Spring-boot-autoconfigure also changes to 2.7.2 together with parent.
I have a bean which injected the bean EntityManagerFactoryBuilder
@...
- 101
0
votes
1
answer
1k
views
Allow dynamic databases based on url params
I have a Rails app (currently 6.1 but I can easily upgrade it if necessary) that connects to external MSSQL databases and provides an API (read-only) with the data.
I use these gems to help me access ...
- 3,096
2
votes
1
answer
313
views
Django architecture for different clients/technologies using same models
My team and I are having a hard time defining the architecture for my backend environment using Django.
To contextualize a little, we built an application similar to an App Store, for all our ...
0
votes
0
answers
144
views
Extracting information from two different databases in Crystal Report
I am looking to get information from two different databases: 1 is a SQL database and 2 is an MS Access table. Both sources don't have a unique identifier to link them to each other so what I've tried ...
- 1
0
votes
0
answers
296
views
Using Django select_related across multiple Databases
I have two database connections in the Django project, below is the Database settings:
# settings.py
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': '...
- 269
1
vote
1
answer
1k
views
Nest can't resolve dependencies: multiple database connections using mongoose package
Hi I am trying to set up multiple database connections using mongoose nestjs package with named connections and following along the documentation found here (https://docs.nestjs.com/techniques/mongodb#...
- 131
1
vote
1
answer
2k
views
Unknown SqlResultSetMapping
I've been sitting here for long to solve this problem.
(I can't show a lot of code because it is corporate secret so here will be parts of it or just examples)
I have my project connected to 2 ...
- 11
0
votes
1
answer
276
views
Is there a way to extract year range from wide data?
I have a series of wide panel datasets. In each of these, I want to generate a series of new variables. E.g., in Dataset1, I have variables Car2009 Car2010 Car2011 in a dataset. Using this, I want to ...
- 75
1
vote
1
answer
213
views
Loop over multiple data frames with mathematical function
I have 5 data frames, split from one according to a variable, to which I want to apply the same function based on the same 3 columns from each data frame. Each contains 10,000 rows.
My data:
Dist ...
- 91
-3
votes
1
answer
56
views
In django, can the .using('db') keyword take a variable?
Example.objects.using('db').raw()
Instead of db could we have a variable that would correspond to the appropriate database?
0
votes
0
answers
46
views
My unit tests don't work with multiple databases [duplicate]
I'm working on a project where there are two databases, and I need to create unit tests for my models and etc.
these are my databases:
DATABASES = {
'default': {},
'auth_db': {
'NAME': '...
- 84
2
votes
2
answers
1k
views
Multiple Database Setup Github Actions
I have defined a secondary external database in my Rails application for read-only purposes. Thus for testing, I setup a local database and plan to mock data within my test examples. Connecting to the ...
- 125
1
vote
1
answer
523
views
MySQL trigger to INSERT in multiple Databases
I have a DB named catalog DB which contains 4 tables in that one is the Customers table which has a list of customers and their alias.
I want to insert a row in a table (tableA) available in all ...
0
votes
1
answer
1k
views
Single Connection Multiple Databases TypeORM
I'm trying to connect to multiple databases from single connection using typeORM in javascript. There's a way doing it using typescript
import {Entity, PrimaryGeneratedColumn, Column} from "...
- 1