Search Results

Search found 17634 results on 706 pages for 'django multi db'.

Page 455/706 | < Previous Page | 451 452 453 454 455 456 457 458 459 460 461 462  | Next Page >

• How to represent "ALL" in Primary Key -foreign Key relationship.

  - by Rohit

  I have to create a db design to store blacklisted fax numbers. I have created a table and one column of this table is customerID which is a foreign key to table Customer. Now i want to have a faxnumber which is blacklisted for all customers. How should i proceed with this. Should i use Null in this case. Please provide options

  Read the article

• How do I make a daemon into a stream in PHP

  - by Itay Moav

  I have a daemon (written in C, but I assume it does not really matter) which outputs messages with printf, and can get input and do stuff with this input (again, not really important what, but he sends those messages to a different machine to be saved there in the DB). My question, how can I make this daemon to be a stream in PHP, so I can hook the input/output of, for example, file_put_contents to this stream.

  Read the article

• rake does not returning anything

  - by CHID

  Hi, I jus created a rails application. I created a model using ruby script/generate model Article next i edited the my articles.rb file by adding these lines in self.up method def self.up create_table :articles do |t| t.string :title t.text :body t.string :published_at t.timestamps end end Now i ran rake db:migrate . But migrate does not work, it simply does no print anything. Anyone knows where i am going wrong?

  Read the article

• Can I separate merged model into source parts?

  - by Yola

  Can I separate merged model into source parts? Need to do it for reason of upgrade to new versions my every or not every source part of db. It must work under 10.5, so i cant use inferredMappingModelForSourceModel.

  Read the article

• HibernateTemplate alwaysUseNewSession

  - by DD

  Hi, I had a problem where I was using the hibernate template to do most of my DB work but I had a part of the system that directly accessed the session to do batch persisting. I noticed that the hibernate template session was old and would be storing cached values which didnt take into account the objects save with the session directly. What are the drawbacks of using alwaysUseNewSession? This fixes the problem as I always get up-to-date objects. Thanks.

  Read the article

• Where can I get SQL for default Oracle's "HR" schema?

  - by Dmitry

  I'm studying Oracle database and have to do some exercises with default "HR" schema. But I think that data in my tables is changed from default values (many students have access to DB and may be someone changed data). Where can I get SQL to construct default "HR" schema?

  Read the article

• SSIS to copy data from one table to another, where not in destination table

  - by alex

  I'm in the process of creating an SSIS package on a server (server1) that looks at the data in a sql db on another site (server2) and copies relevant rows across. The SQL statement required is: SELECT * FROM server2.ordersTable WHERE OrderID Not In (SELECT OrderID FROM server1.ordersTable This selects data from server1 which isn't in the table on server2 (based on order id) I then need to insert the result into a table on server1 How would I approach this? What components do I need etc...?

  Read the article

• Oracle on Linux with ASP.NET Windows Authentication Impersonation

  - by user118190

  Can someone please direct me on how to do this type of setup, i.e. I have a Windows Server with ASP.NET pages and would like to pass those credentials using Integrated Windows Authentication to a Linux-based Oracle DB.

  Read the article

• ASP.NET: How to Append Signature to Word Document

  - by Bolaji

  Currently I am developing a memo application for a company that each director needs to sign the word document as approved or disapprove. I have scan copy of each director as image in my DB. The signatures and date will be appended at the bottom of the doc page

  Read the article

• CPU Configuration Issue for 2 Servers (Server 2008 R2)

  - by Bill Moreland

  I have 2 servers running the exact same Classic ASP code with Access DBs (yes, not ideal, but it is what it is, for now). 1) Xeon 5520 @ 2.27 GHz (6 GB Memory) 2) Xeon E5-2620 @ 2.00 GHz (2 processors, 32 GB Memory) For most pages the newer E5-2620 processes the pages between 10-15% faster. On pages requiring heavy and/or multiple complicated access stored procedures (queries) the older 5520 does a much better job. I believe the servers are configured nearly identically. My question: is it possible that the newer, multi-processor server is not as good at handling Classic ASP as the older single processor? Is there a configuration difference that needs to be in place that I'm missing since I'm shooting for identical implementations?

  Read the article

• Case Statements versus coded if statements

  - by Eric

  What is more efficient - handling with case statements in sql or handling the same data using if statements in code. I'm asking because my colleague has a huge query that has many case statements. I advised her to take stress off of the DB by coding the case statements. I've found that it is more efficient...but why?

  Read the article

• Return more then One field from database SQLAlchemy

  - by David Neudorfer

  This line: used_emails = [row.email for row in db.execute(select([halo4.c.email], halo4.c.email!=''))] Returns: ['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]'] I use this to find a match: if recipient in used_emails: If it finds a match I need to pull another field (halo4.c.code) from the database in the same row. Any suggestions on how to do this?

  Read the article

• Concate String In MYSQL

  - by streetparade

  How can i concate this string in mysql desc=desc+$desct what i want is each time i insert a variable from PHP that the string is added to the string which was already in db and seperated with || the field desc should look like this desc 10||30||90||710 say i want to add the value 20 desc 10||30||90||710||20 then the desc field should look like this How can i implement this?

  Read the article

