ken gen <[EMAIL PROTECTED]> writes: > I'm trying to work out how easy it would be to leverage the Derby DRDA > server endpoint, but instead of passing requests/queries to the SQL engine, > forward them to my application code directly. I'd like to use something like > JXPath, JoSQL or Quaere to actually generate resultsets and return them. > > I've looked in the mail archive, but couldn't find any pointers. I've looked > in the source code, and DRDAConnThread seems to be the best place so far, > but it's not clear if there's a better hook location.
Hi Ken, I think DRDAConnThread would be the best place. An easier way might be to use table functions, which will be present in the next Derby release (10.4). See https://issues.apache.org/jira/browse/DERBY-716 for details. With table functions, your application can generate the result sets and you don't need to modify the Derby code. Rick recently uploaded some demo code to this location: https://issues.apache.org/jira/browse/DERBY-3129 If this new functionality sounds interesting, please try it out and let us know what you think. (You need to download the development sources from http://db.apache.org/derby/dev/derby_source.html or a nightly build from http://dbtg.thresher.com/derby/bits/ to test it.) -- Knut Anders
