Hello everyone,
My company is investigating web development technologies and is considering
ColdFusion. We currently develop with Java servlets (with an Oracle DB and
Oracle App Server on Solaris) but want to have more rapid development.
We did a test between a CF query and a servlet query (using JDBC prepared
statements) and found that the servlet prepared statement was quite a bit
faster than the CF query which is probably just using a regular
non-preprocessed SQL query.
We would like to use the CFSERVLET tag to pass JDBC bind variables to a Java
servlet which uses JDBC and a prepared statement to make a query to the
database, and then return
the result set directly to the calling ColdFusion page (without having to
loop through the result set) where it can be manipulated by CF tags.
The documentation implies that this can be done, but I have not seen an
example showing how to do exactly this in either the CF or JRun
documentation.
Any light that anyone can shed on how to do this would be greatly
appreciated and help us in our decision-making process.
Please reply directly to [EMAIL PROTECTED] as well as to the list.
Thanks.
Aurelio Sablone
Product Architect
First Insight Corp.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
