Hi Anyone out there with sufficient knowledge of EMC Documentum and Oracle to know whether it is possible to set up a documentum repository on top of oracle so that it uses Character based field lengths rather than byte based. By Default Documentum seems to use byte based fields so if a field is string(32) it can contain 32 bytes rathe...
I'm sorry, but this keyword doesn't mean anything to me... Can someone give me a definition? Thanks in advance... ...
I have a Winforms application created in Visual Studio 2005 Pro, it connects to an SQL Server 2005 database using the SqlConnection / SqlCommand / SqlDataAdapter classes to extract data. I have stored procedures in my database to return the data to me. What is the best way to handle queries that take a "long time" to complete? (i.e long...
When using IDbCommand, IDataReader, or DataTable, can you depend on the destructor to dispose resources, or will these objects leak resources if dispose is not called directly? ...
Hello, I'm curious to know how NULLs are stored into a database ? It surely depends on the database server but I would like to have an general idea about it. First try: Suppose that the server put a undefined value (could be anything) into the field for a NULL value. Could you be very lucky and retrieve the NULL value with ...WHER...
I have some servers in Europe and some in Asia. I would like to be able to work out where the current server is by querying ... something. Is there some global variable I can query or sp_xxx I can execute to find out the locale of the server? ...
I'm trying to define a table to store student grades for a online report card. I can't decide how to do it, though. The grades are given by subject, in a trimestral period. Every trimester has a average grade, the total missed classes and a "recovering grade" (i don't know the right term in english, but it's an extra test you take to tr...
What's the most appropriate type used to store the duration time information of a video in sql server? ...
I'm familiar with SQLite and Derby. I used SQLLite in a Ruby project before and I looked at Derby for a personal Java project that went nowhere. Both of these were 2+ years ago, and I'm sure much has changed. What are the top contenders (preferably free) today? ...
currently i have jdbc code with the following basic stucture: get Connection (do the next 4 lines several times, never closing statement) get statement get result set process result set close result set close connection It occurred to me after writing this code that i need to close the statement. 1 what are the effects of not cl...
I suppose this question could just as easily be applied to PHP with regard to MSSQL. However, with some versions of MSSQL being so expensive, I always wondered, what is the real advantage of choosing it over MySQL for .NET development? Is it really difficult to use .NET tools in conjunction with a MySQL database? Why not create some sort...
What is the best way to store a large number of data points? For example temperature values which are measured every minute over lots of locations? SQL databases with one row per data points doesn't seem very efficient. ...
Hi everyone, I am working on a PHP application that intends to ease company workflow and project management, let's say something like Basecamp and GoPlan. I am not sure on what the best approach is, database-wise. Should I use a single database and add client-specific columns to each of the tables, or should I create a database for eac...
I've been experiencing the good and the bad sides of messaging systems in real production environments, and I must admit that a well organized table or schema of tables simply beats every time any other form of messaging queue, because: Data are permanently stored on a table. I've seen so many java (jms) applications that lose or vanis...
Hi, I am developing an application which will be connected to Access database at the beginning and the plan is to switch to MS SQL or SQL Express in the near future. The datatables structures are same for both types of databases and I am trying to avoid duplicating the code and trying to find the way to minimize the code. For example I...
I have a windows service connecting to a SqlServer database on the local box. This works fine most all the time. At a large customer, however, the database connectivity gets corrupted for some rare and unknown reason. When this happens, calls to DbDataAdapter.Fill return a DataSet with a different number of columns than in the select ...
Is there a way to tunnel a proxy to access a remote sql server database on visual studio 2008? I'm working in a project at college that uses a sql server database but the access is restricted to the internal network. I'd like to access the database from my home too. Thanks in advance. ...
I'm using an in-memory dataset to represent an array of objects. I've got most of the code figured out to fill the dataset at runtime, but part of my object contains a dynamic array of TPoint records, and I have no idea how to set up the dataset and the loading code to make that work. I know a TPoint can be represented by an ADT field,...
What is a view in Oracle? ...
I have a PHP web application which uses a MySQL database for object tagging, in which I've used the tag structure accepted as the answer to this SO question. I'd like to implement a tag hierarchy, where each tag can have a unique parent tag. Searches for a parent tag T would then match all descendants of T (i.e. T, tags whos parent is T...