Search Results

Search found 39311 results on 1573 pages for 'database stuff'.

Page 203/1573 | < Previous Page | 199 200 201 202 203 204 205 206 207 208 209 210  | Next Page >

• NHibernate - does it work well with database-level cascading deletions on foreign key constraints

  - by Nelson LaQuet

  Dose nHibernate play well with database level cascading deletions? What I mean is that if I have a constraint set at the RDBMS level to cascade delete all orphans, will nHibernate invoke any custom delete logic at the application level if I were to delete an entity though nHibernate? Or should I remove the cascading deletions from the RDBMS level and just use the cascading delete feature of nHibernate itself by defining that behavior though its configuration? Thanks

  Read the article

• Any gotchas in migrating database connectivity to DataSource?

  - by Everyone

  Looking at some old application code which uses explicit driver loading as Class.forName(...).newInstance I have been told to change this to use the Java 1.4.2 mechanism to establish a database connection using ContextLookup, and DataSource. Are there any gotchas I should be aware of?

  Read the article

• SQL Server Compact - count records/get space used for all tables in database

  - by Andy White

  Is there a way to get a record count or a space-used value for all the tables in a SQL Server Compact database file (SQL CE 3.5.1)?

  Read the article

• Multiuser XML document "database" for asp.net app

  - by Pierreten

  I was thinking about a way to allow multiple users to get CRUD access to an XML document in an asp.net app. The operations would obviously have to be made under the assumption of a multithreaded environment. For perf reasons, would it make sense to cache the document, and use a mutex on that cached version? When would changes be flushed to the physical XML document? Any and all recommendations are appreciated (also "use a database" isn't an option at this point unfortunately)

  Read the article

• Error, could not create MachMessagePort for database doctor (com.apple.addressbook.migrationdaemon)

  - by user262998

  I'm working in address book for iphone. it generate address into UILabel. when I'm running the application everything goes well, but after showing about %30 of the addresses and sadenly stopped without any reason! Only in terminal shows: Error, could not create MachMessagePort for database doctor (com.apple.addressbook.migrationdaemon) starting in process migration Please help me!

  Read the article

• [rails] do we need database level constraints

  - by shrimpy

  i have the same problem as in the following post http://stackoverflow.com/questions/1451570/ruby-on-rails-database-migration-not-creating-foreign-keys-in-mysql-tables so i am wondering, why rails do not support generate foreign key by default??? it is not necessary??? or we suppose to do it manually?

  Read the article

• Oracle Database Enforce CHECK on multiple tables

  - by GigaPr

  I am trying to enforce a CHECK Constraint in a ORACLE Database on multiple tables CREATE TABLE RollingStocks ( Id NUMBER, Name Varchar2(80) NOT NULL, RollingStockCategoryId NUMBER NOT NULL, CONSTRAINT Pk_RollingStocks Primary Key (Id), CONSTRAINT Check_RollingStocks_CategoryId CHECK ((RollingStockCategoryId IN (SELECT Id FROM FreightWagonTypes)) OR (RollingStockCategoryId IN (SELECT Id FROM LocomotiveClasses))) ); ...but i get the following error: *Cause: Subquery is not allowed here in the statement. *Action: Remove the subquery from the statement. Can you help me understanding what is the problem or how to achieve the same result?

  Read the article

• inheritance in document database?

  - by nils petersohn

  i am wondering because i searched the pdf "xxx the definitive guide" and "beginning xxx" for the word "inheritance" but i didn't find anything? am i missing something? because i am doing a tablePerHierarchy inheritance with hibernate and mysql, does that become deprecated for some reason in xxx? (replace xxx with the "not only sql" database you like)

  Read the article

• contents of page reload when any user post data in database in php

  - by Mayan Alagar Pandi

  Hello Tech Jargons, I have developing messenger in php. In my application in need to reload the content of div in a page while any user post their comments on database of server. Please kindly help me... Thanks in Advance Mayan Alagar.

  Read the article

• Dataset to Database

  - by user181421

  Hello, I'm working with framework 2.0. I have a dataset with many rows that were entered by the user and I need to write them to the database. What is the right way to do it? TY

  Read the article

• SQL Select statement that includes a column that isn't in the database

  - by Cypher

  I'm trying to execute a SELECT statement that includes a column of a static string value. I've done this in Access, but never with raw SQL. Is this possible? Example: Name Status John Unpaid Terry Unpaid Joe Unpaid In the above example, the "Status" column doesn't exist in the database.

  Read the article

• Symfony - Delete and reload all database records for each test

  - by Andree

  Hi there, From the Jobeet tutorial provided in Symfony website, I found out that I can load fixtures data each time I run unit test by using this script: Doctrine_Core::loadData(sfConfig::get('sf_test_dir').'/fixtures'); However, I want to delete and reload all records from database each time I run a unit test. Currently, I'm doing this manually (Run symfony doctrine:build --all before each test). Can someone provided me a correct way to do this?

  Read the article

• Using linq, database doesn't have FK relations to tables

  - by mrblah

  Hi, I have a database that has primary key fields in its tables, but the FK mappings are not in place. What are the ramifications of this when using linq-to-sql?

  Read the article

• SQLite database creation fails, documentation is unclear

  - by Lars D

  When I add this code to my Android 2.1 Java app, it fails: db=SQLiteDatabase.openOrCreateDatabase("Locations", null); Do I need a special permission to create a database, or can anybody provide a suggestion how to find out what goes wrong?

  Read the article

• Create database triggers with sql-injection without stacked queries

  - by Henri

  Currently im working on a research paper about sql-injection with RFID tags and Im curious if it is possible to create a database trigger with an sql injections if stacked queries are disabled. If stacked queries are enabled, of course it is easy (assuming you know the table layout), but what if they're disabled for security reasons.

  Read the article

• Inserting database structure into MySQL with PHP?

  - by Andreas Carlbom

  Yo. I'm trying to find a way to insert a whole database structure into MySQL with PHP. Now, my main question is if there's any way to do this beyond just inserting the whole bloody thing line by line? Thanks.

  Read the article

• How to create a huge Informix database?

  - by tabrez

  Can anyone provide me with a script for creating a huge database (for example, 2 GB of data) in IBM Informix Dynamic Server (IDS) version 11.50.FC4 on a Linux RHEL 64-bit machine?

  Read the article

• Indexing File Names To a Database

  - by Nathan Campos

  I have a folder with more than 2000 files and I need to index their file names on a database(MySQL) using Java, but how could I do this? PS: The MySQL connection part I already know.

  Read the article

• Connecting to SQL Database from another computer

  - by yomayne

  I'm new to SQL Server, and have been following this tutorial I carefully followed all the steps, but when I try to connect to the database from the other computer, I get the error "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)" What steps do I need to take to fix this? Thanks (I'm using SQL Server 2008 R2 on both the machines)

  Read the article

