Oh, sweet! That is a better way to do it. I guess as long as servicefactory doesn't go away, this should work with furture versions. I'd hate to see Adobe drop that, because I know a lot of people use it.
> -----Original Message----- > From: Denny Valliant [mailto:[EMAIL PROTECTED] > Sent: Friday, April 21, 2006 11:57 PM > > It might b e worth noting that you can use undocumented > "don't use these > and expect them to work over time" type functions to use an existing > datasource, so you don't need to save your db user & pass "hard"ly. > > Something like: > daFactory = CreateObject ("Java"," > coldfusion.server.ServiceFactory"); > conn = daFactory.getDataSourceService > ().getDatasource("yourDataSourceName").getConnection(); > for the connection and the rest like the rest. > > Worth it for me, to use non public api whatnot. Be warned, may not > work in the future (but there would be something else anyway ;) > :de > > On 4/20/06, Qasim Rasheed <[EMAIL PROTECTED]> wrote: > > > > Jacob, > > > > Here is an example implementation for Oracle. You can > definitely modify it > > for any other database. > > > > <cfscript> > > //connection url > > connURL = "jdbc:macromedia:oracle://.........."; > > jclass = createobject('java','java.lang.Class'); > > jclass.forName('macromedia.jdbc.oracle.OracleDriver'); > > driverManager = CreateObject('java', 'java.sql.DriverManager'); > > //user name and passwword > > conn = driverManager.getConnection( connURL, 'USER', 'PASSWORD' ); > > sql = "delete from atable where id = ?"; > > ps = conn.prepareStatement(sql); > > ps.setString(1,'2'); > > n = ps.executeUpdate(); > > </cfscript> > > <cfoutput> > > Records Affected: #n# > > </cfoutput> [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238559 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54