Please some help on how to debug this! On my development machine I can succesfully host a local WCF service that uses a SQLIte database for its storage. I simply xcopied the wcf service dll's, the database file and the System.Data.SqLite.dll to the win 2008 server. The server hosts the the WCF service in IIS7.This worked without a hitch...
How can i call the onUpgrade Method of the database? Background of my question: I do a backup on the sdcard of the full database. And the user can restore this database. But if in the meantime (beetwen backup and restore) an app update has made changes to the database i get a problem on restoring. The new colums are not there after res...
Is a table locked every time I insert sth. in it? Because I want to insert thousands of rows each second so I want to know if having more than one thread for inserting helps effectively or not. If each insert locks the table just one thread is almost as efficient as for example 10 threads. If it depends on the Database engine, I use SQL ...
I am trying to configure CakePHP to act as a REST API for an app i'm writing. I have 3 tables: dishes { id, name, description } users { id, name, email } dishes_users { id, user_id, dish_id } I would like it so that when someone visits /users/1.xml, the data that gets returns is just the list of 'dishes' that a user has in...
I have a mysql database table that I want to partition by date, particularly by month & year. However, when new data is added for a new month, I don't want to need to manually update the database. When I initially create my database, I have data in Nov 09, Dec 09, Jan 10, etc. Now when February starts, I'd like a Feb 10 partition automa...
Is there a way to select rows from a DB where the timestamp is in a certain year? I don't have a specific timestamp, just a range (ex. all timestamps within the year 2009). Is there a way to do this? How else might I go about doing something like this? Thanks for your help! -iMaster ...
I'm writing an application that indexes data for our stores, some of which are open late (8 am - 2 am). We need to be able to search this database quickly -- basically, to run a query to find which stores are open at a given point in time (now, Sunday at 1 am, whatever). In addition, the open/close times can vary day-by-day -- some sto...
I am new to blackberry development. I want to do data manipulation (CRUD) for a small project. Can you help me understand different options that can be used for blackberry data persistence for O.S 4.5? I want to know and explore all possible data persistence models for blackberry O.S 4.5. I did some searching and found blackberry dat...
Hi. What is the best way to import large ammount of data from an Oracle DB to the MS SQL Server 2000? Also, a column mapping facility should be provided. ...
I have a complex database that's looking like this: product *1 <-> n* inventory *n <-> 1* inventoryUser *1 <-> n* user Now I would like to query e.g. all products where user.firstname = 'peter' in hql. ...
Hey Everybody, I am trying to build a rake tasks, that fetches a product feed and adds it to my db. task :testme => :environment do require 'nokogiri' require 'zlib' require 'open-uri' @url = "http://some_url/filename.xml.gz" @source = open((@url), :http_basic_authentication=>[USERID, "PASSWORD"]) @gz = Zlib::GzipReader.new(@s...
SQL Server to MySql conversion, i want convert the SQL Server query dump to mysql database. I have SQL Server query dump. Please give me a good conversion tool free of cost. I tried with phpmyadmin import feature, its not working. ...
Well, The question explains all, Using DB2mon tool, Is there a way to tell which client is connecting using which type of connection (type 2 jdbc or type 4 jdbc connection)? All of the connections are showing as db2jcc process which is the common driver for both type 2 and type 4. Also if there is a way to find out whether is connection...
i am trying to grant execute privs in stored proc in more than one database. The problem is this stored proc might not be in some of the databases. So how can i write a script which checks if stored proc exists in database and if does then provide execute privs for user? ...
I want a .csv list, mysql database, or any other list of all U.S states and cities, including which cities are in which state. From this list I will generate a mysql database with the following fields: states: - id (int, auto_increment, primary) - name (varchar 255) cities: - id (int, auto_increment, primary) - stateId (id of the s...
I want to use a database table as a queue. I want to insert in it and take elements from it in the inserted order (FIFO). My main consideration is performance because I have thousands of these transactions each second. So I want to use a SQL query that gives me the first element without searching the whole table. I do not remove a row wh...
I have a String field where I store two-word area names. Ex: New York Thing is, whenever I try to query that field (area:New York) no results come up, even though it is stored exactly as New York. Why is this? The results DO come up if I search like this: area:"New York" but they wont come up if searching like this: area:New. Any id...
I am sending this to a function, and I want double-quotes around the value of the variable below, example $var = "New York" (note the quotes) $fq.=" + area:$state"; So when I echo $state I want double quotes around it, how can I do this? Thanks ...
Hello, I am writing a PHP script (which also uses linux bash commands) which will run through test cases by doing the following: I am using a PostgreSQL database (8.4.2)... 1.) Create a DB 2.) Modify the DB 3.) Store a database dump of the DB (pg_dump) 4.) Do regression testing by doing steps 1.) and 2.), and then take another databa...
I perform an insert as follows: INSERT INTO foo (a,b,c) SELECT x,y,z FROM fubar WHERE ... However, if some of the rows that are being inserted violate the duplicate key index on foo, I want the database to ignore those rows, and not insert them and continue inserting the other rows. The DB in question is Informix 11.5. Curre...