• Caching Mysql database for better performance

  - by kobey

  Hi, I'm using Amazon cloud and I've performance issue since the HDD is not located on my machine. My database is small (~500MB) and I can afford to keep it all in my RAM. I do not want to keep queries in my RAM, i need all the tables there. How can i do it? Thanks, Koby P.S. I'm using ubuntu server...

  Read the article

• Get unrelated entities in one trip to the database

  - by kathy

  Hello,, I have 3 entities that are not related to each other and I want to get all these entities in one trip to the database how can I do this ?? Thanks

  Read the article

• keep LinqToSQL sync with the database

  - by user112976

  Hello, I am going to develop a new website with asp.net 3.5 and LinqToSQL. For maintainability purposes, how can I modify a Linq class if an attribute is added to a table in the database ? Thank you.

  Read the article

• Transport Database Query through Web Services without using Dataset

  - by Marty Trenouth

  Understanding that passing Datasets through web services is a bit heavy (and almost if not completely unconsumable to non .NET clients) what is the best way to prep database query results that don't map to known types for transport through web services in c#?

  Read the article

• Restore Mysql database query is not working in ASP.NET, C#

  - by santhosha

  We are using Mysql.exe to restore database by the following query string cmd ="-h" + ViewState["host"].ToString() + " " + "-u" + ViewState["user"].ToString() + " " + "-p" + ViewState["password"].ToString() + " " + ViewState["dbName"].ToString() + "<" + " " + Server.MapPath("BackupFiles/") + path; The same query is executing in MySql command prompt but we are not able to restore using the above query in VisualStudio .Net, we have tried MysqlImport.exe to do the restore but it was no use. we are newbie to MySql if any help would be appreciated.

  Read the article

• need to get value from the database and populate a drop down list using jquery

  - by jarus

  hi i need to populate a drop down list when i select a certain value , and the options need to be queried from the database .. can i achieve this from jquery ? if i can then please i would appreciate any help..

  Read the article

< Previous Page | 199 200 201 202 203 204 205 206 207 208 209 210  | Next Page >