Access Coldfusion SQL driver directly

[Aneesha]

Hi

Anybody know if I can access coldfusion MS SQL driver directly like I can
access the mysql driver

eg

<cfscript>
clazz = CreateObject("java", "java.lang.Class");
clazz.forName("org.gjt.mm.mysql.Driver");
driverManager = CreateObject("java", "java.sql.DriverManager");
conurl = "jdbc:mysql://server/db?user=u&password=p";
connection = driverManager.getConnection(conurl);
</cfscript>

Thanks

[mxstu]

I believe you can.

[Aneesha]

Would you happen to know what the clazz.forName is?

Thanks

[mxstu]

It depends on which one you're using. I've used both the macromedia driver and
the ms driver. Sorry for all the extra text.. I was too lazy to cut out the
class names ;-)

getPageContext().getClass().forName("macromedia.jd bc.MacromediaDriver");

getPageContext().getClass().forName("com.microsoft .jdbc.sqlserver.SQLServerDrive
r");

[Aneesha]

Thank you very much.

I'm trying to experiment with batch updates:
[url]https://www6.software.ibm.com/developerworks/education/x-insert/x-insert-8-1.html[/url]

[mxstu]

Do you have to register to access that link?

[Aneesha]

Yes -- you have to register to access a few things on that site.

This is what I'm doing:

class = createObject("java", "java.lang.Class");
class.forName("macromedia.jdbc.sqlserver.SQLServer Driver");
dm = createObject("java","java.sql.DriverManager");

con =
dm.getConnection("jdbc:macromedia:sqlserver://sqlserver;databaseName=dbname","us
ername","password");
st = con.createStatement();

st.addBatch(sql1);
st.addBatch(sql2);
st.addBatch(sql3);

st.executeBatch();
st.close();
con.close();

[mxstu]

Okay. I would be curious to see if there is any difference in performance
between your code and a CFQUERY update using CFQUERYPARAM, which is supposed to
provide enhanced performance when executing the same statement w/parameters
multiple times.