Hi, In Android when you upgrade a database all data is lost. I'm going through a phase of development right now that is forcing many database upgrades. I don't want to lose all my data (and have to manually re-enter it) each time I upgrade my database. I would like to store my data in flat files and load those flat files into their re...
I am getting the following error when trying to execute a stored procedure in Oracle that contains two input parameters: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'P_GET_NEXT_AVAILABLE_RUN' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Both input parameters require values...
we have 3 tables: grandfathers, fathers, sons. grandfathers have many fathers, and fathers have many sons, through the foreing keys grandfather_id and father_id. Each record has only one property, the name of the person. What I want is to have a list of all grandfathers, each with a field called grandsons_names which is the csv of all ...
I have ran into this problem a few times and I am wondering what other people are doing. When I am creating a database, sometimes I have to import data into a table on a regular basis, let's say daily. What I normally do is delete all of the records and reimport every record from the external data source. Many times I will have to stor...
I have three basic types of entities: People, Businesses, and Assets. Each Asset can be owned by one and only one Person or Business. Each Person and Business can own from 0 to many Assets. What would be the best practice for storing this type of conditional relationship in Microsoft SQL Server? My initial plan is to have two nullabl...
When I do: show processlist I see all my 20 servers connected to it. But, after a while, they drop off one by one. I know it's not the script problem. My script does Not terminate. Could it be that it time-out if it doesn't make a query within a certain time? How do I change that setting? Edit: The python script selects and inserts ...
When it comes to column order in DB tables, are there any standards or at least best practices? Here are a few handmade best practices that I've adopted: primary key comes first; foreign keys come after the primary key; columns holding user generated data come after the foreign keys; timestamp columns come in the end of the table (no ...
Hello all, My newbie question of the day is.... I have a comment function on my site that I have 3 versions of for the same page. I have one that has specific traits for A. signed in and looking at own profile B. signed in looking at someone elses profile C. Not signed in at all I have it working just great depending on what criteria t...
I have asp.net mvc site, my action generate the page, using master page. on master page included widgets by RenderAction helper. How can i use one database connection in page controller and in widget controller? ...
Hi, This might be an easy one for some one but I haven't found a simple solution yet. I'm automating a larger process at the moment, and one step is to back up then drop the database, before recreating it from scratch. I've got a script that will do the back up and drop as follows: Use [Master] BACKUP DATABASE [databaseName] TO DI...
This might be something very trivial, but I am a novice with some Object-Oriented patterns. Put simply, is it a bad practice to use methods from one DAO in another DAO? I am trying to create an entity within a DAO and find it very hard to create that entity using just that DAO. So, is it ok to use other DAO methods within the other DAO?...
I'm looking for a way to quickly "clone" a database from 1 postgresql server to another. Assuming... I have a postgresql server running on HostA, serving 2 databases I have 2 devices mounted on HostA, each device stores the data for one of the database (i.e. 1 database => 1 tablespace => 1 device ) I am able to obtain a "safe" point i...
Hi, Typically, the databases are designed as below to allow multiple types for an entity. Entity Name Type Additional info Entity name can be something like account number and type could be like savings,current etc in a bank database for example. Mostly, type will be some kind of string. There could be additional information associat...
As part of a ASP.NET MVC project I'm working on, I'll be working with SQL Server 2008 Express. I'm not sure how I should go about having a version-controllable (I'm using Mercurial) way of recreating the database. Ideally it should be run every time I perform a build in Visual Studio 2008. EDIT 1: In response to couple of the answers,...
hi is there a good data dictionary tool out there for a db2 database on linux or mac. Could only find some win apps. maybe something wiki like or html generator. Thanks ...
We're setting out to build an online platform (API, Servers, Data, Wahoo!). For context, imagine that we need to build something like twitter, but with the comments (tweets) organized around a live event. Information about the live event itself must be delivered to clients as fast and consistently as possible, while comments about the ev...
Hello, I have to design an application is mostly an interface with a database for data entry. The application must be able to work while it is disconnected from the database with cached data and insert that data when it has connection again. There will be two different modes, connected or disconnected, no need to detect disconnection in...
I am reading about SOLR and indexing a MySQL database into SOLR. What do they mean by "tokenize" and "un-tokenize"? And what does it mean when fields are "normalized"? I know how and what it means to normalize a database, but a field? How can a simple field be normalized? Thanks ...
I don't know if it exists some code generation method for Flex based on XML or Database Structure. For example, we want to manipulate a table in the DB, the most common task is (View/Insert/Update/Delete). And when we have more than 100 fields on the interface, it's rather boring to type them manually in Flex. Is there some ways to gene...
I've got to Tables related in one-to-many association: Product*1 - n*Inventory @Entity public class Product { // Identifier and properties ... @OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL) public Set<Inventory> getInventories() { return inventories; } public void setInventories(Set<Inven...