• Hibernate - how to create list of pojos?

  - by AspNewbie

  I am very new to Hibernate. I have MySQL database and mapped pojos. What should I do next? I know little bit LINQ to SQL from .NET, and it generates me List of mapped objects. So basically, what are my next steps after creating POJOS if I want to have List of them and do CRUD operations upon them and data will be also saved in DB not only in java objects ? kthx

  Read the article

• What trace flags are needed for detecting deadlocks

  - by AngryHacker

  I am trying to get better information on deadlocks that are occurring in my DB. After reading this article, it's still unclear to me whether I should be using trace flag 1204, 1222 or both.

  Read the article

• Check if string is serialized in PHP

  - by Industrial

  Hi everyone, I am in the middle of building a cache layer for the Redis DB to my application and I have come to the point where's it's about to take care of arrays. I wonder if there's any good (high performance!) way of controlling an string to be serialized or not with PHP? Thanks a lot!

  Read the article

• How do I keep connection in object explorer

  - by dotnet-practitioner

  This is regarding SQL server 2008 management studio.. I connect to different environment DB and every time I launch the Sql management console, I have to sign up every time to get those connections back in object explorer. Is there a way I could persist the connection so I don't have to login every time to different environments?

  Read the article

• Variable table or column names.

  - by Frank Computer

  INFORMIX-SQL or any other SQL-based DB: Suppose I have an app where depending on the value of some columns, example: company.code char(3) {abc} company.brach char(2) {01} Can I construct table name "abc01" for inclusion in SELECT * FROM abc01; ? In other words, a variable table name.. same question applies for column names.

  Read the article

• Centralized way of organizing urls in Jersey?

  - by drozzy

  Forgive me if I am asking an obvious question (maybe I missed it in the docs somewhere?) but has anyone found a good way to organize their URLs in Jersey Java framework? I mean organizing them centrally in your Java source code, so that you can be sure there are not two classes that refer to the same Url. For example django has a really nice regex-based matching. I was thinking of doing something like an enum: enum Urls{ CARS ("cars"), CAR_INFO ("car", "{info}"); public Urls(String path, String args) ... } but you can imagine that gets out of hand pretty quickly if you have urls like: cars/1/wheels/3 where you need multiple path-ids interleaved with one another... Any tips?

  Read the article

• Do views only perform the joins that they need to, or all joins always?

  - by Nate

  I am on an oracle DB. Lets say I have one view that joins to three tables. The view has two fields each. Each field only needs data from two of the three tables. If I query the view and return only one field, does the view still join to three tables or just to the two tables that it needs to calculate the field?

  Read the article

• Oracle: How can I know a table is getting populated?

  - by Tami

  Hi, I'm in charge of an oracle db where we don't have any documentation (at all). And at the moment I need to know HOW a table is getting populated. Ideally, I'd like to know from which procedure, trigger, whatever... this table gets its data from. Any idea would be much appreciated. Thanks.

  Read the article

• How important is it for me to pool my connections?

  - by Rio Mango

  It has been suggested to me that I rearrange my code to "pool" my ADO connections. On each web page I would open one connection and keep using the same open connection. But someone else told me that was important 10 years ago but is not so important now. If I make, let's say, 5 db calls on a web posting, is it problematic to be using 5 separate connections that I open/close?

  Read the article

• Hibernate query cache automatically refreshed on external update?

  - by artgon

  I'm creating a service that has read-only access to the database. I have a query cache and a second level cache enabled (READ_ONLY mode) in Hibernate to speed up the service, as the tables being accessed change rarely. My question is, if someone goes into the DB and changes the tables manually (i.e. outside of Hibernate), does the cache recognize automatically that it needs to be cleared? Is there a time limit on the cache?

  Read the article

• RAID striping on a desktop machine

  - by Blazemore

  I currently have a 120Gib SSD which is pretty fast for things like game loading times and video editing. However, I was wondering about getting another identical drive and hooking it up with a striping RAID array in hardware (I boot multiple operating systems). This would have the dual benefits of providing a larger logical drive, while also providing greater performance. However, I have a few questions: What kind of performance increase can I expect to see with a pair of good quality SSDs? How expensive is a quality desktop RAID controller? Will the controller present the OS with a single logical drive? Does this mean I can still partition it and multi-boot? Basically, can I treat the RAID controller as "a hard drive" at the OS level?

  Read the article

• Consolidate information held in a number of SQL Server Express Instances

  - by user321271

  Hi, I'm trying to determine the best architecture for creating an oData web service for information held in a number of SQL Server Express instances. The web service should provide a consolidated view of the data. All the SQL Server Express instances have the same DB schema. I was initially planning to use SQL server replication however as I understand it, SQL Server 2008 Express cannot be used as a publisher. Any help or suggestions would be appreciated.

  Read the article

< Previous Page | 451 452 453 454 455 456 457 458 459 460 461 462  | Next Page >