Say you have a ServiceCall database table that records down all the service calls made to you. Each of this record contains a many to one relationship to Customer record, where it stores which customer made the Service Call. Ok, suppose the Customer has stop doing business with you and you do not need the Customer's record in your datab...
I've been given the task of creating a site that will allow our various large clients to log into our website and click on our various pages to view analytics data based on their sales. Does anyone have any idea about the best way to handle multiple databases based off the user? Lets say we have 3 big name clients, the design decision ...
I have a simple table with two columns (well two columns of interest, plus just an ID)... I have an ajax search which is just looking for keywords... which are then sent to my real search... the ajax search doesn't care what they are, but they need to be distinct... How can I merge the two columns together: City, Country Krakow, Polan...
I was Wondering if there is anyway of suspending / resuming weblogic 10 jdbc datasources via the command line. I am aware that i can do this in the admin console, but because our app has many different datasources it is a bit of a pain. The reason behind this is that our testers are doing error flow tests and have to simulate the db goi...
How can I use the RAD way productively (reusing code). Any samples, existing libraries, basic crud generators? How can I design the OOP way? Which design patterns to use for connection, abstracting different engines/db access layers (bde-dbexpress-ado), basic CRUD operations. ...
Does the Microsoft "Extensible Storage Engine" expose enough access to the storage manager to allow me to write a custom access method, for example a GiST? Alternatively, is there a basic log manager / buffer pool manager project for Windows that I could extend to play around with GiST without re-inventing the entire wheel? (Access meth...
I have an application that is scheduled and get some data from a another database table and dumps in my main applications database table,the number of records in this table increases daily and I assume it will grow daily as it is transactions event data that occur.This data is used for processing by the main application which takes each ...
Doesn't have to be the same syntax, but same or similar functionality. Please provide the name used for the construct and a simple example. ...
Currently I'm developing a Blackberry Application to access internal business contacts in our company. As far as I know there is no database platform for j2me or blackberry applications. What the the best way to store large sets of data without a database? I found http://www.mcobject.com/j2me_database via google which uses a B-Tree alg...
ok here's the rhubarb - I'm working on an application that has been written in VB6 (in which I have less than 1 month's experience), and the gist of the application is it's a simple database select/update type of app. Basically all it does is you can search for employees (selecting the record from the database), and edit their data (and...
I have table in Database and the primry key is 'ID', Just I want to ask how can I make it AUTOINCREMENT I know that's esay Q, but I dont know how can I do it. thanks ...
If say I need to run two separate SQL statements against two separate databases. Right now I do (pseudocode): Try{ declare variable connectionA to DatabaseA declare variable connectionB to DatabaseB connectionA.open() connectionB.open() declare variable SQLCmdA with ConnectionA and one SQL statement declare variable SQLCmdB with...
I'm designing a personal project which is largely database driven. I'm trying to come up with a good design for how to handle database interop, and I'd like the input of the experienced minds here at StackOverflow. Is the following good design, or is there a more standard way of handling communication with the database? EDIT I was main...
I have given an assignment to get the feasibility for making a dll which takes some inputs such as database name(Mysql,access, sql, oracle etc.) and some more inputs to generate a query and based on that the dll should return a recordset to the application. is it a good idea. if yes then what inputs should i consider ...
As a followup to my previous question. I am an ASP.NET Programmer, and am wondering how NHibernate would help me get my job done easier and more quickly than it would otherwise. Pretend I know nothing about NHibernate. What is it, and what can it do for me? ...
I am a new developer for a DOORS database and when writing scripts in dxl. If you know there are only 1 dimensional arrays in dxl. I wanted to use more than one dimension so I decided to use a dynamic array, but this slowed my script down a lot, and when we have around 14000 objects per module it would take a day or so for the script to...
I have two machines on amazon ec2, one with a drupal installation and another one with the mysql database. I wonder if it's worth to patch drupal to activate mysql client compression. Are there any caveats? ...
Hi. There are several threads in my application that work in the background. They connect to database and execute some time consuming select queries. In most of cases these queries return only several records. From time to time, however, they may return tens of thousands records. All these are then processed in a loop. Because such sit...
In Java and C#, they both have something like System.terminate(). If my program has open database connections, database readers, and database command variables, and I terminate my program in a catch clause, will database resources still remain in use? or will they be freed automatically since my entire program has just exited? Normally,...
In Object Role Modeling (ORM), given an entity of thing that had a relationship to an entity of type and where the type entity can be specified to live and the thing entity could have a value for date of birth, how would I specify a constraint that would exclude instances of thing from having a value for date of birth if the instance of ...