Questions tagged [multiple-databases]

631 questions
0
votes
1 answer

Multi app architecture and databases

I have just developped a Human Ressource WebApp in Laravel. So in this app, I have my user database. Now, I have 2 old apps, that I'm about to rewrite / Migrate to Laravel. The first one is to manage employee payments. The second app is for…
Juliatzin
  • 18,455
  • 40
  • 166
  • 325
0
votes
1 answer

Getting query results from 3 dbs when result only matches parameters of 1 db

Say I have 3 companies that all have customers. I want to write a code that searches all 3 companies for customers that have been terminated and laid off, then returns all the companies that that person is a customer with, regardless of that…
0
votes
0 answers

cakephp3 multiple database connections with plugin not loading

I am trying to load some data from a plugin model which uses a different database. I have added an entry in my config/app.php as follows: /** * The test connection is used during the test suite. */ 'alternate1' => [ …
0
votes
0 answers

Is there a way to avoid default database setting in Django project?

According to Django we can keep default database as empty dictionary {} but when we run it , raises Improperly configured database settings. I have used automated routers in my app files and registered them on settings.py . Django cannot avoid…
Avii
  • 31
  • 1
  • 8
0
votes
0 answers

MariaDB databases in different directories

I have the following scenario: On a Raspberry Pi (Raspbian Jessie) I run a python script receiving a huge number of individual data sets from a measuring device via UART. These data sets are "cached" in a mariaDB database (engine: MEMORY) and from…
0
votes
1 answer

SAS, SQL explicit passthrough, multiple Teradata databases

I have inherited a steep Teradata SQL query which runs on 3 Teradata databases. Preferring not to get bogged down in the functional aspects of the query (with various windowing statements), I would like to pass the query explicitly through to…
0
votes
1 answer

Getting NoUniqueBeanDefinitionException when extends QueryDslRepositorySupport and multiple datasources

I need to use multiple databases. I am using Spring Boot + Spring Data JPA, so I have two configuration classes: @Configuration @EnableTransactionManagement @EnableJpaRepositories(basePackages="com.rest.dao.first", entityManagerFactoryRef =…
0
votes
1 answer

Different database for each user

We are building a web application using asp.net mvc and sql server 2012. The users of this application are sql developers, each of them have sql server installed in their local machines. If user A opens the application, the data from User A's local…
0
votes
0 answers

Mongoose switching database according to userid

My system is designed so that every user has their own database with 3 collections inside. I'm designing an admin system that need to connect to the user db when they log in - how do I design this using Mongoose? I know that Mongoose has useDb that…
0
votes
1 answer

Logging into Multiple sites

I have two different websites written in Rails(W1) and PHP(W2) both on different hosts. I used Authlogic for W1's authetication now I want to allow user of W1 to login into W2 using same username and password (as of W2). How can I do this?
Bhushan Lodha
  • 6,824
  • 7
  • 62
  • 100
0
votes
2 answers

Multiple datasources with Grails 3.1.5 and Postgresql

I am trying to connect to two postgresql databases from a single Grails 3.1.5 application, my application.yml looks like this: hibernate: cache: queries: false use_second_level_cache: true use_query_cache: false …
Eddard Stark
  • 3,575
  • 8
  • 35
  • 51
0
votes
2 answers

Database Error while updating the ci_session? I am using mulitiple Database?

Error Number: 1146 Table buz85ftp_buzoonga2.ci_sessions doesn't exist UPDATE `ci_sessions` SET `last_activity` = 1468474888, `user_data` =…
Puneeth Kumar
  • 182
  • 2
  • 14
0
votes
1 answer

Importing multiple .db files to sybase using SQL Anywhere 16 and merging Tables

I am kinda new to sybase/SQL programming, but I am having to work with 160 databases with .db files that are accessible through Sybase Central (64-bit). Each database has several tables related to different chemicals (160 different chemicals thus…
0
votes
1 answer

Mapping entities across 2 (or more) databases

Context I'm developing a website where I have to use data from two distinct databases (one local with full access, one external on read only). One of "local" entities needs mapping to an "external" entity. The external entity won't have its data…
Michael De Keyser
  • 787
  • 1
  • 17
  • 45
0
votes
1 answer

Database documentation and reverse engineering

I know this question has been asked in various forms over and over again but I cannot find a single complete answer and I believe it is a general problem in the RDBMS/data area and industry. To explain the problem I will tell you a short (and maybe…
urban
  • 5,392
  • 3
  • 19
  • 45