633 questions
0 votes
0 answers
130 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 ...
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:...
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 ...
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 ...
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 ...
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 ...
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 ...
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... -...
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 ...
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 ...