Re: PreparedStatement.toString() - nice formatting

I wrote a fix for this, but seeing the comments at https://issues.apache.org/jira/browse/DERBY-3676 I am not sure its a good idea. Please feel free to attach the patch proposal to the JIRA issue anyway, even if you think it may not be perfect. It may be just the thing to help somebody else, or s

Re: PreparedStatement.toString() - nice formatting

Thanks for pushing this forward, Will. I have added another suggestion to DERBY-3676, an approach which could leverage what you've built already. Let's see if the community can improve this or surface more problems. Would the suggested approach satisfy your needs? Regards, -Rick wbecker wrote

Re: Can I write a query that joins tables in two databases?

Hi Ian, Table Functions can be invoked in the FROM list of any query block. Practically speaking, that means that you can invoke them in the top-level FROM list and materialize them anywhere that you can include a subquery. And yes, you can use them in outer joins. Here for instance is an out

Re: Can I write a query that joins tables in two databases?

Thanks Rick, I am glad I described the problem I was trying to solve. Table Functions look very promising I will start experimenting with them. Are there any restrictions on where such a table can be used? Specifically, in my application, I want to be able to use an outer join. That way I c

Re: Replicating Derby Database Files

Thanks for the replies, Rick and Narayanan! I will look into the documentation some more and see if we can use this feature. Regards, Sai Pullabhotla On Fri, May 16, 2008 at 12:33 AM, Narayanan <[EMAIL PROTECTED]> wrote: > Sai Pullabhotla wrote: >> >> Rick, >> >> Thanks for the reply. I briefly

Re: PreparedStatement.toString() - nice formatting

I wrote a fix for this, but seeing the comments at https://issues.apache.org/jira/browse/DERBY-3676 I am not sure its a good idea. Rick Hillegas-2 wrote: > > Hi Will, > > Thanks for bringing this up. I have logged DERBY-3676 to track this > request. At first blush this looks like a straightfo

Re: PreparedStatement.toString() - nice formatting

Hi, I have half coded this anyway, so I might as well. I'll check out the code and see how hard it is to write up a patch. Cheers, Will Rick Hillegas-2 wrote: > > Hi Will, > > Thanks for bringing this up. I have logged DERBY-3676 to track this > request. At first blush this looks like a str