Search Results

Search found 30605 results on 1225 pages for 'database abstraction'.

Page 200/1225 | < Previous Page | 196 197 198 199 200 201 202 203 204 205 206 207  | Next Page >

• how can i store data from csv file to sql database in asp.net

  - by vksnd

  in my project i have existing csv file and all they have up to 20 lak records. and they all i store in my sql database. so plz help me how can i do this. i use sql bulk insert query but they didn't run in asp.net

  Read the article

• How do I connect to MSSQL 2008 database in Java with JDBC

  - by shuxer

  I have MSSQL 2008 installed on my local PC, and my Java application needs to connect to a MSSQL database. I am a new to MSSQL and I would like get some help on creating user login for my Java application and getting connection via JDBC. So far I tried to create a user login for my app and used following connection string, but I doesn't work at all. Any help and hint will be appreciated. jdbc:jtds:sqlserver://127.0.0.1:1433/dotcms username="shuxer" password="itarator"

  Read the article

• Is it possible to run an alter on all my database objects to test them

  - by Khanzor

  I'm in the course of doing some schema migrations, and would like to know if it's possible or advisable to run every stored procedure, view and function in my database as an alter statement to "compile" them all to make sure nothing is completely broken.

  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

• 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

• [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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

< Previous Page | 196 197 198 199 200 201 202 203 204 205 206 207  | Next Page >