On 11/23/06, thierry boileau <[EMAIL PROTECTED]> wrote: [...]
Good morning,
you're right : the current behaviour is bugged. If you want to use the resultSet, the connection need to stay open. This connector has been released a long time ago and has probably been updated without tests. As Jerome said, we are working on some refactorings to the JDBC Client in order to return XML result sets. That is to say, the jdbcHelper will get the resultSet, generate an XML Representation of the resultSet then release the connection, and return the new representation.
I have some concerns about the proposed approach... (A) What about results that are quite large? I.e. that take up a lot of memory or won't fit into memory? (B) What about performance? Doing that extra transformation is costly. (C) What about those of use who really don't want to have to bother with yet still more XML in the system?
The main reason of this refactoring is that keeping an open connection does not really comply with a REST approach.
Yes and no. The purpose, IMHO, is for the service to bridge from a purely REST to the messiness of things like databases. Thanks, John
