Accessing Connection object without ServiceFactory

can access connection object :

 

theservicefactory = createobject('java','coldfusion.server.servicefactory');

//creating connection object passing dsn name

con = theservicefactory.getdatasourceservice().getdatasource('datasourcename').getconnection();

 

my server admin doesnt want me use servicefactory. alternative methods of getting connection object?

 

ps need access connection object perform oracle batch insert.

why aren't using datasource directly?

 

<cfquery name="queryname" datasource="datasourcename">

     <!--- oracle batch insert code --->

</cfquery>

 

if stuck inside cfscript reason, try using query function:  http://help.adobe.com/en_us/coldfusion/9.0/cfmlref/wse9cbe5cf462523a0693d5dae123bcd28f6d-7 ffb.html

 

message edited by: miguel-f

More discussions in Database Access

adobe