how to access a db table that changes structure
From: ciao ciao (ciao_at_ciao.net)
Date: 06/29/04
- Next message: Luke McCarthy: "Re: JDBC + SSL = "No trusted certificate found" (RESOLVED)"
- Previous message: Daniel Dittmar: "Re: SQLJ code ...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 29 Jun 2004 19:09:02 GMT
Hello all, I've a database table that can change structure, think about
an ITEMS table with certain columns. Some of these columns are
fixed and never change, other columns can change: the end user
can add new columns (all of type VARCHAR) or remove
previoulsy added columns.
I have to design some classes to access the database, like an "item"
class with methods to get and set values in the db.
The problem is that the table isn't always the same! so I cannot use
a "normal" DAO, because sometimes in the future there will be new
columns and I won't be able to get them.
Thanks.
- Next message: Luke McCarthy: "Re: JDBC + SSL = "No trusted certificate found" (RESOLVED)"
- Previous message: Daniel Dittmar: "Re: SQLJ code ...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
