database

Connecting swings with sql

I want to learn sql connectivity with swings(java) can any one suggest a good resource available for my purpose. ...

Obtaining a Hibernate transaction within a Spring class

I am working on a program that uses Spring and obtains Hibernate transactions transparently using a TransactionInterceptor. This makes it very convenient to say "when this method is invoked from some other class, wrap it in a transaction if it's not already in one." However, I have a class that needs to attempt a write and must find ou...

entering values into database from 'unlimited' dynamic controls

there's a dropdown displaying 1-10 from where the user selects the number of textboxes he wants - if he chooses unlimited, it shows him a textbox wherein he enters the exact number of textboxes he'd like. if he enters 40, it shows him 40 textboxes which are created at runtime. my question is, how do i enter the data from 40 - or 'whatev...

Any real world experience with H2 database?

Has anybody out there got any real world experience with the H2 database? I'm interested in: performance stability bugs ...

.Net Database Querying Options Aside Linq

Hello, I've been doing a lot of implementation in Linq recently, and it suddenly occurred to me that as great as it is, I haven't really explored any other options. Any thoughts? ...

How are the automobile databases maintained?

I'm looking into developing a used cars web app, but I've searched and I cannot find any avaliable database for download (paid or free) that contains all the makers and models of automobiles. How should I go about this? Should I scrap someone else's website? What guarantees do I have that the said website is updated frequently? Where do...

A better error handler code for debugging db related methods in C# ?!

Hi, all. I have the following region I keep snippetting after the try {} blocks. It's purpose is to provide debugging information whenever configured back to the database ... It does debug nicely ( not all it is supposed to debug , but enough to find exactly the error, BUT .. The code smells. Even I can get it. Do you have a better idea...

convert database table into XML schema file

Hello everyone, I am using SQL Server 2005. Is there any command or GUI tool (e.g. any menu/function from SQL Server management studio) to convert database table into XML schema file (.xsd)? thanks in advance, George ...

Relational Database Options that work with .Net framework aside SQL (Possibly using Linq)?

Exactly what the title says...........any thoughts on other good options for relational database implementation aside from SQL Server DB's. It's necessary for the .Net Framework to be able to communicate with it also. ...

Question on Prepared Statement in Java

We have a Prepared Statement in Java and we hear that it is different from Statement in the Way that this prepared statement need not be compiled every time it is used. My question is where is this Compiled Statement stored ? In the Client code that uses it or is it stored by the Database ? Why would a DB Store a Compiled statement and...

What are the best scenarios for using object-oriented databases?

We are planning to use OO databases to store configuration objects. The options are: 1 - Create 300+ relational tables. 2 - Create a generic structure with few tables. We think this would make object relation mapping more complex to build and maintain. 3 - Use a OO database. We are testing this now. What do you think ? ...

How safe is it to pre-generate a Guid and insert it into a table as a Primary Key?

I've seen many situations before where a PK is a Guid with no default value, and as such the developer would generate random Guids and use them to insert into the database. I've often wondered what is the possibility that they would generate a number that already existed? ...

GUID vs INT IDENTITY

I'm aware of the benefits of using a GUID, as well as the benefits of using and INT as a PK in a database. Considering that a GUID is in essence a 128 bit INT and a normal INT is 32 bit, the INT is a space saver (though this point is generally moot in most modern systems). In the end, in what circumstances would you see yourself using a...

Equivalents to SQL Server TOP

In SQL Server, TOP may be used to return the first n number of rows in a query. For example, SELECT TOP 100 * FROM users ORDER BY id might be used to return the first 100 people that registered for a site. (This is not necessarily the best way, I am just using it as an example). My question is - What is the equivalent to TOP in other da...

SQL Server 2005 indexing same columns in different order

I have a report that was taking a long time to execute. I ran the database engine tuning advisor and one of the recommendations was to create 2 indexes. However, I noticed that the indexes were the same columns, but in different orders. Here is the table: ---Locations--- | *LocationID | | Code | | ...more... | | DivisionID |...

relational databases and versioning: revision intervals

I've been thinking about how to apply data versioning to a relatively simple database I have, and figured I should do something like is mentioned in Jim T's post where there are global revision #s (e.g. like in Subversion or Mercurial) and each database record has a validity interval. Example: Create a person. |Name|D.O.B |Tel...

How can I make hundreds of simultaneously running processes communicate with a database through one or few permanent sessions?

Long speech short: How can I make hundreds of simultaneously running processes communicate with a database through one or few permanent sessions? The whole story: I once built a number crunching engine that handles vast amounts of large data files by forking off one child after another giving each a small number of files to work on. Fil...

.NET Entity Framework

Is it bad practice to use the code-gen'ed objects from Entity Framework as business objects? Or is it better to write a secondary wrapper around Entity Framework objects that I would then pass between layers? For example, write my own POCO Person that accepts one of my code-gen'ed Entity Framework object EFPerson to initialize the POCO ...

C++ Database Connectivity?

Hey, I want to know how to connect databases with C++? Any cross-platform solution which supports many databases? I know about SQLAPI++ but its a shareware... so any free one? What solutions do I have if I limit the OSes to Windows only? Thanks ...

UniData Data Access Products for .NET

I am doing some research about how to access data in a UniData database from .NET code. From what I have found, I can use UniObjects for .NET and U2.NET. I have also found this information, which I think is possible by using U2.NET, but I'm not quite sure. I am also unsure as to the cost of these products, and if they are free, how to ...