>documentation, I was actually able to get the following to work:
>
><cfscript>
>clazz = CreateObject("java", "java.lang.Class");
>// replace the package/class name of your db driver
>clazz.forName("macromedia.jdbc.MacromediaDriver");
>driverManager = CreateObject("java", "java.sql.DriverManager");
>// replace w/ your server, database name, username & password
>conurl =
>"jdbc:macromedia:oracle://********:1521;SID=*********;user=*********;password=*********";
>connection = driverManager.getConnection(conurl);
>query = "DELETE FROM IDS WHERE ID=1";
>preparedStatement = connection.prepareStatement(query);
>result = preparedStatement.executeUpdate();
>WriteOutput("result = " & result);
>connection.close();
></cfscript>
>
>For what it's worth, this is the second time I've resorted to using the
>datadirect documentation to solve a driver-related issue with Cold
>Fusion :)
>
Rick, perhaps I missed it, but what issue did you run into with the drivers
that you needed to resort to this? Your query looks to be pretty basic.
Just curious.
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
