Thanks for the advice. I think I may end up just doing the whole thing by hand. It's looking like that may be less work than setting up OJB to work. Which is a shame, because I really like OJB :) Thanks again for the advice though
-Pete
From: Thomas Dudziak Sent: Mon 12/6/2004 1:30 PM To: OJB Users List Subject: Re: db with many tables
Peter Guarnieri wrote:
Hey all,As a second thought, an easier route may be using commons-sql (http://jakarta.apache.org/commons/sandbox/sql/) which can out-of-the-box map tables to dynabeans.
I'm currently trying to write a Java program to suck out a whole heap of data from an MsSQL db which is the backend of an MS SharePoint portal. Sharepoint stores data for each new "list" created by creating a new table. So every time someone creates a new list of documents for exampele, a table is created, named ProjectXXX_nameoflist. I want to have a Java class to represent a particular kind of table. For instance, they'll be a DocumentBean for tables in the db that stores information about a list of documents. How can I set something like this up with OJB? How do I have one Java class map to a dynamically determined number of tables? Is there some way to fill in the table name at runtime? There's no way to know beforehand what the names of the tables will be; right now I'm running some queries on the sysobjects table to figure that out. Does anyone know of any method for doing this?
Tom
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
