Questions tagged [multiple-databases]
631 questions
0
votes
1 answer
spring mvc hibernate creating and manipulating sessionfactorys of several databases
here I have a problem that I want to find a solution here, I work on a project using spring mvc and hibernate in my project I have several databases with same architecture (database by company) and a database for authentication, when the user login…
user820688
- 719
- 2
- 13
- 27
0
votes
0 answers
SQL Server : Query Multiple Databases within Multiple Linked Servers, Return One result set
I have multiple linked servers, containing many databases. I'm trying to search through all the server/databases for specific information and return back one result set within SQL.
I'm looking for a way without changing server settings/firewall to…
user2414546
- 1
- 1
0
votes
1 answer
How to solve multiple databases in one edmx for ASP.net MVC?
After I searched around on Google and Stackoverflow, I understand that I need to ask because I'm newbie about MVC.
My question is How to use multiple databases on edmx?
I think if I can put entity from different databases on same edmx, MVC can…
CMMaung
- 165
- 5
- 11
- 27
0
votes
2 answers
Same report, different databases
I created reports on Web Intelligence accessing an Oracle database. But now, other people want the same reports. Each one of them has a different database (but all are Oracle) with the same structure but with his own data.
What do I have to do to…
user2366817
- 1
- 1
0
votes
1 answer
Asynchronous multiple query from different datasources or databases
I'm having trouble to find appropriate solution for that:
I have several databases with the same structure but with different data. And when my web app execute a query, it must separate this query for each database and execute it asynchronously and…
Andrej Soroj
- 1,103
- 1
- 9
- 10
0
votes
1 answer
Architecture for MVC Application for running web reports on data across 2 database servers
I have an ASP.NET MVC 4 application that uses a database in US or Canada, depending on which website you are on.
This program lets you filter job data on various filters and the criteria gets translated to a SQL query with a good number of table…
Abe
- 6,386
- 12
- 46
- 75
0
votes
0 answers
dynamically connecting to multiple databases in rails
my project require connecting to multiple databases within a rails project. The database information is not known in advance, so including the database information in config/database.yml is not an option. Here is my code to solve this :
mclass…
user1652840
- 41
- 3
0
votes
1 answer
Delegate pattern for Rails remote database?
I am working on a Rails application that requires roles-based permissions (let's call it the "Hidden" application), but the application will not be handling user authentication. The Main application sets an encrypted cookie and the Hidden…
Peter Degen-Portnoy
- 786
- 1
- 8
- 16
0
votes
1 answer
Multiple Databases using PDO
I'm pretty new to using PDO and I would like to set it up so I can have multiple databases as and when I need them. So I've created a function that allows you to pass a database name to be used as and when.
It does work to a certain extent, as in it…
Gareth Daine
- 4,016
- 5
- 40
- 67
0
votes
0 answers
Single Database joins Vs Multiple database joins. which is better as per performance
I have some question regarding SQL Server Database.
I have a old database in working state in which the actual data of Employee exists.
I am creating a new database for my application. For this new application I need to depend on data from old…
blue
- 568
- 3
- 10
- 30
0
votes
1 answer
Grails how to call another database table?
Example :
i have 2 db : db1 and db2
and i have 2 domain in my app,
class domain1 {
String test
Domain2 domain2
static mapping = {
datasource 'db1'
}
}
class domain2 {
static mapping = {
datasource 'db2'
}
}
when i…
rsijaya
- 159
- 2
- 14
0
votes
1 answer
establish_connection doesn't bring over model associations
Issue: I have multiple databases that I have to connect to depending on the server that is chosen from the start. If I have a client table that has an association of userclasses, I can connect to one of the databases fine and query clients, but if I…
Magicmarkker
- 1,063
- 7
- 25
0
votes
1 answer
How i can do to connect to different db's in different machines with nhibernate and unhaddins?
I'm trying to connect with nHibernate and Unhaddins in different machines , each has a database in Oracle. They have different tables with different database.
I'll need to read a table, let's call it as C_SM_SEND.
Inside this Table, I have a…
Gustavo Gonçalves
- 528
- 1
- 12
- 33
0
votes
1 answer
Howto configure solr with db-data-config.xml to index documents from multiple sources
I'm trying to index multiple databases into one solr index. I've been reading the solr wiki on multiple data sources and trying to fiddle with different kind of settings but I'm not able to get the desired result.
My configuration looks like…
Bertjan Broeksema
- 1,541
- 17
- 28
0
votes
2 answers
performance of parameterized queries for different db's
A lot of people know that it is important to use parameterized queries to prevent sql injection attacks.
Parameterized queries are also much faster in sqlite and oracle when doing online transaction processing because the query optimizer doesn't…
tuinstoel
- 7,248
- 27
- 27