You said: Currently these tables all live in the same database, but in the future they may be moved to different servers to scale out if the needs arise.
That's why I concentrated on the JDBC url problem. But you can use a file as a list of tables. Read each line, and a sub-entity can substitute the line value into the SQL statement. On Sat, Dec 18, 2010 at 6:46 PM, Andy <angelf...@yahoo.com> wrote: > > --- On Sat, 12/18/10, Lance Norskog <goks...@gmail.com> wrote: > >> You can have a file with 1,2,3 on >> separate lines. There is a >> line-by-line file reader that can pull these as separate >> drivers. >> Inside that entity the JDBC url has to be altered with the >> incoming >> numbers. I don't know if this will work. > > I'm not sure I understand. > > How will altering the JDBC url change the name of the table it is importing > data from? > > Wouldn't I need to change the actual SQL query itself? > > "select * from Document1" > "select * from Document2" > ... > "select * from Document36" > > > > -- Lance Norskog goks...@gmail.com