Hi, On Fri, Apr 16, 2010 at 10:28 PM, Anjana Fernando <[email protected]> wrote: > On Fri, Apr 16, 2010 at 9:25 PM, Anjana Fernando <[email protected]> wrote: >> On Fri, Apr 16, 2010 at 9:17 PM, David Fisher <[email protected]> wrote: >>> One possibility is to use Derby >>> (http://db.apache.org/derby/papers/ApacheCon.html look into "Saucer >>> Separation") to read an excel sheet into an internal structure. Derby would >>> then provide the sql capability. >>> >>> So, I would recommend you look into incorporating POI under Derby somehow >>> as the database file driver. >>> >>> I were forced to do this that is what I'd do. >>> >> >> Thanks, will take a look :) .. >> > > Hi Dave, > > I'm guessing, you were referring to the table functions feature that > is used in Derby. After going through it a little, I see that it > cannot be really used to the requirement I'm suggesting. If this > functionality is to be used in a generic way, the behavior have to be > dynamic, where the Excel sheets has to be mapped to database tables > and so in, at the runtime. But table functions require that you give a > specific static function providing a result set to the external data. > And also the SQL syntax also will be different when referring to the > imported tables, but I would prefer if the user is transparent from > those complexities and can use SQL via a JDBC driver in a way that it > is talking to a database directly.
To add to that, I'm guessing you cannot support DML operations with that. Anjana. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
