Very cool -- do you recall if JDBC connections and result sets are
allowed to be used across different threads?
-Brian
On Aug 29, 2007, at 8:14 AM, Nicky Sandhu wrote:
In my rookie attempt to create the JDBC component
(https://issues.apache.org/activemq/browse/CAMEL-128) I encountered
the
following questions
1. If the exchange out is send out the ResultSet (open cursor) then
is there
support for a callback on the exchange to allow a lifecycle of end
on the
exchange to allow one to close out the ResultSet. Instead I have
created a
limit on the read size and copied the data into a list of hash
maps. Not
very efficient and I don't like it much. Any suggestions ?
2. I would like the component to poll the database. Is such a polling
consumer better accomplished by doing
from("timer:...").setBody(sqlStmt).to("jdbc:...").pipeline
("direct:a") ?
3. Lastly the conversion mechanism from result set to other types. Any
suggestions on whether using the type converter is appropriate here ?
--
View this message in context: http://www.nabble.com/Camel-JDBC-
Component-tf4348358s22882.html#a12389082
Sent from the Camel - Development mailing list archive at Nabble.com.
