Hi all I am using Microsoft.Jet.OleDb.4.0 provider to obtaint data from Excel files. Here's the connection string and it works properly: string conn = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=source.xls;Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\""; The problem is that I want whenever excel file was opened or to be using by a...
I'm working on an rather small application (C#, winform) that is kind of front-end to MS Access database file stored on shared drive. While it is possible that drive could be down I am checking connection while loading Main Form. I would like to know your opinions on how to deal with this problem. I came up with ideas like: Applicat...
hi there! i have a problem with double values i need to store in an android homed sqlite database. since these double values represent gps values (lat & lng), i really NEED an absolute precision down to the 9th number after the comma. now i have a table like this: CREATE TABLE x REAL lng; and insert sth (hardcoded) like: INSERT INT...
I'm a newbie to rails, and I have researched a whole day. I think my problem is easy. There is a table questions_tags_relation, it has two columns(no id): columns: question_id -> string tag_id -> string And I have a hash: record = {:question_id=>'111111', :tag_id=>'22222'} And there is no model 'QuestionsTags', and I don't want to...
Can someone point to me some documentation on how to run the Oracle times ten database in an embedded mode within a java application? I would like to run times-ten as a replacement for HSQLDB. ...
We are revamping our product which gets highly customized for each client. Currently we have to maintain separate database for each client which heavily affects persistence layer. Our major goal for new database schema is extensibility. I am not an expert database designer thus require input from experts :). I am thinking about extensi...
Can someone point me in the right direction for creating indexes when using MigratorDotNet? I have some tables which need multi column indexes. Thanks ...
I want to construct a system which is responsible for updating my database columns. It is similar to registration of memberships.We have users and they send a request form of their wishes.First of all , the system inserts all of these information in a table .One column specifies the state of the request.It contains the integer values w...
Hi, In my domain model I have a bi-directionnel association between the ProductList entity and the Product entity with the following hibernate mapping : @Entity @Indexed @Table(name="product_list") public class ProductList { @ManyToMany(fetch=FetchType.LAZY) @JoinTable(name = "list_items", inverseJoinColumns = { @JoinColumn(na...
I am guessing no, since the foreign keys are the primary keys in their own tables, so they will be unique. More info I am using MySQL and the following three tables are using the InnoDB engine. ======================= ======================= | galleries | | images | |---------------------| |------------...
I'm at my wit's end trying to handle these errors. Basically, I've created the following User and Relationship patterns, using Mongoid to handle my database. This seems like a near-carbon copy of the example at the bottom of the page here. I'm trying to call any of the following: user1.relationships.find(:all, :conditions => {:rel_us...
Hello all, For use in a language-learning web application, do you know of data structures and underlying database schema/ layout that would allow efficient storage, processing and querying of sentences, verbs, nouns etc. for different natural languages? For example I would like to store each verb only once and link sentences to a verb o...
I am looking for a database system that should be a relational database. But a main feature has to be that it forgets entries to fit a certain condition, like 'least recently used' on a certain size of the DB. In other words, I want a kind of 'weak reference' in a DB. Is there already such a solution? What do you think about that idea:...
What difference between Super and Candidate key in ERDB? Thanks. ...
Hi, Can you recommend good embedded databases with Visual C++/MFC? I've looked at: - SQLite - HamsterDB Any others? ...
I'm using Node.js for some project work and I would like to monitor my Mongo database (collection) for changes, basically fire an event if something gets added. Anyone know if this is possible? I'm using the node-mongodb-native drivers. If it's not I'd also like any available pointers on pushing data from the server (run with node) to ...
My MySql server currently has 235 databases. Should I worry? They all have same structure with MyISAM tables. The hardware is a virtual machine with 2 GB RAM running on a Quad-Core AMD Opteron 2.2GHz. Recently cPanel sent me an email saying that MySql has failed and a restart has been made. New databases are being expected to be creat...
Trying to use database sessions in PHP without re-inventing the wheel so I'm looking for a clean library or example that could send me in the right direction. ...
I am writing an app that displays fun-facts (and the source they are from). The user can browse through the facts one by one. Here is the design I thought of : Create a table in SQLiteDatabase with a text column that stores the fun-fact and a second column that stores it's source. (not sure if this is the best way to go about doing it...
Is there a reason that most logs seem to be in plain text, as opposed to being put in a MySQL/other sort of database? It seems to me that putting them into a database would make analysis much, much easier…but would that come at the sacrifice of speed or something else? (I'm not that concerned with portability, and obviously you'd have ...