Questions tagged [multi-database]
120 questions
0
votes
1 answer
Multisite Rails/Jruby site has ActiveRecord::AdapterNotSpecified database configuration does not specify adapter issue
Trying to have web app change schemas based on a drop down. I have a feeling that I am not pulling in the drop down selection.
Model:
class MyApp < ActiveRecord::Base
def initialize(dbase)
@dbase = fdbase
if @dbase == 'DB01'
…
nmvida
- 5
- 5
0
votes
1 answer
Django Select Database From URL
I have a multi-database Django Project (Python 2.7, Django 1.4 ) and I need that the database used in every single transaction triggered in a request be selected through the url from that request.
Ex:
url='db1.myproject.com'
Would trigger the use…
lealhugui
- 189
- 1
- 12
0
votes
0 answers
How migration multi-dbs in Rails
How do I build multi databases environments in Rails?
of course, I know, using "establish_connection" allow to connect specified database, but no longer good to migration.
In the best condition, when "rake db:migrate", each tables are created in…
lassy
- 61
- 5
0
votes
1 answer
JDBC:is it possible to execute multi-database Querys in java?
I want to execute an sql-query over 2 databases using java
but have some problems finding out how to do it without writing everything by myself
maybe someone has an idea how to do it.
example:
database1
table1(names):…
DavidB
- 73
- 1
- 9
0
votes
0 answers
How to Select sql Database and copy and edit the figures
Hi i would like to know how can i use a grid view select option and replicate the selected row and be able to edit the information in it as well and save/update it into another database
like if i click select,textboxes will fill up with the details…
0
votes
3 answers
Storing flags in SQL column, and indexing them
I need to store a set of flags that are related to an entity into database. Flags might not be the best word because these are not binary information (on/off), but rather a to-be-defined set of codes.
Normally, you would store each information (say…
usr-local-ΕΨΗΕΛΩΝ
- 26,101
- 30
- 154
- 305
0
votes
1 answer
Limit data manipulation from user only through application layer for multi-database solution
I'm starting the development of a new software that must be compliant to SQL Server (2005 and above), Oracle (10r2 and above) and Sybase (12.5 and above). I'm planning on implementing the database abstraction using stored procedures, so I can use…
Pascal
- 2,944
- 7
- 49
- 78
0
votes
1 answer
How can I make a select in django using a multi-database?
I 'm using multi-database, and I try:
cursor = connection.cursor().using(profile.dbname)
cursor.execute('select id_retorno from prc_sequenciadora(' + str(profile.idempresa) + ', "VENDA_PEDIDO", "IDVENDA_PEDIDO", 0, 0)')# calls…
fh_bash
- 1,725
- 4
- 16
- 23
0
votes
1 answer
How to create tables in multiple databases using Django models.py
I would like to create table "A" in one database (assume in SQL Server 2008) and another table in "B" (My SQL) using models.py through Django.
Both the tables structures "A" and "B" may differ. I have verified that through router.py can achieve…
shiva
- 88
- 1
- 8
-1
votes
1 answer
Trying to get property 'user_nicename' of non-object
I make many database applications, in my database have the same table name and the same file. how can i display all the data
this is my model
this ins my model users
class Users extends Model
{
// protected $connection = 'mysql4';
protected…
iqbal
- 1
-1
votes
2 answers
how to manage database in laravel
i want to use multiple databases, i have 1db/user and 1 main db,already set main db in config file but how to manage user database(db name = {user_id}_db). thanks in advance
this is my config code
'main' => [
'driver' => 'mysql',
'host' =>…
HilAy Patel
- 1
- 1
- 3
-1
votes
1 answer
How to connect multi server and database in C#
public class MyDatabaseConnection
{
string connectionString = "Data Source= my DS3;Initial Catalog = MyCATA;Persist Security Info=True;User ID=sa;Password=mypsw*";
public MyDatabaseConnection(string connectionString)
{
…
Milestone89
- 29
- 6
-2
votes
2 answers
how to show one id for multiple data?
i have 2 table.
first table for cust. expml :
id
name
12
Anna
23
Beth
and the last one is for stuff
id_stuff
type
1
Knife
2
mug
3
fork
i want to show data in potgresql like…
Yulan
- 1
-2
votes
1 answer
YII2 Ajax Multiple DB connection
I am working with YII2.0 Multiple DB connection using ajax,i having multiple database like account, customer_1,customer_2..customer_n
in account database having user table then each user in that table have the corresponding DB.
Based on the user_id…
sen
- 129
- 5
- 13
-3
votes
1 answer
How can relation multi-subdomain websites with separated databases?
I development multi subdomain website with separated databases with sso, like as:
www.example.com (corporate web & shop) - www_db
blog.example.com - blog_db
forum.example.com - forum_db
account.example.com - login, register, account_db…
Cardinal
- 1
- 1